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("保存成功！");
}
