奥杰cms源码 - ContentEdit(七)

        //加上系统时间字段
        col += "sys_opTime";

        colvalue += "getdate()";
        supdate += "sys_opTime=getdate()";

        query = query.Trim();
        query = query.Substring( 1, query.Length - 2 ).Trim();
        string Dbquery = "";
        if( query == "*" ) {
            Dbquery = "insert into " + tablename + " ( " + col + " ) values ( " + colvalue + " )";
        } else if( IsNumber( query ) ) {
            Dbquery = " update " + tablename + " set " + supdate + " where sys_id = " + query + " ";
        } else {
            return false;
        }
        if( Dbquery != "" ) {
            try {
                conn.Open();
                SqlCommand com = new SqlCommand( Dbquery, conn );
                com.ExecuteNonQuery();
                return true;
            } catch( Exception e ) {
                e.ToString();
                return false;
            } finally {
                conn.Close();
            }
        } else
            return false;
    }

    ///

    /// 显示/隐藏内容，也就是将sys_hidden的值置为 0 / -1
    ///

    public bool ShowOrHide( int[] newsId, bool isHide )
    {
        int nResult = 0;

        try {
            SqlCommand cmd = new SqlCommand();
            if( newsId.Length < 0 ) return false;
            int hidden = -1;
            if( isHide )
                hidden = 0;
            string HideSql = "update " + tablename + " set sys_hidden=" + hidden + " where ";
            for( int i = 0; i < newsId.Length; i++ ) {
                if( i == 0 )
                    HideSql += "sys_id=" + newsId[i];
                else
                    HideSql += " or sys_id=" + newsId[i];
            }
            cmd.CommandType = CommandType.Text;
            cmd.Connection = conn;
            try {
                cmd.Connection.Open();
                cmd.CommandText = HideSql;
                nResult = cmd.ExecuteNonQuery();
            } catch( Exception ex ) {
                throw new InnerAppExp( "ContentEdit.ShowOrHide", "数据库操作异常：" + ex.Message, -1 );
            } finally {
                cmd.Connection.Close();
            }

        } catch( Exception ex ) {
            throw new InnerAppExp( "ContentEdit.ShowOrHide", "未知异常：" + ex.Message, -1 );
        }
        if( nResult != -1 )
            return true;
        else
            return false;
    }