奥杰cms源码 - ContentEdit(八)

    ///

    /// 插入新数据
    ///

    /// 列名数组
    /// 值数组
    /// true or false
    public bool Insert( string[] namelist, string[] valuelist )
    {
        if( namelist.Length != valuelist.Length ) return false;
        if( tablename == "" && ColNod == null ) return false;

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

        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() + "\‘" + ",";
                }
            }
        }

        //加上系统时间字段
        col += "sys_opTime,sys_opUser";
        colvalue += "getdate(),‘" + UserName+"‘";

        string Dbquery = "";
        Dbquery = "insert into " + tablename + " ( " + col + " ) values ( " + colvalue + " )";
        if( Dbquery == "" ) return false;

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