public void UpdateBrandWarrantyInfoBySysNo(ProductBrandWarrantyInfo productBrandWarrantyInfo) { using (var tran = new TransactionScope()) { List <ProductBrandWarrantyInfo> _brandWarrantyInfoAll = GetBrandWarrantyInfoByAll(); //更新日期和詳細信息 foreach (int item in productBrandWarrantyInfo.SysNos) { ProductBrandWarrantyInfo _oldProductBrandWarrantyInfo = _brandWarrantyInfoAll.Where(p => p.SysNo == item).FirstOrDefault(); brandRequestDA.UpdateBrandWarrantyInfoBySysNo(new ProductBrandWarrantyInfo() { SysNo = item, EditUser = productBrandWarrantyInfo.EditUser, WarrantyDay = productBrandWarrantyInfo.WarrantyDay, WarrantyDesc = productBrandWarrantyInfo.WarrantyDesc }); string LogNote = String.Format( @"用户名:{0} 批量更新操作 原数据:BrandSysNo:{1} C1SysNo:{2} C2SysNo:{3} C3SysNo:{4} WarrantyDay:{5} WarrantyDesc{6} 替换为 BrandSysNo:{7} C1SysNo:{8} C2SysNo:{9} C3SysNo:{10} WarrantyDay:{11} WarrantyDesc{12} " , productBrandWarrantyInfo.EditUser.UserDisplayName, _oldProductBrandWarrantyInfo.BrandSysNo , _oldProductBrandWarrantyInfo.C1SysNo, _oldProductBrandWarrantyInfo.C2SysNo , _oldProductBrandWarrantyInfo.C3SysNo, _oldProductBrandWarrantyInfo.WarrantyDay , _oldProductBrandWarrantyInfo.WarrantyDesc , _oldProductBrandWarrantyInfo.BrandSysNo, _oldProductBrandWarrantyInfo.C1SysNo , _oldProductBrandWarrantyInfo.C2SysNo, _oldProductBrandWarrantyInfo.C3SysNo , productBrandWarrantyInfo.WarrantyDay, productBrandWarrantyInfo.WarrantyDesc); ExternalDomainBroker.CreateOperationLog(LogNote, BizLogType.IM_BrandWarranty_Edit, item, "8601"); } tran.Complete(); } }
//删除操作 public void DelBrandWarrantyInfoBySysNos(List <ProductBrandWarrantyInfo> productBrandWarrantyInfos) { using (var tranDel = new TransactionScope()) { List <String> errorlist = new List <String>(); productBrandWarrantyInfos.ForEach(p => { ProductBrandWarrantyInfo _ProductBrandWarranty = brandRequestDA.GetAllowDeleteBrandWarranty( int.Parse(p.C3SysNo.ToString()), int.Parse(p.BrandSysNo.ToString())); if (_ProductBrandWarranty != null) { errorlist.Add(String.Format("C3SysNo:{0} 品牌:{1} 有被商品使用,不能删除!" , p.C3SysNo.ToString(), p.BrandSysNo.ToString())); } else { string LogNote = String.Format("用户名:{0} 删除操作 品牌系统编号为{1}", p.EditUser.UserDisplayName, p.SysNo.ToString()); brandRequestDA.DelBrandWarrantyInfoBySysNo(int.Parse(p.SysNo.ToString())); ExternalDomainBroker.CreateOperationLog( LogNote, BizLogType.IM_BrandWarranty_Delete , int.Parse(p.SysNo.ToString()), "8601"); } }); tranDel.Complete(); if (errorlist.Count > 0) { throw new BizException(string.Format("失败{0}条,\n内容是:{1}" , errorlist.Count, errorlist.Join(";"))); } } }
public void BrandWarrantyInfoByAddOrUpdate(ProductBrandWarrantyInfo productBrandWarrantyInfo) { //查找数据库书否存在记录 //存在更新操作反之添加操作 //记录日志 //如果C1SysNo 为1的话 那所有的 子类下的都需要 添加 using (var tran = new TransactionScope()) { //找出所有三级类 int sysNo = 0; List <Int32> C3SysNos = GetC3SysNos(productBrandWarrantyInfo); List <ProductBrandWarrantyInfo> _brandWarrantyInfoAll = GetBrandWarrantyInfoByAll(); foreach (int C3SysNo in C3SysNos) { productBrandWarrantyInfo.C3SysNo = C3SysNo; ProductBrandWarrantyInfo _newproductBrandWarrantyInfo = new ProductBrandWarrantyInfo(); ProductBrandWarrantyInfo _productBrandWarrantyInfo = _brandWarrantyInfoAll .Where(p => p.C3SysNo.Equals(productBrandWarrantyInfo.C3SysNo)) .Where(p => p.BrandSysNo.Equals(productBrandWarrantyInfo.BrandSysNo)).FirstOrDefault(); if (_productBrandWarrantyInfo == null) { sysNo = brandRequestDA.InsertBrandWarrantyInfo( productBrandWarrantyInfo); } else { brandRequestDA.UpdateBrandWarrantyInfoByBrandSysNoAndC3SysNo(productBrandWarrantyInfo); } string LogNote = _productBrandWarrantyInfo == null ? String.Format( "用户名:{0} 添加操作 BrandSysNo:{1} C1SysNo:{2} C2SysNo:{3} C3SysNo:{4} WarrantyDay:{5} WarrantyDesc{6}" , productBrandWarrantyInfo.EditUser.UserDisplayName, productBrandWarrantyInfo.BrandSysNo , productBrandWarrantyInfo.C1SysNo, productBrandWarrantyInfo.C2SysNo , productBrandWarrantyInfo.C3SysNo, productBrandWarrantyInfo.WarrantyDay , productBrandWarrantyInfo.WarrantyDesc) : String.Format( @"用户名:{0} 更新操作 原数据:BrandSysNo:{1} C1SysNo:{2} C2SysNo:{3} C3SysNo:{4} WarrantyDay:{5} WarrantyDesc{6} 替换为 BrandSysNo:{7} C1SysNo:{8} C2SysNo:{9} C3SysNo:{10} WarrantyDay:{11} WarrantyDesc{12} " , productBrandWarrantyInfo.EditUser.UserDisplayName, _productBrandWarrantyInfo.BrandSysNo , _productBrandWarrantyInfo.C1SysNo, _productBrandWarrantyInfo.C2SysNo , _productBrandWarrantyInfo.C3SysNo, _productBrandWarrantyInfo.WarrantyDay , _productBrandWarrantyInfo.WarrantyDesc , productBrandWarrantyInfo.BrandSysNo, productBrandWarrantyInfo.C1SysNo , productBrandWarrantyInfo.C2SysNo, productBrandWarrantyInfo.C3SysNo , productBrandWarrantyInfo.WarrantyDay, productBrandWarrantyInfo.WarrantyDesc); //记录日志 ExternalDomainBroker.CreateOperationLog(LogNote , _productBrandWarrantyInfo == null ? BizLogType.IM_BrandWarranty_Add : BizLogType.IM_BrandWarranty_Edit , _productBrandWarrantyInfo == null ? sysNo : int.Parse(_productBrandWarrantyInfo.SysNo.ToString()), "8601"); } tran.Complete(); } }
public void DefaultRMAPolicyInfoAdd(DefaultRMAPolicyInfo defaultRMAPolicy) { //如果品牌为空 对应的所有品牌 //是否存在重复 //新增操作 //记录日志 List <String> errorlist = new List <String>(); try { DefaultRMAPolicyInfo _oldDefaultRMAPolicy = rmaPolicyRequestDA.DefaultRMAPolicyByAll() .Where(p => p.C3SysNo == defaultRMAPolicy.C3SysNo) .Where(p => p.BrandSysNo == defaultRMAPolicy.BrandSysNo) .Where(p => p.RMAPolicySysNo == defaultRMAPolicy.RMAPolicySysNo).Count() > 0 ? rmaPolicyRequestDA.DefaultRMAPolicyByAll() .Where(p => p.C3SysNo == defaultRMAPolicy.C3SysNo) .Where(p => p.BrandSysNo == defaultRMAPolicy.BrandSysNo) .Where(p => p.RMAPolicySysNo == defaultRMAPolicy.RMAPolicySysNo).FirstOrDefault() : null; if (_oldDefaultRMAPolicy != null) { errorlist.Add(String.Format("C3SysNo:{0} " + ResouceManager.GetMessageString("IM.Brand", "Brand") + ":{1} " + ResouceManager.GetMessageString("IM.Product", "Repeated") , _oldDefaultRMAPolicy.C3SysNo, _oldDefaultRMAPolicy.BrandSysNo)); } else { using (var tran = new TransactionScope()) { defaultRMAPolicy.BrandSysNo = defaultRMAPolicy.BrandSysNo; int _newId = rmaPolicyRequestDA.InsertDefaultRMAPolicyInfo(defaultRMAPolicy); string LogNote = String.Format(ResouceManager.GetMessageString("IM.Product", "UserName") + ":{0} " + ResouceManager.GetMessageString("IM.Product", "AddOperation") + " C3SysNo:{1} BrandSysNo:{2} RMAPolicySysNo:{3}" , defaultRMAPolicy.CreateUser.UserDisplayName , defaultRMAPolicy.C3SysNo , defaultRMAPolicy.BrandSysNo , defaultRMAPolicy.RMAPolicySysNo); //记录日志 ExternalDomainBroker.CreateOperationLog(LogNote , BizLogType.DefaultRMAPolicy_Add, _newId, "8601"); tran.Complete(); } } } catch (Exception ex) { errorlist.Add(ex.ToString()); } if (errorlist.Count > 0) { throw new BizException(string.Format(ResouceManager.GetMessageString("IM.Product", "Fail") + "{0}" + ResouceManager.GetMessageString("IM.Product", "NumberUnit") + ",\n" + ResouceManager.GetMessageString("IM.Product", "ContentIs") + ":{1}" , errorlist.Count, errorlist.Join(";"))); } }
public void DelDelDefaultRMAPolicyBySysNoBySysNos(List <DefaultRMAPolicyInfo> defaultRMAPolicyInfos) { using (var tranDel = new TransactionScope()) { defaultRMAPolicyInfos.ForEach(p => { string LogNote = String.Format(ResouceManager.GetMessageString("IM.Product", "UserName") + ":{0} " + ResouceManager.GetMessageString("IM.Product", "DeleteOperation") + " " + ResouceManager.GetMessageString("IM.Product", "BrandSysNo") + "{1}" , p.EditUser.UserDisplayName, p.SysNo.ToString()); rmaPolicyRequestDA.DelDefaultRMAPolicyBySysNo(int.Parse(p.SysNo.ToString())); ExternalDomainBroker.CreateOperationLog( LogNote, BizLogType.DefaultRMAPolicy_Del , int.Parse(p.SysNo.ToString()), "8601"); }); tranDel.Complete(); } //throw new BizException("删除成功!"); }
public void UpdateDefaultRMAPolicyBySysNo(DefaultRMAPolicyInfo defaultRMAPolicy) { //更新 //是否存在重复 //更新操作 using (var tran = new TransactionScope()) { List <DefaultRMAPolicyInfo> _defaultRMAPolicys = rmaPolicyRequestDA.DefaultRMAPolicyByAll(); DefaultRMAPolicyInfo _oldDefaultRMAPolicy = rmaPolicyRequestDA.DefaultRMAPolicyByAll() .Where(p => p.C3SysNo == defaultRMAPolicy.C3SysNo) .Where(p => p.BrandSysNo == defaultRMAPolicy.BrandSysNo) .Where(p => p.RMAPolicySysNo == defaultRMAPolicy.RMAPolicySysNo).Count() > 0 ? rmaPolicyRequestDA.DefaultRMAPolicyByAll() .Where(p => p.C3SysNo == defaultRMAPolicy.C3SysNo) .Where(p => p.BrandSysNo == defaultRMAPolicy.BrandSysNo) .Where(p => p.RMAPolicySysNo == defaultRMAPolicy.RMAPolicySysNo).FirstOrDefault() : null; if (_oldDefaultRMAPolicy != null) { throw new BizException(String.Format("C3SysNo:{0} " + ResouceManager.GetMessageString("IM.Product", "Brand") + ":{1} " + ResouceManager.GetMessageString("IM.Product", "Repeated") , _oldDefaultRMAPolicy.C3SysNo, _oldDefaultRMAPolicy.BrandSysNo)); } rmaPolicyRequestDA.UpdateDefaultRMAPolicyBySysNo(defaultRMAPolicy); string LogNote = String.Format(ResouceManager.GetMessageString("IM.Product", "UserName") + ":{0} " + ResouceManager.GetMessageString("IM.Product", "Updated") + ResouceManager.GetMessageString("IM.Product", "SourceData") + " RMAPolicySysNo:{1} " + ResouceManager.GetMessageString("IM.Product", "UpdateData") + " RMAPolicySysNo:{2}" , defaultRMAPolicy.EditUser.UserDisplayName , _defaultRMAPolicys.Where(p => p.SysNo == defaultRMAPolicy.SysNo).First().RMAPolicySysNo , defaultRMAPolicy.RMAPolicySysNo); //记录日志 ExternalDomainBroker.CreateOperationLog(LogNote , BizLogType.DefaultRMAPolicy_Edit , Int32.Parse(defaultRMAPolicy.SysNo.ToString()), "8601"); tran.Complete(); } // throw new BizException("保存成功!"); }