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

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： nchar;
        /// 数据长度： 2;
        /// 是否允许为空： N;
        /// 默认值： (N'N');
        /// 描述： 是否已读;
        /// </summary>
        public const string cIsRead = "IsRead";

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

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

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： nvarchar;
        /// 数据长度： 200;
        /// 是否允许为空： N;
        /// 默认值： ;
        /// 描述： 违规内容;
        /// </summary>
        public const string cLogType = "LogType";

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

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

        /// <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";

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

        #endregion
        public MarketViolations_info() { }

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

        public void CreateTableInfo(DataRow poRow)
        {
            _Checher = UtilStr.StrFromObj(poRow[cChecher]);
            _IsRead = UtilStr.StrFromObj(poRow[cIsRead]);
            _LogContent = UtilStr.StrFromObj(poRow[cLogContent]);
            _LogDate = UtilStr.StrFromObj(poRow[cLogDate]);
            _LogType = UtilStr.StrFromObj(poRow[cLogType]);
            _MarketID = UtilStr.StrFromObj(poRow[cMarketID]);
            _Result = UtilStr.StrFromObj(poRow[cResult]);
            _TimeCreated = UtilStr.StrFromObj(poRow[cTimeCreated]);
            _TimeLastMod = UtilStr.StrFromObj(poRow[cTimeLastMod]);
            _UserIDLastMod = UtilStr.StrFromObj(poRow[cUserIDLastMod]);
            _ViolationsNo = UtilStr.StrFromObj(poRow[cViolationsNo]);
        }

        public MarketViolations_info(string pcViolationsNo, DBConnSql poDBConn)
        {
            if (pcViolationsNo.Trim().Length > 0 && poDBConn != null)
            {
                string lcSql = "select * from " + Tn.MarketViolations + " where ViolationsNo='" + pcViolationsNo + "'";
                rsQuery loQuery = poDBConn.OpenQuery(lcSql);
                if (loQuery != null && loQuery.IsOpened && loQuery.RecCount == 1)
                {
                    loQuery.MoveFirst();
                    CreateTableInfo(loQuery.CurrentRow);
                }
            }
        }
        private string _Checher = "";
        public string Checher
        {
            get { return _Checher; }
            set { _Checher = value; }
        }

        private string _IsRead = "";
        public string IsRead
        {
            get { return _IsRead; }
            set { _IsRead = value; }
        }

        private string _LogContent = "";
        public string LogContent
        {
            get { return _LogContent; }
            set { _LogContent = value; }
        }

        private string _LogDate = "";
        public string LogDate
        {
            get { return _LogDate; }
            set { _LogDate = value; }
        }

        private string _LogType = "";
        public string LogType
        {
            get { return _LogType; }
            set { _LogType = value; }
        }

        private string _MarketID = "";
        public string MarketID
        {
            get { return _MarketID; }
            set { _MarketID = value; }
        }

        private string _Result = "";
        public string Result
        {
            get { return _Result; }
            set { _Result = 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; }
        }

        private string _ViolationsNo = "";
        public string ViolationsNo
        {
            get { return _ViolationsNo; }
            set { _ViolationsNo = value; }
        }

        [ScriptIgnore]
        public rsXmlNode DataXMLNode
        {
            get
            {
                rsXmlNode loMainNode = new rsXmlNode("MarketViolationsRecord", "");
                rsXmlNode loNode = null;
                loNode = new rsXmlNode(cChecher, Checher);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cIsRead, IsRead);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cLogContent, LogContent);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cLogDate, LogDate);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cLogType, LogType);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cMarketID, MarketID);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cResult, Result);
                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);
                loNode = new rsXmlNode(cViolationsNo, ViolationsNo);
                loMainNode.AddChild(loNode);
                return loMainNode;
            }
        }
        public string InsertSql()
        {
            return " insert into " + Tn.MarketViolations + " " +
                    " (" + cChecher + "," + cIsRead + "," + cLogContent + "," + cLogDate + "," + cLogType + "," + cMarketID + "," + cResult + "," + cTimeCreated + "," + cTimeLastMod + "," + cUserIDLastMod + "," + cViolationsNo + ") " +
                    " values ('" + _Checher + "','" + _IsRead + "','" + _LogContent + "','" + _LogDate + "','" + _LogType + "','" + _MarketID + "','" + _Result + "','" + _TimeCreated + "','" + _TimeLastMod + "','" + _UserIDLastMod + "','" + _ViolationsNo + "') ";
        }

        public string UpdateSql()
        {
            return " update " + Tn.MarketViolations + " " +
                    " set " + cChecher + "='" + _Checher + "'," + cIsRead + "='" + _IsRead + "'," + cLogContent + "='" + _LogContent + "'," + cLogDate + "='" + _LogDate + "'," + cLogType + "='" + _LogType + "'," + cMarketID + "='" + _MarketID + "'," + cResult + "='" + _Result + "'," + cTimeCreated + "='" + _TimeCreated + "'," + cTimeLastMod + "='" + _TimeLastMod + "'," + cUserIDLastMod + "='" + _UserIDLastMod + "' " +
                    " where  " + cViolationsNo + "='" + _ViolationsNo + "'";
        }

        public string DeleteSql()
        {
            return "Delete " + Tn.MarketViolations + " where " + cViolationsNo + "='" + _ViolationsNo + "'";
        }
    }
    #endregion

    #region

    public class MarketViolations_Qry : rsQuery
    {
        public String Checher
        {
            get { return GetString(MarketViolations_info.cChecher); }
            //    set { SetField(MarketViolations_info.cChecher, value); } 
        }

        public Boolean IsRead
        {
            get { return GetBool(MarketViolations_info.cIsRead); }
            //    set { SetField(MarketViolations_info.cIsRead, value); } 
        }

        public String LogContent
        {
            get { return GetString(MarketViolations_info.cLogContent); }
            //    set { SetField(MarketViolations_info.cLogContent, value); } 
        }

        public DateTime LogDate
        {
            get { return GetDateTime(MarketViolations_info.cLogDate); }
            //    set { SetField(MarketViolations_info.cLogDate, value); } 
        }

        public String LogType
        {
            get { return GetString(MarketViolations_info.cLogType); }
            //    set { SetField(MarketViolations_info.cLogType, value); } 
        }

        public String MarketID
        {
            get { return GetString(MarketViolations_info.cMarketID); }
            //    set { SetField(MarketViolations_info.cMarketID, value); } 
        }

        public String Result
        {
            get { return GetString(MarketViolations_info.cResult); }
            //    set { SetField(MarketViolations_info.cResult, value); } 
        }

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

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

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

        public Byte[] ViolationsNo
        {
            get { return GetBytes(MarketViolations_info.cViolationsNo); }
            //    set { SetField(MarketViolations_info.cViolationsNo, value); } 
        }

    }
    #endregion

}