奥杰cms源码 - ContentEdit(六)

        if( Dbquery != "" ) {
            if( isShowHidden == false ) {
                Dbquery += " sys_hidden!=-1;";
            } else {
                Dbquery += " 1=1;";
            }
            try {
                conn.Open();
                SqlDataAdapter da = new SqlDataAdapter( Dbquery, conn );
                DataTable dt = new DataTable();
                da.Fill( dt );
                return dt;
            } catch( Exception e ) {
                e.ToString();
                return null;
            } finally {
                conn.Close();
            }

        } else
            return null;
    }

    public bool Write( string query, string fieldName, string value )
    {
        string[] namelist = fieldName.Split( ‘,‘ );
        string[] valuelist = value.Split( ‘,‘ );

        if( namelist.Length != valuelist.Length ) return false;
        if( tablename == "" && ColNod == null ) return false;

        string col = "";
        string colvalue = "";
        string supdate = "";

        for( int i = 0; i < namelist.Length; i++ ) {
            //XmlNodeList li = ColNod.GetNodes( "fields/field" );
            XmlDomNode nod = ColNod.GetNode( "fields/field[@name=‘" + namelist[i].Trim() + "‘]" );
            if( nod != null ) {
                string sysname = nod.GetAttr( "name" );
                if( sysname != "" && sysname != "sys_id" ) {
                    col += namelist[i].Trim() + ",";
                    colvalue += "\‘" + valuelist[i].Trim() + "\‘" + ",";
                    supdate += namelist[i].Trim() + "=‘" + valuelist[i].Trim() + "‘,";
                }
            }
        }