//提交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));
}
}
public bool GetCheckStock2(string checkno, ref List <T_StockInfoEX> list)
{
Check_DB db = new Check_DB();
return(db.GetCheckStock2(checkno, ref list));
}
