using System; 
using System.Collections.Generic; 
using System.Text; 
using System.Data; 
using SysBaseLibs; 
using System.Web.Script.Serialization;
 namespace SysDataLibs.TableClass  
 {  
    #region      SysRegisters  
     public class SysRegisters_info : ITableInfo
     {
         #region      SysRegisters表 字段信息
         /// <summary> 
         /// 为关键字段： N ;
         /// 自动增长： N;
         /// 数据类型： nchar;
         /// 数据长度： 2;
         /// 是否允许为空： N;
         /// 默认值： (N'N');
         /// 描述： 是否审核;
         /// </summary>
         public const string cIsAudit = "IsAudit";

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

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

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

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

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

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

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

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

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

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

         /// <summary> 
         /// 为关键字段： N ;
         /// 自动增长： N;
         /// 数据类型： varchar;
         /// 数据长度： 19;
         /// 是否允许为空： N;
         /// 默认值： ;
         /// 描述： 用户编号;
         /// </summary>
         public const string cUserCode = "UserCode";

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

         /// <summary> 
         /// 为关键字段： N ;
         /// 自动增长： N;
         /// 数据类型： smalldatetime;
         /// 数据长度： 4;
         /// 是否允许为空： N;
         /// 默认值： ;
         /// 描述： 截止时间;
         /// </summary>
         public const string cValidEndTime = "ValidEndTime";

         /// <summary> 
         /// 为关键字段： N ;
         /// 自动增长： N;
         /// 数据类型： smalldatetime;
         /// 数据长度： 4;
         /// 是否允许为空： N;
         /// 默认值： ;
         /// 描述： 发证时间;
         /// </summary>
         public const string cValidStartTime = "ValidStartTime";

         /// <summary> 
         /// 为关键字段： N ;
         /// 自动增长： N;
         /// 数据类型： nvarchar;
         /// 数据长度： 200;
         /// 是否允许为空： N;
         /// 默认值： ;
         /// 描述： 工商注册号;
         /// </summary>
         public const string cWarrantNumber = "WarrantNumber";

         #endregion
         public SysRegisters_info() { }

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

         public void CreateTableInfo(DataRow poRow)
         {
             _IsAudit = UtilStr.StrFromObj(poRow[cIsAudit]);
             _LinkTel = UtilStr.StrFromObj(poRow[cLinkTel]);
             _MarketID = UtilStr.StrFromObj(poRow[cMarketID]);
             _MarketName = UtilStr.StrFromObj(poRow[cMarketName]);
             _Password = UtilStr.StrFromObj(poRow[cPassword]);
             _RegionID = UtilStr.StrFromObj(poRow[cRegionID]);
             _RegionName = UtilStr.StrFromObj(poRow[cRegionName]);
             _RegisterDate = UtilStr.StrFromObj(poRow[cRegisterDate]);
             _RegisterID = UtilStr.StrFromObj(poRow[cRegisterID]);
             _RegisterIP = UtilStr.StrFromObj(poRow[cRegisterIP]);
             _SystemID = UtilStr.StrFromObj(poRow[cSystemID]);
             _UserCode = UtilStr.StrFromObj(poRow[cUserCode]);
             _UserName = UtilStr.StrFromObj(poRow[cUserName]);
             _ValidEndTime = UtilStr.StrFromObj(poRow[cValidEndTime]);
             _ValidStartTime = UtilStr.StrFromObj(poRow[cValidStartTime]);
             _WarrantNumber = UtilStr.StrFromObj(poRow[cWarrantNumber]);
         }

         public SysRegisters_info(string pcRegisterID, DBConnSql poDBConn)
         {
             if (pcRegisterID.Trim().Length > 0 && poDBConn != null)
             {
                 string lcSql = "select * from " + Tn.SysRegisters + " where RegisterID='" + pcRegisterID + "'";
                 rsQuery loQuery = poDBConn.OpenQuery(lcSql);
                 if (loQuery != null && loQuery.IsOpened && loQuery.RecCount == 1)
                 {
                     loQuery.MoveFirst();
                     CreateTableInfo(loQuery.CurrentRow);
                 }
             }
         }
         private string _IsAudit = "";
         public string IsAudit
         {
             get { return _IsAudit; }
             set { _IsAudit = value; }
         }

         private string _LinkTel = "";
         public string LinkTel
         {
             get { return _LinkTel; }
             set { _LinkTel = 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 _Password = "";
         public string Password
         {
             get { return SysSecLibs.SysSecurity.Decrypt(_Password); }
             set { _Password = SysSecLibs.SysSecurity.Encrypt(value); }
         }

         private string _RegionID = "";
         public string RegionID
         {
             get { return _RegionID; }
             set { _RegionID = value; }
         }

         private string _RegionName = "";
         public string RegionName
         {
             get { return _RegionName; }
             set { _RegionName = value; }
         }

         private string _RegisterDate = "";
         public string RegisterDate
         {
             get { return _RegisterDate; }
             set { _RegisterDate = value; }
         }

         private string _RegisterID = "";
         public string RegisterID
         {
             get { return _RegisterID; }
             set { _RegisterID = value; }
         }

         private string _RegisterIP = "";
         public string RegisterIP
         {
             get { return _RegisterIP; }
             set { _RegisterIP = value; }
         }

         private string _SystemID = "";
         public string SystemID
         {
             get { return _SystemID; }
             set { _SystemID = value; }
         }

         public string GroupID
         {
             get
             {
                 string lcRetVal = "ViewG";
                 if (!string.IsNullOrEmpty(SystemID))
                 {
                     if (SystemID == "Farmer")
                     {
                         lcRetVal = "FarmerG";
                     }
                     else if (SystemID == "GSSys")
                     {
                         lcRetVal = "GSSysG";
                     }
                     else if (SystemID == "Industry")
                     {
                         lcRetVal = "IndustryG";
                     }
                     else if (SystemID == "SuperMark")
                     {
                         lcRetVal = "SuperMarkG";
                     }
                 }
                 return lcRetVal;
             }
         }

         private string _UserCode = "";
         public string UserCode
         {
             get { return _UserCode; }
             set { _UserCode = value; }
         }

         private string _UserName = "";
         public string UserName
         {
             get { return _UserName; }
             set { _UserName = value; }
         }

         private string _ValidEndTime = "";
         public string ValidEndTime
         {
             get { return _ValidEndTime; }
             set { _ValidEndTime = value; }
         }

         private string _ValidStartTime = "";
         public string ValidStartTime
         {
             get { return _ValidStartTime; }
             set { _ValidStartTime = value; }
         }

         private string _WarrantNumber = "";
         public string WarrantNumber
         {
             get { return _WarrantNumber; }
             set { _WarrantNumber = value; }
         }

         [ScriptIgnore]
         public rsXmlNode DataXMLNode
         {
             get
             {
                 rsXmlNode loMainNode = new rsXmlNode("SysRegistersRecord", "");
                 rsXmlNode loNode = null;
                 loNode = new rsXmlNode(cIsAudit, IsAudit);
                 loMainNode.AddChild(loNode);
                 loNode = new rsXmlNode(cLinkTel, LinkTel);
                 loMainNode.AddChild(loNode);
                 loNode = new rsXmlNode(cMarketID, MarketID);
                 loMainNode.AddChild(loNode);
                 loNode = new rsXmlNode(cMarketName, MarketName);
                 loMainNode.AddChild(loNode);
                 loNode = new rsXmlNode(cPassword, Password);
                 loMainNode.AddChild(loNode);
                 loNode = new rsXmlNode(cRegionID, RegionID);
                 loMainNode.AddChild(loNode);
                 loNode = new rsXmlNode(cRegionName, RegionName);
                 loMainNode.AddChild(loNode);
                 loNode = new rsXmlNode(cRegisterDate, RegisterDate);
                 loMainNode.AddChild(loNode);
                 loNode = new rsXmlNode(cRegisterID, RegisterID);
                 loMainNode.AddChild(loNode);
                 loNode = new rsXmlNode(cRegisterIP, RegisterIP);
                 loMainNode.AddChild(loNode);
                 loNode = new rsXmlNode(cSystemID, SystemID);
                 loMainNode.AddChild(loNode);
                 loNode = new rsXmlNode(cUserCode, UserCode);
                 loMainNode.AddChild(loNode);
                 loNode = new rsXmlNode(cUserName, UserName);
                 loMainNode.AddChild(loNode);
                 loNode = new rsXmlNode(cValidEndTime, ValidEndTime);
                 loMainNode.AddChild(loNode);
                 loNode = new rsXmlNode(cValidStartTime, ValidStartTime);
                 loMainNode.AddChild(loNode);
                 loNode = new rsXmlNode(cWarrantNumber, WarrantNumber);
                 loMainNode.AddChild(loNode);
                 return loMainNode;
             }
         }
         public string InsertSql()
         {
             return " insert into " + Tn.SysRegisters + " " +
                          " (" + cIsAudit + "," + cLinkTel + "," + cMarketID + "," + cMarketName + "," + cPassword + "," + cRegionID + "," + cRegionName + "," + cRegisterDate + "," + cRegisterID + "," + cRegisterIP + "," + cSystemID + "," + cUserCode + "," + cUserName + "," + cValidEndTime + "," + cValidStartTime + "," + cWarrantNumber + ") " +
                          " values ('" + _IsAudit + "','" + _LinkTel + "','" + _MarketID + "','" + _MarketName + "','" + _Password + "','" + _RegionID + "','" + _RegionName + "','" + _RegisterDate + "','" + _RegisterID + "','" + _RegisterIP + "','" + _SystemID + "','" + _UserCode + "','" + _UserName + "','" + _ValidEndTime + "','" + _ValidStartTime + "','" + _WarrantNumber + "') ";
         }

         public string UpdateSql()
         {
             return " update " + Tn.SysRegisters + " " +
                  " set " + cIsAudit + "='" + _IsAudit + "'," + cLinkTel + "='" + _LinkTel + "'," + cMarketID + "='" + _MarketID + "'," + cMarketName + "='" + _MarketName + "'," + cPassword + "='" + _Password + "'," + cRegionID + "='" + _RegionID + "'," + cRegionName + "='" + _RegionName + "'," + cRegisterDate + "='" + _RegisterDate + "'," + cRegisterIP + "='" + _RegisterIP + "'," + cSystemID + "='" + _SystemID + "'," + cUserCode + "='" + _UserCode + "'," + cUserName + "='" + _UserName + "'," + cValidEndTime + "='" + _ValidEndTime + "'," + cValidStartTime + "='" + _ValidStartTime + "'," + cWarrantNumber + "='" + _WarrantNumber + "' " +
                  " where  " + cRegisterID + "='" + _RegisterID + "'";
         }

         public string DeleteSql()
         {
             return "Delete " + Tn.SysRegisters + " where " + cRegisterID + "='" + _RegisterID + "'";
         }
         public bool AuditThisInfo(UserSession poSession)
         {
             //
             if (poSession.DBConn.BeginTrans())
             {
                 string lcSql = " Update " + Tn.SysRegisters + " set  " + SysRegisters_info.cIsAudit + "='Y' where  " + SysRegisters_info.cRegisterID + "='" + _RegisterID + "'";
                 if (poSession.DBConn.ExecuteSql(lcSql))
                 {
                     Sys_Users_info loUserInfo = new Sys_Users_info();
                     loUserInfo.UserCode = this.UserCode;
                     loUserInfo.Names = this.UserName;
                     loUserInfo.SystemID = this.SystemID;
                     loUserInfo.RegionID = this.RegionID;
                     loUserInfo.Password = this.Password;
                     loUserInfo.Telephone = this.LinkTel;
                     loUserInfo.IsSystem = "N";
                     loUserInfo.IsAdvance = "Y";
                     loUserInfo.IsAudit = "Y";
                     loUserInfo.IsLock = "N";
                     loUserInfo.UserID = loUserInfo.SystemID + "_" + loUserInfo.UserCode;
                     loUserInfo.FarmID = SysDataLibs.AppEnv.SysSetObj.GetString("DEFULTFARMID");
                     loUserInfo.DepartmentID = SysDataLibs.AppEnv.SysSetObj.GetString("DEFAULTDEPARTMENTID");
                     loUserInfo.DutyID = SysDataLibs.AppEnv.SysSetObj.GetString("DEFAULTDUTYID");
                     loUserInfo.CreateDate = DateTime.Now.ToShortDateString();
                     loUserInfo.CreateUser = poSession.UserInfo.UserID;

                     Markets_info loMarket = new Markets_info();
                     loMarket.MarketID = this.MarketID;
                     loMarket.Names = this.MarketName;
                     loMarket.RegionID = this.RegionID;
                     loMarket.MarketTypeID = SysDataLibs.AppEnv.SysSetObj.GetString("DEFAULTMARKETTYPEID");//
                     loMarket.IsLock = "0";
                     loMarket.AuditFlag = "0";
                     loMarket.MarketSellerNum = "0";
                     loMarket.Area = "0";
                     loMarket.Turnover = "0";
                     loMarket.PractiseTime = DateTime.Now.ToShortDateString();

                     MarketHasWarrant_info loWarrant = new MarketHasWarrant_info();
                     loWarrant.WarrantNumber = this.WarrantNumber;
                     loWarrant.ValidStartTime = this.ValidStartTime;
                     loWarrant.ValidEndTime = this.ValidEndTime;
                     loWarrant.MarketID = this.MarketID;
                     loWarrant.WarrantStyle = "1";
                     loWarrant.WarrantTypeID = "1";

                     UserHasMarket_info loUserMarket = new UserHasMarket_info();
                     loUserMarket.MarketID = this.MarketID;
                     loUserMarket.UserID = loUserInfo.UserID;

                     Sys_GroupHasUser_info loGroupHasUser = new Sys_GroupHasUser_info();
                     loGroupHasUser.UserID = loUserInfo.UserID;
                     loGroupHasUser.GroupID = this.GroupID;

                     lcSql = loUserInfo.InsertSql() + " \r\n ";
                     lcSql += loMarket.InsertSql() + " \r\n ";
                     lcSql += loWarrant.InsertSql() + " \r\n ";

                     if (poSession.DBConn.ExecuteSql(lcSql))
                     {
                         if (poSession.DBConn.CommitTrans())
                         {
                             //poSession.DBConn.ExcuteSqlTran(loGroupHasUser.InsertSql());
                             Sys_GroupHasUser_info.UpdateUserToGroup(loGroupHasUser.UserID, loGroupHasUser.GroupID, poSession.DBConn);
                             return poSession.DBConn.ExcuteSqlTran(loUserMarket.InsertSql());
                         }
                         else
                             poSession.DBConn.RollbackTrans();
                     }
                     else
                         poSession.DBConn.RollbackTrans();

                 }
                 else
                     poSession.DBConn.RollbackTrans();
                
             }
             return false;
         }

     }
    #endregion 

  #region 

    public class SysRegisters_Qry : rsQuery  
    {  
        public Boolean IsAudit  
           {  
               get { return GetBool(SysRegisters_info.cIsAudit); } 
           //    set { SetField(SysRegisters_info.cIsAudit, value); } 
           } 
 
        public String LinkTel  
           {  
               get { return GetString(SysRegisters_info.cLinkTel); } 
           //    set { SetField(SysRegisters_info.cLinkTel, value); } 
           } 
 
        public String MarketID  
           {  
               get { return GetString(SysRegisters_info.cMarketID); } 
           //    set { SetField(SysRegisters_info.cMarketID, value); } 
           } 
 
        public String MarketName  
           {  
               get { return GetString(SysRegisters_info.cMarketName); } 
           //    set { SetField(SysRegisters_info.cMarketName, value); } 
           } 
 
        public String Password  
           {  
               get { return GetString(SysRegisters_info.cPassword); } 
           //    set { SetField(SysRegisters_info.cPassword, value); } 
           } 
 
        public String RegionID  
           {  
               get { return GetString(SysRegisters_info.cRegionID); } 
           //    set { SetField(SysRegisters_info.cRegionID, value); } 
           } 
 
        public String RegionName  
           {  
               get { return GetString(SysRegisters_info.cRegionName); } 
           //    set { SetField(SysRegisters_info.cRegionName, value); } 
           } 
 
        public DateTime RegisterDate  
           {  
               get { return GetDateTime(SysRegisters_info.cRegisterDate); } 
           //    set { SetField(SysRegisters_info.cRegisterDate, value); } 
           } 
 
        public String RegisterID  
           {  
               get { return GetString(SysRegisters_info.cRegisterID); } 
           //    set { SetField(SysRegisters_info.cRegisterID, value); } 
           } 
 
        public String RegisterIP  
           {  
               get { return GetString(SysRegisters_info.cRegisterIP); } 
           //    set { SetField(SysRegisters_info.cRegisterIP, value); } 
           } 
 
        public String SystemID  
           {  
               get { return GetString(SysRegisters_info.cSystemID); } 
           //    set { SetField(SysRegisters_info.cSystemID, value); } 
           } 
 
        public String UserCode  
           {  
               get { return GetString(SysRegisters_info.cUserCode); } 
           //    set { SetField(SysRegisters_info.cUserCode, value); } 
           } 
 
        public String UserName  
           {  
               get { return GetString(SysRegisters_info.cUserName); } 
           //    set { SetField(SysRegisters_info.cUserName, value); } 
           } 
 
        public DateTime ValidEndTime  
           {  
               get { return GetDateTime(SysRegisters_info.cValidEndTime); } 
           //    set { SetField(SysRegisters_info.cValidEndTime, value); } 
           } 
 
        public DateTime ValidStartTime  
           {  
               get { return GetDateTime(SysRegisters_info.cValidStartTime); } 
           //    set { SetField(SysRegisters_info.cValidStartTime, value); } 
           } 
 
        public String WarrantNumber  
           {  
               get { return GetString(SysRegisters_info.cWarrantNumber); } 
           //    set { SetField(SysRegisters_info.cWarrantNumber, value); } 
           } 
 
    } 
  #endregion 

}