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

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

   /// <summary> 
   /// 为关键字段： N ;
   /// 自动增长： N;
   /// 数据类型： int;
   /// 数据长度： 4;
   /// 是否允许为空： Y;
   /// 默认值： ;
   /// 描述： 检测人员1学历;
   /// </summary>
    public const string  cInspector1DegreeTypeID = "Inspector1DegreeTypeID";

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

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

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

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

   /// <summary> 
   /// 为关键字段： N ;
   /// 自动增长： N;
   /// 数据类型： int;
   /// 数据长度： 4;
   /// 是否允许为空： Y;
   /// 默认值： ;
   /// 描述： 检测人员2学历;
   /// </summary>
    public const string  cInspector2DegreeTypeID = "Inspector2DegreeTypeID";

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

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

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

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

   /// <summary> 
   /// 为关键字段： N ;
   /// 自动增长： N;
   /// 数据类型： int;
   /// 数据长度： 4;
   /// 是否允许为空： Y;
   /// 默认值： ;
   /// 描述： 检测人员3学历;
   /// </summary>
    public const string  cInspector3DegreeTypeID = "Inspector3DegreeTypeID";

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

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

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

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

   /// <summary> 
   /// 为关键字段： N ;
   /// 自动增长： N;
   /// 数据类型： varchar;
   /// 数据长度： 20;
   /// 是否允许为空： Y;
   /// 默认值： ;
   /// 描述： 检测设备名称;
   /// </summary>
    public const string  cInspectorFacility = "InspectorFacility";

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

   /// <summary> 
   /// 为关键字段： N ;
   /// 自动增长： N;
   /// 数据类型： int;
   /// 数据长度： 4;
   /// 是否允许为空： Y;
   /// 默认值： ;
   /// 描述： 检测场所面积;
   /// </summary>
    public const string  cRoomSize = "RoomSize";

    #endregion       
       public MarketInspectFacility_info(){} 
 
       public MarketInspectFacility_info(DataRow poRow) 
       { 
           CreateTableInfo(poRow); 
       }  
 
        public void CreateTableInfo(DataRow poRow) 
       { 
         _ID=UtilStr.StrFromObj(poRow[cID]);  
         _Inspector1Age=UtilStr.StrFromObj(poRow[cInspector1Age]);  
         _Inspector1DegreeTypeID=UtilStr.StrFromObj(poRow[cInspector1DegreeTypeID]);  
         _Inspector1Gender=UtilStr.StrFromObj(poRow[cInspector1Gender]);  
         _Inspector1Name=UtilStr.StrFromObj(poRow[cInspector1Name]);  
         _Inspector1Tel=UtilStr.StrFromObj(poRow[cInspector1Tel]);  
         _Inspector2Age=UtilStr.StrFromObj(poRow[cInspector2Age]);  
         _Inspector2DegreeTypeID=UtilStr.StrFromObj(poRow[cInspector2DegreeTypeID]);  
         _Inspector2Gender=UtilStr.StrFromObj(poRow[cInspector2Gender]);  
         _Inspector2Name=UtilStr.StrFromObj(poRow[cInspector2Name]);  
         _Inspector2Tel=UtilStr.StrFromObj(poRow[cInspector2Tel]);  
         _Inspector3Age=UtilStr.StrFromObj(poRow[cInspector3Age]);  
         _Inspector3DegreeTypeID=UtilStr.StrFromObj(poRow[cInspector3DegreeTypeID]);  
         _Inspector3Gender=UtilStr.StrFromObj(poRow[cInspector3Gender]);  
         _Inspector3Name=UtilStr.StrFromObj(poRow[cInspector3Name]);  
         _Inspector3Tel=UtilStr.StrFromObj(poRow[cInspector3Tel]);  
         _InspectorCount=UtilStr.StrFromObj(poRow[cInspectorCount]);  
         _InspectorFacility=UtilStr.StrFromObj(poRow[cInspectorFacility]);  
         _MarketID=UtilStr.StrFromObj(poRow[cMarketID]);  
         _RoomSize=UtilStr.StrFromObj(poRow[cRoomSize]);  
         }  
 
 public MarketInspectFacility_info( string pcID, DBConnSql poDBConn) 
  { 
     if ( pcID.Trim().Length > 0 && poDBConn != null) 
     { 
         string lcSql = "select * from " + Tn.MarketInspectFacility + " where ID='"+pcID+"'"; 
        rsQuery loQuery = poDBConn.OpenQuery(lcSql); 
        if (loQuery != null && loQuery.IsOpened && loQuery.RecCount == 1) 
        {  
            loQuery.MoveFirst(); 
            CreateTableInfo(loQuery.CurrentRow); 
        } 
    } 
  } 
        private string _ID="";  
        public string ID  
           {  
               get { return _ID; } 
               set { _ID = value; } 
           } 
 
        private string _Inspector1Age="";  
        public string Inspector1Age  
           {  
               get { return _Inspector1Age; } 
               set { _Inspector1Age = value; } 
           } 
 
        private string _Inspector1DegreeTypeID="";  
        public string Inspector1DegreeTypeID  
           {  
               get { return _Inspector1DegreeTypeID; } 
               set { _Inspector1DegreeTypeID = value; } 
           } 
 
        private string _Inspector1Gender="";  
        public string Inspector1Gender  
           {  
               get { return _Inspector1Gender; } 
               set { _Inspector1Gender = value; } 
           } 
 
        private string _Inspector1Name="";  
        public string Inspector1Name  
           {  
               get { return _Inspector1Name; } 
               set { _Inspector1Name = value; } 
           } 
 
        private string _Inspector1Tel="";  
        public string Inspector1Tel  
           {  
               get { return _Inspector1Tel; } 
               set { _Inspector1Tel = value; } 
           } 
 
        private string _Inspector2Age="";  
        public string Inspector2Age  
           {  
               get { return _Inspector2Age; } 
               set { _Inspector2Age = value; } 
           } 
 
        private string _Inspector2DegreeTypeID="";  
        public string Inspector2DegreeTypeID  
           {  
               get { return _Inspector2DegreeTypeID; } 
               set { _Inspector2DegreeTypeID = value; } 
           } 
 
        private string _Inspector2Gender="";  
        public string Inspector2Gender  
           {  
               get { return _Inspector2Gender; } 
               set { _Inspector2Gender = value; } 
           } 
 
        private string _Inspector2Name="";  
        public string Inspector2Name  
           {  
               get { return _Inspector2Name; } 
               set { _Inspector2Name = value; } 
           } 
 
        private string _Inspector2Tel="";  
        public string Inspector2Tel  
           {  
               get { return _Inspector2Tel; } 
               set { _Inspector2Tel = value; } 
           } 
 
        private string _Inspector3Age="";  
        public string Inspector3Age  
           {  
               get { return _Inspector3Age; } 
               set { _Inspector3Age = value; } 
           } 
 
        private string _Inspector3DegreeTypeID="";  
        public string Inspector3DegreeTypeID  
           {  
               get { return _Inspector3DegreeTypeID; } 
               set { _Inspector3DegreeTypeID = value; } 
           } 
 
        private string _Inspector3Gender="";  
        public string Inspector3Gender  
           {  
               get { return _Inspector3Gender; } 
               set { _Inspector3Gender = value; } 
           } 
 
        private string _Inspector3Name="";  
        public string Inspector3Name  
           {  
               get { return _Inspector3Name; } 
               set { _Inspector3Name = value; } 
           } 
 
        private string _Inspector3Tel="";  
        public string Inspector3Tel  
           {  
               get { return _Inspector3Tel; } 
               set { _Inspector3Tel = value; } 
           } 
 
        private string _InspectorCount="";  
        public string InspectorCount  
           {  
               get { return _InspectorCount; } 
               set { _InspectorCount = value; } 
           } 
 
        private string _InspectorFacility="";  
        public string InspectorFacility  
           {  
               get { return _InspectorFacility; } 
               set { _InspectorFacility = value; } 
           } 
 
        private string _MarketID="";  
        public string MarketID  
           {  
               get { return _MarketID; } 
               set { _MarketID = value; } 
           } 
 
        private string _RoomSize="";  
        public string RoomSize  
           {  
               get { return _RoomSize; } 
               set { _RoomSize = value; } 
           } 
 
     [ScriptIgnore] 
     public rsXmlNode DataXMLNode 
    { 
       get 
       { 
      rsXmlNode loMainNode = new rsXmlNode("MarketInspectFacilityRecord", "");  
      rsXmlNode loNode =null; 
      loNode = new rsXmlNode(cID, ID); 
       loMainNode.AddChild(loNode);  
      loNode = new rsXmlNode(cInspector1Age, Inspector1Age); 
       loMainNode.AddChild(loNode);  
      loNode = new rsXmlNode(cInspector1DegreeTypeID, Inspector1DegreeTypeID); 
       loMainNode.AddChild(loNode);  
      loNode = new rsXmlNode(cInspector1Gender, Inspector1Gender); 
       loMainNode.AddChild(loNode);  
      loNode = new rsXmlNode(cInspector1Name, Inspector1Name); 
       loMainNode.AddChild(loNode);  
      loNode = new rsXmlNode(cInspector1Tel, Inspector1Tel); 
       loMainNode.AddChild(loNode);  
      loNode = new rsXmlNode(cInspector2Age, Inspector2Age); 
       loMainNode.AddChild(loNode);  
      loNode = new rsXmlNode(cInspector2DegreeTypeID, Inspector2DegreeTypeID); 
       loMainNode.AddChild(loNode);  
      loNode = new rsXmlNode(cInspector2Gender, Inspector2Gender); 
       loMainNode.AddChild(loNode);  
      loNode = new rsXmlNode(cInspector2Name, Inspector2Name); 
       loMainNode.AddChild(loNode);  
      loNode = new rsXmlNode(cInspector2Tel, Inspector2Tel); 
       loMainNode.AddChild(loNode);  
      loNode = new rsXmlNode(cInspector3Age, Inspector3Age); 
       loMainNode.AddChild(loNode);  
      loNode = new rsXmlNode(cInspector3DegreeTypeID, Inspector3DegreeTypeID); 
       loMainNode.AddChild(loNode);  
      loNode = new rsXmlNode(cInspector3Gender, Inspector3Gender); 
       loMainNode.AddChild(loNode);  
      loNode = new rsXmlNode(cInspector3Name, Inspector3Name); 
       loMainNode.AddChild(loNode);  
      loNode = new rsXmlNode(cInspector3Tel, Inspector3Tel); 
       loMainNode.AddChild(loNode);  
      loNode = new rsXmlNode(cInspectorCount, InspectorCount); 
       loMainNode.AddChild(loNode);  
      loNode = new rsXmlNode(cInspectorFacility, InspectorFacility); 
       loMainNode.AddChild(loNode);  
      loNode = new rsXmlNode(cMarketID, MarketID); 
       loMainNode.AddChild(loNode);  
      loNode = new rsXmlNode(cRoomSize, RoomSize); 
       loMainNode.AddChild(loNode);  
   return loMainNode ; 
      } 
      } 
         public string InsertSql() 
                   {  
                        return " insert into "+Tn.MarketInspectFacility+" "+ 
 " ("+cInspector1Age+","+cInspector1DegreeTypeID+","+cInspector1Gender+","+cInspector1Name+","+cInspector1Tel+","+cInspector2Age+","+cInspector2DegreeTypeID+","+cInspector2Gender+","+cInspector2Name+","+cInspector2Tel+","+cInspector3Age+","+cInspector3DegreeTypeID+","+cInspector3Gender+","+cInspector3Name+","+cInspector3Tel+","+cInspectorCount+","+cInspectorFacility+","+cMarketID+","+cRoomSize+") "+ 
 " values ("+_Inspector1Age+","+_Inspector1DegreeTypeID+",'"+_Inspector1Gender+"','"+_Inspector1Name+"','"+_Inspector1Tel+"',"+_Inspector2Age+","+_Inspector2DegreeTypeID+",'"+_Inspector2Gender+"','"+_Inspector2Name+"','"+_Inspector2Tel+"',"+_Inspector3Age+","+_Inspector3DegreeTypeID+",'"+_Inspector3Gender+"','"+_Inspector3Name+"','"+_Inspector3Tel+"',"+_InspectorCount+",'"+_InspectorFacility+"','"+_MarketID+"',"+_RoomSize+") " ; 
                   }  
 
        public string UpdateSql() 
                   { 
                        return " update "+Tn.MarketInspectFacility+" "+ 
 " set "+cInspector1Age+"="+_Inspector1Age+","+cInspector1DegreeTypeID+"="+_Inspector1DegreeTypeID+","+cInspector1Gender+"='"+_Inspector1Gender+"',"+cInspector1Name+"='"+_Inspector1Name+"',"+cInspector1Tel+"='"+_Inspector1Tel+"',"+cInspector2Age+"="+_Inspector2Age+","+cInspector2DegreeTypeID+"="+_Inspector2DegreeTypeID+","+cInspector2Gender+"='"+_Inspector2Gender+"',"+cInspector2Name+"='"+_Inspector2Name+"',"+cInspector2Tel+"='"+_Inspector2Tel+"',"+cInspector3Age+"="+_Inspector3Age+","+cInspector3DegreeTypeID+"="+_Inspector3DegreeTypeID+","+cInspector3Gender+"='"+_Inspector3Gender+"',"+cInspector3Name+"='"+_Inspector3Name+"',"+cInspector3Tel+"='"+_Inspector3Tel+"',"+cInspectorCount+"="+_InspectorCount+","+cInspectorFacility+"='"+_InspectorFacility+"',"+cMarketID+"='"+_MarketID+"',"+cRoomSize+"="+_RoomSize+" "+ 
 " where  "+cID+"="+_ID+"" ; 
                   } 
 
        public string DeleteSql() 
                   { 
                        return "Delete "+Tn.MarketInspectFacility+" where "+cID+"="+_ID+"" ; 
                   } 
    } 
    #endregion 

  #region 

    public class MarketInspectFacility_Qry : rsQuery  
    {  
        public Int64 ID  
           {  
               get { return GetInt(MarketInspectFacility_info.cID); } 
           //    set { SetField(MarketInspectFacility_info.cID, value); } 
           } 
 
        public Int64 Inspector1Age  
           {  
               get { return GetInt(MarketInspectFacility_info.cInspector1Age); } 
           //    set { SetField(MarketInspectFacility_info.cInspector1Age, value); } 
           } 
 
        public Int64 Inspector1DegreeTypeID  
           {  
               get { return GetInt(MarketInspectFacility_info.cInspector1DegreeTypeID); } 
           //    set { SetField(MarketInspectFacility_info.cInspector1DegreeTypeID, value); } 
           } 
 
        public Int64 Inspector1Gender  
           {  
               get { return GetInt(MarketInspectFacility_info.cInspector1Gender); } 
           //    set { SetField(MarketInspectFacility_info.cInspector1Gender, value); } 
           } 
 
        public String Inspector1Name  
           {  
               get { return GetString(MarketInspectFacility_info.cInspector1Name); } 
           //    set { SetField(MarketInspectFacility_info.cInspector1Name, value); } 
           } 
 
        public String Inspector1Tel  
           {  
               get { return GetString(MarketInspectFacility_info.cInspector1Tel); } 
           //    set { SetField(MarketInspectFacility_info.cInspector1Tel, value); } 
           } 
 
        public Int64 Inspector2Age  
           {  
               get { return GetInt(MarketInspectFacility_info.cInspector2Age); } 
           //    set { SetField(MarketInspectFacility_info.cInspector2Age, value); } 
           } 
 
        public Int64 Inspector2DegreeTypeID  
           {  
               get { return GetInt(MarketInspectFacility_info.cInspector2DegreeTypeID); } 
           //    set { SetField(MarketInspectFacility_info.cInspector2DegreeTypeID, value); } 
           } 
 
        public Int64 Inspector2Gender  
           {  
               get { return GetInt(MarketInspectFacility_info.cInspector2Gender); } 
           //    set { SetField(MarketInspectFacility_info.cInspector2Gender, value); } 
           } 
 
        public String Inspector2Name  
           {  
               get { return GetString(MarketInspectFacility_info.cInspector2Name); } 
           //    set { SetField(MarketInspectFacility_info.cInspector2Name, value); } 
           } 
 
        public String Inspector2Tel  
           {  
               get { return GetString(MarketInspectFacility_info.cInspector2Tel); } 
           //    set { SetField(MarketInspectFacility_info.cInspector2Tel, value); } 
           } 
 
        public Int64 Inspector3Age  
           {  
               get { return GetInt(MarketInspectFacility_info.cInspector3Age); } 
           //    set { SetField(MarketInspectFacility_info.cInspector3Age, value); } 
           } 
 
        public Int64 Inspector3DegreeTypeID  
           {  
               get { return GetInt(MarketInspectFacility_info.cInspector3DegreeTypeID); } 
           //    set { SetField(MarketInspectFacility_info.cInspector3DegreeTypeID, value); } 
           } 
 
        public Int64 Inspector3Gender  
           {  
               get { return GetInt(MarketInspectFacility_info.cInspector3Gender); } 
           //    set { SetField(MarketInspectFacility_info.cInspector3Gender, value); } 
           } 
 
        public String Inspector3Name  
           {  
               get { return GetString(MarketInspectFacility_info.cInspector3Name); } 
           //    set { SetField(MarketInspectFacility_info.cInspector3Name, value); } 
           } 
 
        public String Inspector3Tel  
           {  
               get { return GetString(MarketInspectFacility_info.cInspector3Tel); } 
           //    set { SetField(MarketInspectFacility_info.cInspector3Tel, value); } 
           } 
 
        public Int64 InspectorCount  
           {  
               get { return GetInt(MarketInspectFacility_info.cInspectorCount); } 
           //    set { SetField(MarketInspectFacility_info.cInspectorCount, value); } 
           } 
 
        public String InspectorFacility  
           {  
               get { return GetString(MarketInspectFacility_info.cInspectorFacility); } 
           //    set { SetField(MarketInspectFacility_info.cInspectorFacility, value); } 
           } 
 
        public String MarketID  
           {  
               get { return GetString(MarketInspectFacility_info.cMarketID); } 
           //    set { SetField(MarketInspectFacility_info.cMarketID, value); } 
           } 
 
        public Int64 RoomSize  
           {  
               get { return GetInt(MarketInspectFacility_info.cRoomSize); } 
           //    set { SetField(MarketInspectFacility_info.cRoomSize, value); } 
           } 
 
    } 
  #endregion 

}