//提交U9盘点信息 public JsonResult SaveCheckToU9(string CheckNo) { try { if (string.IsNullOrEmpty(CheckNo)) { return(Json(new { state = false }, JsonRequestBehavior.AllowGet)); } Check_DB CheckDB = new Check_DB(); List <T_StockInfoEX> Checklist = new List <T_StockInfoEX>(); List <T_StockInfoEX> Scanlist = new List <T_StockInfoEX>(); CheckDB.GetCheckStock2(CheckNo, ref Checklist); //盘点单 CheckDB.GetCheckSerialno(CheckNo, ref Scanlist); //实盘结果 if (Checklist.Count == 0 || Scanlist.Count == 0) { return(Json(new { state = false }, JsonRequestBehavior.AllowGet)); } //wms数据和erp数据对账 for (int i = 0; i < Checklist.Count; i++) { for (int j = 0; j < Scanlist.Count; j++) { if (Checklist[i].MaterialNo == Scanlist[j].MaterialNo && Checklist[i].BatchNo == Scanlist[j].BatchNo) { Checklist[i].ScanQty = Scanlist[j].Qty; Scanlist[j].IsAmount = 1; } } } //没匹配的数据 for (int i = 0; i < Scanlist.Count; i++) { if (Scanlist[i].IsAmount != 1) { Checklist.Add(new T_StockInfoEX() { U9MaterialNo = Scanlist[i].MaterialNo, U9BatchNo = Scanlist[i].BatchNo, ScanQty = Scanlist[i].Qty, Qty = 0 }); } } T_Material_Batch_Func FUNC = new T_Material_Batch_Func(); string strMsg = ""; if (FUNC.SaveCheckToU9(Checklist, CheckNo, currentUser.UserNo, ref strMsg)) { return(Json(new { state = true }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { state = false, ErrorMsg = strMsg }, JsonRequestBehavior.AllowGet)); } } catch (Exception ex) { return(Json(new { state = false, Msg = ex.ToString() }, JsonRequestBehavior.AllowGet)); } }
// 物料盘点分析 public JsonResult GetCheckStockA(string CheckNo) { try { if (string.IsNullOrEmpty(CheckNo)) { return(Json(new { state = false }, JsonRequestBehavior.AllowGet)); } Check_DB CheckDB = new Check_DB(); List <T_StockInfoEX> Checklist = new List <T_StockInfoEX>(); List <T_StockInfoEX> Scanlist = new List <T_StockInfoEX>(); CheckDB.GetCheckStock2(CheckNo, ref Checklist); //盘点单 CheckDB.GetCheckSerialno(CheckNo, ref Scanlist); //实盘结果 if (Checklist.Count == 0 || Scanlist.Count == 0) { return(Json(new { state = false }, JsonRequestBehavior.AllowGet)); } //wms数据和erp数据对账 for (int i = 0; i < Checklist.Count; i++) { for (int j = 0; j < Scanlist.Count; j++) { if (Checklist[i].MaterialNo == Scanlist[j].MaterialNo && Checklist[i].BatchNo == Scanlist[j].BatchNo) { Checklist[i].ScaMaterialNo = Scanlist[j].MaterialNo; Checklist[i].ScaBatchNo = Scanlist[j].BatchNo; Checklist[i].ScanQty = Scanlist[j].Qty; Scanlist[j].IsAmount = 1; } } } //没匹配的数据 for (int i = 0; i < Scanlist.Count; i++) { if (Scanlist[i].IsAmount != 1) { Checklist.Add(new T_StockInfoEX() { ScaMaterialNo = Scanlist[i].MaterialNo, ScaBatchNo = Scanlist[i].BatchNo, ScanQty = Scanlist[i].Qty, Qty = 0 }); } } return(Json(new { Result = 1, Data = Checklist }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(new { Result = 0, ResultValue = ex.ToString() }, JsonRequestBehavior.AllowGet)); } }