| | |
| | | /// Default: |
| | | /// Nullable:False |
| | | /// </summary> |
| | | public int? Qty { get; set; } |
| | | public decimal? Qty { get; set; } |
| | | |
| | | /// <summary> |
| | | /// Desc:整箱数量 |
| | | /// Default: |
| | | /// Nullable:True |
| | | /// </summary> |
| | | public int? FullQty { get; set; } |
| | | public decimal? FullQty { get; set; } |
| | | |
| | | /// <summary> |
| | | /// Desc:状态 |
| | |
| | | /// <summary> |
| | | /// 实际数量 |
| | | /// </summary> |
| | | public int? RealQty { get; set; } |
| | | public decimal? RealQty { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 盘点结果 |
| | |
| | | public string Standard { get; set; } |
| | | public string LotNo { get; set; } |
| | | public string LotText { get; set; } |
| | | public int Qty { get; set; } |
| | | public decimal Qty { get; set; } |
| | | public string SupplierLot { get; set; } |
| | | public string PalletNo { get; set; } |
| | | |
| | |
| | | /// <summary> |
| | | /// 库存数量 |
| | | /// </summary> |
| | | public int? Qty { get; set; } |
| | | public decimal? Qty { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 实际数量 |
| | | /// </summary> |
| | | public int? RealQty { get; set; } |
| | | public decimal? RealQty { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 盘点结果 |
| | |
| | | /// <summary> |
| | | /// Desc:拣货数量 |
| | | /// </summary> |
| | | public int? CompleteQty { get; set; } |
| | | public decimal? CompleteQty { get; set; } |
| | | |
| | | /// <summary> |
| | | /// Desc:新托盘 |
| | |
| | | { |
| | | public string PalletNo { get; set; } |
| | | public string BoxNo { get; set; } |
| | | public int Qty { get; set; } |
| | | public decimal Qty { get; set; } |
| | | |
| | | public string SkuNo { get; set; } |
| | | public string SkuName { get; set; } |
| | |
| | | public class BoxInfo |
| | | { |
| | | public string BoxNo { get; set; } // 箱码/支码 |
| | | public int Qty { get; set; } // 箱内数量 |
| | | public decimal Qty { get; set; } // 箱内数量 |
| | | public string SkuNo { get; set; } // 物料编码 |
| | | public string SkuName { get; set; } // 物料名称 |
| | | public string LotNo { get; set; } // 批次 |
| | | public int? PickedQty { get; set; } // 箱内已拣数量 |
| | | public decimal? PickedQty { get; set; } // 箱内已拣数量 |
| | | } |
| | | public class DetailIdSkuLotNo |
| | | { |
| | |
| | | /// Default: |
| | | /// Nullable:False |
| | | /// </summary> |
| | | public int? Qty { get; set; } |
| | | public decimal? Qty { get; set; } |
| | | |
| | | /// <summary> |
| | | /// Desc:整托数量 |
| | | /// Default: |
| | | /// Nullable:True |
| | | /// </summary> |
| | | public int? FullQty { get; set; } |
| | | public decimal? FullQty { get; set; } |
| | | |
| | | /// <summary> |
| | | /// Desc:状态 |
| | |
| | | ASNNo = asnList.ASNNo, |
| | | ASNDetailNo = asnList.Id, |
| | | BoxNo = maxBoxCode, |
| | | Qty = int.Parse(boxQty.ToString()), |
| | | Qty = boxQty, |
| | | FullQty = bNum, |
| | | Status = "0", |
| | | SkuNo = asnList.SkuNo, |
| | |
| | | } |
| | | Db.BeginTran(); |
| | | var time = DateTime.Now; |
| | | var qty = 0; |
| | | decimal qty = 0; |
| | | foreach (var item in boxInfos) |
| | | { |
| | | //删除解绑箱支信息 |
| | |
| | | LotNo = m.LotNo, |
| | | LotText = m.LotText, |
| | | SupplierLot = m.SupplierLot, |
| | | Qty = (int)m.Qty, |
| | | Qty = (decimal)m.Qty, |
| | | |
| | | PalletNo = m.PalletNo |
| | | }).ToList(); |
| | |
| | | BoxNo2 = l.BoxNo2, |
| | | BoxNo3 = l.BoxNo3, |
| | | PalletNo = l.PalletNo, |
| | | Qty = (int)l.RealQty, |
| | | Qty = (decimal)l.RealQty, |
| | | FullQty = stockBoxInfo.FullQty,//满箱数量 |
| | | Status = "2", |
| | | SkuNo = l.SkuNo, |
| | |
| | | }; |
| | | Db.Insertable<DataBoxInfo>(databox).ExecuteCommand(); |
| | | //库存明细增加数量 |
| | | stockDetailInfo.Qty += (int)l.RealQty; |
| | | stockDetailInfo.Qty += l.RealQty; |
| | | } |
| | | else |
| | | { |
| | | //库存明细增加数量 |
| | | stockDetailInfo.Qty = (int)l.RealQty; |
| | | stockDetailInfo.Qty = l.RealQty; |
| | | } |
| | | stockDetailInfo.Status = "0"; |
| | | |
| | |
| | | } |
| | | if (sku.Type != "4") |
| | | { |
| | | de.Qty += (int)l.RealQty; |
| | | de.Qty += (decimal)l.RealQty; |
| | | } |
| | | else |
| | | { |
| | | de.Qty += (int)(l.RealQty - l.Qty); |
| | | de.Qty += (decimal)(l.RealQty - l.Qty); |
| | | } |
| | | |
| | | Db.Updateable(de).ExecuteCommand(); |
| | |
| | | PalletNo3 = model.PalletNo3, |
| | | Status = "1", |
| | | CompleteTime = DateTime.Now, |
| | | Qty = (int)model.Qty, |
| | | Qty = (decimal)model.Qty, |
| | | FullQty = null, |
| | | SkuNo = "100099", |
| | | SkuName = "托盘", |
| | |
| | | UpbindPalletNo = upBindPalletNo, |
| | | PalletNo2 = bindVms[0].PalletNo2, |
| | | PalletNo3 = bindVms[0].PalletNo3, |
| | | Qty = (int)bindVms[0].Qty, |
| | | Qty = bindVms[0].Qty, |
| | | LotNo = bindVms[0].LotNo, |
| | | LotText = bindVms[0].LotText, |
| | | SupplierLot = bindVms[0].SupplierLot, |
| | |
| | | return strMsg; |
| | | } |
| | | #endregion |
| | | var pallQty = 0;//托盘上数量 |
| | | decimal pallQty = 0;//托盘上数量 |
| | | var boxinfo2 = boxinfo.Where(w => w.SkuNo == noticeItem.SkuNo && w.LotNo == noticeItem.LotNo && w.PalletNo == model.PalletNo).ToList(); |
| | | if (boxinfo2.Count <= 0) |
| | | { |
| | |
| | | { |
| | | throw new Exception("-1:箱码信息不存在,请核查!"); |
| | | } |
| | | var bNum = 0;//数量 |
| | | decimal bNum = 0;//数量 |
| | | //验证箱码是否已绑定托盘 |
| | | foreach (var item in boxinfo) |
| | | { |
| | |
| | | var boxGroup = boxInfoList.GroupBy(m => m.BoxNo).ToList(); |
| | | foreach (var g in boxGroup) |
| | | { |
| | | var boxFullQty = 0;//箱内总数量 |
| | | decimal boxFullQty = 0;//箱内总数量 |
| | | foreach (var box in g) |
| | | { |
| | | if (box.BindNo != null && box.BindNo != 0) |
| | |
| | | { |
| | | PalletNo = palletNo, |
| | | SkuNo = sku, |
| | | Qty = (int?)stockDetail.Qty, |
| | | Qty = stockDetail.Qty, |
| | | CheckResult = 4, |
| | | }; |
| | | |
| | |
| | | |
| | | |
| | | var list = checkLog.ToList(); |
| | | var num = 0; |
| | | decimal num = 0; |
| | | foreach (var l in list) |
| | | { |
| | | l.RealQty = 0; |
| | | l.CheckResult = 1; |
| | | l.CheckDate = time; |
| | | l.CheckUserId = userId; |
| | | num -= int.Parse(l.RealQty.ToString()); |
| | | num -= (decimal)l.RealQty; |
| | | } |
| | | if (checkDetail.RealQty == null) |
| | | { |
| | |
| | | { |
| | | throw new Exception("拣货数量不能大于箱内剩余待拣数量"); |
| | | } |
| | | var pickQty = 0;//拣货的数量 |
| | | decimal pickQty = 0;//拣货的数量 |
| | | var comDetailList = Db.Queryable<BllCompleteDetail>().Where(m => m.IsDel == "0" && m.ExportAllotId == allot.Id && m.PalletNo == palletNo).ToList(); |
| | | var comList = new List<BllCompleteDetail>(); |
| | | foreach (var item in boxInfos) |
| | |
| | | { |
| | | throw new Exception("该箱码内存在支码不能进行数量拣货"); |
| | | } |
| | | int boxQty = boxInfo.First().Qty; |
| | | decimal boxQty = boxInfo.First().Qty; |
| | | if (Convert.ToInt32(pickQty1) > boxQty) |
| | | { |
| | | throw new Exception("拣货数量不能大于箱内数量"); |
| | |
| | | } |
| | | } |
| | | } |
| | | var pickQty = 0;//拣货的数量 |
| | | decimal pickQty = 0;//拣货的数量 |
| | | |
| | | var comList = new List<BllCompleteDetail>(); |
| | | foreach (var item in boxInfos) |
| | |
| | | { |
| | | throw new Exception("该箱码内存在支码不能进行数量拣货"); |
| | | } |
| | | int boxQty = boxInfo.First().Qty; |
| | | decimal boxQty = boxInfo.First().Qty; |
| | | if (Convert.ToInt32(pickQty1) > boxQty) |
| | | { |
| | | throw new Exception("拣货数量不能大于箱内数量"); |
| | |
| | | } |
| | | } |
| | | } |
| | | var pickQty = 0;//拣货的数量 |
| | | decimal pickQty = 0;//拣货的数量 |
| | | |
| | | var comList = new List<BllCompleteDetail>(); |
| | | foreach (var item in boxInfos) |
| | |
| | | { |
| | | throw new Exception("该箱码内存在支码不能进行数量拣货"); |
| | | } |
| | | int boxQty = boxInfo.First().Qty; |
| | | decimal boxQty = boxInfo.First().Qty; |
| | | if (Convert.ToInt32(pickQty1) > boxQty) |
| | | { |
| | | throw new Exception("拣货数量不能大于箱内数量"); |
| | |
| | | } |
| | | } |
| | | } |
| | | var pickQty = 0;//拣货的数量 |
| | | decimal pickQty = 0;//拣货的数量 |
| | | |
| | | var comList = new List<BllCompleteDetail>(); |
| | | foreach (var item in boxInfos) |
| | |
| | | } |
| | | #endregion |
| | | |
| | | var pickQty = 0;//拣货的数量 |
| | | decimal pickQty = 0;//拣货的数量 |
| | | if (string.IsNullOrWhiteSpace(boxNo))//整托拣货 |
| | | { |
| | | List<DataBoxInfo> boxInfos; |
| | |
| | | { |
| | | throw new Exception("该箱码内存在支码不能进行数量拣货"); |
| | | } |
| | | int boxQty = boxInfo.First().Qty; |
| | | decimal boxQty = boxInfo.First().Qty; |
| | | if (Convert.ToInt32(pickQty1) > boxQty) |
| | | { |
| | | throw new Exception("拣货数量不能大于箱内数量"); |
| | |
| | | /// Default: |
| | | /// Nullable:False |
| | | /// </summary> |
| | | public int Qty {get;set;} |
| | | public decimal Qty {get;set;} |
| | | |
| | | /// <summary> |
| | | /// Desc:整箱数量 |
| | | /// Default: |
| | | /// Nullable:True |
| | | /// </summary> |
| | | public int? FullQty {get;set;} |
| | | public decimal? FullQty {get;set;} |
| | | |
| | | /// <summary> |
| | | /// Desc:状态 |
| | |
| | | /// Default: |
| | | /// Nullable:True |
| | | /// </summary> |
| | | public int? Qty {get;set;} |
| | | public decimal? Qty {get;set;} |
| | | |
| | | /// <summary> |
| | | /// Desc:二级托盘号 |
| | |
| | | /// Default: |
| | | /// Nullable:True |
| | | /// </summary> |
| | | public int? RealQty {get;set;} |
| | | public decimal? RealQty {get;set;} |
| | | |
| | | /// <summary> |
| | | /// Desc:盘点结果 |
| | |
| | | /// Default: |
| | | /// Nullable:True |
| | | /// </summary> |
| | | public int? Qty {get;set;} |
| | | public decimal? Qty {get;set;} |
| | | |
| | | /// <summary> |
| | | /// Desc:实际数量 |
| | | /// Default: |
| | | /// Nullable:True |
| | | /// </summary> |
| | | public int? RealQty {get;set;} |
| | | public decimal? RealQty {get;set;} |
| | | |
| | | /// <summary> |
| | | /// Desc:盘点结果 |
| | |
| | | /// Default: |
| | | /// Nullable:True |
| | | /// </summary> |
| | | public int? CompleteQty {get;set;} |
| | | public decimal? CompleteQty {get;set;} |
| | | |
| | | /// <summary> |
| | | /// Desc:新托盘 |
| | |
| | | /// Default: |
| | | /// Nullable:False |
| | | /// </summary> |
| | | public int Qty {get;set;} |
| | | public decimal Qty {get;set;} |
| | | |
| | | /// <summary> |
| | | /// Desc:整箱数量 |
| | | /// Default: |
| | | /// Nullable:True |
| | | /// </summary> |
| | | public int? FullQty {get;set;} |
| | | public decimal? FullQty {get;set;} |
| | | |
| | | /// <summary> |
| | | /// Desc:状态 |
| | |
| | | /// Default: |
| | | /// Nullable:False |
| | | /// </summary> |
| | | public int FrozenQty { get; set; } |
| | | public decimal FrozenQty { get; set; } |
| | | } |
| | | } |