public string CreateOutBillNo() { string billno = ""; IQueryable <OutBillMaster> outBillMasterQuery = OutBillMasterRepository.GetQueryable(); string sysTime = System.DateTime.Now.ToString("yyMMdd"); var billNos = outBillMasterQuery.Where(i => i.BillNo.Contains(sysTime)) .AsEnumerable().OrderBy(i => i.BillNo) .Select(i => i.BillNo); if (billNos.Count() == 0) { billno = System.DateTime.Now.ToString("yyMMdd") + "0001" + "CK"; } else { string billNoStr = billNos.Last(b => b.Contains(sysTime)); int i = Convert.ToInt32(billNoStr.ToString().Substring(6, 4)); i++; string newcode = i.ToString(); for (int j = 0; j < 4 - i.ToString().Length; j++) { newcode = "0" + newcode; } billno = System.DateTime.Now.ToString("yyMMdd") + newcode + "CK"; } return(billno); }
/// <summary> /// 生成出库单号 /// </summary> /// <param name="userName">登陆用户</param> /// <returns></returns> public object GenInBillNo(string userName) { string billno = ""; IQueryable <OutBillMaster> outBillMasterQuery = OutBillMasterRepository.GetQueryable(); string sysTime = System.DateTime.Now.ToString("yyMMdd"); var outBillMaster = outBillMasterQuery.Where(i => i.BillNo.Contains(sysTime)).ToArray().OrderBy(i => i.BillNo).Select(i => new { i.BillNo }.BillNo); var employee = EmployeeRepository.GetQueryable().FirstOrDefault(i => i.UserName == userName); if (outBillMaster.Count() == 0) { billno = System.DateTime.Now.ToString("yyMMdd") + "0001" + "OU"; } else { string billNoStr = outBillMaster.Last(b => b.Contains(sysTime)); int i = Convert.ToInt32(billNoStr.ToString().Substring(6, 4)); i++; string newcode = i.ToString(); for (int j = 0; j < 4 - i.ToString().Length; j++) { newcode = "0" + newcode; } billno = System.DateTime.Now.ToString("yyMMdd") + newcode + "OU"; } var findBillInfo = new { BillNo = billno, billNoDate = DateTime.Now.ToString("yyyy-MM-dd"), employeeID = employee == null ? string.Empty : employee.ID.ToString(), employeeCode = employee == null ? string.Empty : employee.EmployeeCode, employeeName = employee == null ? string.Empty : employee.EmployeeName }; return(findBillInfo); }
public bool Delete(string BillNo, out string errorInfo) { errorInfo = string.Empty; var ibm = OutBillMasterRepository.GetQueryable().FirstOrDefault(i => i.BillNo == BillNo && i.Status == "1"); if (ibm != null) { try { //Del(OutBillDetailRepository, ibm.OutBillAllots); Del(OutBillDetailRepository, ibm.OutBillDetails); OutBillMasterRepository.Delete(ibm); OutBillMasterRepository.SaveChanges(); return(true); } catch (Exception e) { errorInfo = "删除失败!原因:" + e.Message; return(false); } } else { errorInfo = "删除失败!未找到当前需要删除的数据!"; return(false); } }
/// <summary> /// 出库审核 /// </summary> /// <param name="billNo">单据号</param> /// <param name="userName">登陆用户</param> /// <returns></returns> public bool Audit(string billNo, string userName, out string errorInfo) { bool result = false; errorInfo = string.Empty; var outbm = OutBillMasterRepository.GetQueryable().FirstOrDefault(i => i.BillNo == billNo); var employee = EmployeeRepository.GetQueryable().FirstOrDefault(i => i.UserName == userName); if (outbm != null && outbm.Status == "1") { if (string.IsNullOrEmpty(outbm.TargetCellCode))//判断出库主单是否有指定货位 { outbm.Status = "2"; outbm.VerifyDate = DateTime.Now; outbm.UpdateTime = DateTime.Now; outbm.VerifyPersonID = employee.ID; OutBillMasterRepository.SaveChanges(); result = true; } else//如果出库主单指定了货位那么就从指定的货位出库 { result = OutAllot(outbm, employee.ID); errorInfo = infoStr; } } return(result); }
public object GetOutBillMaster() { var outBillMaster = OutBillMasterRepository.GetQueryable() .Where(i => i.Status == "4" || i.Status == "5") .Select(i => new { BillNo = i.BillNo, BillType = "2" }) .ToArray(); return(outBillMaster); }
public bool DownOutBillMaster(string beginDate, string endDate, out string errorInfo) { errorInfo = string.Empty; bool result = false; string outBillStr = ""; string outBillMasterStr = ""; try { var outBillNos = OutBillMasterRepository.GetQueryable().Where(i => i.BillNo == i.BillNo).Select(i => new { i.BillNo }).ToArray(); for (int i = 0; i < outBillNos.Length; i++) { outBillStr += outBillNos[i].BillNo + ","; } OutBillMaster[] outBillMasterList = OutBillMasterDownService.GetOutBillMaster(outBillStr); foreach (var master in outBillMasterList) { var outBillMaster = new OutBillMaster(); outBillMaster.BillNo = master.BillNo; outBillMaster.BillDate = master.BillDate; outBillMaster.BillTypeCode = master.BillTypeCode; outBillMaster.WarehouseCode = master.WarehouseCode; outBillMaster.Status = "1"; outBillMaster.IsActive = master.IsActive; outBillMaster.UpdateTime = DateTime.Now; OutBillMasterRepository.Add(outBillMaster); outBillMasterStr += master.BillNo + ","; } if (outBillMasterStr != string.Empty) { OutBillDetail[] outBillDetailList = OutBillMasterDownService.GetOutBillDetail(outBillMasterStr); foreach (var detail in outBillDetailList) { var outBillDetail = new OutBillDetail(); outBillDetail.BillNo = detail.BillNo; outBillDetail.ProductCode = detail.ProductCode; outBillDetail.UnitCode = detail.UnitCode; outBillDetail.Price = detail.Price; outBillDetail.BillQuantity = detail.BillQuantity; outBillDetail.AllotQuantity = detail.AllotQuantity; outBillDetail.RealQuantity = detail.RealQuantity; outBillDetail.Description = detail.Description; OutBillDetailRepository.Add(outBillDetail); } } OutBillMasterRepository.SaveChanges(); result = true; } catch (Exception e) { errorInfo = "出错,原因:" + e.Message; } return(result); }
public System.Data.DataTable GetStockOut(int page, int rows, string BillNo) { IQueryable <OutBillMaster> OutBillMasterQuery = OutBillMasterRepository.GetQueryable().Where(o => o.Status != "6"); var outBillMaster = OutBillMasterQuery.Where(i => i.BillNo.Contains(BillNo)).OrderBy(i => i.BillNo).Select(s => new { s.BillNo, s.Warehouse.WarehouseName, s.BillType.BillTypeName, //BillDate = s.BillDate.ToString("yyyy-MM-dd hh:mm:ss"), OperatePersonName = s.OperatePerson.EmployeeName, //s.OperatePersonID, //Status = WhatStatus(s.Status), s.Status, VerifyPersonName = s.VerifyPersonID == null ? string.Empty : s.VerifyPerson.EmployeeName, //VerifyDate = (s.VerifyDate == null ? string.Empty : ((DateTime)s.VerifyDate).ToString("yyyy-MM-dd hh:mm:ss")), Description = s.Description, //UpdateTime = s.UpdateTime.ToString("yyyy-MM-dd hh:mm:ss"), s.TargetCellCode }); System.Data.DataTable dt = new System.Data.DataTable(); dt.Columns.Add("出库单号", typeof(string)); dt.Columns.Add("仓库名称", typeof(string)); dt.Columns.Add("订单类型", typeof(string)); dt.Columns.Add("操作员", typeof(string)); dt.Columns.Add("审核人", typeof(string)); dt.Columns.Add("处理状态", typeof(string)); //dt.Columns.Add("BillDate", typeof(string)); //dt.Columns.Add("VerifyDate", typeof(string)); //dt.Columns.Add("UpdateTime", typeof(string)); dt.Columns.Add("备注", typeof(string)); dt.Columns.Add("目标货位编码", typeof(string)); foreach (var o in outBillMaster) { dt.Rows.Add ( o.BillNo , o.WarehouseName , o.BillTypeName , o.OperatePersonName , o.VerifyPersonName , o.Status //, o.BillDate //, o.VerifyDate //, o.UpdateTime , o.Description , o.TargetCellCode ); } return(dt); }
public bool AllotCancelConfirm(string billNo, out string strResult) { bool result = false; var ibm = OutBillMasterRepository.GetQueryable().FirstOrDefault(i => i.BillNo == billNo && i.Status == "4"); if (ibm != null) { if (string.IsNullOrEmpty(ibm.LockTag)) { try { using (var scope = new TransactionScope()) { if (ibm.MoveBillMaster != null) { try { MoveBillCreater.DeleteMoveBillDetail(ibm.MoveBillMaster); MoveBillMasterRepository.Delete(ibm.MoveBillMaster); MoveBillMasterRepository.SaveChanges(); } catch (Exception) { strResult = "删除同步移库单失败,请重新取消!"; return(false); } } ibm.Status = "3"; ibm.UpdateTime = DateTime.Now; OutBillMasterRepository.SaveChanges(); result = true; strResult = "取消成功"; scope.Complete(); } } catch (Exception) { strResult = "当前订单其他人正在操作,请稍候重试!"; } } else { strResult = "当前订单其他人正在操作,请稍候重试!"; } } else { strResult = "当前订单状态不是已确认,或当前订单不存在!"; } return(result); }
public bool AntiTrial(string id, ref string errorInfo) { try { Guid ID = new Guid(id); var sortWork = SortWorkDispatchRepository.GetQueryable() .FirstOrDefault(s => s.ID == ID); if (sortWork == null) { errorInfo = "当前选择的调度记录不存在,未能反审!"; return(false); } if (sortWork.DispatchStatus != "2") { errorInfo = "当前选择的调度记录不是已审核,未能反审!"; return(false); } if (sortWork.OutBillMaster.Status != "2") { errorInfo = "当前选择的调度记录出库单不是已审核,未能反审!"; return(false); } if (sortWork.MoveBillMaster.Status != "2") { errorInfo = "当前选择的调度记录移库单不是已审核,未能反审!"; return(false); } using (var scope = new TransactionScope()) { //出库反审 var outMaster = OutBillMasterRepository.GetQueryable().FirstOrDefault(o => o.BillNo == sortWork.OutBillNo); outMaster.Status = "1"; outMaster.UpdateTime = DateTime.Now; //移库反审 var moveMater = MoveBillMasterRepository.GetQueryable().FirstOrDefault(m => m.BillNo == sortWork.MoveBillNo); moveMater.Status = "1"; moveMater.UpdateTime = DateTime.Now; //分拣作业反审 sortWork.DispatchStatus = "1"; sortWork.UpdateTime = DateTime.Now; SortWorkDispatchRepository.SaveChanges(); scope.Complete(); return(true); } } catch (Exception e) { errorInfo = "反审失败,详情:" + e.Message; return(false); } }
public bool AllotDelete(string billNo, long id, out string strResult) { bool result = false; var ibm = OutBillMasterRepository.GetQueryable().FirstOrDefault(i => i.BillNo == billNo && i.Status == "3"); if (ibm != null) { if (string.IsNullOrEmpty(ibm.LockTag)) { var allotDetail = ibm.OutBillAllots.Single(a => a.ID == (int)id); if (string.IsNullOrEmpty(allotDetail.Storage.LockTag)) { try { allotDetail.OutBillDetail.AllotQuantity -= allotDetail.AllotQuantity; allotDetail.Storage.OutFrozenQuantity -= allotDetail.AllotQuantity; allotDetail.Storage.LockTag = string.Empty; ibm.OutBillAllots.Remove(allotDetail); OutBillAllotRepository.Delete(allotDetail); if (ibm.OutBillAllots.Count == 0) { ibm.Status = "2"; ibm.UpdateTime = DateTime.Now; } OutBillAllotRepository.SaveChanges(); strResult = ""; result = true; } catch (Exception) { strResult = "当前储位或订单其他人正在操作,请稍候重试!"; } } else { strResult = "当前储位其他人正在操作,请稍候重试!"; } } else { strResult = "当前订单其他人正在操作,请稍候重试!"; } } else { strResult = "当前订单状态不是已分配,或当前订单不存在!"; } return(result); }
public object GetOutBillMaster() { string str = ""; var outBillAllot = OutBillAllotRepository.GetQueryable().Where(a => a.Status != "2").Select(a => a.BillNo).ToArray(); for (int i = 0; i < outBillAllot.Length; i++) { str += outBillAllot[i]; } var outBillMaster = OutBillMasterRepository.GetQueryable().ToArray().Where(b => str.Contains(b.BillNo) && b.Status != "6") .Distinct() .OrderByDescending(b => b.BillDate) .Select(b => new { BillNo = b.BillNo }); return(outBillMaster); }
/// <summary> /// 出库审核 /// </summary> /// <param name="billNo">单据号</param> /// <param name="userName">登陆用户</param> /// <returns></returns> public bool Audit(string billNo, string userName, out string errorInfo) { bool result = false; errorInfo = string.Empty; var outbm = OutBillMasterRepository.GetQueryable().FirstOrDefault(i => i.BillNo == billNo); var employee = EmployeeRepository.GetQueryable().FirstOrDefault(i => i.UserName == userName); if (outbm != null && outbm.Status == "1") { outbm.Status = "2"; outbm.VerifyDate = DateTime.Now; outbm.UpdateTime = DateTime.Now; outbm.VerifyPersonID = employee.ID; OutBillMasterRepository.SaveChanges(); result = true; } return(result); }
/// <summary> /// 出库反审 /// </summary> /// <param name="billNo">单据号</param> /// <returns></returns> public bool AntiTrial(string billNo, out string errorInfo) { bool result = false; errorInfo = string.Empty; var outbm = OutBillMasterRepository.GetQueryable().Where(i => billNo.Contains(i.BillNo)); if (outbm.Count() > 0) { foreach (var item in outbm.ToArray()) { if (item.Status == "2") { try { item.Status = "1"; item.VerifyDate = null; item.UpdateTime = DateTime.Now; item.VerifyPersonID = null; OutBillMasterRepository.SaveChanges(); result = true; } catch (Exception e) { errorInfo = item.BillNo + "其他人员正在操作!无法保存!" + e.Message; } } else { errorInfo = item.BillNo + "这条单据状态不是已审核!"; } } } else { errorInfo = "保存失败!没有找到这些数据!"; } return(result); }
public bool Save(OutBillMaster outBillMaster, out string errorInfo) { bool result = false; errorInfo = string.Empty; var outbm = OutBillMasterRepository.GetQueryable().FirstOrDefault(i => i.BillNo == outBillMaster.BillNo && i.Status == "1"); if (outbm != null) { try { outbm.BillDate = outBillMaster.BillDate; outbm.BillTypeCode = outBillMaster.BillTypeCode; outbm.WarehouseCode = outBillMaster.WarehouseCode; outbm.OperatePersonID = outBillMaster.OperatePersonID; outbm.Status = "1"; outbm.VerifyPersonID = outBillMaster.VerifyPersonID; outbm.VerifyDate = outBillMaster.VerifyDate; outbm.Description = outBillMaster.Description; outbm.IsActive = "1"; outbm.UpdateTime = DateTime.Now; outbm.Origin = "1"; outbm.TargetCellCode = outBillMaster.TargetCellCode; OutBillMasterRepository.SaveChanges(); result = true; } catch (Exception e) { errorInfo = "删除失败!原因:" + e.Message; } } else { errorInfo = "保存失败!没有找到这条数据!"; } return(result); }
public void Dispatch(string connectionId, Model.ProgressState ps, CancellationToken cancellationToken, string workDispatchId, string userName) { Locker.LockKey = workDispatchId; ConnectionId = connectionId; ps.State = StateType.Start; NotifyConnection(ps.Clone()); IQueryable <SortOrderDispatch> sortOrderDispatchQuery = SortOrderDispatchRepository.GetQueryable(); IQueryable <SortOrder> sortOrderQuery = SortOrderRepository.GetQueryable(); IQueryable <SortOrderDetail> sortOrderDetailQuery = SortOrderDetailRepository.GetQueryable(); IQueryable <OutBillMaster> outBillMasterQuery = OutBillMasterRepository.GetQueryable(); IQueryable <OutBillDetail> outBillDetailQuery = OutBillDetailRepository.GetQueryable(); IQueryable <MoveBillMaster> moveBillMasterQuery = MoveBillMasterRepository.GetQueryable(); IQueryable <MoveBillDetail> moveBillDetailQuery = MoveBillDetailRepository.GetQueryable(); IQueryable <SortingLowerlimit> sortingLowerlimitQuery = SortingLowerlimitRepository.GetQueryable(); IQueryable <SortingLine> sortingLineQuery = SortingLineRepository.GetQueryable(); IQueryable <Storage> storageQuery = StorageRepository.GetQueryable(); IQueryable <SortWorkDispatch> sortWorkDispatchQuery = SortWorkDispatchRepository.GetQueryable(); workDispatchId = workDispatchId.Substring(0, workDispatchId.Length - 1); int[] work = workDispatchId.Split(',').Select(s => Convert.ToInt32(s)).ToArray(); //调度表未作业的数据 var temp = sortOrderDispatchQuery.Where(s => work.Any(w => w == s.ID) && s.WorkStatus == "1") .Join(sortOrderQuery, dp => new { dp.OrderDate, dp.DeliverLineCode }, om => new { om.OrderDate, om.DeliverLineCode }, (dp, om) => new { dp.OrderDate, dp.SortingLine, dp.DeliverLineCode, om.OrderID } ).Join(sortOrderDetailQuery, dm => new { dm.OrderID }, od => new { od.OrderID }, (dm, od) => new { dm.OrderDate, dm.SortingLine, od.Product, od.UnitCode, od.Price, od.RealQuantity } ).GroupBy(r => new { r.OrderDate, r.SortingLine, r.Product, r.UnitCode, r.Price }) .Select(r => new { r.Key.OrderDate, r.Key.SortingLine, r.Key.Product, r.Key.UnitCode, r.Key.Price, SumQuantity = r.Sum(p => p.RealQuantity * r.Key.Product.UnitList.Unit02.Count) }) .GroupBy(r => new { r.OrderDate, r.SortingLine }) .Select(r => new { r.Key.OrderDate, r.Key.SortingLine, Products = r }) .ToArray(); var employee = EmployeeRepository.GetQueryable().FirstOrDefault(i => i.UserName == userName); string operatePersonID = employee != null?employee.ID.ToString() : ""; if (employee == null) { ps.State = StateType.Error; ps.Errors.Add("未找到当前用户,或当前用户不可用!"); NotifyConnection(ps.Clone()); return; } decimal sumAllotQuantity = 0; decimal sumAllotLineQuantity = 0; MoveBillMaster lastMoveBillMaster = null; foreach (var item in temp) { try { if (cancellationToken.IsCancellationRequested) { return; } bool hasError = false; ps.State = StateType.Info; ps.Messages.Add("开始调度" + item.SortingLine.SortingLineName); NotifyConnection(ps.Clone()); using (var scope = new TransactionScope()) { if (item.Products.Count() > 0) { if (cancellationToken.IsCancellationRequested) { return; } if (lastMoveBillMaster != null && lastMoveBillMaster.WarehouseCode != item.SortingLine.Cell.WarehouseCode) { if (MoveBillCreater.CheckIsNeedSyncMoveBill(lastMoveBillMaster.WarehouseCode)) { MoveBillCreater.CreateSyncMoveBillDetail(lastMoveBillMaster); } } sumAllotLineQuantity = 0; if (cancellationToken.IsCancellationRequested) { return; } MoveBillMaster moveBillMaster = MoveBillCreater.CreateMoveBillMaster(item.SortingLine.Cell.WarehouseCode, item.SortingLine.MoveBillTypeCode, operatePersonID); moveBillMaster.Origin = "2"; moveBillMaster.Description = "分拣调度生成!"; lastMoveBillMaster = moveBillMaster; foreach (var product in item.Products.ToArray()) { if (cancellationToken.IsCancellationRequested) { return; } decimal sumBillQuantity = temp.Sum(t => t.Products.Sum(p => p.SumQuantity)); sumAllotQuantity += product.SumQuantity; decimal sumBillProductQuantity = item.Products.Sum(p => p.SumQuantity); sumAllotLineQuantity += product.SumQuantity; ps.State = StateType.Processing; ps.TotalProgressName = "分拣作业调度"; ps.TotalProgressValue = (int)(sumAllotQuantity / sumBillQuantity * 100); ps.CurrentProgressName = "正在调度:" + item.SortingLine.SortingLineName; ps.CurrentProgressValue = (int)(sumAllotLineQuantity / sumBillProductQuantity * 100); NotifyConnection(ps.Clone()); if (cancellationToken.IsCancellationRequested) { return; } //获取分拣线下限数据 var sortingLowerlimitQuantity = sortingLowerlimitQuery.Where(s => s.ProductCode == product.Product.ProductCode && s.SortingLineCode == product.SortingLine.SortingLineCode); decimal lowerlimitQuantity = 0; if (sortingLowerlimitQuantity.Count() > 0) { lowerlimitQuantity = sortingLowerlimitQuantity.Sum(s => s.Quantity); } if (cancellationToken.IsCancellationRequested) { return; } //获取分拣备货区库存 var storageQuantity = storageQuery.Where(s => s.ProductCode == product.Product.ProductCode) .Join(sortingLineQuery, s => s.Cell, l => l.Cell, (s, l) => new { l.SortingLineCode, s.Quantity } ) .Where(r => r.SortingLineCode == product.SortingLine.SortingLineCode); decimal storQuantity = 0; if (storageQuantity.Count() > 0) { storQuantity = storageQuantity.Sum(s => s.Quantity); } //获取当前这个卷烟库存数量 string[] areaTypes = new string[] { "1", "2", "4" }; var areaSumQuantitys = storageQuery.Where(s => areaTypes.Any(t => t == s.Cell.Area.AreaType) && s.ProductCode == product.Product.ProductCode).ToArray(); decimal areaQuantiy = 0; if (areaSumQuantitys.Count() > 0) { areaQuantiy = areaSumQuantitys.Sum(s => s.Quantity - s.OutFrozenQuantity); } if (cancellationToken.IsCancellationRequested) { return; } //获取移库量(按整件计)出库量加上下限量减去备货区库存量取整 decimal quantity = 0; quantity = Math.Ceiling((product.SumQuantity + lowerlimitQuantity - storQuantity) / product.Product.Unit.Count) * product.Product.Unit.Count; if (areaQuantiy < quantity)//判断当前这个卷烟库存是否小于移库量 { //出库量减去备货区库存量取整 quantity = Math.Ceiling((product.SumQuantity - storQuantity) / product.Product.Unit.Count) * product.Product.Unit.Count; if (areaQuantiy < quantity) { //出库量减去备货区库存量 quantity = product.SumQuantity - storQuantity; } } if (quantity > 0) { if (cancellationToken.IsCancellationRequested) { return; } AlltoMoveBill(moveBillMaster, product.Product, item.SortingLine.Cell, ref quantity, cancellationToken, ps, item.SortingLine.Cell.CellCode); } if (quantity > 0) { //生成移库不完整,可能是库存不足; hasError = true; ps.State = StateType.Error; ps.Errors.Add(product.Product.ProductCode + " " + product.Product.ProductName + " 库存不足!"); NotifyConnection(ps.Clone()); } } if (!hasError) { if (cancellationToken.IsCancellationRequested) { return; } OutBillMaster outBillMaster = OutBillCreater.CreateOutBillMaster(item.SortingLine.Cell.WarehouseCode, item.SortingLine.OutBillTypeCode, operatePersonID); outBillMaster.Origin = "2"; outBillMaster.Description = "分拣调度生成!"; //添加出库单细单 foreach (var product in item.Products.ToArray()) { if (cancellationToken.IsCancellationRequested) { return; } OutBillCreater.AddToOutBillDetail(outBillMaster, product.Product, product.Price, product.SumQuantity); } if (cancellationToken.IsCancellationRequested) { return; } //添加出库、移库主单和作业调度表 SortWorkDispatch sortWorkDisp = AddSortWorkDispMaster(moveBillMaster, outBillMaster, item.SortingLine.SortingLineCode, item.OrderDate); //修改线路调度作业状态和作业ID var sortDispTemp = sortOrderDispatchQuery.Where(s => work.Any(w => w == s.ID) && s.OrderDate == item.OrderDate && s.SortingLineCode == item.SortingLine.SortingLineCode); foreach (var sortDisp in sortDispTemp.ToArray()) { if (cancellationToken.IsCancellationRequested) { return; } sortDisp.SortWorkDispatchID = sortWorkDisp.ID; sortDisp.WorkStatus = "2"; } if (cancellationToken.IsCancellationRequested) { return; } SortWorkDispatchRepository.SaveChanges(); scope.Complete(); ps.Messages.Add(item.SortingLine.SortingLineName + " 调度成功!"); } else { ps.State = StateType.Info; ps.Messages.Add(item.SortingLine.SortingLineName + " 调度失败!"); NotifyConnection(ps.Clone()); return; } } } if (cancellationToken.IsCancellationRequested) { return; } if (MoveBillCreater.CheckIsNeedSyncMoveBill(lastMoveBillMaster.WarehouseCode)) { MoveBillCreater.CreateSyncMoveBillDetail(lastMoveBillMaster); } MoveBillMasterRepository.SaveChanges(); } catch (Exception e) { ps.State = StateType.Info; ps.Errors.Add(item.SortingLine.SortingLineName + "作业调度失败! 详情:" + e.Message); NotifyConnection(ps.Clone()); return; } } ps.State = StateType.Info; ps.Messages.Add("调度完成!"); NotifyConnection(ps.Clone()); }
public bool Add(DateTime datetime, out string strResult) { bool result = false; strResult = string.Empty; var outBillMaster = OutBillMasterRepository.GetQueryable().Where(i => i.BillDate <= datetime); var outBillDetail = OutBillDetailRepository.GetQueryable().Where(i => i.OutBillMaster.BillDate <= datetime); var outBillAllot = OutBillAllotRepository.GetQueryable().Where(i => i.OutBillMaster.BillDate <= datetime); if (outBillMaster.Any()) { #region 主表移入历史表 try { foreach (var item in outBillMaster.ToArray()) { OutBillMasterHistory history = new OutBillMasterHistory(); history.BillNo = item.BillNo; history.BillDate = item.BillDate; history.BillTypeCode = item.BillTypeCode; history.WarehouseCode = item.WarehouseCode; history.OperatePersonID = item.OperatePersonID; history.Status = item.Status; history.VerifyPersonID = item.VerifyPersonID; history.VerifyDate = item.VerifyDate; history.Description = item.Description; history.IsActive = item.IsActive; history.UpdateTime = item.UpdateTime; history.Origin = item.Origin; history.TargetCellCode = item.TargetCellCode; OutBillMasterHistoryRepository.Add(history); } result = true; } catch (Exception e) { strResult = "主库单:" + e.InnerException.ToString(); result = false; } #endregion if (outBillDetail.Any()) { #region 细表移入历史表 try { foreach (var item in outBillDetail.ToArray()) { OutBillDetailHistory history = new OutBillDetailHistory(); history.ID = item.ID; history.BillNo = item.BillNo; history.ProductCode = item.ProductCode; history.UnitCode = item.UnitCode; history.Price = item.Price; history.BillQuantity = item.BillQuantity; history.AllotQuantity = item.AllotQuantity; history.RealQuantity = item.RealQuantity; history.Description = item.Description; OutBillDetailHistoryRepository.Add(history); } result = true; } catch (Exception e) { strResult = "细库单" + e.InnerException.ToString(); return(false); } #endregion if (outBillAllot.Any()) { #region 分配表移入历史表 try { foreach (var item3 in outBillAllot.ToArray()) { OutBillAllotHistory history3 = new OutBillAllotHistory(); history3.BillNo = item3.BillNo; history3.ProductCode = item3.ProductCode; history3.OutBillDetailId = item3.OutBillDetailId; history3.CellCode = item3.CellCode; history3.StorageCode = item3.StorageCode; history3.UnitCode = item3.UnitCode; history3.AllotQuantity = item3.AllotQuantity; history3.RealQuantity = item3.RealQuantity; history3.OperatePersonID = item3.OperatePersonID; history3.Operator = item3.Operator; history3.StartTime = item3.StartTime; history3.FinishTime = item3.FinishTime; history3.Status = item3.Status; OutBillAllotHistoryRepository.Add(history3); } result = true; } catch (Exception e) { strResult = "分配单:" + e.InnerException.ToString(); result = false; } #endregion } } if (result == true) { #region 除主细分配表 try { foreach (var item in outBillMaster.ToList()) { Del(OutBillAllotRepository, item.OutBillAllots); Del(OutBillDetailRepository, item.OutBillDetails); OutBillMasterRepository.Delete(item); result = true; } } catch (Exception e) { strResult = "删除情况:" + e.InnerException.ToString(); } OutBillMasterHistoryRepository.SaveChanges(); #endregion } } else { strResult = "数据不存在!"; } return(result); }
public bool Audit(string id, string userName, ref string errorInfo) { try { Guid ID = new Guid(id); var sortWork = SortWorkDispatchRepository.GetQueryable().FirstOrDefault(s => s.ID == ID); var employee = EmployeeRepository.GetQueryable().FirstOrDefault(i => i.UserName == userName); if (employee == null) { errorInfo = "当前用户不存在或不可用,未能审核!"; return(false); } if (sortWork == null) { errorInfo = "当前选择的调度记录不存在,未能审核!"; return(false); } if (sortWork.DispatchStatus != "1") { errorInfo = "当前选择的调度记录不是已调度,未能审核!"; return(false); } if (sortWork.OutBillMaster.Status != "1") { errorInfo = "当前选择的调度记录出库单不是已录入,未能审核!"; return(false); } if (sortWork.MoveBillMaster.Status != "1") { errorInfo = "当前选择的调度记录移库单不是已录入,未能审核!"; return(false); } using (var scope = new TransactionScope()) { //出库审核 var outMaster = OutBillMasterRepository.GetQueryable() .FirstOrDefault(o => o.BillNo == sortWork.OutBillNo); outMaster.Status = "2"; outMaster.VerifyPersonID = employee.ID; outMaster.VerifyDate = DateTime.Now; outMaster.UpdateTime = DateTime.Now; //移库审核 var moveMater = MoveBillMasterRepository.GetQueryable() .FirstOrDefault(m => m.BillNo == sortWork.MoveBillNo); moveMater.Status = "2"; moveMater.VerifyPersonID = employee.ID; moveMater.VerifyDate = DateTime.Now; moveMater.UpdateTime = DateTime.Now; //分拣作业审核 sortWork.DispatchStatus = "2"; sortWork.UpdateTime = DateTime.Now; SortWorkDispatchRepository.SaveChanges(); scope.Complete(); return(true); } } catch (Exception e) { errorInfo = "审核失败,详情:" + e.Message; return(false); } }
public bool AllotConfirm(string billNo, string userName, ref string errorInfo) { try { var ibm = OutBillMasterRepository.GetQueryable().FirstOrDefault(i => i.BillNo == billNo && i.Status == "3"); var employee = EmployeeRepository.GetQueryable().FirstOrDefault(i => i.UserName == userName); if (employee == null) { errorInfo = "当前用户不存在或不可用,未能审核!"; return(false); } if (ibm == null) { errorInfo = "当前订单状态不是已分配,或当前订单不存在!"; return(false); } if (!(ibm.OutBillDetails.All(b => b.BillQuantity == b.AllotQuantity) && ibm.OutBillDetails.Sum(b => b.BillQuantity) == ibm.OutBillAllots.Sum(a => a.AllotQuantity))) { errorInfo = "当前订单分配未完成或分配结果不正确!"; return(false); } if (!string.IsNullOrEmpty(ibm.LockTag)) { errorInfo = "当前订单其他人正在操作,请稍候重试!"; return(false); } using (var scope = new TransactionScope()) { if (MoveBillCreater.CheckIsNeedSyncMoveBill(ibm.WarehouseCode)) { var moveBillMaster = MoveBillCreater.CreateMoveBillMaster(ibm.WarehouseCode, "3001", employee.ID.ToString()); MoveBillCreater.CreateSyncMoveBillDetail(moveBillMaster); moveBillMaster.Status = "2"; moveBillMaster.Description = "出库生成同步移库单!"; moveBillMaster.VerifyDate = DateTime.Now; moveBillMaster.VerifyPersonID = employee.ID; if (MoveBillCreater.CheckIsNeedSyncMoveBill(ibm.WarehouseCode)) { errorInfo = "生成同步移库单不完整,请重新确认!"; return(false); } else { ibm.MoveBillMasterBillNo = moveBillMaster.BillNo; } } ibm.Status = "4"; ibm.UpdateTime = DateTime.Now; OutBillMasterRepository.SaveChanges(); scope.Complete(); return(true); } } catch (Exception e) { errorInfo = "确认分配失败,详情:" + e.Message; return(false); } }
public bool AllotEdit(string billNo, long id, string cellCode, decimal allotQuantity, out string strResult) { bool result = false; var ibm = OutBillMasterRepository.GetQueryable().FirstOrDefault(i => i.BillNo == billNo && i.Status == "3"); var cell = CellRepository.GetQueryable().Single(c => c.CellCode == cellCode); if (ibm != null) { if (string.IsNullOrEmpty(ibm.LockTag)) { var allotDetail = ibm.OutBillAllots.Single(a => a.ID == (int)id); if (string.IsNullOrEmpty(allotDetail.Storage.LockTag)) { Storage storage; if (allotDetail.CellCode == cellCode) { storage = allotDetail.Storage; storage.OutFrozenQuantity -= allotDetail.AllotQuantity; } else { storage = Locker.LockNoEmpty(cell, allotDetail.Product); allotDetail.Storage.OutFrozenQuantity -= allotDetail.AllotQuantity; } if (storage != null) { decimal q1 = allotDetail.OutBillDetail.BillQuantity - allotDetail.OutBillDetail.AllotQuantity; decimal q2 = allotQuantity * allotDetail.Unit.Count; decimal q3 = storage.Quantity - storage.OutFrozenQuantity; if (q1 >= q2 && q2 <= q3) { try { allotDetail.OutBillDetail.AllotQuantity -= allotDetail.AllotQuantity; allotDetail.OutBillDetail.AllotQuantity += q2; storage.OutFrozenQuantity += q2; storage.LockTag = string.Empty; allotDetail.CellCode = storage.Cell.CellCode; allotDetail.StorageCode = storage.StorageCode; allotDetail.AllotQuantity = q2; OutBillAllotRepository.SaveChanges(); strResult = "保存修改成功!"; result = true; } catch (Exception) { strResult = "保存修改失败,订单或储位其他人正在操作!"; } } else { strResult = "分配数量超过订单数量,或者当前储位库存量不足!"; } } else { strResult = "当前选择的储位不可用,其他人正在操作或没有库存!"; } } else { strResult = "当前储位其他人正在操作,请稍候重试!"; } } else { strResult = "当前订单其他人正在操作,请稍候重试!"; } } else { strResult = "当前订单状态不是已分配,或当前订单不存在!"; } return(result); }
public bool Settle(string id, ref string errorInfo) { try { Guid ID = new Guid(id); var sortWork = SortWorkDispatchRepository.GetQueryable().FirstOrDefault(s => s.ID == ID); if (sortWork == null) { errorInfo = "当前选择的调度记录不存在,未能结单!"; return(false); } if (sortWork.DispatchStatus == "1") { errorInfo = "当前选择的调度记录不是执行中,未能结单!"; return(false); } if (sortWork.MoveBillMaster.Status == "1") { errorInfo = "当前选择的调度记录移库单不是执行中,未能结单!"; return(false); } using (var scope = new TransactionScope()) { //移库细单解锁冻结量 var moveDetail = MoveBillDetailRepository.GetQueryable() .Where(m => m.BillNo == sortWork.MoveBillNo && m.Status != "2"); if (moveDetail.Any()) { var sourceStorages = moveDetail.Select(m => m.OutStorage).ToArray(); var targetStorages = moveDetail.Select(m => m.InStorage).ToArray(); if (!Locker.Lock(sourceStorages) || !Locker.Lock(targetStorages)) { errorInfo = "锁定储位失败,储位其他人正在操作,无法取消分配请稍候重试!"; return(false); } moveDetail.AsParallel().ForAll( (Action <MoveBillDetail>) delegate(MoveBillDetail m) { if (m.InStorage.ProductCode == m.ProductCode && m.OutStorage.ProductCode == m.ProductCode && m.InStorage.InFrozenQuantity >= m.RealQuantity && m.OutStorage.OutFrozenQuantity >= m.RealQuantity) { m.InStorage.InFrozenQuantity -= m.RealQuantity; m.OutStorage.OutFrozenQuantity -= m.RealQuantity; m.InStorage.LockTag = string.Empty; m.OutStorage.LockTag = string.Empty; } else { throw new Exception("储位的卷烟或移库冻结量与当前分配不符,信息可能被异常修改,不能结单!"); } } ); //解锁分拣线路调度的状态,以便重新做作业调度; foreach (var sortDisp in sortWork.SortOrderDispatchs) { sortDisp.SortWorkDispatchID = null; sortDisp.WorkStatus = "1"; } } else { //出库单作自动出库 var storages = StorageRepository.GetQueryable().Where(s => s.CellCode == sortWork.SortingLine.CellCode && s.Quantity - s.OutFrozenQuantity > 0).ToArray(); if (!Locker.Lock(storages)) { errorInfo = "锁定储位失败,储位其他人正在操作,无法取消分配请稍候重试!"; return(false); } var outAllots = sortWork.OutBillMaster.OutBillAllots; var outDetails = OutBillDetailRepository.GetQueryableIncludeProduct() .Where(o => o.BillNo == sortWork.OutBillMaster.BillNo); outDetails.ToArray().AsParallel().ForAll( (Action <OutBillDetail>) delegate(OutBillDetail o) { var ss = storages.Where(s => s.ProductCode == o.ProductCode).ToArray(); foreach (var s in ss) { lock (s) { if (o.BillQuantity - o.AllotQuantity > 0) { decimal allotQuantity = s.Quantity; decimal billQuantity = o.BillQuantity - o.AllotQuantity; allotQuantity = allotQuantity < billQuantity ? allotQuantity : billQuantity; o.AllotQuantity += allotQuantity; o.RealQuantity += allotQuantity; s.Quantity -= allotQuantity; var billAllot = new OutBillAllot() { BillNo = sortWork.OutBillMaster.BillNo, OutBillDetailId = o.ID, ProductCode = o.ProductCode, CellCode = s.CellCode, StorageCode = s.StorageCode, UnitCode = o.UnitCode, AllotQuantity = allotQuantity, RealQuantity = allotQuantity, FinishTime = DateTime.Now, Status = "2" }; lock (sortWork.OutBillMaster.OutBillAllots) { sortWork.OutBillMaster.OutBillAllots.Add(billAllot); } } else { break; } } } if (o.BillQuantity - o.AllotQuantity > 0) { throw new Exception(sortWork.SortingLine.SortingLineName + " " + o.ProductCode + " " + o.Product.ProductName + "分拣备货区库存不足,未能结单!"); } } ); storages.AsParallel().ForAll(s => s.LockTag = string.Empty); } //出库结单 var outMaster = OutBillMasterRepository.GetQueryable() .FirstOrDefault(o => o.BillNo == sortWork.OutBillNo); outMaster.Status = "6"; outMaster.UpdateTime = DateTime.Now; //移库结单 var moveMater = MoveBillMasterRepository.GetQueryable() .FirstOrDefault(m => m.BillNo == sortWork.MoveBillNo); moveMater.Status = "4"; moveMater.UpdateTime = DateTime.Now; //分拣作业结单 sortWork.DispatchStatus = "4"; sortWork.UpdateTime = DateTime.Now; SortWorkDispatchRepository.SaveChanges(); scope.Complete(); return(true); } } catch (AggregateException ex) { errorInfo = "结单失败,详情:" + ex.InnerExceptions.Select(i => i.Message).Aggregate((m, n) => m + n); return(false); } catch (Exception e) { errorInfo = "结单失败,详情:" + e.Message; return(false); } }
public bool AllotAdd(string billNo, long id, string cellCode, string productName, out string strResult, out decimal allotQuantity) { bool result = false; var ibm = OutBillMasterRepository.GetQueryable().FirstOrDefault(i => i.BillNo == billNo); var cell = CellRepository.GetQueryable().Single(c => c.CellCode == cellCode); var obm = OutBillDetailRepository.GetQueryable().FirstOrDefault(o => o.ID == id); var stor = StorageRepository.GetQueryable().Single(c => c.CellCode == cellCode); decimal q1 = obm.BillQuantity - obm.AllotQuantity; allotQuantity = 0; if (ibm != null) { if (string.IsNullOrEmpty(ibm.LockTag)) { Storage storage = Locker.LockNoEmpty(cell, obm.Product); if (storage != null) { if (stor.Product.ProductName == productName) { if (q1 > 0) { OutBillAllot billAllot = null; decimal q3 = storage.Quantity - storage.OutFrozenQuantity; if (q1 <= q3) { try { billAllot = new OutBillAllot() { BillNo = billNo, OutBillDetailId = obm.ID, ProductCode = obm.ProductCode, CellCode = storage.CellCode, StorageCode = storage.StorageCode, UnitCode = obm.UnitCode, AllotQuantity = q1, RealQuantity = 0, Status = "0" }; allotQuantity = (q3 - q1) / storage.Product.Unit.Count; obm.AllotQuantity += q1; storage.OutFrozenQuantity += q1; ibm.OutBillAllots.Add(billAllot); ibm.Status = "3"; storage.LockTag = string.Empty; StorageRepository.SaveChanges(); strResult = "保存修改成功!"; result = true; } catch (Exception) { strResult = "保存添加失败,订单或储位其他人正在操作!"; } } else { try { billAllot = new OutBillAllot() { BillNo = billNo, OutBillDetailId = obm.ID, ProductCode = obm.ProductCode, CellCode = storage.CellCode, StorageCode = storage.StorageCode, UnitCode = obm.UnitCode, AllotQuantity = q3, RealQuantity = 0, Status = "0" }; obm.AllotQuantity += q3; storage.OutFrozenQuantity += q3; ibm.OutBillAllots.Add(billAllot); ibm.Status = "3"; storage.LockTag = string.Empty; StorageRepository.SaveChanges(); strResult = "保存修改成功!"; result = true; } catch (Exception) { strResult = "保存添加失败,订单或储位其他人正在操作!"; } } } else { strResult = "该产品已无分配任务!"; } } else { strResult = "该卷烟没有出库任务!"; } } else { strResult = "当前选择的储位不可用,其他人正在操作或没有库存!"; } } else { strResult = "当前订单其他人正在操作,请稍候重试!"; } } else { strResult = "当前订单状态不是已分配,或当前订单不存在!"; } return(result); }
public bool AllotCancel(string billNo, out string strResult) { bool result = false; var ibm = OutBillMasterRepository.GetQueryable().FirstOrDefault(i => i.BillNo == billNo && i.Status == "3"); if (ibm != null) { if (string.IsNullOrEmpty(ibm.LockTag)) { try { using (var scope = new TransactionScope()) { var outAllot = OutBillAllotRepository.GetQueryable() .Where(o => o.BillNo == ibm.BillNo) .ToArray(); var storages = outAllot.Select(i => i.Storage).ToArray(); if (!Locker.Lock(storages)) { strResult = "锁定储位失败,储位其他人正在操作,无法取消分配请稍候重试!"; return(false); } outAllot.AsParallel().ForAll( (Action <OutBillAllot>) delegate(OutBillAllot o) { if (o.Storage.ProductCode == o.ProductCode && o.Storage.OutFrozenQuantity >= o.AllotQuantity) { lock (o.OutBillDetail) { o.OutBillDetail.AllotQuantity -= o.AllotQuantity; } o.Storage.OutFrozenQuantity -= o.AllotQuantity; o.Storage.LockTag = string.Empty; } else { throw new Exception("储位的卷烟或出库冻结量与当前分配不符,信息可能被异常修改,不能取消当前出库分配!"); } } ); OutBillAllotRepository.SaveChanges(); OutBillAllotRepository.GetObjectSet() .DeleteEntity(i => i.BillNo == ibm.BillNo); ibm.Status = "2"; ibm.UpdateTime = DateTime.Now; OutBillMasterRepository.SaveChanges(); result = true; strResult = "取消成功"; scope.Complete(); } } catch (Exception e) { strResult = "取消分配失败,详情:" + e.Message; } } else { strResult = "当前订单其他人正在操作,请稍候重试!"; } } else { strResult = "当前订单状态不是已分配,或当前订单不存在!"; } return(result); }
public void Allot(string connectionId, Model.ProgressState ps, System.Threading.CancellationToken cancellationToken, string billNo, string[] areaCodes) { Locker.LockKey = billNo; ConnectionId = connectionId; ps.State = StateType.Start; NotifyConnection(ps.Clone()); IQueryable <OutBillMaster> outBillMasterQuery = OutBillMasterRepository.GetQueryable(); IQueryable <Cell> cellQuery = CellRepository.GetQueryable(); IQueryable <Storage> storageQuery = StorageRepository.GetQueryable(); OutBillMaster billMaster = outBillMasterQuery.Single(b => b.BillNo == billNo); if (!CheckAndLock(billMaster, ps)) { return; } //选择未分配的细单; var billDetails = billMaster.OutBillDetails.Where(b => (b.BillQuantity - b.AllotQuantity) > 0).ToArray(); //选择当前订单操作目标仓库; var storages = storageQuery.Where(s => s.Cell.WarehouseCode == billMaster.WarehouseCode); if (areaCodes.Length > 0) { //选择指定库区; storages = storages.Where(s => areaCodes.Any(a => a == s.Cell.AreaCode)); } else { storages = storages.Where(s => s.Cell.Area.AllotOutOrder > 0); } storages = storages.Where(s => string.IsNullOrEmpty(s.LockTag) && s.Cell.IsActive == "1" && s.Quantity - s.OutFrozenQuantity > 0); foreach (var billDetail in billDetails) { //1:主库区 1;2:件烟区 2; //3;条烟区 3;4:暂存区 4; //5:备货区 0;6:残烟区 0; //7:罚烟区 0;8:虚拟区 0; //9:其他区 0; //分配整盘;排除 件烟区 条烟区 string[] areaTypes = new string[] { "2", "3", "5" }; var ss = storages.Where(s => areaTypes.All(a => a != s.Cell.Area.AreaType) && s.ProductCode == billDetail.ProductCode) .OrderBy(s => new { s.Cell.Area.AllotOutOrder, s.StorageTime }); AllotPallet(billMaster, billDetail, ss, cancellationToken, ps); //分配件烟;件烟区 areaTypes = new string[] { "2" }; ss = storages.Where(s => areaTypes.Any(a => a == s.Cell.Area.AreaType) && s.ProductCode == billDetail.ProductCode) .OrderBy(s => new { s.Cell.Area.AllotOutOrder, s.StorageTime }); AllotPiece(billMaster, billDetail, ss, cancellationToken, ps); //分配件烟 (下层储位);排除 件烟区 条烟区 areaTypes = new string[] { "2", "3", "5" }; ss = storages.Where(s => areaTypes.All(a => a != s.Cell.Area.AreaType) && s.ProductCode == billDetail.ProductCode && s.Cell.Layer == 1) .OrderBy(s => new { s.Cell.Area.AllotOutOrder, s.StorageTime }); AllotPiece(billMaster, billDetail, ss, cancellationToken, ps); //分配件烟 (非下层储位);排除 件烟区 条烟区 areaTypes = new string[] { "2", "3", "5" }; ss = storages.Where(s => areaTypes.All(a => a != s.Cell.Area.AreaType) && s.ProductCode == billDetail.ProductCode && s.Cell.Layer != 1) .OrderBy(s => new { s.Cell.Area.AllotOutOrder, s.StorageTime }); AllotPiece(billMaster, billDetail, ss, cancellationToken, ps); //分配条烟;条烟区 areaTypes = new string[] { "3" }; ss = storages.Where(s => areaTypes.Any(a => a == s.Cell.Area.AreaType) && s.ProductCode == billDetail.ProductCode) .OrderBy(s => new { s.Cell.Area.AllotOutOrder, s.StorageTime }); AllotBar(billMaster, billDetail, ss, cancellationToken, ps); //分配条烟;件烟区 areaTypes = new string[] { "2" }; ss = storages.Where(s => areaTypes.Any(a => a == s.Cell.Area.AreaType) && s.ProductCode == billDetail.ProductCode) .OrderBy(s => new { s.Cell.Area.AllotOutOrder, s.StorageTime }); AllotBar(billMaster, billDetail, ss, cancellationToken, ps); //分配条烟 (主库区下层); areaTypes = new string[] { "1" }; ss = storages.Where(s => areaTypes.All(a => a == s.Cell.Area.AreaType) && s.ProductCode == billDetail.ProductCode && s.Cell.Layer == 1) .OrderBy(s => new { s.Cell.Area.AllotOutOrder, s.StorageTime }); AllotBar(billMaster, billDetail, ss, cancellationToken, ps); //分配条烟 (主库区) areaTypes = new string[] { "1" }; ss = storages.Where(s => areaTypes.All(a => a == s.Cell.Area.AreaType) && s.ProductCode == billDetail.ProductCode && s.Cell.Layer != 1) .OrderBy(s => new { s.Cell.Area.AllotOutOrder, s.StorageTime }); AllotBar(billMaster, billDetail, ss, cancellationToken, ps); //分配条烟 (暂存区) areaTypes = new string[] { "4" }; ss = storages.Where(s => areaTypes.All(a => a == s.Cell.Area.AreaType) && s.ProductCode == billDetail.ProductCode) .OrderBy(s => s.StorageTime) .OrderBy(s => s.Cell.Area.AllotOutOrder); AllotBar(billMaster, billDetail, ss, cancellationToken, ps); if (billDetail.BillQuantity > billDetail.AllotQuantity) { ps.State = StateType.Warning; ps.Errors.Add(billDetail.ProductCode + " " + billDetail.Product.ProductName + ",库存不足!" + "订单量:" + billDetail.BillQuantity / billDetail.Product.Unit.Count + "(件)," + "未分配量:" + (billDetail.BillQuantity - billDetail.RealQuantity) / billDetail.Product.Unit.Count + "(件)"); } } string billno = billMaster.BillNo; if (billMaster.OutBillDetails.Any(i => i.BillQuantity - i.AllotQuantity > 0)) { ps.State = StateType.Warning; ps.Errors.Add("分配未全部完成,没有储位可分配!"); NotifyConnection(ps.Clone()); OutBillMasterRepository.GetObjectSet() .UpdateEntity(i => i.BillNo == billno, i => new OutBillMaster() { LockTag = "" }); } else { ps.State = StateType.Info; ps.Messages.Add("分配完成,开始保存请稍候!"); NotifyConnection(ps.Clone()); billMaster.Status = "3"; try { if (!cancellationToken.IsCancellationRequested) { billMaster.LockTag = string.Empty; CellRepository.SaveChanges(); ps.State = StateType.Info; ps.Messages.Clear(); ps.Messages.Add("分配成功!"); NotifyConnection(ps.Clone()); } } catch (Exception e) { ps.State = StateType.Error; ps.Messages.Add("保存失败,详情:" + e.Message); NotifyConnection(ps.Clone()); } finally { OutBillMasterRepository.GetObjectSet() .UpdateEntity(i => i.BillNo == billno, i => new OutBillMaster() { LockTag = "" }); } } }
public object GetDetails(int page, int rows, string BillNo, string beginDate, string endDate, string OperatePersonCode, string CheckPersonCode, string Status, string IsActive) { IQueryable <OutBillMaster> OutBillMasterQuery = OutBillMasterRepository.GetQueryable().Where(o => o.Status != "6"); var outBillMaster = OutBillMasterQuery .OrderByDescending(t => t.BillDate) .OrderByDescending(t => t.BillNo) .Select(i => i); if (!BillNo.Equals(string.Empty) && BillNo != null) { outBillMaster = outBillMaster.Where(i => i.BillNo.Contains(BillNo)); } if (!beginDate.Equals(string.Empty)) { DateTime begin = Convert.ToDateTime(beginDate); outBillMaster = outBillMaster.Where(i => i.BillDate >= begin); } if (!endDate.Equals(string.Empty)) { DateTime end = Convert.ToDateTime(endDate).AddDays(1); outBillMaster = outBillMaster.Where(i => i.BillDate <= end); } if (!OperatePersonCode.Equals(string.Empty) && OperatePersonCode != null) { outBillMaster = outBillMaster.Where(i => i.OperatePerson.EmployeeCode.Contains(OperatePersonCode)); } if (!Status.Equals(string.Empty)) { outBillMaster = outBillMaster.Where(i => i.Status.Contains(Status) && i.Status != "6"); } if (!IsActive.Equals(string.Empty)) { outBillMaster = outBillMaster.Where(i => i.IsActive.Contains(IsActive)); } if (!CheckPersonCode.Equals(string.Empty)) { outBillMaster = outBillMaster.Where(i => i.VerifyPerson.EmployeeCode == CheckPersonCode); } int total = outBillMaster.Count(); outBillMaster = outBillMaster.Skip((page - 1) * rows).Take(rows); var temp = outBillMaster.ToArray().AsEnumerable().Select(i => new { i.BillNo, BillDate = i.BillDate.ToString("yyyy-MM-dd HH:mm:ss"), i.Warehouse.WarehouseCode, i.Warehouse.WarehouseName, i.OperatePersonID, i.VerifyPersonID, OperatePersonCode = i.OperatePerson.EmployeeCode, OperatePersonName = i.OperatePerson.EmployeeName, VerifyPersonCode = i.VerifyPersonID == null ? string.Empty : i.VerifyPerson.EmployeeCode, VerifyPersonName = i.VerifyPersonID == null ? string.Empty : i.VerifyPerson.EmployeeName, SumQuantity = i.OutBillDetails.Sum(s => s.BillQuantity / s.Product.Unit.Count), BillTypeCode = i.BillType.BillTypeCode, BillTypeName = i.BillType.BillTypeName, VerifyDate = i.VerifyDate == null ? string.Empty : ((DateTime)i.VerifyDate).ToString("yyyy-MM-dd HH:mm:ss"), Status = WhatStatus(i.Status), IsActive = i.IsActive == "1" ? "可用" : "不可用", Description = i.Description, UpdateTime = i.UpdateTime.ToString("yyyy-MM-dd HH:mm:ss"), i.TargetCellCode }); return(new { total, rows = temp.ToArray() }); }
public bool AllotAdd(string billNo, long id, string productCode, string cellCode, int allotQuantity, out string strResult) { bool result = false; var ibm = OutBillMasterRepository.GetQueryable().FirstOrDefault(i => i.BillNo == billNo); var cell = CellRepository.GetQueryable().Single(c => c.CellCode == cellCode); var obm = OutBillDetailRepository.GetQueryable().FirstOrDefault(o => o.ProductCode == productCode); if (ibm != null) { if (string.IsNullOrEmpty(ibm.LockTag)) { Storage storage = Locker.LockNoEmpty(cell, obm.Product); if (storage != null && allotQuantity > 0) { OutBillAllot billAllot = null; decimal q1 = obm.BillQuantity - obm.AllotQuantity; decimal q2 = allotQuantity * obm.Unit.Count; decimal q3 = storage.Quantity - storage.OutFrozenQuantity; if (q1 >= q2 && q2 <= q3) { try { billAllot = new OutBillAllot() { BillNo = billNo, OutBillDetailId = obm.ID, ProductCode = obm.ProductCode, CellCode = storage.CellCode, StorageCode = storage.StorageCode, UnitCode = obm.UnitCode, AllotQuantity = q2, RealQuantity = 0, Status = "0" }; obm.AllotQuantity += q2; storage.OutFrozenQuantity += q2; ibm.OutBillAllots.Add(billAllot); ibm.Status = "3"; storage.LockTag = string.Empty; StorageRepository.SaveChanges(); strResult = "保存修改成功!"; result = true; } catch (Exception) { strResult = "保存添加失败,订单或储位其他人正在操作!"; } } else { strResult = "分配数量超过订单数量,或者当前储位库存量不足!"; } } else { strResult = "当前选择的储位不可用,其他人正在操作或没有库存!"; } } else { strResult = "当前订单其他人正在操作,请稍候重试!"; } } else { strResult = "当前订单状态不是已分配,或当前订单不存在!"; } return(result); }
public DataSet Insert() { IQueryable <OutBillMaster> outBillMaster = OutBillMasterRepository.GetQueryable(); IQueryable <OutBillAllot> outBillAllot = OutBillAllotRepository.GetQueryable(); IQueryable <OutBillDetail> outBillDetail = OutBillDetailRepository.GetQueryable(); var outBillMasterQuery = outBillMaster.Where(i => i.Status == "6").Select(i => new { STORE_BILL_ID = i.BillNo, RELATE_BUSI_BILL_NUM = outBillAllot.Count(a => a.BillNo == i.BillNo), DIST_CTR_CODE = i.WarehouseCode, QUANTITY_SUM = outBillAllot.Where(a => a.BillNo == i.BillNo).Sum(a => a.AllotQuantity / 200), AMOUNT_SUM = outBillDetail.Where(d => d.BillNo == i.BillNo).Sum(d => d.Price * d.AllotQuantity / 200), DETAIL_NUM = outBillDetail.Count(d => d.BillNo == i.BillNo), personCode = i.VerifyPerson, personDate = i.VerifyDate, operater = i.OperatePerson, operateDate = i.BillDate, BILL_TYPE = i.BillTypeCode }); DataSet ds = this.GenerateEmptyTables(); DataRow inbrddr = ds.Tables["WMS_OUT_BILLMASTER"].NewRow(); foreach (var p in outBillMasterQuery) { inbrddr["STORE_BILL_ID"] = p.STORE_BILL_ID; inbrddr["RELATE_BUSI_BILL_NUM"] = p.RELATE_BUSI_BILL_NUM; inbrddr["DIST_CTR_CODE"] = p.DIST_CTR_CODE; inbrddr["AREA_TYPE"] = "0901"; inbrddr["QUANTITY_SUM"] = -p.QUANTITY_SUM; inbrddr["AMOUNT_SUM"] = p.AMOUNT_SUM; inbrddr["DETAIL_NUM"] = p.DETAIL_NUM; inbrddr["CREATOR_CODE"] = p.operater.ToString() ?? ""; inbrddr["CREATE_DATE"] = p.operateDate; inbrddr["AUDITOR_CODE"] = p.personCode.ToString() ?? ""; inbrddr["AUDIT_DATE"] = p.personDate; inbrddr["ASSIGNER_CODE"] = p.operater; inbrddr["ASSIGN_DATE"] = p.operateDate; inbrddr["AFFIRM_CODE"] = p.operater; inbrddr["AFFIRM_DATE"] = p.operateDate; inbrddr["IN_OUT_TYPE"] = "1203"; inbrddr["BILL_TYPE"] = p.BILL_TYPE; inbrddr["BILL_STATUS"] = "99"; inbrddr["DISUSE_STATUS"] = "0"; inbrddr["IS_IMPORT"] = "0"; ds.Tables["WMS_OUT_BILLMASTER"].Rows.Add(inbrddr); } DataRow inbrddrDetail = ds.Tables["WMS_OUT_BILLDETAIL"].NewRow(); var outBillDetailQuery = outBillDetail.Where(i => i.OutBillMaster.Status == "6").Select(i => new { STORE_BILL_DETAIL_ID = i.ID, STORE_BILL_ID = i.BillNo, BRAND_CODE = i.ProductCode, BRAND_NAME = i.Product.ProductName, QUANTITY = i.BillQuantity / 200 }); foreach (var p in outBillDetailQuery) { inbrddrDetail["STORE_BILL_DETAIL_ID"] = p.STORE_BILL_DETAIL_ID; inbrddrDetail["STORE_BILL_ID"] = p.STORE_BILL_ID; inbrddrDetail["BRAND_CODE"] = p.BRAND_CODE; inbrddrDetail["BRAND_NAME"] = p.BRAND_NAME; inbrddrDetail["QUANTITY"] = -p.QUANTITY; inbrddrDetail["IS_IMPORT"] = "0"; ds.Tables["WMS_OUT_BILLDETAIL"].Rows.Add(inbrddrDetail); } DataRow inbrddrAllot = ds.Tables["WMS_OUT_BILLALLOT"].NewRow(); var outBillAllotQuery = outBillAllot.Where(i => i.OutBillMaster.Status == "6").Select(i => new { BUSI_ACT_ID = i.ID, BUSI_BILL_DETAIL_ID = i.OutBillDetailId, BUSI_BILL_ID = i.BillNo, BRAND_CODE = i.ProductCode, BRAND_NAME = i.Product.ProductName, QUANTITY = i.AllotQuantity / 200, DIST_CTR_CODE = i.OutBillMaster.WarehouseCode, STORE_PLACE_CODE = i.Storage.CellCode, UPDATE_CODE = i.Operator, //BEGIN_STOCK_QUANTITY =StorageRepository.GetQueryable().Where(s=>s.ProductCode==i.ProductCode).Sum(s=>s.Quantity/200)-i.AllotQuantity, //END_STOCK_QUANTITY = i.AllotQuantity, BILL_TYPE = i.OutBillMaster.BillTypeCode }); foreach (var p in outBillAllotQuery) { inbrddrAllot["BUSI_ACT_ID"] = p.BUSI_ACT_ID; inbrddrAllot["BUSI_BILL_DETAIL_ID"] = p.BUSI_BILL_DETAIL_ID; inbrddrAllot["BUSI_BILL_ID"] = p.BUSI_BILL_ID; inbrddrAllot["BRAND_CODE"] = p.BRAND_CODE; inbrddrAllot["BRAND_NAME"] = p.BRAND_NAME; inbrddrAllot["QUANTITY"] = -p.QUANTITY; inbrddrAllot["DIST_CTR_CODE"] = p.DIST_CTR_CODE; inbrddrAllot["ORG_CODE"] = "01"; inbrddrAllot["STORE_ROOM_CODE"] = "001"; inbrddrAllot["STORE_PLACE_CODE"] = p.STORE_PLACE_CODE; inbrddrAllot["TARGET_NAME"] = p.STORE_PLACE_CODE; inbrddrAllot["IN_OUT_TYPE"] = "1203"; inbrddrAllot["BILL_TYPE"] = p.BILL_TYPE; inbrddrAllot["BEGIN_STOCK_QUANTITY"] = 0; inbrddrAllot["END_STOCK_QUANTITY"] = 0; inbrddrAllot["DISUSE_STATUS"] = "0"; inbrddrAllot["RECKON_STATUS"] = "1"; inbrddrAllot["RECKON_DATE"] = DateTime.Now.ToString("yyyy-MM-dd"); inbrddrAllot["UPDATE_CODE"] = p.UPDATE_CODE; inbrddrAllot["UPDATE_DATE"] = DateTime.Now.ToString("yyyy-MM-dd"); inbrddrAllot["IS_IMPORT"] = "0"; ds.Tables["WMS_OUT_BILLALLOT"].Rows.Add(inbrddrAllot); } return(ds); }
public void Dispatch(string connectionId, Model.ProgressState ps, CancellationToken cancellationToken, string workDispatchId, string userName) { Locker.LockKey = workDispatchId; ConnectionId = connectionId; ps.State = StateType.Start; NotifyConnection(ps.Clone()); IQueryable <SortOrderDispatch> sortOrderDispatchQuery = SortOrderDispatchRepository.GetQueryable(); IQueryable <SortOrder> sortOrderQuery = SortOrderRepository.GetQueryable(); IQueryable <SortOrderDetail> sortOrderDetailQuery = SortOrderDetailRepository.GetQueryable(); IQueryable <OutBillMaster> outBillMasterQuery = OutBillMasterRepository.GetQueryable(); IQueryable <OutBillDetail> outBillDetailQuery = OutBillDetailRepository.GetQueryable(); IQueryable <MoveBillMaster> moveBillMasterQuery = MoveBillMasterRepository.GetQueryable(); IQueryable <MoveBillDetail> moveBillDetailQuery = MoveBillDetailRepository.GetQueryable(); IQueryable <SortingLowerlimit> sortingLowerlimitQuery = SortingLowerlimitRepository.GetQueryable(); IQueryable <SortingLine> sortingLineQuery = SortingLineRepository.GetQueryable(); IQueryable <Storage> storageQuery = StorageRepository.GetQueryable(); IQueryable <SortWorkDispatch> sortWorkDispatchQuery = SortWorkDispatchRepository.GetQueryable(); IQueryable <THOK.Authority.DbModel.SystemParameter> systemParQuery = SystemParameterRepository.GetQueryable(); var IsUselowerlimit = systemParQuery.FirstOrDefault(s => s.ParameterName == "IsUselowerlimit"); //查询调度是否使用下限 0 否 1是 var isRoundingTray = systemParQuery.FirstOrDefault(s => s.ParameterName == "isRoundingTray"); //查询立式机总量大于20件的是否取整托盘 0表示不取整托盘。其它任意数字表示大于的总数 workDispatchId = workDispatchId.Substring(0, workDispatchId.Length - 1); int[] work = workDispatchId.Split(',').Select(s => Convert.ToInt32(s)).ToArray(); //调度表未作业的数据 var temp = sortOrderDispatchQuery.Join(sortOrderQuery, dp => new { dp.OrderDate, dp.DeliverLineCode }, om => new { om.OrderDate, om.DeliverLineCode }, (dp, om) => new { dp.ID, dp.WorkStatus, dp.OrderDate, dp.SortingLine, dp.DeliverLineCode, om.OrderID } ).Join(sortOrderDetailQuery, dm => new { dm.OrderID }, od => new { od.OrderID }, (dm, od) => new { dm.ID, dm.WorkStatus, dm.OrderDate, dm.SortingLine, od.Product, od.UnitCode, od.Price, od.RealQuantity } ).WhereIn(s => s.ID, work) .Where(s => s.WorkStatus == "1") .GroupBy(r => new { r.OrderDate, r.SortingLine, r.Product, r.UnitCode, r.Price }) .Select(r => new { r.Key.OrderDate, r.Key.SortingLine, r.Key.Product, r.Key.UnitCode, r.Key.Price, SumQuantity = r.Sum(p => p.RealQuantity * r.Key.Product.UnitList.Unit02.Count) }) .AsParallel() .GroupBy(r => new { r.OrderDate, r.SortingLine }) .Select(r => new { r.Key.OrderDate, r.Key.SortingLine, Products = r }) .OrderBy(s => s.SortingLine.SortingLineCode) //如果取整托盘多余的量是1号线就倒序排序,目前多余的量放入2号线,所以先调度一号线 .ToArray(); var temp1 = sortingLowerlimitQuery.GroupBy(r => new { r.Product, r.SortType }) .Select(s => new { s.Key.Product, s.Key.SortType }).ToArray(); var temp2 = sortOrderDispatchQuery.Join(sortOrderQuery, dp => new { dp.OrderDate, dp.DeliverLineCode }, om => new { om.OrderDate, om.DeliverLineCode }, (dp, om) => new { dp.ID, dp.WorkStatus, dp.OrderDate, om.OrderID } ).Join(sortOrderDetailQuery, dm => new { dm.OrderID }, od => new { od.OrderID }, (dm, od) => new { dm.ID, dm.WorkStatus, od.Product, od.RealQuantity } ).WhereIn(s => s.ID, work) .GroupBy(r => new { r.Product }) .Select(s => new { s.Key.Product, Quantity = s.Sum(p => p.RealQuantity * s.Key.Product.UnitList.Unit02.Count) }) .ToArray(); Dictionary <string, decimal> proQuan = new Dictionary <string, decimal>(); var employee = EmployeeRepository.GetQueryable().FirstOrDefault(i => i.UserName == userName); string operatePersonID = employee != null?employee.ID.ToString() : ""; if (employee == null) { ps.State = StateType.Error; ps.Errors.Add("未找到当前用户,或当前用户不可用!"); NotifyConnection(ps.Clone()); return; } decimal sumAllotQuantity = 0; decimal sumAllotLineQuantity = 0; MoveBillMaster lastMoveBillMaster = null; foreach (var item in temp) { try { if (cancellationToken.IsCancellationRequested) { return; } bool hasError = false; ps.State = StateType.Info; ps.Messages.Add("开始调度" + item.SortingLine.SortingLineName); NotifyConnection(ps.Clone()); //using (var scope = new TransactionScope()) //{ if (item.Products.Count() > 0) { if (cancellationToken.IsCancellationRequested) { return; } if (lastMoveBillMaster != null && lastMoveBillMaster.WarehouseCode != item.SortingLine.Cell.WarehouseCode) { if (MoveBillCreater.CheckIsNeedSyncMoveBill(lastMoveBillMaster.WarehouseCode)) { MoveBillCreater.CreateSyncMoveBillDetail(lastMoveBillMaster); } } sumAllotLineQuantity = 0; if (cancellationToken.IsCancellationRequested) { return; } MoveBillMaster moveBillMaster = MoveBillCreater.CreateMoveBillMaster(item.SortingLine.Cell.WarehouseCode, item.SortingLine.MoveBillTypeCode, operatePersonID); moveBillMaster.Origin = "2"; moveBillMaster.Description = item.SortingLine.SortingLineCode + " 分拣调度生成!"; lastMoveBillMaster = moveBillMaster; foreach (var product in item.Products.ToArray()) { if (product.SumQuantity > 0) { if (cancellationToken.IsCancellationRequested) { return; } decimal sumBillQuantity = temp.Sum(t => t.Products.Sum(p => p.SumQuantity)); sumAllotQuantity += product.SumQuantity; decimal sumBillProductQuantity = item.Products.Sum(p => p.SumQuantity); sumAllotLineQuantity += product.SumQuantity; ps.State = StateType.Processing; ps.TotalProgressName = "分拣作业调度"; ps.TotalProgressValue = (int)(sumAllotQuantity / sumBillQuantity * 100); ps.CurrentProgressName = "正在调度:" + item.SortingLine.SortingLineName; ps.CurrentProgressValue = (int)(sumAllotLineQuantity / sumBillProductQuantity * 100); NotifyConnection(ps.Clone()); if (cancellationToken.IsCancellationRequested) { return; } //获取分拣线下限数据 var sortingLowerlimitQuantity = sortingLowerlimitQuery.Where(s => s.ProductCode == product.Product.ProductCode && s.SortingLineCode == product.SortingLine.SortingLineCode); decimal lowerlimitQuantity = 0; if (sortingLowerlimitQuantity.Count() > 0) { lowerlimitQuantity = sortingLowerlimitQuantity.Sum(s => s.Quantity); } if (cancellationToken.IsCancellationRequested) { return; } //获取分拣备货区库存 var storageQuantity = storageQuery.Where(s => s.ProductCode == product.Product.ProductCode) .Join(sortingLineQuery, s => s.Cell, l => l.Cell, (s, l) => new { l.SortingLineCode, s.Quantity } ) .Where(r => r.SortingLineCode == product.SortingLine.SortingLineCode); decimal storQuantity = 0; if (storageQuantity.Count() > 0) { storQuantity = storageQuantity.Sum(s => s.Quantity); } //获取当前这个卷烟库存数量 string[] areaTypes = new string[] { "1", "2", "4" }; var areaSumQuantitys = storageQuery.Where(s => areaTypes.Any(t => t == s.Cell.Area.AreaType) && s.ProductCode == product.Product.ProductCode).ToArray(); decimal areaQuantiy = 0; if (areaSumQuantitys.Count() > 0) { areaQuantiy = areaSumQuantitys.Sum(s => s.Quantity - s.OutFrozenQuantity); } //是否使用下限 if (IsUselowerlimit != null && IsUselowerlimit.ParameterValue == "0") { lowerlimitQuantity = 0; } if (cancellationToken.IsCancellationRequested) { return; } //获取移库量(按整件计)出库量加上下限量减去备货区库存量取整 decimal quantity = 0; quantity = Math.Ceiling((product.SumQuantity + lowerlimitQuantity - storQuantity) / product.Product.Unit.Count) * product.Product.Unit.Count; //立式机大于20件的取整托盘 //查询这个卷烟是否是立式机的卷烟 if (isRoundingTray != null && Convert.ToInt32(isRoundingTray.ParameterValue) > 0) { var temp3 = temp1.FirstOrDefault(s => s.Product.ProductCode == product.Product.ProductCode && s.SortType == "1"); if (temp3 != null && temp.Count() >= 2 && quantity > 0) { //查询这个订单在分拣当中是否存在.大于20件取整托盘, var SumlowerlimitQuantity = temp2.FirstOrDefault(s => s.Product.ProductCode == temp3.Product.ProductCode); if (SumlowerlimitQuantity != null && SumlowerlimitQuantity.Quantity > (Convert.ToInt32(isRoundingTray.ParameterValue) * product.Product.Unit.Count)) { decimal WholeCare = 0; //托盘数 decimal SumSortingQuantity = 0; //整托盘的数量 decimal Quantity1 = 0; decimal Quantity2 = 0; //取2条线数量总和取整托盘 WholeCare = Math.Ceiling(SumlowerlimitQuantity.Quantity / (product.Product.CellMaxProductQuantity * product.Product.Unit.Count)); SumSortingQuantity = Convert.ToDecimal(WholeCare * (product.Product.Unit.Count * product.Product.CellMaxProductQuantity)); if (item.SortingLine.SortingLineCode == "1") { //总订单量减去当前分拣线订单量,这里是另一条线的量 Quantity1 = SumlowerlimitQuantity.Quantity - product.SumQuantity; if (Quantity1 > 0) { //整托盘数量减去另一条线的量, Quantity1 = Math.Ceiling(Quantity1 / product.Product.Unit.Count) * product.Product.Unit.Count; Quantity2 = SumSortingQuantity - Quantity1; if (Quantity2 >= quantity) { quantity = Quantity2; proQuan.Add(product.Product.ProductCode, SumSortingQuantity - quantity); } } } else { if (proQuan.Keys.Contains(product.Product.ProductCode)) { if (proQuan[product.Product.ProductCode] >= quantity) { quantity = proQuan[product.Product.ProductCode]; } } } } } } //取整托盘,查询这个卷烟是否是通道机的卷烟 decimal wholeTray = 0; var temp4 = temp1.FirstOrDefault(s => s.Product.ProductCode == product.Product.ProductCode && s.SortType == "2"); if (product.Product.IsRounding == "2" || temp4 != null) { wholeTray = Math.Ceiling(quantity / (product.Product.CellMaxProductQuantity * product.Product.Unit.Count)); quantity = Convert.ToDecimal(wholeTray * (product.Product.Unit.Count * product.Product.CellMaxProductQuantity)); } if (areaQuantiy < quantity) //判断当前这个卷烟库存是否小于移库量 { //出库量减去备货区库存量取整 quantity = Math.Ceiling((product.SumQuantity - storQuantity) / product.Product.Unit.Count) * product.Product.Unit.Count; if (areaQuantiy < quantity) { //出库量减去备货区库存量 quantity = product.SumQuantity - storQuantity; } } //不取整的烟直接出库。 if (product.Product.IsRounding == "1") { quantity = product.SumQuantity - storQuantity; } if (quantity > 0) { if (cancellationToken.IsCancellationRequested) { return; } AlltoMoveBill(moveBillMaster, product.Product, item.SortingLine.Cell, ref quantity, cancellationToken, ps, item.SortingLine.Cell.CellCode); } if (quantity > 0) { //生成移库不完整,可能是库存不足; hasError = true; ps.State = StateType.Error; ps.Errors.Add(item.SortingLine.SortingLineCode + "线," + product.Product.ProductCode + " " + product.Product.ProductName + ",库存不足!当前总量:" + Convert.ToDecimal(product.SumQuantity / product.Product.UnitList.Unit02.Count) + "(条),缺少:" + Convert.ToDecimal(quantity / product.Product.UnitList.Unit02.Count) + "(条)"); NotifyConnection(ps.Clone()); } } } if (!hasError) { if (cancellationToken.IsCancellationRequested) { return; } OutBillMaster outBillMaster = OutBillCreater.CreateOutBillMaster(item.SortingLine.Cell.WarehouseCode, item.SortingLine.OutBillTypeCode, operatePersonID); outBillMaster.Origin = "2"; outBillMaster.Description = item.SortingLine.SortingLineCode + " 分拣调度生成!"; //添加出库单细单 foreach (var product in item.Products.ToArray()) { if (cancellationToken.IsCancellationRequested) { return; } OutBillCreater.AddToOutBillDetail(outBillMaster, product.Product, product.Price, product.SumQuantity); } if (cancellationToken.IsCancellationRequested) { return; } //添加出库、移库主单和作业调度表 SortWorkDispatch sortWorkDisp = AddSortWorkDispMaster(moveBillMaster, outBillMaster, item.SortingLine.SortingLineCode, item.OrderDate); //修改线路调度作业状态和作业ID var sortDispTemp = sortOrderDispatchQuery.WhereIn(s => s.ID, work) .Where(s => s.OrderDate == item.OrderDate && s.SortingLineCode == item.SortingLine.SortingLineCode); foreach (var sortDisp in sortDispTemp.ToArray()) { if (cancellationToken.IsCancellationRequested) { return; } sortDisp.SortWorkDispatchID = sortWorkDisp.ID; sortDisp.WorkStatus = "2"; } if (cancellationToken.IsCancellationRequested) { return; } SortWorkDispatchRepository.SaveChanges(); //scope.Complete(); ps.Messages.Add(item.SortingLine.SortingLineName + " 调度成功!"); } else { ps.State = StateType.Info; ps.Messages.Add(item.SortingLine.SortingLineName + " 调度失败!"); NotifyConnection(ps.Clone()); return; } } //} } catch (Exception e) { ps.State = StateType.Info; ps.Errors.Add(item.SortingLine.SortingLineName + "作业调度失败! 详情:" + e.Message); NotifyConnection(ps.Clone()); return; } } if (cancellationToken.IsCancellationRequested) { return; } if (MoveBillCreater.CheckIsNeedSyncMoveBill(lastMoveBillMaster.WarehouseCode)) { MoveBillCreater.CreateSyncMoveBillDetail(lastMoveBillMaster); } MoveBillMasterRepository.SaveChanges(); ps.State = StateType.Info; ps.Messages.Add("调度完成!"); NotifyConnection(ps.Clone()); }
/// <summary> /// 出库结单 /// </summary> /// <param name="billNo">单据号</param> /// <param name="errorInfo">错误信息</param> /// <returns></returns> public bool Settle(string billNo, out string errorInfo) { bool result = false; errorInfo = string.Empty; var outbm = OutBillMasterRepository.GetQueryable().FirstOrDefault(i => i.BillNo == billNo); if (outbm != null && outbm.Status == "5") { using (var scope = new TransactionScope()) { try { //结单移库单,修改冻结量 var moveDetail = MoveBillDetailRepository.GetQueryable() .Where(m => m.BillNo == outbm.MoveBillMasterBillNo && m.Status != "2"); //结单出库单,修改冻结量 var outAllot = OutBillAllotRepository.GetQueryable() .Where(o => o.BillNo == outbm.BillNo && o.Status != "2"); var sourceStorages = moveDetail.Select(m => m.OutStorage).ToArray(); var targetStorages = moveDetail.Select(m => m.InStorage).ToArray(); var storages = outAllot.Select(i => i.Storage).ToArray(); if (!Locker.Lock(storages) || !Locker.Lock(sourceStorages) || !Locker.Lock(targetStorages)) { errorInfo = "锁定储位失败,储位其他人正在操作,无法取消分配请稍候重试!"; return(false); } moveDetail.AsParallel().ForAll( (Action <MoveBillDetail>) delegate(MoveBillDetail m) { if (m.InStorage.ProductCode == m.ProductCode && m.OutStorage.ProductCode == m.ProductCode && m.InStorage.InFrozenQuantity >= m.RealQuantity && m.OutStorage.OutFrozenQuantity >= m.RealQuantity) { m.InStorage.InFrozenQuantity -= m.RealQuantity; m.OutStorage.OutFrozenQuantity -= m.RealQuantity; m.InStorage.LockTag = string.Empty; m.OutStorage.LockTag = string.Empty; } else { throw new Exception("储位的卷烟或入库冻结量与当前分配不符,信息可能被异常修改,不能结单!"); } } ); MoveBillDetailRepository.SaveChanges(); outAllot.AsParallel().ForAll( (Action <OutBillAllot>) delegate(OutBillAllot o) { if (o.Storage.ProductCode == o.ProductCode && o.Storage.OutFrozenQuantity >= o.AllotQuantity) { o.Storage.OutFrozenQuantity -= o.AllotQuantity; o.Storage.LockTag = string.Empty; } else { throw new Exception("储位的卷烟或入库冻结量与当前分配不符,信息可能被异常修改,不能结单!"); } } ); if (outbm.MoveBillMaster != null) { outbm.MoveBillMaster.Status = "4"; outbm.MoveBillMaster.UpdateTime = DateTime.Now; } outbm.Status = "6"; outbm.UpdateTime = DateTime.Now; OutBillMasterRepository.SaveChanges(); scope.Complete(); result = true; } catch (Exception e) { errorInfo = "出库单结单出错!原因:" + e.Message; return(false); } } } return(result); }