internal string UpdateSaleContractStatusCore(ExtendedIdentityDbContext dbContext,
SaleContract contract, ContractStatus contractStatus, string userName)
{
if (contract == null)
{
return("SaleContract model为空。");
}
try
{
contract.ContractStatus = contractStatus;
string errorMessage2 = AddOrUpdateSaleContractFinancialObjsSecond(
dbContext, userName, contract);
if (!string.IsNullOrWhiteSpace(errorMessage2))
{
return(errorMessage2);
}
int effectedRows = dbContext.SaveChanges();
if (effectedRows < 1)
{
return("修改SaleContract审核状态失败。");
}
}
catch (Exception ee)
{
LogHelper.Error("修改SaleContract审核状态失败。", ee);
return(ee.Message);
}
return(string.Empty);
}
public string UpdateSaleContractCore(ExtendedIdentityDbContext dbContext,
ContractInfo model, string userName)
{
if (model == null)
{
return("SaleContract model为空。");
}
try
{
SaleContract contract = null;
if (model.ContractId > 0)
{
contract = dbContext.SaleContracts.Find(model.ContractId);
}
if (contract == null)
{
contract = dbContext.SaleContracts.Create();
}
string errorMessage1 = this.UpdateSaleContractFirst(dbContext, model,
userName, contract);
if (!string.IsNullOrWhiteSpace(errorMessage1))
{
return(errorMessage1);
}
string errorMessage2 = AddOrUpdateSaleContractFinancialObjsSecond(
dbContext, userName, contract);
if (!string.IsNullOrWhiteSpace(errorMessage2))
{
return(errorMessage2);
}
int effectedRows = dbContext.SaveChanges();
if (effectedRows < 1)
{
return("修改SaleContract失败。");
}
}
catch (Exception ee)
{
LogHelper.Error("修改SaleContract失败。", ee);
return(ee.Message);
}
return(string.Empty);
}
private void InitDefaultResItems(ExtendedIdentityDbContext context)
{
var zeroSupplier = context.Suppliers.Find(0);
if (zeroSupplier == null)
{
zeroSupplier = context.Suppliers.Create();
zeroSupplier.SupplierName = "（未选择）";
zeroSupplier.IsDeleted = true;
context.Suppliers.Add(zeroSupplier);
context.SaveChanges();
context.Database.ExecuteSqlCommand(
"UPDATE suppliers SET SupplierId = 0 WHERE SupplierId = " + zeroSupplier.SupplierId);
}
var zeroHarbor = context.Harbors.Find(0);
if (zeroHarbor == null)
{
zeroHarbor = context.Harbors.Create();
zeroHarbor.HarborKey = "（未选择）";
zeroHarbor.IsDeleted = true;
context.Harbors.Add(zeroHarbor);
context.SaveChanges();
context.Database.ExecuteSqlCommand(
"UPDATE harbors SET HarborId = 0 WHERE HarborId = "
+ zeroHarbor.HarborId);
}
var zeroDeclarCom = context.DeclarationCompanies.Find(0);
if (zeroDeclarCom == null)
{
zeroDeclarCom = context.DeclarationCompanies.Create();
zeroDeclarCom.CompanyName = "（未选择）";
zeroDeclarCom.IsDeleted = true;
context.DeclarationCompanies.Add(zeroDeclarCom);
context.SaveChanges();
context.Database.ExecuteSqlCommand(
"UPDATE DeclarationCompanies SET DeclarationCompanyId = 0 WHERE DeclarationCompanyId = "
+ zeroDeclarCom.DeclarationCompanyId);
}
var zeroHkCom = context.HKLogistics.Find(0);
if (zeroHkCom == null)
{
zeroHkCom = context.HKLogistics.Create();
zeroHkCom.CompanyName = "（未选择）";
zeroHkCom.IsDeleted = true;
context.HKLogistics.Add(zeroHkCom);
context.SaveChanges();
context.Database.ExecuteSqlCommand(
"UPDATE hongkonglogisticscompanies SET HongkongLogisticsCompanyId = 0 WHERE HongkongLogisticsCompanyId = "
+ zeroHkCom.HongkongLogisticsCompanyId);
}
var zeroMlCom = context.MainlandLogistics.Find(0);
if (zeroMlCom == null)
{
zeroMlCom = context.MainlandLogistics.Create();
zeroMlCom.CompanyName = "（未选择）";
zeroMlCom.IsDeleted = true;
context.MainlandLogistics.Add(zeroMlCom);
context.SaveChanges();
context.Database.ExecuteSqlCommand(
"UPDATE mainlandlogisticscompanies SET MainlandLogisticsCompanyId = 0 WHERE MainlandLogisticsCompanyId = "
+ zeroMlCom.MainlandLogisticsCompanyId);
}
var zeroProd = context.Products.Find(0);
if (zeroProd == null)
{
zeroProd = context.Products.Create();
zeroProd.ProductKey = "（未选择）";
zeroProd.IsDeleted = true;
context.Products.Add(zeroProd);
context.SaveChanges();
context.Database.ExecuteSqlCommand(
"UPDATE Products SET ProductId = 0 WHERE ProductId = "
+ zeroProd.ProductId);
}
var zeroSale = context.SaleClients.Find(0);
if (zeroSale == null)
{
zeroSale = context.SaleClients.Create();
zeroSale.CompanyName = "（未选择）";
zeroSale.IsDeleted = true;
context.SaleClients.Add(zeroSale);
context.SaveChanges();
context.Database.ExecuteSqlCommand(
"UPDATE SaleClients SET SaleClientId = 0 WHERE SaleClientId = "
+ zeroSale.SaleClientId);
}
var zeroShouse = context.StoreHouses.Find(0);
if (zeroShouse == null)
{
zeroShouse = context.StoreHouses.Create();
zeroShouse.StoreHouseName = "（未选择）";
zeroShouse.IsDeleted = true;
context.StoreHouses.Add(zeroShouse);
context.SaveChanges();
context.Database.ExecuteSqlCommand(
"UPDATE StoreHouses SET StoreHouseId = 0 WHERE StoreHouseId = "
+ zeroShouse.StoreHouseId);
}
//var zeroShouse = context.Suppliers.Find(0);
//if (zeroShouse == null)
//{
// zeroShouse = context.Suppliers.Create();
// zeroShouse.StoreHouseName = "（未选择）";
// context.Suppliers.Add(zeroShouse);
// context.SaveChanges();
// context.Database.ExecuteSqlCommand(
// "UPDATE StoreHouses SET StoreHouseId = 0 WHERE StoreHouseId = "
// + zeroShouse.StoreHouseId);
//}
}