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

   /// <summary> 
   /// 为关键字段： N ;
   /// 自动增长： N;
   /// 数据类型： money;
   /// 数据长度： 8;
   /// 是否允许为空： Y;
   /// 默认值： ;
   /// 描述： 年规管理费;
   /// </summary>
    public const string  cAnnualManageFee = "AnnualManageFee";

   /// <summary> 
   /// 为关键字段： N ;
   /// 自动增长： N;
   /// 数据类型： money;
   /// 数据长度： 8;
   /// 是否允许为空： Y;
   /// 默认值： ;
   /// 描述： 年规摊位费;
   /// </summary>
    public const string  cAnnualStallFee = "AnnualStallFee";

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

   /// <summary> 
   /// 为关键字段： N ;
   /// 自动增长： N;
   /// 数据类型： nvarchar;
   /// 数据长度： 20;
   /// 是否允许为空： Y;
   /// 默认值： ;
   /// 描述： 食品信用安全码;
   /// </summary>
    public const string  cCardIndex = "CardIndex";

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

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

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

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

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

   /// <summary> 
   /// 为关键字段： N ;
   /// 自动增长： N;
   /// 数据类型： nvarchar;
   /// 数据长度： 100;
   /// 是否允许为空： Y;
   /// 默认值： ;
   /// 描述： 营业执照名称;
   /// </summary>
    public const string  cLicenseName = "LicenseName";

   /// <summary> 
   /// 为关键字段： N ;
   /// 自动增长： N;
   /// 数据类型： nvarchar;
   /// 数据长度： 40;
   /// 是否允许为空： Y;
   /// 默认值： ;
   /// 描述： 社会统一信用编码;
   /// </summary>
    public const string  cLicenseNo = "LicenseNo";

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

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

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

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

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

   /// <summary> 
   /// 为关键字段： N ;
   /// 自动增长： N;
   /// 数据类型： int;
   /// 数据长度： 4;
   /// 是否允许为空： Y;
   /// 默认值： ;
   /// 描述： 经营方式(零售/批发);
   /// </summary>
    public const string  cRunningWayTypeID = "RunningWayTypeID";

   /// <summary> 
   /// 为关键字段： N ;
   /// 自动增长： N;
   /// 数据类型： int;
   /// 数据长度： 4;
   /// 是否允许为空： N;
   /// 默认值： ((0));
   /// 描述： 信誉分;
   /// </summary>
    public const string  cScore = "Score";

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

   /// <summary> 
   /// 为关键字段： N ;
   /// 自动增长： N;
   /// 数据类型： int;
   /// 数据长度： 4;
   /// 是否允许为空： Y;
   /// 默认值： ;
   /// 描述： 从业人员1年龄;
   /// </summary>
    public const string  cStaff1Age = "Staff1Age";

   /// <summary> 
   /// 为关键字段： N ;
   /// 自动增长： N;
   /// 数据类型： varchar;
   /// 数据长度： 100;
   /// 是否允许为空： Y;
   /// 默认值： ;
   /// 描述： 从业人员1当前地址;
   /// </summary>
    public const string  cStaff1CurrentAddress = "Staff1CurrentAddress";

   /// <summary> 
   /// 为关键字段： N ;
   /// 自动增长： N;
   /// 数据类型： smallint;
   /// 数据长度： 2;
   /// 是否允许为空： Y;
   /// 默认值： ;
   /// 描述： 从业人员1性别;
   /// </summary>
    public const string  cStaff1Gender = "Staff1Gender";

   /// <summary> 
   /// 为关键字段： N ;
   /// 自动增长： N;
   /// 数据类型： varchar;
   /// 数据长度： 10;
   /// 是否允许为空： Y;
   /// 默认值： ;
   /// 描述： 从业人员1姓名;
   /// </summary>
    public const string  cStaff1Name = "Staff1Name";

   /// <summary> 
   /// 为关键字段： N ;
   /// 自动增长： N;
   /// 数据类型： varchar;
   /// 数据长度： 100;
   /// 是否允许为空： Y;
   /// 默认值： ;
   /// 描述： 从业人员1居住地址;
   /// </summary>
    public const string  cStaff1Residence = "Staff1Residence";

   /// <summary> 
   /// 为关键字段： N ;
   /// 自动增长： N;
   /// 数据类型： int;
   /// 数据长度： 4;
   /// 是否允许为空： Y;
   /// 默认值： ;
   /// 描述： 从业人员2年龄;
   /// </summary>
    public const string  cStaff2Age = "Staff2Age";

   /// <summary> 
   /// 为关键字段： N ;
   /// 自动增长： N;
   /// 数据类型： varchar;
   /// 数据长度： 100;
   /// 是否允许为空： Y;
   /// 默认值： ;
   /// 描述： 从业人员2当前地址;
   /// </summary>
    public const string  cStaff2CurrentAddress = "Staff2CurrentAddress";

   /// <summary> 
   /// 为关键字段： N ;
   /// 自动增长： N;
   /// 数据类型： smallint;
   /// 数据长度： 2;
   /// 是否允许为空： Y;
   /// 默认值： ;
   /// 描述： 从业人员2性别;
   /// </summary>
    public const string  cStaff2Gender = "Staff2Gender";

   /// <summary> 
   /// 为关键字段： N ;
   /// 自动增长： N;
   /// 数据类型： varchar;
   /// 数据长度： 10;
   /// 是否允许为空： Y;
   /// 默认值： ;
   /// 描述： 从业人员2姓名;
   /// </summary>
    public const string  cStaff2Name = "Staff2Name";

   /// <summary> 
   /// 为关键字段： N ;
   /// 自动增长： N;
   /// 数据类型： varchar;
   /// 数据长度： 100;
   /// 是否允许为空： Y;
   /// 默认值： ;
   /// 描述： 从业人员2居住地址;
   /// </summary>
    public const string  cStaff2Residence = "Staff2Residence";

   /// <summary> 
   /// 为关键字段： N ;
   /// 自动增长： N;
   /// 数据类型： int;
   /// 数据长度： 4;
   /// 是否允许为空： Y;
   /// 默认值： ;
   /// 描述： 从业人员3年龄;
   /// </summary>
    public const string  cStaff3Age = "Staff3Age";

   /// <summary> 
   /// 为关键字段： N ;
   /// 自动增长： N;
   /// 数据类型： varchar;
   /// 数据长度： 100;
   /// 是否允许为空： Y;
   /// 默认值： ;
   /// 描述： 从业人员3当前地址;
   /// </summary>
    public const string  cStaff3CurrentAddress = "Staff3CurrentAddress";

   /// <summary> 
   /// 为关键字段： N ;
   /// 自动增长： N;
   /// 数据类型： smallint;
   /// 数据长度： 2;
   /// 是否允许为空： Y;
   /// 默认值： ;
   /// 描述： 从业人员3性别;
   /// </summary>
    public const string  cStaff3Gender = "Staff3Gender";

   /// <summary> 
   /// 为关键字段： N ;
   /// 自动增长： N;
   /// 数据类型： varchar;
   /// 数据长度： 10;
   /// 是否允许为空： Y;
   /// 默认值： ;
   /// 描述： 从业人员3姓名;
   /// </summary>
    public const string  cStaff3Name = "Staff3Name";

   /// <summary> 
   /// 为关键字段： N ;
   /// 自动增长： N;
   /// 数据类型： varchar;
   /// 数据长度： 100;
   /// 是否允许为空： Y;
   /// 默认值： ;
   /// 描述： 从业人员3居住地址;
   /// </summary>
    public const string  cStaff3Residence = "Staff3Residence";

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

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

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

    #endregion       
       public MarketSellers_info(){} 
 
       public MarketSellers_info(DataRow poRow) 
       { 
           CreateTableInfo(poRow); 
       }  
 
        public void CreateTableInfo(DataRow poRow) 
       { 
         _Age=UtilStr.StrFromObj(poRow[cAge]);  
         _AnnualManageFee=UtilStr.StrFromObj(poRow[cAnnualManageFee]);  
         _AnnualStallFee=UtilStr.StrFromObj(poRow[cAnnualStallFee]);  
         _ApparatusTypeID=UtilStr.StrFromObj(poRow[cApparatusTypeID]);  
         _CardIndex=UtilStr.StrFromObj(poRow[cCardIndex]);  
         _EnterMarketDate=UtilStr.StrFromObj(poRow[cEnterMarketDate]);  
         _Facia=UtilStr.StrFromObj(poRow[cFacia]);  
         _Gender=UtilStr.StrFromObj(poRow[cGender]);  
         _IdCard=UtilStr.StrFromObj(poRow[cIdCard]);  
         _IsLock=UtilStr.StrFromObj(poRow[cIsLock]);  
         _LicenseName=UtilStr.StrFromObj(poRow[cLicenseName]);  
         _LicenseNo=UtilStr.StrFromObj(poRow[cLicenseNo]);  
         _MarketID=UtilStr.StrFromObj(poRow[cMarketID]);  
         _Name=UtilStr.StrFromObj(poRow[cName]);  
         _Remark=UtilStr.StrFromObj(poRow[cRemark]);  
         _ResidenceAddress=UtilStr.StrFromObj(poRow[cResidenceAddress]);  
         _RewardRecords=UtilStr.StrFromObj(poRow[cRewardRecords]);  
         _RunningWayTypeID=UtilStr.StrFromObj(poRow[cRunningWayTypeID]);  
         _Score=UtilStr.StrFromObj(poRow[cScore]);  
         _SellerID=UtilStr.StrFromObj(poRow[cSellerID]);  
         _Staff1Age=UtilStr.StrFromObj(poRow[cStaff1Age]);  
         _Staff1CurrentAddress=UtilStr.StrFromObj(poRow[cStaff1CurrentAddress]);  
         _Staff1Gender=UtilStr.StrFromObj(poRow[cStaff1Gender]);  
         _Staff1Name=UtilStr.StrFromObj(poRow[cStaff1Name]);  
         _Staff1Residence=UtilStr.StrFromObj(poRow[cStaff1Residence]);  
         _Staff2Age=UtilStr.StrFromObj(poRow[cStaff2Age]);  
         _Staff2CurrentAddress=UtilStr.StrFromObj(poRow[cStaff2CurrentAddress]);  
         _Staff2Gender=UtilStr.StrFromObj(poRow[cStaff2Gender]);  
         _Staff2Name=UtilStr.StrFromObj(poRow[cStaff2Name]);  
         _Staff2Residence=UtilStr.StrFromObj(poRow[cStaff2Residence]);  
         _Staff3Age=UtilStr.StrFromObj(poRow[cStaff3Age]);  
         _Staff3CurrentAddress=UtilStr.StrFromObj(poRow[cStaff3CurrentAddress]);  
         _Staff3Gender=UtilStr.StrFromObj(poRow[cStaff3Gender]);  
         _Staff3Name=UtilStr.StrFromObj(poRow[cStaff3Name]);  
         _Staff3Residence=UtilStr.StrFromObj(poRow[cStaff3Residence]);  
         _Tel=UtilStr.StrFromObj(poRow[cTel]);  
         _TempAddress=UtilStr.StrFromObj(poRow[cTempAddress]);  
         _TradeTypeID=UtilStr.StrFromObj(poRow[cTradeTypeID]);  
         }  
 
 public MarketSellers_info( string pcSellerID, DBConnSql poDBConn) 
  { 
     if ( pcSellerID.Trim().Length > 0 && poDBConn != null) 
     { 
         string lcSql = "select * from " + Tn.MarketSellers + " where SellerID='"+pcSellerID+"'"; 
        rsQuery loQuery = poDBConn.OpenQuery(lcSql); 
        if (loQuery != null && loQuery.IsOpened && loQuery.RecCount == 1) 
        {  
            loQuery.MoveFirst(); 
            CreateTableInfo(loQuery.CurrentRow); 
        } 
    } 
  } 
        private string _Age="";  
        public string Age  
           {  
               get { return _Age; } 
               set { _Age = value; } 
           } 
 
        private string _AnnualManageFee="";  
        public string AnnualManageFee  
           {  
               get { return _AnnualManageFee; } 
               set { _AnnualManageFee = value; } 
           } 
 
        private string _AnnualStallFee="";  
        public string AnnualStallFee  
           {  
               get { return _AnnualStallFee; } 
               set { _AnnualStallFee = value; } 
           } 
 
        private string _ApparatusTypeID="";  
        public string ApparatusTypeID  
           {  
               get { return _ApparatusTypeID; } 
               set { _ApparatusTypeID = value; } 
           } 
 
        private string _CardIndex="";  
        public string CardIndex  
           {  
               get { return _CardIndex; } 
               set { _CardIndex = 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 _IsLock="";  
        public string IsLock  
           {  
               get { return _IsLock; } 
               set { _IsLock = value; } 
           } 
 
        private string _LicenseName="";  
        public string LicenseName  
           {  
               get { return _LicenseName; } 
               set { _LicenseName = value; } 
           } 
 
        private string _LicenseNo="";  
        public string LicenseNo  
           {  
               get { return _LicenseNo; } 
               set { _LicenseNo = value; } 
           } 
 
        private string _MarketID="";  
        public string MarketID  
           {  
               get { return _MarketID; } 
               set { _MarketID = value; } 
           } 
 
        private string _Name="";  
        public string Name  
           {  
               get { return _Name; } 
               set { _Name = value; } 
           } 
 
        private string _Remark="";  
        public string Remark  
           {  
               get { return _Remark; } 
               set { _Remark = value; } 
           } 
 
        private string _ResidenceAddress="";  
        public string ResidenceAddress  
           {  
               get { return _ResidenceAddress; } 
               set { _ResidenceAddress = value; } 
           } 
 
        private string _RewardRecords="";  
        public string RewardRecords  
           {  
               get { return _RewardRecords; } 
               set { _RewardRecords = value; } 
           } 
 
        private string _RunningWayTypeID="";  
        public string RunningWayTypeID  
           {  
               get { return _RunningWayTypeID; } 
               set { _RunningWayTypeID = value; } 
           } 
 
        private string _Score="";  
        public string Score  
           {  
               get { return _Score; } 
               set { _Score = value; } 
           } 
 
        private string _SellerID="";  
        public string SellerID  
           {  
               get { return _SellerID; } 
               set { _SellerID = value; } 
           } 
 
        private string _Staff1Age="";  
        public string Staff1Age  
           {  
               get { return _Staff1Age; } 
               set { _Staff1Age = value; } 
           } 
 
        private string _Staff1CurrentAddress="";  
        public string Staff1CurrentAddress  
           {  
               get { return _Staff1CurrentAddress; } 
               set { _Staff1CurrentAddress = value; } 
           } 
 
        private string _Staff1Gender="";  
        public string Staff1Gender  
           {  
               get { return _Staff1Gender; } 
               set { _Staff1Gender = value; } 
           } 
 
        private string _Staff1Name="";  
        public string Staff1Name  
           {  
               get { return _Staff1Name; } 
               set { _Staff1Name = value; } 
           } 
 
        private string _Staff1Residence="";  
        public string Staff1Residence  
           {  
               get { return _Staff1Residence; } 
               set { _Staff1Residence = value; } 
           } 
 
        private string _Staff2Age="";  
        public string Staff2Age  
           {  
               get { return _Staff2Age; } 
               set { _Staff2Age = value; } 
           } 
 
        private string _Staff2CurrentAddress="";  
        public string Staff2CurrentAddress  
           {  
               get { return _Staff2CurrentAddress; } 
               set { _Staff2CurrentAddress = value; } 
           } 
 
        private string _Staff2Gender="";  
        public string Staff2Gender  
           {  
               get { return _Staff2Gender; } 
               set { _Staff2Gender = value; } 
           } 
 
        private string _Staff2Name="";  
        public string Staff2Name  
           {  
               get { return _Staff2Name; } 
               set { _Staff2Name = value; } 
           } 
 
        private string _Staff2Residence="";  
        public string Staff2Residence  
           {  
               get { return _Staff2Residence; } 
               set { _Staff2Residence = value; } 
           } 
 
        private string _Staff3Age="";  
        public string Staff3Age  
           {  
               get { return _Staff3Age; } 
               set { _Staff3Age = value; } 
           } 
 
        private string _Staff3CurrentAddress="";  
        public string Staff3CurrentAddress  
           {  
               get { return _Staff3CurrentAddress; } 
               set { _Staff3CurrentAddress = value; } 
           } 
 
        private string _Staff3Gender="";  
        public string Staff3Gender  
           {  
               get { return _Staff3Gender; } 
               set { _Staff3Gender = value; } 
           } 
 
        private string _Staff3Name="";  
        public string Staff3Name  
           {  
               get { return _Staff3Name; } 
               set { _Staff3Name = value; } 
           } 
 
        private string _Staff3Residence="";  
        public string Staff3Residence  
           {  
               get { return _Staff3Residence; } 
               set { _Staff3Residence = 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; } 
           } 
 
     [ScriptIgnore] 
     public rsXmlNode DataXMLNode 
    { 
       get 
       { 
      rsXmlNode loMainNode = new rsXmlNode("MarketSellersRecord", "");  
      rsXmlNode loNode =null; 
      loNode = new rsXmlNode(cAge, Age); 
       loMainNode.AddChild(loNode);  
      loNode = new rsXmlNode(cAnnualManageFee, AnnualManageFee); 
       loMainNode.AddChild(loNode);  
      loNode = new rsXmlNode(cAnnualStallFee, AnnualStallFee); 
       loMainNode.AddChild(loNode);  
      loNode = new rsXmlNode(cApparatusTypeID, ApparatusTypeID); 
       loMainNode.AddChild(loNode);  
      loNode = new rsXmlNode(cCardIndex, CardIndex); 
       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(cIsLock, IsLock); 
       loMainNode.AddChild(loNode);  
      loNode = new rsXmlNode(cLicenseName, LicenseName); 
       loMainNode.AddChild(loNode);  
      loNode = new rsXmlNode(cLicenseNo, LicenseNo); 
       loMainNode.AddChild(loNode);  
      loNode = new rsXmlNode(cMarketID, MarketID); 
       loMainNode.AddChild(loNode);  
      loNode = new rsXmlNode(cName, Name); 
       loMainNode.AddChild(loNode);  
      loNode = new rsXmlNode(cRemark, Remark); 
       loMainNode.AddChild(loNode);  
      loNode = new rsXmlNode(cResidenceAddress, ResidenceAddress); 
       loMainNode.AddChild(loNode);  
      loNode = new rsXmlNode(cRewardRecords, RewardRecords); 
       loMainNode.AddChild(loNode);  
      loNode = new rsXmlNode(cRunningWayTypeID, RunningWayTypeID); 
       loMainNode.AddChild(loNode);  
      loNode = new rsXmlNode(cScore, Score); 
       loMainNode.AddChild(loNode);  
      loNode = new rsXmlNode(cSellerID, SellerID); 
       loMainNode.AddChild(loNode);  
      loNode = new rsXmlNode(cStaff1Age, Staff1Age); 
       loMainNode.AddChild(loNode);  
      loNode = new rsXmlNode(cStaff1CurrentAddress, Staff1CurrentAddress); 
       loMainNode.AddChild(loNode);  
      loNode = new rsXmlNode(cStaff1Gender, Staff1Gender); 
       loMainNode.AddChild(loNode);  
      loNode = new rsXmlNode(cStaff1Name, Staff1Name); 
       loMainNode.AddChild(loNode);  
      loNode = new rsXmlNode(cStaff1Residence, Staff1Residence); 
       loMainNode.AddChild(loNode);  
      loNode = new rsXmlNode(cStaff2Age, Staff2Age); 
       loMainNode.AddChild(loNode);  
      loNode = new rsXmlNode(cStaff2CurrentAddress, Staff2CurrentAddress); 
       loMainNode.AddChild(loNode);  
      loNode = new rsXmlNode(cStaff2Gender, Staff2Gender); 
       loMainNode.AddChild(loNode);  
      loNode = new rsXmlNode(cStaff2Name, Staff2Name); 
       loMainNode.AddChild(loNode);  
      loNode = new rsXmlNode(cStaff2Residence, Staff2Residence); 
       loMainNode.AddChild(loNode);  
      loNode = new rsXmlNode(cStaff3Age, Staff3Age); 
       loMainNode.AddChild(loNode);  
      loNode = new rsXmlNode(cStaff3CurrentAddress, Staff3CurrentAddress); 
       loMainNode.AddChild(loNode);  
      loNode = new rsXmlNode(cStaff3Gender, Staff3Gender); 
       loMainNode.AddChild(loNode);  
      loNode = new rsXmlNode(cStaff3Name, Staff3Name); 
       loMainNode.AddChild(loNode);  
      loNode = new rsXmlNode(cStaff3Residence, Staff3Residence); 
       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);  
   return loMainNode ; 
      } 
      } 
         public string InsertSql() 
                   {  
                        return " insert into "+Tn.MarketSellers+" "+ 
 " ("+cAge+","+cAnnualManageFee+","+cAnnualStallFee+","+cApparatusTypeID+","+cCardIndex+","+cEnterMarketDate+","+cFacia+","+cGender+","+cIdCard+","+cIsLock+","+cLicenseName+","+cLicenseNo+","+cMarketID+","+cName+","+cRemark+","+cResidenceAddress+","+cRewardRecords+","+cRunningWayTypeID+","+cScore+","+cStaff1Age+","+cStaff1CurrentAddress+","+cStaff1Gender+","+cStaff1Name+","+cStaff1Residence+","+cStaff2Age+","+cStaff2CurrentAddress+","+cStaff2Gender+","+cStaff2Name+","+cStaff2Residence+","+cStaff3Age+","+cStaff3CurrentAddress+","+cStaff3Gender+","+cStaff3Name+","+cStaff3Residence+","+cTel+","+cTempAddress+","+cTradeTypeID+") "+ 
 " values ("+_Age+","+_AnnualManageFee+","+_AnnualStallFee+","+_ApparatusTypeID+",'"+_CardIndex+"','"+_EnterMarketDate+"','"+_Facia+"','"+_Gender+"','"+_IdCard+"','"+_IsLock+"','"+_LicenseName+"','"+_LicenseNo+"','"+_MarketID+"','"+_Name+"','"+_Remark+"','"+_ResidenceAddress+"','"+_RewardRecords+"',"+_RunningWayTypeID+","+_Score+","+_Staff1Age+",'"+_Staff1CurrentAddress+"','"+_Staff1Gender+"','"+_Staff1Name+"','"+_Staff1Residence+"',"+_Staff2Age+",'"+_Staff2CurrentAddress+"','"+_Staff2Gender+"','"+_Staff2Name+"','"+_Staff2Residence+"',"+_Staff3Age+",'"+_Staff3CurrentAddress+"','"+_Staff3Gender+"','"+_Staff3Name+"','"+_Staff3Residence+"','"+_Tel+"','"+_TempAddress+"',"+_TradeTypeID+") " ; 
                   }  
 
        public string UpdateSql() 
                   { 
                        return " update "+Tn.MarketSellers+" "+ 
 " set "+cAge+"="+_Age+","+cAnnualManageFee+"="+_AnnualManageFee+","+cAnnualStallFee+"="+_AnnualStallFee+","+cApparatusTypeID+"="+_ApparatusTypeID+","+cCardIndex+"='"+_CardIndex+"',"+cEnterMarketDate+"='"+_EnterMarketDate+"',"+cFacia+"='"+_Facia+"',"+cGender+"='"+_Gender+"',"+cIdCard+"='"+_IdCard+"',"+cIsLock+"='"+_IsLock+"',"+cLicenseName+"='"+_LicenseName+"',"+cLicenseNo+"='"+_LicenseNo+"',"+cMarketID+"='"+_MarketID+"',"+cName+"='"+_Name+"',"+cRemark+"='"+_Remark+"',"+cResidenceAddress+"='"+_ResidenceAddress+"',"+cRewardRecords+"='"+_RewardRecords+"',"+cRunningWayTypeID+"="+_RunningWayTypeID+","+cScore+"="+_Score+","+cStaff1Age+"="+_Staff1Age+","+cStaff1CurrentAddress+"='"+_Staff1CurrentAddress+"',"+cStaff1Gender+"='"+_Staff1Gender+"',"+cStaff1Name+"='"+_Staff1Name+"',"+cStaff1Residence+"='"+_Staff1Residence+"',"+cStaff2Age+"="+_Staff2Age+","+cStaff2CurrentAddress+"='"+_Staff2CurrentAddress+"',"+cStaff2Gender+"='"+_Staff2Gender+"',"+cStaff2Name+"='"+_Staff2Name+"',"+cStaff2Residence+"='"+_Staff2Residence+"',"+cStaff3Age+"="+_Staff3Age+","+cStaff3CurrentAddress+"='"+_Staff3CurrentAddress+"',"+cStaff3Gender+"='"+_Staff3Gender+"',"+cStaff3Name+"='"+_Staff3Name+"',"+cStaff3Residence+"='"+_Staff3Residence+"',"+cTel+"='"+_Tel+"',"+cTempAddress+"='"+_TempAddress+"',"+cTradeTypeID+"="+_TradeTypeID+" "+ 
 " where  "+cSellerID+"="+_SellerID+"" ; 
                   } 
 
        public string DeleteSql() 
                   { 
                        return "Delete "+Tn.MarketSellers+" where "+cSellerID+"="+_SellerID+"" ; 
                   } 
    } 
    #endregion 

  #region 

    public class MarketSellers_Qry : rsQuery  
    {  
        public Int64 Age  
           {  
               get { return GetInt(MarketSellers_info.cAge); } 
           //    set { SetField(MarketSellers_info.cAge, value); } 
           } 
 
        public Decimal AnnualManageFee  
           {  
               get { return GetDecimal(MarketSellers_info.cAnnualManageFee); } 
           //    set { SetField(MarketSellers_info.cAnnualManageFee, value); } 
           } 
 
        public Decimal AnnualStallFee  
           {  
               get { return GetDecimal(MarketSellers_info.cAnnualStallFee); } 
           //    set { SetField(MarketSellers_info.cAnnualStallFee, value); } 
           } 
 
        public Int64 ApparatusTypeID  
           {  
               get { return GetInt(MarketSellers_info.cApparatusTypeID); } 
           //    set { SetField(MarketSellers_info.cApparatusTypeID, value); } 
           } 
 
        public String CardIndex  
           {  
               get { return GetString(MarketSellers_info.cCardIndex); } 
           //    set { SetField(MarketSellers_info.cCardIndex, value); } 
           } 
 
        public DateTime EnterMarketDate  
           {  
               get { return GetDateTime(MarketSellers_info.cEnterMarketDate); } 
           //    set { SetField(MarketSellers_info.cEnterMarketDate, value); } 
           } 
 
        public String Facia  
           {  
               get { return GetString(MarketSellers_info.cFacia); } 
           //    set { SetField(MarketSellers_info.cFacia, value); } 
           } 
 
        public Int64 Gender  
           {  
               get { return GetInt(MarketSellers_info.cGender); } 
           //    set { SetField(MarketSellers_info.cGender, value); } 
           } 
 
        public String IdCard  
           {  
               get { return GetString(MarketSellers_info.cIdCard); } 
           //    set { SetField(MarketSellers_info.cIdCard, value); } 
           } 
 
        public Boolean IsLock  
           {  
               get { return GetBool(MarketSellers_info.cIsLock); } 
           //    set { SetField(MarketSellers_info.cIsLock, value); } 
           } 
 
        public String LicenseName  
           {  
               get { return GetString(MarketSellers_info.cLicenseName); } 
           //    set { SetField(MarketSellers_info.cLicenseName, value); } 
           } 
 
        public String LicenseNo  
           {  
               get { return GetString(MarketSellers_info.cLicenseNo); } 
           //    set { SetField(MarketSellers_info.cLicenseNo, value); } 
           } 
 
        public String MarketID  
           {  
               get { return GetString(MarketSellers_info.cMarketID); } 
           //    set { SetField(MarketSellers_info.cMarketID, value); } 
           } 
 
        public String Name  
           {  
               get { return GetString(MarketSellers_info.cName); } 
           //    set { SetField(MarketSellers_info.cName, value); } 
           } 
 
        public String Remark  
           {  
               get { return GetString(MarketSellers_info.cRemark); } 
           //    set { SetField(MarketSellers_info.cRemark, value); } 
           } 
 
        public String ResidenceAddress  
           {  
               get { return GetString(MarketSellers_info.cResidenceAddress); } 
           //    set { SetField(MarketSellers_info.cResidenceAddress, value); } 
           } 
 
        public String RewardRecords  
           {  
               get { return GetString(MarketSellers_info.cRewardRecords); } 
           //    set { SetField(MarketSellers_info.cRewardRecords, value); } 
           } 
 
        public Int64 RunningWayTypeID  
           {  
               get { return GetInt(MarketSellers_info.cRunningWayTypeID); } 
           //    set { SetField(MarketSellers_info.cRunningWayTypeID, value); } 
           } 
 
        public Int64 Score  
           {  
               get { return GetInt(MarketSellers_info.cScore); } 
           //    set { SetField(MarketSellers_info.cScore, value); } 
           } 
 
        public Int64 SellerID  
           {  
               get { return GetInt(MarketSellers_info.cSellerID); } 
           //    set { SetField(MarketSellers_info.cSellerID, value); } 
           } 
 
        public Int64 Staff1Age  
           {  
               get { return GetInt(MarketSellers_info.cStaff1Age); } 
           //    set { SetField(MarketSellers_info.cStaff1Age, value); } 
           } 
 
        public String Staff1CurrentAddress  
           {  
               get { return GetString(MarketSellers_info.cStaff1CurrentAddress); } 
           //    set { SetField(MarketSellers_info.cStaff1CurrentAddress, value); } 
           } 
 
        public Int64 Staff1Gender  
           {  
               get { return GetInt(MarketSellers_info.cStaff1Gender); } 
           //    set { SetField(MarketSellers_info.cStaff1Gender, value); } 
           } 
 
        public String Staff1Name  
           {  
               get { return GetString(MarketSellers_info.cStaff1Name); } 
           //    set { SetField(MarketSellers_info.cStaff1Name, value); } 
           } 
 
        public String Staff1Residence  
           {  
               get { return GetString(MarketSellers_info.cStaff1Residence); } 
           //    set { SetField(MarketSellers_info.cStaff1Residence, value); } 
           } 
 
        public Int64 Staff2Age  
           {  
               get { return GetInt(MarketSellers_info.cStaff2Age); } 
           //    set { SetField(MarketSellers_info.cStaff2Age, value); } 
           } 
 
        public String Staff2CurrentAddress  
           {  
               get { return GetString(MarketSellers_info.cStaff2CurrentAddress); } 
           //    set { SetField(MarketSellers_info.cStaff2CurrentAddress, value); } 
           } 
 
        public Int64 Staff2Gender  
           {  
               get { return GetInt(MarketSellers_info.cStaff2Gender); } 
           //    set { SetField(MarketSellers_info.cStaff2Gender, value); } 
           } 
 
        public String Staff2Name  
           {  
               get { return GetString(MarketSellers_info.cStaff2Name); } 
           //    set { SetField(MarketSellers_info.cStaff2Name, value); } 
           } 
 
        public String Staff2Residence  
           {  
               get { return GetString(MarketSellers_info.cStaff2Residence); } 
           //    set { SetField(MarketSellers_info.cStaff2Residence, value); } 
           } 
 
        public Int64 Staff3Age  
           {  
               get { return GetInt(MarketSellers_info.cStaff3Age); } 
           //    set { SetField(MarketSellers_info.cStaff3Age, value); } 
           } 
 
        public String Staff3CurrentAddress  
           {  
               get { return GetString(MarketSellers_info.cStaff3CurrentAddress); } 
           //    set { SetField(MarketSellers_info.cStaff3CurrentAddress, value); } 
           } 
 
        public Int64 Staff3Gender  
           {  
               get { return GetInt(MarketSellers_info.cStaff3Gender); } 
           //    set { SetField(MarketSellers_info.cStaff3Gender, value); } 
           } 
 
        public String Staff3Name  
           {  
               get { return GetString(MarketSellers_info.cStaff3Name); } 
           //    set { SetField(MarketSellers_info.cStaff3Name, value); } 
           } 
 
        public String Staff3Residence  
           {  
               get { return GetString(MarketSellers_info.cStaff3Residence); } 
           //    set { SetField(MarketSellers_info.cStaff3Residence, value); } 
           } 
 
        public String Tel  
           {  
               get { return GetString(MarketSellers_info.cTel); } 
           //    set { SetField(MarketSellers_info.cTel, value); } 
           } 
 
        public String TempAddress  
           {  
               get { return GetString(MarketSellers_info.cTempAddress); } 
           //    set { SetField(MarketSellers_info.cTempAddress, value); } 
           } 
 
        public Int64 TradeTypeID  
           {  
               get { return GetInt(MarketSellers_info.cTradeTypeID); } 
           //    set { SetField(MarketSellers_info.cTradeTypeID, value); } 
           } 
 
    } 
  #endregion 

}