/// <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 DeleteOutWarehouseBill(long nId, 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())
{
//如果出库单是由出仓单自动生成的，则不允许手工删除
OutWarehouseBill bill = dao.LoadOutWarehouseBill(nId, nOpStaffId, strOpStaffName, out strErrText);
if (bill == null)
{
return false;
}
if (bill.ShipmentBillId > 0)
{
strErrText = InnoSoft.LS.Resources.Strings.CanNotDeleteOutWarehouseBillCreateByShipmentBill;
return false;
}
//删除出库单数据
if (!dao.DeleteOutWarehouseBill(nId, nOpStaffId, strOpStaffName, out strErrText))
{
return false;
}
//删除出库单货物数据
if (!dao.DeleteOutWarehouseBillAllGoods(nId, 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="nOpStaffId"></param>
/// <param name="strOpStaffName"></param>
/// <param name="strErrText"></param>
/// <returns></returns>
public bool DeleteCustomerStorageAndForceFeeSettlement(long nId, 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())
{
if (!dao.DeleteCustomerStorageAndForceFeeSettlement(nId, nOpStaffId, strOpStaffName, out strErrText))
return false;
}
transScope.Complete();
}
return true;
}
catch (Exception e)
{
strErrText = e.Message;
return false;
}
}
/// <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 DeleteMoveWarehouseBill(long nId, 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())
{
if (!dao.DeleteMoveWarehouseBill(nId, nOpStaffId, strOpStaffName, out strErrText))
{
return false;
}
}
transScope.Complete();
}
return true;
}
catch (Exception e)
{
strErrText = e.Message;
return false;
}
}
/// <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 UpdateOutWarehouseBill(OutWarehouseBill bill, List<OutWarehouseBillGoods> 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())
{
//修改出库单数据
if (!dao.UpdateOutWarehouseBill(bill, nOpStaffId, strOpStaffName, out strErrText))
{
return false;
}
//修改出库货物数据
foreach (OutWarehouseBillGoods goods in listGoods)
{
if (!dao.UpdateOutWarehouseBillGoods(goods, 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 = bill.LoadingForceFeePrice;
data.UnloadingForceFeePrice = 0;
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].LoadingForceFeePrice = bill.LoadingForceFeePrice;
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 = bill.LoadingForceFeePrice;
data.UnloadingForceFeePrice = 0;
//计算截止时间
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;
}
}
}
}
transScope.Complete();
}
return true;
}
catch (Exception e)
{
strErrText = e.Message;
return false;
}
}
/// <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="bill"></param>
/// <param name="listGoods"></param>
/// <param name="nOpStaffId"></param>
/// <param name="strOpStaffName"></param>
/// <param name="strErrText"></param>
/// <returns></returns>
public long InsertMoveWarehouseBill(MoveWarehouseBill bill, List<MoveWarehouseBillGoods> listGoods, long nOpStaffId, string strOpStaffName, out string strErrText)
{
long nMoveWarehouseBillId = 0;
try
{
using (TransactionScope transScope = new TransactionScope(TransactionScopeOption.Required, new TimeSpan(2, 0, 0)))
{
using (StockDAO dao = new StockDAO())
{
//新增移库单数据
nMoveWarehouseBillId = dao.InsertMoveWarehouseBill(bill, nOpStaffId, strOpStaffName, out strErrText);
if (nMoveWarehouseBillId <= 0)
return 0;
//新增移库货物数据
foreach (MoveWarehouseBillGoods goods in listGoods)
{
goods.MoveWarehouseBillId = nMoveWarehouseBillId;
if (!dao.InsertMoveWarehouseBillGoods(goods, nOpStaffId, strOpStaffName, out strErrText))
{
return 0;
}
}
}
transScope.Complete();
}
return nMoveWarehouseBillId;
}
catch (Exception e)
{
strErrText = e.Message;
return 0;
}
}
/// <summary>
/// 根据条件读取寄库计划发货数据
/// </summary>
/// <param name="strConsigningDeliveryNo"></param>
/// <param name="nOpStaffId"></param>
/// <param name="strOpStaffName"></param>
/// <param name="strErrText"></param>
/// <returns></returns>
public List<ConsigningDeliverPlanDeliverGoods> LoadConsigningDeliverPlanDeliverGoodsByConditions(string strConsigningDeliveryNo, long nOpStaffId, string strOpStaffName, out string strErrText)
{
try
{
List<ConsigningDeliverPlanDeliverGoods> ret = null;
using (TransactionScope transScope = new TransactionScope(TransactionScopeOption.Required, new TimeSpan(2, 0, 0)))
{
using (StockDAO dao = new StockDAO())
{
ret = dao.LoadConsigningDeliverPlanDeliverGoodsByConditions(strConsigningDeliveryNo, nOpStaffId, strOpStaffName, out strErrText);
if (ret == null)
return null;
}
transScope.Complete();
}
return ret;
}
catch (Exception e)
{
strErrText = e.Message;
return null;
}
}
/// <summary>
/// 取消送货单数据
/// </summary>
/// <param name="nId"></param>
/// <param name="nOpStaffId"></param>
/// <param name="strOpStaffName"></param>
/// <param name="strErrText"></param>
/// <returns></returns>
public bool CancelDeliverBill(long nId, long nOpStaffId, string strOpStaffName, out string strErrText)
{
try
{
strErrText = string.Empty;
long nShipmentBillId = 0;
long nDispatchBillId = 0;
long nPlanId = 0;
using (TransactionScope transScope = new TransactionScope(TransactionScopeOption.Required, new TimeSpan(2, 0, 0)))
{
using (DeliverDAO dao = new DeliverDAO())
{
//读取送货单数据
DeliverBill bill = dao.LoadDeliverBill(nId, nOpStaffId, strOpStaffName, out strErrText);
if (bill == null)
{
return false;
}
nShipmentBillId = bill.ShipmentBillId;
nDispatchBillId = bill.DispatchBillId;
nPlanId = bill.PlanId;
//删除送货单数据
if (!dao.DeleteDeliverBill(nId, nOpStaffId, strOpStaffName, out strErrText))
{
return false;
}
//删除送货单货物数据
if (!dao.DeleteDeliverBillAllGoods(nId, nOpStaffId, strOpStaffName, out strErrText))
{
return false;
}
//删除出仓单数据
if (!dao.DeleteShipmentBill(nShipmentBillId, nOpStaffId, strOpStaffName, out strErrText))
{
return false;
}
//删除出仓单货物数据
if (!dao.DeleteShipmentBillAllGoods(nShipmentBillId, nOpStaffId, strOpStaffName, out strErrText))
{
return false;
}
}
using (StockDAO dao = new StockDAO())
{
//读取出库单数据
OutWarehouseBill bill = dao.LoadOutWarehouseBillByShipmentBillId(nShipmentBillId, nOpStaffId, strOpStaffName, out strErrText);
if (bill == null)
{
return false;
}
//删除出库单数据
if (!dao.DeleteOutWarehouseBill(bill.Id, nOpStaffId, strOpStaffName, out strErrText))
{
return false;
}
//删除出库单货物数据
if (!dao.DeleteOutWarehouseBillAllGoods(bill.Id, nOpStaffId, strOpStaffName, out strErrText))
{
return false;
}
}
using (DispatchDAO dao = new DispatchDAO())
{
//读取调度单计划数据
DispatchBillDeliverPlan plan = dao.LoadDispatchBillDeliverPlan(nDispatchBillId, nPlanId, nOpStaffId, strOpStaffName, out strErrText);
if (plan == null)
{
return false;
}
//读取调度单数据
DispatchBill bill = dao.LoadDispatchBill(nDispatchBillId, nOpStaffId, strOpStaffName, out strErrText);
if (bill == null)
{
return false;
}
//修改或删除调度单数据
bill.TotalPackages = bill.TotalPackages - plan.Packages;
bill.TotalTunnages = bill.TotalTunnages - plan.Tunnages;
bill.TotalPiles = bill.TotalPiles - plan.Piles;
bill.TotalTenThousands = bill.TotalTenThousands - plan.TenThousands;
bill.TotalTransportCharges = bill.TotalTransportCharges - plan.TransportCharges;
if (bill.TotalPackages == 0 && bill.TotalTunnages == 0 && bill.TotalPiles == 0 && bill.TotalTenThousands == 0)
{
if (!dao.DeleteDispatchBill(nDispatchBillId, nOpStaffId, strOpStaffName, out strErrText))
{
return false;
}
}
else
{
if (!dao.UpdateDispatchBill(bill, nOpStaffId, strOpStaffName, out strErrText))
{
return false;
}
}
//删除调度单计划数据
if (!dao.DeleteDispatchBillDeliverPlan(nDispatchBillId, nPlanId, nOpStaffId, strOpStaffName, out strErrText))
{
return false;
}
//删除调度计划货物数据
if (!dao.DeleteDispatchBillDeliverPlanAllGoods(nDispatchBillId, nPlanId, nOpStaffId, strOpStaffName, out strErrText))
{
return false;
}
//校验调度单数据
if (bill.TotalPackages != 0 || bill.TotalTunnages != 0 || bill.TotalPiles != 0 || bill.TotalTenThousands != 0)
{
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="strStartTime"></param>
/// <param name="strEndTime"></param>
/// <param name="strCustomerName"></param>
/// <param name="strWarehouse"></param>
/// <param name="strIsConsigning"></param>
/// <param name="nOpStaffId"></param>
/// <param name="strOpStaffName"></param>
/// <param name="strErrText"></param>
/// <returns></returns>
public List<StatStorageAndForceFee> LoadStatStorageAndForceFeeByConditions(string strStartTime, string strEndTime, string strCustomerName, string strWarehouse, string strIsConsigning, long nOpStaffId, string strOpStaffName, out string strErrText)
{
try
{
List<StatStorageAndForceFee> ret = null;
using (TransactionScope transScope = new TransactionScope(TransactionScopeOption.Required, new TimeSpan(2, 0, 0)))
{
using (StockDAO dao = new StockDAO())
{
ret = dao.LoadStatStorageAndForceFeeByConditions(strStartTime, strEndTime, strCustomerName, strWarehouse, strIsConsigning, nOpStaffId, strOpStaffName, out strErrText);
if (ret == null)
return null;
}
transScope.Complete();
}
return ret;
}
catch (Exception e)
{
strErrText = e.Message;
return null;
}
}
/// <summary>
/// 根据条件读取出库货物数据
/// </summary>
/// <param name="strStartTime"></param>
/// <param name="strEndTime"></param>
/// <param name="strCustomerName"></param>
/// <param name="strDeliveryNo"></param>
/// <param name="strOutWarehouseBillNo"></param>
/// <param name="strGoodsNo"></param>
/// <param name="strBatchNo"></param>
/// <param name="strCarNo"></param>
/// <param name="strReceiverName"></param>
/// <param name="strOutType"></param>
/// <param name="strWarehouse"></param>
/// <param name="strReceiveType"></param>
/// <param name="nOpStaffId"></param>
/// <param name="strOpStaffName"></param>
/// <param name="strErrText"></param>
/// <returns></returns>
public List<OutWarehouseBillGoods> LoadOutWarehouseBillGoodsByConditions(string strStartTime, string strEndTime, string strCustomerName, string strDeliveryNo, string strOutWarehouseBillNo, string strGoodsNo, string strBatchNo, string strCarNo, string strReceiverName, string strOutType, string strWarehouse, string strReceiveType, long nOpStaffId, string strOpStaffName, out string strErrText)
{
try
{
List<OutWarehouseBillGoods> ret = null;
using (TransactionScope transScope = new TransactionScope(TransactionScopeOption.Required, new TimeSpan(2, 0, 0)))
{
using (StockDAO dao = new StockDAO())
{
ret = dao.LoadOutWarehouseBillGoodsByConditions(strStartTime, strEndTime, strCustomerName, strDeliveryNo, strOutWarehouseBillNo, strGoodsNo, strBatchNo, strCarNo, strReceiverName, strOutType, strWarehouse, strReceiveType, nOpStaffId, strOpStaffName, out strErrText);
if (ret == null)
return null;
}
transScope.Complete();
}
return ret;
}
catch (Exception e)
{
strErrText = e.Message;
return null;
}
}
/// <summary>
/// 读取出库单所有货物数据
/// </summary>
/// <param name="nOutWarehouseBillId"></param>
/// <param name="nOpStaffId"></param>
/// <param name="strOpStaffName"></param>
/// <param name="strErrText"></param>
/// <returns></returns>
public List<OutWarehouseBillGoods> LoadOutWarehouseBillAllGoods(long nOutWarehouseBillId, long nOpStaffId, string strOpStaffName, out string strErrText)
{
try
{
List<OutWarehouseBillGoods> ret = null;
using (TransactionScope transScope = new TransactionScope(TransactionScopeOption.Required, new TimeSpan(2, 0, 0)))
{
using (StockDAO dao = new StockDAO())
{
ret = dao.LoadOutWarehouseBillAllGoods(nOutWarehouseBillId, nOpStaffId, strOpStaffName, out strErrText);
if (ret == null)
return null;
}
transScope.Complete();
}
return ret;
}
catch (Exception e)
{
strErrText = e.Message;
return null;
}
}
/// <summary>
/// 读取指定客户编码、货物编码、批次号和仓库的货物库存数据
/// </summary>
/// <param name="strCustomerId"></param>
/// <param name="strGoodsId"></param>
/// <param name="strBatchNo"></param>
/// <param name="strPacking"></param>
/// <param name="strWarehouse"></param>
/// <param name="strLocation"></param>
/// <param name="strProductionDate"></param>
/// <param name="strEnterWarehouseBillId"></param>
/// <param name="strDeliveryNo">寄库交货单号</param>
/// <param name="nOpStaffId"></param>
/// <param name="strOpStaffName"></param>
/// <param name="strErrText"></param>
/// <returns></returns>
public List<Stock> LoadGoodsStocksByConditions(string strCustomerId, string strGoodsId, string strBatchNo, string strPacking, string strWarehouse, string strLocation, string strProductionDate, string strEnterWarehouseBillId, string strDeliveryNo, long nOpStaffId, string strOpStaffName, out string strErrText)
{
try
{
List<Stock> ret = null;
using (TransactionScope transScope = new TransactionScope(TransactionScopeOption.Required, new TimeSpan(2, 0, 0)))
{
using (StockDAO dao = new StockDAO())
{
ret = dao.LoadGoodsStocksByConditions(strCustomerId, strGoodsId, strBatchNo, strPacking, strWarehouse, strLocation, strProductionDate, strEnterWarehouseBillId, strDeliveryNo, nOpStaffId, strOpStaffName, out strErrText);
if (ret == null)
return null;
}
transScope.Complete();
}
return ret;
}
catch (Exception e)
{
strErrText = e.Message;
return null;
}
}
/// <summary>
/// 根据综合条件读取仓储力支费结算数据
/// </summary>
/// <param name="strStartTime"></param>
/// <param name="strEndTime"></param>
/// <param name="strInvoiceNo"></param>
/// <param name="strCustomerName"></param>
/// <param name="nOpStaffId"></param>
/// <param name="strOpStaffName"></param>
/// <param name="strErrText"></param>
/// <returns></returns>
public List<CustomerStorageAndForceFeeSettlement> LoadCustomerStorageAndForceFeeSettlementsByConditions(string strStartTime, string strEndTime, string strInvoiceNo, string strCustomerName, long nOpStaffId, string strOpStaffName, out string strErrText)
{
try
{
List<CustomerStorageAndForceFeeSettlement> dataResult = null;
strErrText = String.Empty;
using (TransactionScope transScope = new TransactionScope(TransactionScopeOption.Required, new TimeSpan(2, 0, 0)))
{
using (StockDAO dao = new StockDAO())
{
dataResult = dao.LoadCustomerStorageAndForceFeeSettlementsByConditions(strStartTime, strEndTime, strInvoiceNo, strCustomerName, nOpStaffId, strOpStaffName, out strErrText);
}
transScope.Complete();
}
return dataResult;
}
catch (Exception e)
{
strErrText = e.Message;
return null;
}
}
/// <summary>
/// 修改综合查询数据
/// </summary>
/// <param name="nPlanId"></param>
/// <param name="strShipmentNo"></param>
/// <param name="strDeliveryNo"></param>
/// <param name="nPayerId"></param>
/// <param name="strPayerName"></param>
/// <param name="nContractId"></param>
/// <param name="strOriginalContractNo"></param>
/// <param name="nOpStaffId"></param>
/// <param name="strOpStaffName"></param>
/// <param name="strErrText"></param>
/// <returns></returns>
public bool SyntheticalSearchModifyData(long nPlanId, string strShipmentNo, string strDeliveryNo, long nPayerId, string strPayerName, long nContractId, string strOriginalContractNo, long nOpStaffId, string strOpStaffName, out string strErrText)
{
try
{
using (TransactionScope transScope = new TransactionScope(TransactionScopeOption.Required, new TimeSpan(2, 0, 0)))
{
//修改发货计划
using (PlanDAO dao = new PlanDAO())
{
DeliverPlan data = dao.LoadDeliverPlan(nPlanId, nOpStaffId, strOpStaffName, out strErrText);
if (data == null)
{
return false;
}
data.ShipmentNo = strShipmentNo;
data.DeliveryNo = strDeliveryNo;
data.PayerId = nPayerId;
data.PayerName = strPayerName;
if (!dao.UpdateDeliverPlan(data, nOpStaffId, strOpStaffName, out strErrText))
{
return false;
}
}
//修改出仓单和送货单数据
using (DeliverDAO dao = new DeliverDAO())
{
List<ShipmentBill> listShipmentBill = dao.LoadShipmentBillsByPlanId(nPlanId, nOpStaffId, strOpStaffName, out strErrText);
foreach (ShipmentBill data in listShipmentBill)
{
if (!dao.UpdateShipmentBillDeliveryNo(data.Id, strDeliveryNo, nOpStaffId, strOpStaffName, out strErrText))
{
return false;
}
}
List<DeliverBill> listDeliverBill = dao.LoadDeliverBillsByPlanId(nPlanId, nOpStaffId, strOpStaffName, out strErrText);
foreach (DeliverBill data in listDeliverBill)
{
if (!dao.UpdateDeliverBillDeliveryNo(data.Id, strDeliveryNo, nOpStaffId, strOpStaffName, out strErrText))
{
return false;
}
}
}
//修改出库单、入库单和库存数据
using (StockDAO dao = new StockDAO())
{
List<OutWarehouseBill> listOutWarehouseBill = dao.LoadOutWarehouseBillsByPlanId(nPlanId, nOpStaffId, strOpStaffName, out strErrText);
foreach (OutWarehouseBill data in listOutWarehouseBill)
{
data.DeliveryNo = strDeliveryNo;
data.PayerId = nPayerId;
data.PayerName = strPayerName;
if (!dao.UpdateOutWarehouseBill(data, nOpStaffId, strOpStaffName, out strErrText))
{
return false;
}
}
}
//修改合同数据
using (ContractDAO dao = new ContractDAO())
{
if (nContractId > 0)
{
Contract data = dao.LoadContract(nContractId, nOpStaffId, strOpStaffName, out strErrText);
if (data == null)
{
return false;
}
data.OriginalContractNo = strOriginalContractNo;
if (!dao.UpdateContract(data, nOpStaffId, strOpStaffName, out strErrText))
{
return false;
}
}
}
transScope.Complete();
}
return true;
}
catch (Exception e)
{
strErrText = e.Message;
return false;
}
}
/// <summary>
/// 读取库存尾差数据
/// </summary>
/// <param name="strCustomerName"></param>
/// <param name="strGoodsId"></param>
/// <param name="strWarehouse"></param>
/// <param name="strIsConsigning"></param>
/// <param name="strConsignedDeliveryNo"></param>
/// <param name="nOpStaffId"></param>
/// <param name="strOpStaffName"></param>
/// <param name="strErrText"></param>
/// <returns></returns>
public List<Stock> LoadStockEndDifferencesByConditions(string strCustomerName, string strGoodsId, string strWarehouse, string strIsConsigning, string strConsignedDeliveryNo, long nOpStaffId, string strOpStaffName, out string strErrText)
{
try
{
List<Stock> dataResult = null;
strErrText = String.Empty;
using (TransactionScope transScope = new TransactionScope(TransactionScopeOption.Required, new TimeSpan(2, 0, 0)))
{
using (StockDAO dao = new StockDAO())
{
dataResult = dao.LoadStockEndDifferencesByConditions(strCustomerName, strGoodsId, strWarehouse, strIsConsigning, strConsignedDeliveryNo, nOpStaffId, strOpStaffName, out strErrText);
}
transScope.Complete();
}
return dataResult;
}
catch (Exception e)
{
strErrText = e.Message;
return null;
}
}
/// <summary>
/// 取消出仓单
/// </summary>
/// <param name="nId"></param>
/// <param name="nOpStaffId"></param>
/// <param name="strOpStaffName"></param>
/// <param name="strErrText"></param>
/// <returns></returns>
public bool CancelShipmentBill(long nId, 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;
//删除出仓单数据
if (!dao.DeleteShipmentBill(nId, nOpStaffId, strOpStaffName, out strErrText))
{
return false;
}
//删除出仓单货物数据
if (!dao.DeleteShipmentBillAllGoods(nId, nOpStaffId, strOpStaffName, out strErrText))
{
return false;
}
}
//删除出库单数据
using (StockDAO dao = new StockDAO())
{
//读取出库单数据
OutWarehouseBill bill = dao.LoadOutWarehouseBillByShipmentBillId(nId, nOpStaffId, strOpStaffName, out strErrText);
if (bill == null)
{
return false;
}
//删除出库单数据
if (!dao.DeleteOutWarehouseBill(bill.Id, nOpStaffId, strOpStaffName, out strErrText))
{
return false;
}
//删除出库单货物数据
if (!dao.DeleteOutWarehouseBillAllGoods(bill.Id, 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;
}
//删除入库单货物数据
if (!dao.DeleteEnterWarehouseBillAllGoods(bill.Id, nOpStaffId, strOpStaffName, out strErrText))
{
return false;
}
//删除入库单数据
if (!dao.DeleteEnterWarehouseBill(bill.Id, 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;
}
//读取调度单数据
DispatchBill bill = dao.LoadDispatchBill(nDispatchBillId, nOpStaffId, strOpStaffName, out strErrText);
if (bill == null)
{
return false;
}
//修改或删除调度单数据
bill.TotalPackages = bill.TotalPackages - plan.Packages;
bill.TotalTunnages = bill.TotalTunnages - plan.Tunnages;
bill.TotalPiles = bill.TotalPiles - plan.Piles;
bill.TotalTenThousands = bill.TotalTenThousands - plan.TenThousands;
bill.TotalTransportCharges = bill.TotalTransportCharges - plan.TransportCharges;
if (bill.TotalPackages == 0 && bill.TotalTunnages == 0 && bill.TotalPiles == 0 && bill.TotalTenThousands == 0)
{
if (!dao.DeleteDispatchBill(nDispatchBillId, nOpStaffId, strOpStaffName, out strErrText))
{
return false;
}
}
else
{
if (!dao.UpdateDispatchBill(bill, nOpStaffId, strOpStaffName, out strErrText))
{
return false;
}
}
//删除调度单计划数据
if (!dao.DeleteDispatchBillDeliverPlan(nDispatchBillId, nPlanId, nOpStaffId, strOpStaffName, out strErrText))
{
return false;
}
//删除调度计划货物数据
if (!dao.DeleteDispatchBillDeliverPlanAllGoods(nDispatchBillId, nPlanId, nOpStaffId, strOpStaffName, out strErrText))
{
return false;
}
//校验调度单数据
if (bill.TotalPackages != 0 || bill.TotalTunnages != 0 || bill.TotalPiles != 0 || bill.TotalTenThousands != 0)
{
if (!dao.CheckDispatchBill(nDispatchBillId, nOpStaffId, strOpStaffName, out strErrText))
{
return false;
}
}
}
}
//如果是划拨出库，则直接取消发货计划
if (strOutType == InnoSoft.LS.Resources.Options.AllocateGoods)
{
using (PlanDAO dao = new PlanDAO())
{
if (!dao.CancelDeliverPlan(nPlanId, nOpStaffId, strOpStaffName, out strErrText))
{
return false;
}
}
}
transScope.Complete();
}
return true;
}
catch (Exception e)
{
strErrText = e.Message;
return false;
}
}
/// <summary>
/// 读取库存盘点数据
/// </summary>
/// <param name="strWarehouse"></param>
/// <param name="strLocation"></param>
/// <param name="nOpStaffId"></param>
/// <param name="strOpStaffName"></param>
/// <param name="strErrText"></param>
/// <returns></returns>
public List<Stock> LoadStocktakingByConditions(string strWarehouse, string strLocation, long nOpStaffId, string strOpStaffName, out string strErrText)
{
try
{
List<Stock> ret = null;
using (TransactionScope transScope = new TransactionScope(TransactionScopeOption.Required, new TimeSpan(2, 0, 0)))
{
using (StockDAO dao = new StockDAO())
{
ret = dao.LoadStocktakingByConditions(strWarehouse, strLocation, nOpStaffId, strOpStaffName, out strErrText);
if (ret == null)
return null;
}
transScope.Complete();
}
return ret;
}
catch (Exception e)
{
strErrText = e.Message;
return null;
}
}
/// <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="data"></param>
/// <param name="nOpStaffId"></param>
/// <param name="strOpStaffName"></param>
/// <param name="strErrText"></param>
/// <returns></returns>
public long InsertCustomerStorageAndForceFeeSettlement(CustomerStorageAndForceFeeSettlement data, long nOpStaffId, string strOpStaffName, out string strErrText)
{
long nId = 0;
try
{
using (TransactionScope transScope = new TransactionScope(TransactionScopeOption.Required, new TimeSpan(2, 0, 0)))
{
using (StockDAO dao = new StockDAO())
{
nId = dao.InsertCustomerStorageAndForceFeeSettlement(data, nOpStaffId, strOpStaffName, out strErrText);
if (nId <= 0)
return 0;
}
transScope.Complete();
}
return nId;
}
catch (Exception e)
{
strErrText = e.Message;
return 0;
}
}
