//提交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 bool SaveCheckToU9(List <T_StockInfoEX> list, string CheckNo, string UserNo, ref string ErrorMsg)
{
try
{
T_Material_Batch_DB _db = new T_Material_Batch_DB();
if (_db.SaveCheckToU9(list, CheckNo, UserNo, ref ErrorMsg))
{
//WMS开始调整
Check_DB Check_DB = new Check_DB();
if (Check_DB.MingTiaozheng(CheckNo, UserNo, ref ErrorMsg))
{
return(true);
}
else
{
ErrorMsg = "U9过账成功，WMS失败：" + ErrorMsg;
return(false);
}
}
else
{
return(false);
}
}
catch (Exception ex)
{
return(false);
}
}
// 物料盘点分析
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 JsonResult tiaozheng_ms(string CHECKNO)
{
if (currentUser == null)
{
return(Json("Cookie失效，重新登陆！", JsonRequestBehavior.AllowGet));
}
string ErrMsg = "";
Check_DB db = new Check_DB();
if (db.DelCloCheck_MsTest(CHECKNO, 2, ref ErrMsg, currentUser.UserNo))
{
return(Json("调整成功！" + ErrMsg, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(ErrMsg, JsonRequestBehavior.AllowGet));
}
}
//库存调整
public string GetInfoBySerialymh(string barcode)
{
Check_DB db = new Check_DB();
return(db.GetInfoBySerial(barcode));
}
//库存调整
public string SaveInfo(string json, string man)
{
Check_DB db = new Check_DB();
return(db.SaveInfo(json, man));
}
//保存盘点单
public JsonResult SaveCheck(T_StockInfoEX model)
{
try
{
if (string.IsNullOrEmpty(model.WarehouseNo))
{
return(Json(new { state = false }, JsonRequestBehavior.AllowGet));
}
T_WareHouse_DB TWareHouseDB = new T_WareHouse_DB();
string StrongHoldCode = "";
string StrongHoldCodeName = "";
TWareHouseDB.GetStrongholdcode(model.WarehouseNo, ref StrongHoldCode, ref StrongHoldCodeName);
Check_DB checkdb = new Check_DB();
string ErrorMsg = "";
if (!checkdb.CheckIsSvae(model.MaterialNo, model.WarehouseNo, ref ErrorMsg))
{
return(Json(new { state = false, ErrMsg = "待发或者待收库区有该物料不能生成盘点单！【" + ErrorMsg + "】" }, JsonRequestBehavior.AllowGet));
}
string strErrMsg = string.Empty;
List <T_StockInfoEX> lsttask = new List <T_StockInfoEX>();
Query_DB db = new Query_DB();
if (!db.GetStockCombineInfo2(model, ref lsttask, ref strErrMsg))
{
return(Json(new { Result = 0, ErrMsg = strErrMsg }, JsonRequestBehavior.AllowGet));
}
if (model.Check == "0")
{
//检验WMS库存和U9是否一致
T_Material_Batch_Func FUNC = new T_Material_Batch_Func();
List <U9Stock> erp_stock = FUNC.GetStockInfo(model.WarehouseNo, StrongHoldCode, model.MaterialNo);
bool isOk = true;
lsttask.ForEach(itemWMS =>
{
if (erp_stock.FindAll(itemerp => { return(itemerp.MaterialNo == itemWMS.MaterialNo && itemerp.BatchNo == itemWMS.BatchNo && itemerp.Qty == itemWMS.Qty); }).Count != 1)
{
isOk = false;
}
});
if (!isOk)
{
return(Json(new { state = false, ErrMsg = "WMS库存和U9不匹配不能生成盘点单！" }, JsonRequestBehavior.AllowGet));
}
}
Check_Model cm = new Check_Model();
//cm.REMARKS = strremark + txt_remarkD.Text + txt_remark.Text;
cm.CHECKSTATUS = "新建";
cm.CREATER = currentUser.UserNo;
cm.CHECKDESC = "明盘";
string ErrMsg = "";
if (checkdb.SaveCheck2(cm, lsttask, ref ErrMsg))
{
return(Json(new { state = true }, JsonRequestBehavior.AllowGet));
}
return(Json(new { state = false }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { state = false, ErrMsg = ex.ToString() }, JsonRequestBehavior.AllowGet));
}
}
//public string GetScanInfo(string barcode)
//{
// Check_DB db = new Check_DB();
// return db.GetScanInfo(barcode);
//}
public bool ReCheck(string checkno, string peo, ref string ErrMsg)
{
Check_DB db = new Check_DB();
return(db.ReCheck(checkno, peo, ref ErrMsg));
}
public bool DelCloCheck(string checkno, int type, ref string ErrMsg, string username = "")
{
Check_DB db = new Check_DB();
return(db.DelCloCheck(checkno, type, ref ErrMsg, username));
}
public bool SaveCheck2(Check_Model model, List <T_StockInfoEX> list, ref string ErrMsg)
{
Check_DB db = new Check_DB();
return(db.SaveCheck2(model, list, ref ErrMsg));
}
public bool GetCheckArea(int hl, string areano, string houseno, string warehouseno, ref List <CheckArea_Model> list)
{
Check_DB db = new Check_DB();
return(db.GetCheckArea(hl, areano, houseno, warehouseno, ref list));
}
public string GetMinBarocde(string barcode, string checkno, string Qty)
{
Check_DB db = new Check_DB();
return(db.GetMinBarocde(barcode, checkno, Qty));
}
public string GetCheckMing()
{
Check_DB db = new Check_DB();
return(db.GetCheckMing());
}
public string GetScanInfo(string barcode, string CheckNo)
{
Check_DB db = new Check_DB();
return(db.GetScanInfo(barcode, CheckNo));
}
public string GetWareHouse()
{
Check_DB db = new Check_DB();
return(db.GetWareHouse());
}
public bool GetCheckStock2(string checkno, ref List <T_StockInfoEX> list)
{
Check_DB db = new Check_DB();
return(db.GetCheckStock2(checkno, ref list));
}
public string GetMinSerialno(int id)
{
Check_DB db = new Check_DB();
return(db.GetMinSerialno(id));
}
public bool SaveCheck(Check_Model model, List <CheckArea_Model> list, ref string ErrMsg)
{
Check_DB db = new Check_DB();
return(db.SaveCheck(model, list, ref ErrMsg));
}
public string DeleteCheckDetail(string checkno, string json)
{
Check_DB db = new Check_DB();
return(db.DeleteCheckDetail(checkno, json));
}
public bool GetCheckRefInfo(CheckRef_Model model, ref DividPage dividpage, ref List <CheckRef_Model> lsttask, ref string strErrMsg)
{
Check_DB db = new Check_DB();
return(db.GetCheckRefInfo(model, ref dividpage, ref lsttask, ref strErrMsg));
}
public string GetAreanobyCheckno2(string checkno, string areano)
{
Check_DB db = new Check_DB();
return(db.GetAreanobyCheckno2(checkno, areano));
}
public bool GetCheckAnalyze2(CheckAnalyze taskmo, ref DividPage dividpage, ref List <CheckAnalyze> lsttask, ref string strErrMsg)
{
Check_DB db = new Check_DB();
return(db.GetCheckAnalyze2(taskmo, ref dividpage, ref lsttask, ref strErrMsg));
}
public string InsertCheckDetail(string json)
{
Check_DB db = new Check_DB();
return(db.InsertCheckDetail(json));
}
public void dbTest()
{
Check_DB db = new Check_DB();
db.dbTest();
}
public string GetCheckDetail(string checkno)
{
Check_DB db = new Check_DB();
return(db.GetCheckDetail(checkno));
}
