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));
}
}
