Gsmarket/Sources/GS-MarketMG-2018/SysDataLibs/TableClass/Sys_Setting_info.cs

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

        /// <summary> 
        /// 为关键字段： Y --- PrimaryKey;
        /// 自动增长： N;
        /// 数据类型： nvarchar;
        /// 数据长度： 50;
        /// 是否允许为空： N;
        /// 默认值： ;
        /// 描述： SysSetCode;
        /// </summary>
        public const string cSysSetCode = "SysSetCode";

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： nchar;
        /// 数据长度： 10;
        /// 是否允许为空： N;
        /// 默认值： ;
        /// 描述： SysSetType;
        /// </summary>
        public const string cSysSetType = "SysSetType";

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

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

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

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： varchar;
        /// 数据长度： 30;
        /// 是否允许为空： Y;
        /// 默认值： ;
        /// 描述： UserIDLastMod;
        /// </summary>
        public const string cUserIDLastMod = "UserIDLastMod";

        #endregion
        public Sys_Setting_info() { }

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

        public void CreateTableInfo(DataRow poRow)
        {
            _Remark = UtilStr.StrFromObj(poRow[cRemark]);
            _SysSetCode = UtilStr.StrFromObj(poRow[cSysSetCode]);
            _SysSetType = UtilStr.StrFromObj(poRow[cSysSetType]);
            _SysSetValue = UtilStr.StrFromObj(poRow[cSysSetValue]);
            _TimeCreated = UtilStr.StrFromObj(poRow[cTimeCreated]);
            _TimeLastMod = UtilStr.StrFromObj(poRow[cTimeLastMod]);
            _UserIDLastMod = UtilStr.StrFromObj(poRow[cUserIDLastMod]);
        }

        public Sys_Setting_info(string pcSysSetCode, DBConnSql poDBConn)
        {
            if (pcSysSetCode.Trim().Length > 0 && poDBConn != null)
            {
                string lcSql = "select * from " + Tn.Sys_Setting + " where " + Sys_Setting_info.cSysSetCode + "='" + pcSysSetCode + "'";
                rsQuery loQuery = poDBConn.OpenQuery(lcSql);
                if (loQuery != null && loQuery.IsOpened && loQuery.RecCount == 1)
                {
                    loQuery.MoveFirst();
                    CreateTableInfo(loQuery.CurrentRow);
                }
            }
        }
        private string _Remark = "";
        public string Remark
        {
            get { return _Remark; }
            set { _Remark = value; }
        }

        private string _SysSetCode = "";
        public string SysSetCode
        {
            get { return _SysSetCode; }
            set { _SysSetCode = value; }
        }

        private string _SysSetType = "";
        public string SysSetType
        {
            get { return _SysSetType; }
            set { _SysSetType = value; }
        }

        private string _SysSetValue = "";
        public string SysSetValue
        {
            get { return _SysSetValue; }
            set { _SysSetValue = value; }
        }

        private string _TimeCreated = "";
        public string TimeCreated
        {
            get { return _TimeCreated; }
            set { _TimeCreated = value; }
        }

        private string _TimeLastMod = "";
        public string TimeLastMod
        {
            get { return _TimeLastMod; }
            set { _TimeLastMod = value; }
        }

        private string _UserIDLastMod = "";
        public string UserIDLastMod
        {
            get { return _UserIDLastMod; }
            set { _UserIDLastMod = value; }
        }

        [ScriptIgnore]
        public rsXmlNode DataXMLNode
        {
            get
            {
                rsXmlNode loMainNode = new rsXmlNode("Sys_SettingRecord", "");
                rsXmlNode loNode = null;
                loNode = new rsXmlNode(cRemark, Remark);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cSysSetCode, SysSetCode);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cSysSetType, SysSetType);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cSysSetValue, SysSetValue);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cTimeCreated, TimeCreated);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cTimeLastMod, TimeLastMod);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cUserIDLastMod, UserIDLastMod);
                loMainNode.AddChild(loNode);
                return loMainNode;
            }
        }
        public string InsertSql()
        {
            return " insert into " + Tn.Sys_Setting + " " +
                         " (" + cRemark + "," + cSysSetCode + "," + cSysSetType + "," + cSysSetValue + "," + cTimeCreated + "," + cTimeLastMod + "," + cUserIDLastMod + ") " +
                         " values ('" + _Remark + "','" + _SysSetCode + "','" + _SysSetType + "','" + _SysSetValue + "','" + _TimeCreated + "','" + _TimeLastMod + "','" + _UserIDLastMod + "') ";
        }

        public string UpdateSql()
        {
            return " update " + Tn.Sys_Setting + " " +
                         " set " + cRemark + "='" + _Remark + "'," + cSysSetType + "='" + _SysSetType + "'," + cSysSetValue + "='" + _SysSetValue + "'," + cTimeCreated + "='" + _TimeCreated + "'," + cTimeLastMod + "='" + _TimeLastMod + "'," + cUserIDLastMod + "='" + _UserIDLastMod + "' " +
                         " where  " + cSysSetCode + "='" + _SysSetCode + "'";
        }

        public string DeleteSql()
        {
            return "Delete " + Tn.Sys_Setting + " where " + cSysSetCode + "='" + _SysSetCode + "'";
        }
    }
    #endregion

    #region

    public class Sys_Setting_Qry : rsQuery
    {
        public String Remark
        {
            get { return GetString(Sys_Setting_info.cRemark); }
            //    set { SetField(Sys_Setting_info.cRemark, value); } 
        }

        public String SysSetCode
        {
            get { return GetString(Sys_Setting_info.cSysSetCode); }
            //    set { SetField(Sys_Setting_info.cSysSetCode, value); } 
        }

        public String SysSetType
        {
            get { return GetString(Sys_Setting_info.cSysSetType); }
            //    set { SetField(Sys_Setting_info.cSysSetType, value); } 
        }

        public String SysSetValue
        {
            get { return GetString(Sys_Setting_info.cSysSetValue); }
            //    set { SetField(Sys_Setting_info.cSysSetValue, value); } 
        }

        public DateTime TimeCreated
        {
            get { return GetDateTime(Sys_Setting_info.cTimeCreated); }
            //    set { SetField(Sys_Setting_info.cTimeCreated, value); } 
        }

        public DateTime TimeLastMod
        {
            get { return GetDateTime(Sys_Setting_info.cTimeLastMod); }
            //    set { SetField(Sys_Setting_info.cTimeLastMod, value); } 
        }

        public String UserIDLastMod
        {
            get { return GetString(Sys_Setting_info.cUserIDLastMod); }
            //    set { SetField(Sys_Setting_info.cUserIDLastMod, value); } 
        }

    }
    #endregion

}