using System; 
using System.Collections.Generic; 
using System.Text; 
using System.Data; 
using SysBaseLibs; 
using System.Web.Script.Serialization;
namespace SysDataLibs.TableClass
{
    #region      MarketStatute
    public class MarketStatute_info : ITableInfo
    {
        #region      MarketStatute表 字段信息
        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： char;
        /// 数据长度： 10;
        /// 是否允许为空： N;
        /// 默认值： ;
        /// 描述： 市场编号;
        /// </summary>
        public const string cMarketID = "MarketID";

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： ntext;
        /// 数据长度： 16;
        /// 是否允许为空： N;
        /// 默认值： ;
        /// 描述： 制度内容;
        /// </summary>
        public const string cStatuteContent = "StatuteContent";

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

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

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

        #endregion
        public MarketStatute_info() { }

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

        public void CreateTableInfo(DataRow poRow)
        {
            _MarketID = UtilStr.StrFromObj(poRow[cMarketID]);
            _StatuteContent = UtilStr.StrFromObj(poRow[cStatuteContent]);
            _StatuteID = UtilStr.StrFromObj(poRow[cStatuteID]);
            _StatuteTitle = UtilStr.StrFromObj(poRow[cStatuteTitle]);
            _StatuteType = UtilStr.StrFromObj(poRow[cStatuteType]);
        }

        public MarketStatute_info(string pcStatuteID, DBConnSql poDBConn)
        {
            if (pcStatuteID.Trim().Length > 0 && poDBConn != null)
            {
                string lcSql = "select * from " + Tn.MarketStatute + " where StatuteID='" + pcStatuteID + "'";
                rsQuery loQuery = poDBConn.OpenQuery(lcSql);
                if (loQuery != null && loQuery.IsOpened && loQuery.RecCount == 1)
                {
                    loQuery.MoveFirst();
                    CreateTableInfo(loQuery.CurrentRow);
                }
            }
        }
        private string _MarketID = "";
        public string MarketID
        {
            get { return _MarketID; }
            set { _MarketID = value; }
        }

        private string _StatuteContent = "";
        public string StatuteContent
        {
            get { return _StatuteContent; }
            set { _StatuteContent = value; }
        }

        private string _StatuteID = "";
        public string StatuteID
        {
            get { return _StatuteID; }
            set { _StatuteID = value; }
        }

        private string _StatuteTitle = "";
        public string StatuteTitle
        {
            get { return _StatuteTitle; }
            set { _StatuteTitle = value; }
        }

        private string _StatuteType = "";
        public string StatuteType
        {
            get { return _StatuteType; }
            set { _StatuteType = value; }
        }

        [ScriptIgnore]
        public rsXmlNode DataXMLNode
        {
            get
            {
                rsXmlNode loMainNode = new rsXmlNode("MarketStatuteRecord", "");
                rsXmlNode loNode = null;
                loNode = new rsXmlNode(cMarketID, MarketID);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cStatuteContent, StatuteContent);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cStatuteID, StatuteID);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cStatuteTitle, StatuteTitle);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cStatuteType, StatuteType);
                loMainNode.AddChild(loNode);
                return loMainNode;
            }
        }
        public string InsertSql()
        {
            return " insert into " + Tn.MarketStatute + " " +
" (" + cMarketID + "," + cStatuteContent + "," + cStatuteTitle + "," + cStatuteType + ") " +
" values ('" + _MarketID + "','" + _StatuteContent + "','" + _StatuteTitle + "','" + _StatuteType + "') ";
        }

        public string UpdateSql()
        {
            return " update " + Tn.MarketStatute + " " +
" set " + cMarketID + "='" + _MarketID + "'," + cStatuteContent + "='" + _StatuteContent + "'," + cStatuteTitle + "='" + _StatuteTitle + "'," + cStatuteType + "='" + _StatuteType + "' " +
" where  " + cStatuteID + "=" + _StatuteID + "";
        }

        public string DeleteSql()
        {
            return "Delete " + Tn.MarketStatute + " where " + cStatuteID + "=" + _StatuteID + "";
        }
    }
    #endregion

    #region

    public class MarketStatute_Qry : rsQuery
    {
        public String MarketID
        {
            get { return GetString(MarketStatute_info.cMarketID); }
            //    set { SetField(MarketStatute_info.cMarketID, value); } 
        }

        public String StatuteContent
        {
            get { return GetString(MarketStatute_info.cStatuteContent); }
            //    set { SetField(MarketStatute_info.cStatuteContent, value); } 
        }

        public Int64 StatuteID
        {
            get { return GetInt(MarketStatute_info.cStatuteID); }
            //    set { SetField(MarketStatute_info.cStatuteID, value); } 
        }

        public String StatuteTitle
        {
            get { return GetString(MarketStatute_info.cStatuteTitle); }
            //    set { SetField(MarketStatute_info.cStatuteTitle, value); } 
        }

        public Boolean StatuteType
        {
            get { return GetBool(MarketStatute_info.cStatuteType); }
            //    set { SetField(MarketStatute_info.cStatuteType, value); } 
        }

    }
    #endregion

}