private void ToExamine() { Guid id = Guid.Parse(Request.QueryString["CompanyId"]); CompanyType type = (CompanyType)byte.Parse(Request.QueryString["CompanyType"]); AccountBaseType accounType = (AccountBaseType)byte.Parse(Request.QueryString["AccountType"]); AuditType auditType = (AuditType)int.Parse(Request.QueryString["AuditType"]); var address = ChinaPay.B3B.TransactionWeb.PublicClass.AddressShow.GetAddressBaseInfo(hfldAddressCode.Value); bool isUpgrade = false; CompanyUpgrade companyUpgrade = null; if (auditType == AuditType.ApplyAudit) { isUpgrade = true; companyUpgrade = CompanyUpgradeService.QueryCompanyUpgrade(id); } if ((type == CompanyType.Provider && !isUpgrade) || (isUpgrade && companyUpgrade.Type == CompanyType.Provider)) { AccountCombineService.AuditProviderInfo(id, GetProviderAuditInfo(address, isUpgrade)); } else { if (accounType == AccountBaseType.Individual) { AccountCombineService.AuditSupplier(id, GetSupplierIndividualAuditInfo(address, isUpgrade)); } else { AccountCombineService.AuditSupplier(id, GetSupplierEnterpriseInfo(address, isUpgrade)); } } }
/// <summary> /// 保存公司升级申请信息 /// </summary> /// <param name="companyUpgrade"></param> public static void Save(CompanyUpgrade companyUpgrade, string operatorAccount) { if (!string.IsNullOrWhiteSpace(companyUpgrade.Name) && CompanyService.ExistsCompanyName(companyUpgrade.Name)) { throw new InvalidOperationException("系统中已存在指定的 \"单位名称\"。"); } if (!string.IsNullOrWhiteSpace(companyUpgrade.AbbreviateName) && CompanyService.ExistsAbbreviateName(companyUpgrade.AbbreviateName)) { throw new InvalidOperationException("系统中已存在指定的 \"单位简称\"。"); } var repository = Factory.CreateCompanyUpgradeRepository(); repository.Save(companyUpgrade); saveAddLog("公司升级申请信息", string.Format("公司账号为{0}的账号申请为{1}({2}),申请时间为{3}", companyUpgrade.UserNo, companyUpgrade.Type.GetDescription(), companyUpgrade.AccountType.GetDescription(), companyUpgrade.ApplyTime), companyUpgrade.UserNo, operatorAccount); }
public IEnumerable <CompanyUpgrade> QueryNeedAuditCompanys() { var result = new List <CompanyUpgrade>(); string sql = @"SELECT [Company],[ApplyTime] FROM [B3B].[dbo].[T_CompanyUpgradeApplication] WHERE [AuditTime] IS NULL"; using (var dbOperator = new DbOperator(Provider, ConnectionString)) { using (var reader = dbOperator.ExecuteReader(sql)) { while (reader.Read()) { var companyUpgrade = new CompanyUpgrade(); companyUpgrade.Company = reader.GetGuid(0); companyUpgrade.ApplyTime = reader.GetDateTime(1); result.Add(companyUpgrade); } } } return(result); }
private CompanyUpgrade getCompanyUpgrade() { var companyUpgrade = new CompanyUpgrade(); if (this.hfdValid.Value == "true") { companyUpgrade.Name = this.txtCompanyName.Text; companyUpgrade.AbbreviateName = this.txtCompanyAbbreaviateName.Text; companyUpgrade.OfficePhones = this.txtOfficePhone.Text; companyUpgrade.EmergencyName = this.txtEmergencyName.Text; companyUpgrade.EmergencyPhone = this.txtEmergecyMobile.Text; companyUpgrade.ManagerName = this.txtManagerName.Text; companyUpgrade.ManagerPhone = this.txtManagerMobile.Text; companyUpgrade.OrginationCode = this.txtOrgnationCode.Text; } companyUpgrade.ApplyTime = DateTime.Now; companyUpgrade.Audited = false; companyUpgrade.Company = this.CurrentCompany.CompanyId; companyUpgrade.UserNo = this.CurrentCompany.UserName; if (rbnSupplierIndividual.Checked) { companyUpgrade.AccountType = AccountBaseType.Individual; companyUpgrade.Type = Common.Enums.CompanyType.Supplier; } if (rbnSupplierEnterprise.Checked) { companyUpgrade.AccountType = AccountBaseType.Enterprise; companyUpgrade.Type = Common.Enums.CompanyType.Supplier; } if (rbnProviderEnterprise.Checked) { companyUpgrade.AccountType = AccountBaseType.Enterprise; companyUpgrade.Type = Common.Enums.CompanyType.Provider; } return(companyUpgrade); }
// public int Update(Domain.CompanyUpgrade companyUpgrade) { // string sql = @"UPDATE [dbo].[T_CompanyUpgradeApplication] SET [UserNo] = @UserNo,[Name] = @Name,[AbbreviateName] = @AbbreviateName,[OrginationCode] = @OrginationCode, // [OfficePhones] = @OfficePhones,[ManagerName] = @ManagerName,[ManagerPhone] = @ManagerPhone,[EmergencyName] = @EmergencyName,[EmergencyPhone] = @EmergencyPhone, // [Type] = @Type,[AccountType] = @AccountType,[Audited] =@Audited,[AuditTime]=@AuditTime,[ApplyTime] = @ApplyTime WHERE [Company] = @Company"; // using (var dbOperator = new DbOperator(Provider, ConnectionString)) { // dbOperator.AddParameter("Company", companyUpgrade.CompanyId); // dbOperator.AddParameter("UserNo", companyUpgrade.UserNo); // if (string.IsNullOrWhiteSpace(companyUpgrade.CompanyName)) { // dbOperator.AddParameter("Name", DBNull.Value); // } else { // dbOperator.AddParameter("Name", companyUpgrade.CompanyName); // } // if (string.IsNullOrWhiteSpace(companyUpgrade.AbbreviateName)) { // dbOperator.AddParameter("AbbreviateName", DBNull.Value); // } else { // dbOperator.AddParameter("AbbreviateName", companyUpgrade.AbbreviateName); // } // if (string.IsNullOrWhiteSpace(companyUpgrade.OrginationCode)) { // dbOperator.AddParameter("OrginationCode", DBNull.Value); // } else { // dbOperator.AddParameter("OrginationCode", companyUpgrade.OrginationCode); // } // if (string.IsNullOrWhiteSpace(companyUpgrade.CompanyPhone)) { // dbOperator.AddParameter("OfficePhones", DBNull.Value); // } else { // dbOperator.AddParameter("OfficePhones", companyUpgrade.CompanyPhone); // } // if (string.IsNullOrWhiteSpace(companyUpgrade.ManagerName)) { // dbOperator.AddParameter("ManagerName", DBNull.Value); // } else { // dbOperator.AddParameter("ManagerName", companyUpgrade.ManagerName); // } // if (string.IsNullOrWhiteSpace(companyUpgrade.ManagerPhone)) { // dbOperator.AddParameter("ManagerPhone", DBNull.Value); // } else { // dbOperator.AddParameter("ManagerPhone", companyUpgrade.ManagerPhone); // } // if (string.IsNullOrWhiteSpace(companyUpgrade.EmergencyName)) { // dbOperator.AddParameter("EmergencyName", DBNull.Value); // } else { // dbOperator.AddParameter("EmergencyName", companyUpgrade.EmergencyName); // } // if (string.IsNullOrWhiteSpace(companyUpgrade.EmergencyPhone)) { // dbOperator.AddParameter("EmergencyPhone", DBNull.Value); // } else { // dbOperator.AddParameter("EmergencyPhone", companyUpgrade.EmergencyPhone); // } // dbOperator.AddParameter("Type", (int)companyUpgrade.CompanyType); // dbOperator.AddParameter("AccountType", (int)companyUpgrade.AccountType); // dbOperator.AddParameter("Audited",companyUpgrade.Audited); // if (companyUpgrade.AuditTime.HasValue) { // dbOperator.AddParameter("AuditTime", companyUpgrade.AuditTime); // } else { // dbOperator.AddParameter("AuditTime",DBNull.Value); // } // dbOperator.AddParameter("ApplyTime", companyUpgrade.ApplyTime); // return dbOperator.ExecuteNonQuery(sql); // } // } public CompanyUpgrade Query(Guid companyId) { CompanyUpgrade companyUpgrade = null; string sql = @"SELECT [UserNo],[Name],[AbbreviateName],[OrginationCode],[OfficePhones],[ManagerName],[ManagerPhone], [EmergencyName],[EmergencyPhone],[Type],[AccountType],[Audited],[AuditTime],[ApplyTime] FROM [dbo].[T_CompanyUpgradeApplication] WHERE [Company] = @Company"; using (var dbOperator = new DbOperator(Provider, ConnectionString)) { dbOperator.AddParameter("Company", companyId); using (var reader = dbOperator.ExecuteReader(sql)) { while (reader.Read()) { companyUpgrade = new CompanyUpgrade(); companyUpgrade.Company = companyId; companyUpgrade.UserNo = reader.GetString(0); if (!reader.IsDBNull(1)) { companyUpgrade.Name = reader.GetString(1); } if (!reader.IsDBNull(2)) { companyUpgrade.AbbreviateName = reader.GetString(2); } if (!reader.IsDBNull(3)) { companyUpgrade.OrginationCode = reader.GetString(3); } if (!reader.IsDBNull(4)) { companyUpgrade.OfficePhones = reader.GetString(4); } if (!reader.IsDBNull(5)) { companyUpgrade.ManagerName = reader.GetString(5); } if (!reader.IsDBNull(6)) { companyUpgrade.ManagerPhone = reader.GetString(6); } if (!reader.IsDBNull(7)) { companyUpgrade.EmergencyName = reader.GetString(7); } if (!reader.IsDBNull(8)) { companyUpgrade.EmergencyPhone = reader.GetString(8); } companyUpgrade.Type = (Common.Enums.CompanyType)reader.GetByte(9); companyUpgrade.AccountType = (Common.Enums.AccountBaseType)reader.GetByte(10); companyUpgrade.Audited = reader.GetBoolean(11); if (!reader.IsDBNull(12)) { companyUpgrade.AuditTime = reader.GetDateTime(12); } companyUpgrade.ApplyTime = reader.GetDateTime(13); } } } return(companyUpgrade); }
public int Save(CompanyUpgrade companyUpgrade) { string sql = @"IF EXISTS(SELECT NULL FROM [dbo].[T_CompanyUpgradeApplication ] WHERE Company =@Company) UPDATE [dbo].[T_CompanyUpgradeApplication] SET [UserNo] = @UserNo,[Name] = @Name,[AbbreviateName] = @AbbreviateName,[OrginationCode] = @OrginationCode, [OfficePhones] = @OfficePhones,[ManagerName] = @ManagerName,[ManagerPhone] = @ManagerPhone,[EmergencyName] = @EmergencyName,[EmergencyPhone] = @EmergencyPhone, [Type] = @Type,[AccountType] = @AccountType,[Audited] =@Audited,[AuditTime]=@AuditTime,[ApplyTime] = @ApplyTime WHERE [Company] = @Company ELSE INSERT INTO [B3B].[dbo].[T_CompanyUpgradeApplication ]([Company],[UserNo],[Name],[AbbreviateName],[OrginationCode], [OfficePhones],[ManagerName],[ManagerPhone],[EmergencyName] ,[EmergencyPhone],[Type],[AccountType],[Audited],[AuditTime],[ApplyTime]) VALUES(@Company,@UserNo,@Name,@AbbreviateName,@OrginationCode,@OfficePhones,@ManagerName,@ManagerPhone,@EmergencyName,@EmergencyPhone, @Type,@AccountType,@Audited,@AuditTime,@ApplyTime)"; using (var dbOperator = new DbOperator(Provider, ConnectionString)) { dbOperator.AddParameter("Company", companyUpgrade.Company); dbOperator.AddParameter("UserNo", companyUpgrade.UserNo); if (string.IsNullOrWhiteSpace(companyUpgrade.Name)) { dbOperator.AddParameter("Name", DBNull.Value); } else { dbOperator.AddParameter("Name", companyUpgrade.Name); } if (string.IsNullOrWhiteSpace(companyUpgrade.AbbreviateName)) { dbOperator.AddParameter("AbbreviateName", DBNull.Value); } else { dbOperator.AddParameter("AbbreviateName", companyUpgrade.AbbreviateName); } if (string.IsNullOrWhiteSpace(companyUpgrade.OrginationCode)) { dbOperator.AddParameter("OrginationCode", DBNull.Value); } else { dbOperator.AddParameter("OrginationCode", companyUpgrade.OrginationCode); } if (string.IsNullOrWhiteSpace(companyUpgrade.OfficePhones)) { dbOperator.AddParameter("OfficePhones", DBNull.Value); } else { dbOperator.AddParameter("OfficePhones", companyUpgrade.OfficePhones); } if (string.IsNullOrWhiteSpace(companyUpgrade.ManagerName)) { dbOperator.AddParameter("ManagerName", DBNull.Value); } else { dbOperator.AddParameter("ManagerName", companyUpgrade.ManagerName); } if (string.IsNullOrWhiteSpace(companyUpgrade.ManagerPhone)) { dbOperator.AddParameter("ManagerPhone", DBNull.Value); } else { dbOperator.AddParameter("ManagerPhone", companyUpgrade.ManagerPhone); } if (string.IsNullOrWhiteSpace(companyUpgrade.EmergencyName)) { dbOperator.AddParameter("EmergencyName", DBNull.Value); } else { dbOperator.AddParameter("EmergencyName", companyUpgrade.EmergencyName); } if (string.IsNullOrWhiteSpace(companyUpgrade.EmergencyPhone)) { dbOperator.AddParameter("EmergencyPhone", DBNull.Value); } else { dbOperator.AddParameter("EmergencyPhone", companyUpgrade.EmergencyPhone); } dbOperator.AddParameter("Type", (int)companyUpgrade.Type); dbOperator.AddParameter("AccountType", (int)companyUpgrade.AccountType); dbOperator.AddParameter("Audited", companyUpgrade.Audited); if (companyUpgrade.AuditTime.HasValue) { dbOperator.AddParameter("AuditTime", companyUpgrade.AuditTime); } else { dbOperator.AddParameter("AuditTime", DBNull.Value); } dbOperator.AddParameter("ApplyTime", companyUpgrade.ApplyTime); return(dbOperator.ExecuteNonQuery(sql)); } }