奥杰cms源码 - ContentEdit(十)

    ///

    /// 删除指定的内容
    ///

    /// id集合
    /// true or false
    public bool Delete( int[] query )
    {
        if( query.Length == 0 ) return false;

        string strSqlDel = "delete from "+tablename+" where ";

        for( int i = 0; i < query.Length; i++ ) {
            if( query.Length <= 1 || i == query.Length - 1 )
                strSqlDel += "sys_id=" + query[i];
            else
                strSqlDel += "sys_id=" + query[i] + " or ";
        }

        int nResult = 0;
        try {
            SqlCommand cmd = new SqlCommand();
            cmd.CommandType = CommandType.Text;
            cmd.Connection = conn;

            try {
                if( cmd.Connection.State == ConnectionState.Closed )
                    cmd.Connection.Open();
                cmd.CommandText = strSqlDel;
                nResult = cmd.ExecuteNonQuery();
            } catch( Exception ex ) {
                throw new InnerAppExp( "ContentEdit.Delete", "数据库操作异常：" + ex.Message, -1 );
            } finally {
                cmd.Connection.Close();

            }
        } catch( Exception ex ) { throw new InnerAppExp( "ContentEdit.ShowOrHide", "未知异常：" + ex.Message, -1 ); }

        if( nResult < 1 )
            return false;
        else
            return true;
    }