Gsmarket/Sources/GS-MarketMG-2018/SysDataLibs/TableClass/Sys_Info_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_Info
    public class Sys_Info_info : ITableInfo
    {
        #region      Sys_Info表 字段信息
        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： nvarchar;
        /// 数据长度： 500;
        /// 是否允许为空： Y;
        /// 默认值： ;
        /// 描述： 系统消息描述;
        /// </summary>
        public const string cSysInfoDesc = "SysInfoDesc";

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

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： nvarchar;
        /// 数据长度： 500;
        /// 是否允许为空： Y;
        /// 默认值： ;
        /// 描述： 系统消息内容;
        /// </summary>
        public const string cSysInfoMsg = "SysInfoMsg";

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： nvarchar;
        /// 数据长度： 400;
        /// 是否允许为空： Y;
        /// 默认值： ;
        /// 描述： 信息可能发生的位置;
        /// </summary>
        public const string cSysInfoSite = "SysInfoSite";

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： nvarchar;
        /// 数据长度： 100;
        /// 是否允许为空： Y;
        /// 默认值： ;
        /// 描述： 系统消息标题;
        /// </summary>
        public const string cSysInfoTitle = "SysInfoTitle";

        #endregion
        public Sys_Info_info() { }

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

        public void CreateTableInfo(DataRow poRow)
        {
            _SysInfoDesc = UtilStr.StrFromObj(poRow[cSysInfoDesc]);
            _SysInfoID = UtilStr.StrFromObj(poRow[cSysInfoID]);
            _SysInfoMsg = UtilStr.StrFromObj(poRow[cSysInfoMsg]);
            _SysInfoSite = UtilStr.StrFromObj(poRow[cSysInfoSite]);
            _SysInfoTitle = UtilStr.StrFromObj(poRow[cSysInfoTitle]);
        }

        public Sys_Info_info(string pcSysInfoID, DBConnSql poDBConn)
        {
            if (pcSysInfoID.Trim().Length > 0 && poDBConn != null)
            {
                string lcSql = "select * from " + Tn.Sys_Info + " where SysInfoID='" + pcSysInfoID + "'";
                rsQuery loQuery = poDBConn.OpenQuery(lcSql);
                if (loQuery != null && loQuery.IsOpened && loQuery.RecCount == 1)
                {
                    loQuery.MoveFirst();
                    CreateTableInfo(loQuery.CurrentRow);
                }
            }
        }
        private string _SysInfoDesc = "";
        public string SysInfoDesc
        {
            get { return _SysInfoDesc; }
            set { _SysInfoDesc = value; }
        }

        private string _SysInfoID = "";
        public string SysInfoID
        {
            get { return _SysInfoID; }
            set { _SysInfoID = value; }
        }

        private string _SysInfoMsg = "";
        public string SysInfoMsg
        {
            get { return _SysInfoMsg; }
            set { _SysInfoMsg = value; }
        }

        private string _SysInfoSite = "";
        public string SysInfoSite
        {
            get { return _SysInfoSite; }
            set { _SysInfoSite = value; }
        }

        private string _SysInfoTitle = "";
        public string SysInfoTitle
        {
            get { return _SysInfoTitle; }
            set { _SysInfoTitle = value; }
        }

        [ScriptIgnore]
        public rsXmlNode DataXMLNode
        {
            get
            {
                rsXmlNode loMainNode = new rsXmlNode("Sys_InfoRecord", "");
                rsXmlNode loNode = null;
                loNode = new rsXmlNode(cSysInfoDesc, SysInfoDesc);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cSysInfoID, SysInfoID);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cSysInfoMsg, SysInfoMsg);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cSysInfoSite, SysInfoSite);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cSysInfoTitle, SysInfoTitle);
                loMainNode.AddChild(loNode);
                return loMainNode;
            }
        }
        public string InsertSql()
        {
            return " insert into " + Tn.Sys_Info + " " +
" (" + cSysInfoDesc + "," + cSysInfoID + "," + cSysInfoMsg + "," + cSysInfoSite + "," + cSysInfoTitle + ") " +
" values ('" + _SysInfoDesc + "'," + _SysInfoID + ",'" + _SysInfoMsg + "','" + _SysInfoSite + "','" + _SysInfoTitle + "') ";
        }

        public string UpdateSql()
        {
            return " update " + Tn.Sys_Info + " " +
" set " + cSysInfoDesc + "='" + _SysInfoDesc + "'," + cSysInfoMsg + "='" + _SysInfoMsg + "'," + cSysInfoSite + "='" + _SysInfoSite + "'," + cSysInfoTitle + "='" + _SysInfoTitle + "' " +
" where  " + cSysInfoID + "=" + _SysInfoID + "";
        }

        public string DeleteSql()
        {
            return "Delete " + Tn.Sys_Info + " where " + cSysInfoID + "=" + _SysInfoID + "";
        }
    }
    #endregion

    #region

    public class Sys_Info_Qry : rsQuery
    {
        public Sys_Info_Qry()
            : base()
        {
        }


        public void OpenSysInfo()
        {
            string lcSql = "Select * from  " + Tn.Sys_Info;
            DBConnSql loDBConn = new DBConnSql();
            loDBConn.Open();
            this.OpenFromDataTable(loDBConn.OpenDataTable(lcSql));
            loDBConn.Close();
            loDBConn = null;
        }

        public String SysInfoDesc
        {
            get { return GetString(Sys_Info_info.cSysInfoDesc); }
            //    set { SetField(Sys_Info_info.cSysInfoDesc, value); } 
        }

        public Int64 SysInfoID
        {
            get { return GetInt(Sys_Info_info.cSysInfoID); }
            //    set { SetField(Sys_Info_info.cSysInfoID, value); } 
        }

        public String SysInfoMsg
        {
            get { return GetString(Sys_Info_info.cSysInfoMsg); }
            //    set { SetField(Sys_Info_info.cSysInfoMsg, value); } 
        }

        public String SysInfoSite
        {
            get { return GetString(Sys_Info_info.cSysInfoSite); }
            //    set { SetField(Sys_Info_info.cSysInfoSite, value); } 
        }

        public String SysInfoTitle
        {
            get { return GetString(Sys_Info_info.cSysInfoTitle); }
            //    set { SetField(Sys_Info_info.cSysInfoTitle, value); } 
        }

        public bool GoToID(int piID)
        {
            return GoToID(piID + "");
        }
        public bool GoToID(string pcID)
        {
            return this.GoToRecordByFieldsAndValues(Sys_Info_info.cSysInfoID, pcID);
        }

        static Sys_Info_Qry _SysInfoCache = null;
        public static Sys_Info_Qry SysInfoCache
        {
            get
            {
                if (_SysInfoCache == null)
                {
                    _SysInfoCache = new Sys_Info_Qry();
                    _SysInfoCache.OpenSysInfo();
                }
                return _SysInfoCache;
            }
        }

        public static string GetMsgByMsgCode(string pcMsgCode)
        {
            if (SysInfoCache.GoToID(pcMsgCode))
            {
                return SysInfoCache.SysInfoMsg;
            }
            else
                ThreadLog.LogErr("消息编号：" + pcMsgCode + " 不存在！from Sys_Info_Qry ");
            return "";
        }

    }
    #endregion

}