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