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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

        #endregion
        public ViewMarketSellers_info() { }

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

        public void CreateTableInfo(DataRow poRow)
        {
            _Age = UtilStr.StrFromObj(poRow[cAge]);
            _EnterMarketDate = UtilStr.StrFromObj(poRow[cEnterMarketDate]);
            _Facia = UtilStr.StrFromObj(poRow[cFacia]);
            _Gender = UtilStr.StrFromObj(poRow[cGender]);
            _IdCard = UtilStr.StrFromObj(poRow[cIdCard]);
            _MarketID = UtilStr.StrFromObj(poRow[cMarketID]);
            _MarketName = UtilStr.StrFromObj(poRow[cMarketName]);
            _MarketSellerName = UtilStr.StrFromObj(poRow[cMarketSellerName]);
            _ResidenceAddress = UtilStr.StrFromObj(poRow[cResidenceAddress]);
            _SellerID = UtilStr.StrFromObj(poRow[cSellerID]);
            _StallName = UtilStr.StrFromObj(poRow[cStallName]);
            _Tel = UtilStr.StrFromObj(poRow[cTel]);
            _TempAddress = UtilStr.StrFromObj(poRow[cTempAddress]);
            _TradeTypeID = UtilStr.StrFromObj(poRow[cTradeTypeID]);
            _TradeTypeName = UtilStr.StrFromObj(poRow[cTradeTypeName]);
        }

        private string _Age = "";
        public string Age
        {
            get { return _Age; }
            set { _Age = value; }
        }

        private string _EnterMarketDate = "";
        public string EnterMarketDate
        {
            get { return _EnterMarketDate; }
            set { _EnterMarketDate = value; }
        }

        private string _Facia = "";
        public string Facia
        {
            get { return _Facia; }
            set { _Facia = value; }
        }

        private string _Gender = "";
        public string Gender
        {
            get { return _Gender; }
            set { _Gender = value; }
        }

        private string _IdCard = "";
        public string IdCard
        {
            get { return _IdCard; }
            set { _IdCard = value; }
        }

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

        private string _MarketName = "";
        public string MarketName
        {
            get { return _MarketName; }
            set { _MarketName = value; }
        }

        private string _MarketSellerName = "";
        public string MarketSellerName
        {
            get { return _MarketSellerName; }
            set { _MarketSellerName = value; }
        }

        private string _ResidenceAddress = "";
        public string ResidenceAddress
        {
            get { return _ResidenceAddress; }
            set { _ResidenceAddress = value; }
        }

        private string _SellerID = "";
        public string SellerID
        {
            get { return _SellerID; }
            set { _SellerID = value; }
        }

        private string _StallName = "";
        public string StallName
        {
            get { return _StallName; }
            set { _StallName = value; }
        }

        private string _Tel = "";
        public string Tel
        {
            get { return _Tel; }
            set { _Tel = value; }
        }

        private string _TempAddress = "";
        public string TempAddress
        {
            get { return _TempAddress; }
            set { _TempAddress = value; }
        }

        private string _TradeTypeID = "";
        public string TradeTypeID
        {
            get { return _TradeTypeID; }
            set { _TradeTypeID = value; }
        }

        private string _TradeTypeName = "";
        public string TradeTypeName
        {
            get { return _TradeTypeName; }
            set { _TradeTypeName = value; }
        }

        [ScriptIgnore]
        public rsXmlNode DataXMLNode
        {
            get
            {
                rsXmlNode loMainNode = new rsXmlNode("ViewMarketSellersRecord", "");
                rsXmlNode loNode = null;
                loNode = new rsXmlNode(cAge, Age);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cEnterMarketDate, EnterMarketDate);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cFacia, Facia);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cGender, Gender);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cIdCard, IdCard);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cMarketID, MarketID);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cMarketName, MarketName);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cMarketSellerName, MarketSellerName);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cResidenceAddress, ResidenceAddress);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cSellerID, SellerID);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cStallName, StallName);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cTel, Tel);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cTempAddress, TempAddress);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cTradeTypeID, TradeTypeID);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cTradeTypeName, TradeTypeName);
                loMainNode.AddChild(loNode);
                return loMainNode;
            }
        }
    }
    #endregion

    #region

    public class ViewMarketSellers_Qry : rsQuery
    {
        public Int64 Age
        {
            get { return GetInt(ViewMarketSellers_info.cAge); }
            //    set { SetField(ViewMarketSellers_info.cAge, value); } 
        }

        public DateTime EnterMarketDate
        {
            get { return GetDateTime(ViewMarketSellers_info.cEnterMarketDate); }
            //    set { SetField(ViewMarketSellers_info.cEnterMarketDate, value); } 
        }

        public String Facia
        {
            get { return GetString(ViewMarketSellers_info.cFacia); }
            //    set { SetField(ViewMarketSellers_info.cFacia, value); } 
        }

        public Int64 Gender
        {
            get { return GetInt(ViewMarketSellers_info.cGender); }
            //    set { SetField(ViewMarketSellers_info.cGender, value); } 
        }

        public String IdCard
        {
            get { return GetString(ViewMarketSellers_info.cIdCard); }
            //    set { SetField(ViewMarketSellers_info.cIdCard, value); } 
        }

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

        public String MarketName
        {
            get { return GetString(ViewMarketSellers_info.cMarketName); }
            //    set { SetField(ViewMarketSellers_info.cMarketName, value); } 
        }

        public String MarketSellerName
        {
            get { return GetString(ViewMarketSellers_info.cMarketSellerName); }
            //    set { SetField(ViewMarketSellers_info.cMarketSellerName, value); } 
        }

        public String ResidenceAddress
        {
            get { return GetString(ViewMarketSellers_info.cResidenceAddress); }
            //    set { SetField(ViewMarketSellers_info.cResidenceAddress, value); } 
        }

        public Int64 SellerID
        {
            get { return GetInt(ViewMarketSellers_info.cSellerID); }
            //    set { SetField(ViewMarketSellers_info.cSellerID, value); } 
        }

        public String StallName
        {
            get { return GetString(ViewMarketSellers_info.cStallName); }
            //    set { SetField(ViewMarketSellers_info.cStallName, value); } 
        }

        public String Tel
        {
            get { return GetString(ViewMarketSellers_info.cTel); }
            //    set { SetField(ViewMarketSellers_info.cTel, value); } 
        }

        public String TempAddress
        {
            get { return GetString(ViewMarketSellers_info.cTempAddress); }
            //    set { SetField(ViewMarketSellers_info.cTempAddress, value); } 
        }

        public Int64 TradeTypeID
        {
            get { return GetInt(ViewMarketSellers_info.cTradeTypeID); }
            //    set { SetField(ViewMarketSellers_info.cTradeTypeID, value); } 
        }

        public String TradeTypeName
        {
            get { return GetString(ViewMarketSellers_info.cTradeTypeName); }
            //    set { SetField(ViewMarketSellers_info.cTradeTypeName, value); } 
        }

    }
    #endregion

}