奥杰cms源码 - ContentEdit(九)

    ///

    /// 数据更新
    ///

    /// 列名
    /// 值
    ///
    public bool UpDate( int id, string[] fieldName, string[] value )
    {

        if( fieldName.Length != value.Length ) return false;
        if( tablename == "" && ColNod == null ) return false;

        string supdate = "";

        for( int i = 0; i < fieldName.Length; i++ ) {
            //XmlNodeList li = ColNod.GetNodes( "fields/field" );
            XmlDomNode nod = ColNod.GetNode( "fields/field[@name=‘" + fieldName[i].Trim() + "‘]" );
            {
                string sysname = nod.GetAttr( "name" );
                if( sysname != "" && sysname != "sys_id" ) {

                    supdate += fieldName[i].Trim() + "=‘" + value[i].Trim() + "‘,";
                }
            }
        }

        //加上系统时间字段

        supdate += "sys_opTime=getdate(),sys_opUser=‘"+UserName+"‘";

        string Dbquery = " update " + tablename + " set " + supdate + " where sys_id = " + id + " ";
        if( Dbquery == "" ) return false;

        int nResult = 0;
        bool isOK = false;
        try {
            if( conn.State == ConnectionState.Closed )
                conn.Open();
            SqlCommand com = new SqlCommand( Dbquery, conn );
            com.ExecuteNonQuery();
            isOK = true;
        } catch( Exception ex ) {
            isOK = false;
            throw new InnerAppExp( "ContentEdit.UpData", "数据库操作异常：" + ex.Message, -1 );
        } finally {
            conn.Close();
        }
        return isOK;
    }