/// <summary>
/// 修改入库单数据
/// </summary>
/// <param name="bill"></param>
/// <param name="listGoods"></param>
/// <param name="nOpStaffId"></param>
/// <param name="strOpStaffName"></param>
/// <param name="strErrText"></param>
/// <returns></returns>
public bool UpdateEnterWarehouseBill(EnterWarehouseBill bill, List<EnterWarehouseBillGoods> listGoods, long nOpStaffId, string strOpStaffName, out string strErrText)
{
try
{
using (TransactionScope transScope = new TransactionScope(TransactionScopeOption.Required, new TimeSpan(2, 0, 0)))
{
using (StockDAO dao = new StockDAO())
{
//读取原入库单货物数据
List<EnterWarehouseBillGoods> listOldGoods = dao.LoadEnterWarehouseBillAllGoods(bill.Id, nOpStaffId, strOpStaffName, out strErrText);
if (listOldGoods == null)
{
return false;
}
//如果划拨计划所产生的入库单，则修改前必须检查新旧货物的数量
if (bill.PlanId > 0)
{
//检查每个品种数据
var grpOldGoods = listOldGoods.GroupBy(g => new { g.GoodsNo, g.BatchNo, g.Packing, g.ProductionDate, g.EnterWarehouseBillId });
foreach (var grpOld in grpOldGoods)
{
string strGoodsNo = grpOld.Key.GoodsNo;
string strBatchNo = grpOld.Key.BatchNo;
string strPacking = grpOld.Key.Packing;
string strProductionDate = grpOld.Key.ProductionDate;
long nEnterWarehouseBillId = grpOld.Key.EnterWarehouseBillId;
int nOldTotalPackages = grpOld.Sum(s => s.Packages);
decimal decOldTotalTunnages = grpOld.Sum(s => s.Tunnages);
List<EnterWarehouseBillGoods> listNew = listGoods.Where(g => g.GoodsNo == strGoodsNo && g.BatchNo == strBatchNo && (g.Packing ?? string.Empty) == strPacking && g.ProductionDate == strProductionDate && g.EnterWarehouseBillId == nEnterWarehouseBillId).ToList();
if (nOldTotalPackages != listNew.Sum(g => g.Packages) || decOldTotalTunnages != listNew.Sum(g => g.Tunnages))
{
strErrText = string.Format(InnoSoft.LS.Resources.Strings.GoodsModifyBeforeAndAfterPackagesOrTunnagesNotEqual, strGoodsNo, strBatchNo, strPacking, strProductionDate);
return false;
}
}
//检查总数量
if (listGoods.Sum(g => g.Packages) != listOldGoods.Sum(g => g.Packages) || listGoods.Sum(g => g.Tunnages) != listOldGoods.Sum(g => g.Tunnages))
{
strErrText = InnoSoft.LS.Resources.Strings.GoodsModifyBeforeAndAfterTotalPackagesOrTotalTunnagesNotEqual;
return false;
}
}
//新增入库货物数据
foreach (EnterWarehouseBillGoods goods in listGoods)
{
if (goods.Id == 0)
{
if (!dao.InsertEnterWarehouseBillGoods(goods, nOpStaffId, strOpStaffName, out strErrText))
{
return false;
}
}
}
//修改入库货物数据
foreach (EnterWarehouseBillGoods goods in listGoods)
{
if (goods.Id > 0)
{
if (!dao.UpdateEnterWarehouseBillGoods(goods, nOpStaffId, strOpStaffName, out strErrText))
{
return false;
}
}
}
//删除入库单货物数据
foreach (EnterWarehouseBillGoods o in listOldGoods)
{
if (listGoods.FindAll(delegate(EnterWarehouseBillGoods g) { return g.Id == o.Id; }).Count == 0)
{
if (!dao.DeleteEnterWarehouseBillGoods(o.Id, nOpStaffId, strOpStaffName, out strErrText))
{
return false;
}
}
}
//修改入库单数据
if (!dao.UpdateEnterWarehouseBill(bill, nOpStaffId, strOpStaffName, out strErrText))
{
return false;
}
}
using (CustomerDAO dao = new CustomerDAO())
{
//修改下力支费价格数据
List<CustomerForceFeePrice> listForceFeePrice = dao.LoadCustomerForceFeePricesByCustomerId(bill.CustomerId, nOpStaffId, strOpStaffName, out strErrText);
if (listForceFeePrice.Count == 0)
{
//新增力支费价格数据
CustomerForceFeePrice data = new CustomerForceFeePrice();
data.CustomerId = bill.CustomerId;
data.StartTime = bill.CreateTime;
data.EndTime = DateTime.Parse("9999-12-31");
data.LoadingForceFeePrice = 0;
data.UnloadingForceFeePrice = bill.UnloadingForceFeePrice;
if (!dao.InsertCustomerForceFeePrice(data, nOpStaffId, strOpStaffName, out strErrText))
{
return false;
}
}
else
{
int i = 0;
while (i < listForceFeePrice.Count)
{
if (bill.CreateTime.Date >= listForceFeePrice[i].StartTime.Date && bill.CreateTime.Date <= listForceFeePrice[i].EndTime.Date)
{
break;
}
i++;
}
if (i < listForceFeePrice.Count)
{
//修改力支费价格数据
listForceFeePrice[i].UnloadingForceFeePrice = bill.UnloadingForceFeePrice;
if (!dao.UpdateCustomerForceFeePrice(listForceFeePrice[i], nOpStaffId, strOpStaffName, out strErrText))
{
return false;
}
}
else
{
//新增力支费价格数据
CustomerForceFeePrice data = new CustomerForceFeePrice();
data.CustomerId = bill.CustomerId;
data.StartTime = bill.CreateTime;
data.LoadingForceFeePrice = 0;
data.UnloadingForceFeePrice = bill.UnloadingForceFeePrice;
//计算截止时间
i = 0;
while (i < listForceFeePrice.Count)
{
if (bill.CreateTime.Date < listForceFeePrice[i].StartTime.Date)
{
break;
}
i++;
}
if (i < listForceFeePrice.Count)
{
data.EndTime = listForceFeePrice[i].StartTime.Date.AddDays(-1);
}
else
{
data.EndTime = DateTime.Parse("9999-12-31");
}
if (!dao.InsertCustomerForceFeePrice(data, nOpStaffId, strOpStaffName, out strErrText))
{
return false;
}
}
}
//修改仓储费价格数据
List<CustomerStorageFeePrice> listStorageFeePrice = dao.LoadCustomerStorageFeePricesByCustomerId(bill.CustomerId, nOpStaffId, strOpStaffName, out strErrText);
if (listStorageFeePrice.Count == 0)
{
//新增仓储费价格数据
CustomerStorageFeePrice data = new CustomerStorageFeePrice();
data.CustomerId = bill.CustomerId;
data.StartTime = bill.CreateTime;
data.EndTime = DateTime.Parse("9999-12-31");
data.StorageFeePrice = bill.StorageFeePrice;
if (!dao.InsertCustomerStorageFeePrice(data, nOpStaffId, strOpStaffName, out strErrText))
{
return false;
}
}
else
{
int i = 0;
while (i < listStorageFeePrice.Count)
{
if (bill.CreateTime.Date >= listStorageFeePrice[i].StartTime.Date && bill.CreateTime.Date <= listStorageFeePrice[i].EndTime.Date)
{
break;
}
i++;
}
if (i < listStorageFeePrice.Count)
{
//修改仓储费价格数据
listStorageFeePrice[i].StorageFeePrice = bill.StorageFeePrice;
if (!dao.UpdateCustomerStorageFeePrice(listStorageFeePrice[i], nOpStaffId, strOpStaffName, out strErrText))
{
return false;
}
}
else
{
//新增仓储费价格数据
CustomerStorageFeePrice data = new CustomerStorageFeePrice();
data.CustomerId = bill.CustomerId;
data.StartTime = bill.CreateTime;
data.StorageFeePrice = bill.StorageFeePrice;
//计算截止时间
i = 0;
while (i < listStorageFeePrice.Count)
{
if (bill.CreateTime.Date < listStorageFeePrice[i].StartTime.Date)
{
break;
}
i++;
}
if (i < listStorageFeePrice.Count)
{
data.EndTime = listStorageFeePrice[i].StartTime.Date.AddDays(-1);
}
else
{
data.EndTime = DateTime.Parse("9999-12-31");
}
if (!dao.InsertCustomerStorageFeePrice(data, nOpStaffId, strOpStaffName, out strErrText))
{
return false;
}
}
}
}
transScope.Complete();
}
return true;
}
catch (Exception e)
{
strErrText = e.Message;
return false;
}
}
/// <summary>
/// 修改出仓单数据
/// </summary>
/// <param name="nId"></param>
/// <param name="decTransportCharges">运费</param>
/// <param name="listGoods"></param>
/// <param name="nOpStaffId"></param>
/// <param name="strOpStaffName"></param>
/// <param name="strErrText"></param>
/// <returns></returns>
public bool UpdateShipmentBill(long nId, decimal decTransportCharges, List<ShipmentBillGoods> listGoods, long nOpStaffId, string strOpStaffName, out string strErrText)
{
try
{
strErrText = string.Empty;
long nDispatchBillId = 0;
long nPlanId = 0;
string strOutType = string.Empty;
using (TransactionScope transScope = new TransactionScope(TransactionScopeOption.Required, new TimeSpan(2, 0, 0)))
{
//修改出仓单货物数据
using (DeliverDAO dao = new DeliverDAO())
{
ShipmentBill bill = dao.LoadShipmentBill(nId, nOpStaffId, strOpStaffName, out strErrText);
if (bill == null)
{
return false;
}
nDispatchBillId = bill.DispatchBillId;
nPlanId = bill.PlanId;
strOutType = bill.OutType;
foreach (ShipmentBillGoods goods in listGoods)
{
if (!dao.UpdateShipmentBillGoods(goods, nOpStaffId, strOpStaffName, out strErrText))
{
return false;
}
}
}
//如果是划拨出库，则需要修改入库单
if (strOutType == InnoSoft.LS.Resources.Options.AllocateGoods)
{
using (StockDAO dao = new StockDAO())
{
//读取入库单编码
EnterWarehouseBill bill = dao.LoadEnterWarehouseBillByPlanId(nPlanId, nOpStaffId, strOpStaffName, out strErrText);
if (bill == null)
{
return false;
}
long nEnterWarehouseBillId = bill.Id;
//读取入库单货物数据
List<EnterWarehouseBillGoods> listEnterWarehouseBillGoods = dao.LoadEnterWarehouseBillAllGoods(nEnterWarehouseBillId, nOpStaffId, strOpStaffName, out strErrText);
if (listEnterWarehouseBillGoods == null)
{
return false;
}
foreach (EnterWarehouseBillGoods goods in listEnterWarehouseBillGoods)
{
int nNewPackages = 0;
decimal decNewTunnages = 0;
decimal decNewPiles = 0;
decimal decNewTenThousands = 0;
string[] strShipmentBillGoodsIds = goods.ShipmentBillGoodsIds.Split(',');
foreach (string strShipmentBillGoodsId in strShipmentBillGoodsIds)
{
ShipmentBillGoods goods1 = listGoods.Find(delegate(ShipmentBillGoods g) { return g.Id == long.Parse(strShipmentBillGoodsId); });
if (goods1 == null)
{
strErrText = InnoSoft.LS.Resources.Strings.NotFoundShipmentBillGoodsForEnterWarehouseBill;
return false;
}
nNewPackages += goods1.Packages;
decNewTunnages += goods1.Tunnages;
decNewPiles += goods1.Piles;
decNewTenThousands += goods1.TenThousands;
}
goods.Packages = nNewPackages;
goods.Tunnages = decNewTunnages;
goods.Piles = decNewPiles;
goods.TenThousands = decNewTenThousands;
if (!dao.UpdateEnterWarehouseBillGoods(goods, nOpStaffId, strOpStaffName, out strErrText))
{
return false;
}
}
}
}
//如果是发货出库，则需要修改调度记录数据
if (strOutType == InnoSoft.LS.Resources.Options.DeliverGoods)
{
using (DispatchDAO dao = new DispatchDAO())
{
//读取调度单计划数据
DispatchBillDeliverPlan plan = dao.LoadDispatchBillDeliverPlan(nDispatchBillId, nPlanId, nOpStaffId, strOpStaffName, out strErrText);
if (plan == null)
{
return false;
}
decimal decOldTransportCharges = plan.TransportCharges;
//修改调度单计划数据
plan.TransportCharges = decTransportCharges;
if (!dao.UpdateDispatchBillDeliverPlan(plan, nOpStaffId, strOpStaffName, out strErrText))
{
return false;
}
//读取调度单数据
DispatchBill bill = dao.LoadDispatchBill(nDispatchBillId, nOpStaffId, strOpStaffName, out strErrText);
if (bill == null)
{
return false;
}
//修改调度单数据
bill.TotalTransportCharges = bill.TotalTransportCharges - decOldTransportCharges + decTransportCharges;
if (!dao.UpdateDispatchBill(bill, nOpStaffId, strOpStaffName, out strErrText))
{
return false;
}
//校验调度单数据
if (!dao.CheckDispatchBill(nDispatchBillId, nOpStaffId, strOpStaffName, out strErrText))
{
return false;
}
}
}
transScope.Complete();
}
return true;
}
catch (Exception e)
{
strErrText = e.Message;
return false;
}
}
/// <summary>
/// 读取入库单所有货物数据
/// </summary>
/// <param name="nEnterWarehouseBillId"></param>
/// <param name="nOpStaffId"></param>
/// <param name="strOpStaffName"></param>
/// <param name="strErrText"></param>
/// <returns></returns>
public List<EnterWarehouseBillGoods> LoadEnterWarehouseBillAllGoods(long nEnterWarehouseBillId, long nOpStaffId, string strOpStaffName, out string strErrText)
{
try
{
List<EnterWarehouseBillGoods> ret = null;
using (TransactionScope transScope = new TransactionScope(TransactionScopeOption.Required, new TimeSpan(2, 0, 0)))
{
using (StockDAO dao = new StockDAO())
{
ret = dao.LoadEnterWarehouseBillAllGoods(nEnterWarehouseBillId, nOpStaffId, strOpStaffName, out strErrText);
if (ret == null)
return null;
}
transScope.Complete();
}
return ret;
}
catch (Exception e)
{
strErrText = e.Message;
return null;
}
}