using System; 
using System.Collections.Generic; 
using System.Text; 
using System.Data; 
using SysBaseLibs; 
using System.Web.Script.Serialization;
namespace SysDataLibs.TableClass
{
    #region      Sys_UserDefaultColumns
    public class Sys_UserDefaultColumns_info : ITableInfo
    {
        #region      Sys_UserDefaultColumns表 字段信息
        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： nvarchar;
        /// 数据长度： 60;
        /// 是否允许为空： N;
        /// 默认值： ;
        /// 描述： 列名;
        /// </summary>
        public const string cColumnId = "ColumnId";

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： int;
        /// 数据长度： 4;
        /// 是否允许为空： Y;
        /// 默认值： ;
        /// 描述： 序号;
        /// </summary>
        public const string cSequence = "Sequence";

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： nvarchar;
        /// 数据长度： 60;
        /// 是否允许为空： N;
        /// 默认值： ;
        /// 描述： 表编号;
        /// </summary>
        public const string cTableId = "TableId";

        /// <summary> 
        /// 为关键字段： Y --- PrimaryKey;
        /// 自动增长： Y;
        /// 数据类型： int;
        /// 数据长度： 4;
        /// 是否允许为空： N;
        /// 默认值： ;
        /// 描述： 编号;
        /// </summary>
        public const string cUserDefaultId = "UserDefaultId";

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： varchar;
        /// 数据长度： 20;
        /// 是否允许为空： N;
        /// 默认值： ;
        /// 描述： 用户编号;
        /// </summary>
        public const string cUserId = "UserId";

        #endregion
        public Sys_UserDefaultColumns_info() { }

        public Sys_UserDefaultColumns_info(DataRow poRow)
        {
            CreateTableInfo(poRow);
        }

        public void CreateTableInfo(DataRow poRow)
        {
            _ColumnId = UtilStr.StrFromObj(poRow[cColumnId]);
            _Sequence = UtilStr.StrFromObj(poRow[cSequence]);
            _TableId = UtilStr.StrFromObj(poRow[cTableId]);
            _UserDefaultId = UtilStr.StrFromObj(poRow[cUserDefaultId]);
            _UserId = UtilStr.StrFromObj(poRow[cUserId]);
        }

        public Sys_UserDefaultColumns_info(string pcUserDefaultId, DBConnSql poDBConn)
        {
            if (pcUserDefaultId.Trim().Length > 0 && poDBConn != null)
            {
                string lcSql = "select * from " + Tn.Sys_UserDefaultColumns + " where UserDefaultId='" + pcUserDefaultId + "'";
                rsQuery loQuery = poDBConn.OpenQuery(lcSql);
                if (loQuery != null && loQuery.IsOpened && loQuery.RecCount == 1)
                {
                    loQuery.MoveFirst();
                    CreateTableInfo(loQuery.CurrentRow);
                }
            }
        }
        private string _ColumnId = "";
        public string ColumnId
        {
            get { return _ColumnId; }
            set { _ColumnId = value; }
        }

        private string _Sequence = "";
        public string Sequence
        {
            get { return _Sequence; }
            set { _Sequence = value; }
        }

        private string _TableId = "";
        public string TableId
        {
            get { return _TableId; }
            set { _TableId = value; }
        }

        private string _UserDefaultId = "";
        public string UserDefaultId
        {
            get { return _UserDefaultId; }
            set { _UserDefaultId = value; }
        }

        private string _UserId = "";
        public string UserId
        {
            get { return _UserId; }
            set { _UserId = value; }
        }

        [ScriptIgnore]
        public rsXmlNode DataXMLNode
        {
            get
            {
                rsXmlNode loMainNode = new rsXmlNode("Sys_UserDefaultColumnsRecord", "");
                rsXmlNode loNode = null;
                loNode = new rsXmlNode(cColumnId, ColumnId);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cSequence, Sequence);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cTableId, TableId);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cUserDefaultId, UserDefaultId);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cUserId, UserId);
                loMainNode.AddChild(loNode);
                return loMainNode;
            }
        }
        public string InsertSql()
        {
            return " insert into " + Tn.Sys_UserDefaultColumns + " " +
" (" + cColumnId + "," + cSequence + "," + cTableId + "," + cUserId + ") " +
" values ('" + _ColumnId + "'," + _Sequence + ",'" + _TableId + "','" + _UserId + "') ";
        }

        public string UpdateSql()
        {
            return " update " + Tn.Sys_UserDefaultColumns + " " +
" set " + cColumnId + "='" + _ColumnId + "'," + cSequence + "=" + _Sequence + "," + cTableId + "='" + _TableId + "'," + cUserId + "='" + _UserId + "' " +
" where  " + cUserDefaultId + "=" + _UserDefaultId + "";
        }

        public string DeleteSql()
        {
            return "Delete " + Tn.Sys_UserDefaultColumns + " where " + cUserDefaultId + "=" + _UserDefaultId + "";
        }

        public static bool SaveUserDefault(string pcUserId, string pcTableId, string pcColumnIds, DBConnSql poDBConn)
        {
            if (pcUserId.Trim().Length > 0 && pcTableId.Trim().Length > 0)
            {
                string lcSql = "";
                lcSql += " Delete " + Tn.Sys_UserDefaultColumns + " where UserId='" + pcUserId + "' and  TableId = '" + pcTableId + "' \r\n ";
                Array loArr = UtilStr.StrToArray(pcColumnIds);
                if (loArr != null && loArr.Length > 0)
                {
                    int i = 1;
                    foreach (string lcColId in loArr)
                    {
                        string lcColumnId = UtilStr.FormatStr(lcColId);
                        lcSql += "  insert into " + Tn.Sys_UserDefaultColumns + " (ColumnId,Sequence,TableId,UserId) values ('" + lcColumnId + "'," + i + ",'" + pcTableId + "','" + pcUserId + "')  \r\n ";
                        i++;
                    }
                }

                if (poDBConn.ExcuteSqlTran(lcSql))
                {
                    return true;
                }
            }
            return false;
        }
    }
    #endregion

    #region

    public class Sys_UserDefaultColumns_Qry : rsQuery
    {
        public String ColumnId
        {
            get { return GetString(Sys_UserDefaultColumns_info.cColumnId); }
            //    set { SetField(Sys_UserDefaultColumns_info.cColumnId, value); } 
        }

        public Int64 Sequence
        {
            get { return GetInt(Sys_UserDefaultColumns_info.cSequence); }
            //    set { SetField(Sys_UserDefaultColumns_info.cSequence, value); } 
        }

        public String TableId
        {
            get { return GetString(Sys_UserDefaultColumns_info.cTableId); }
            //    set { SetField(Sys_UserDefaultColumns_info.cTableId, value); } 
        }

        public Int64 UserDefaultId
        {
            get { return GetInt(Sys_UserDefaultColumns_info.cUserDefaultId); }
            //    set { SetField(Sys_UserDefaultColumns_info.cUserDefaultId, value); } 
        }

        public String UserId
        {
            get { return GetString(Sys_UserDefaultColumns_info.cUserId); }
            //    set { SetField(Sys_UserDefaultColumns_info.cUserId, value); } 
        }

    }
    #endregion

}