From 5791a98ec10b2fe741255ac4cc1af9f80ea2aaf1 Mon Sep 17 00:00:00 2001
From: 王 垚 <1402714037@qq.com>
Date: 星期一, 25 七月 2022 17:27:26 +0800
Subject: [PATCH] 调整
---
WebAPI/Controllers/POInStockController.cs | 8 -
WebAPI/Controllers/BarCodeController.cs | 247 +++++++++++++++++++++++++++++++++++++++++++++++++
2 files changed, 249 insertions(+), 6 deletions(-)
diff --git a/WebAPI/Controllers/BarCodeController.cs b/WebAPI/Controllers/BarCodeController.cs
index fe7c3b1..ad0e3a6 100644
--- a/WebAPI/Controllers/BarCodeController.cs
+++ b/WebAPI/Controllers/BarCodeController.cs
@@ -636,7 +636,6 @@
foreach (Model.ClsGy_BarCodeBill_WMS_Model oItemSub2 in ls2)
{
//鍐呯
- //LogService.Write("寰幆绗竴娆�:" + oItemSub2.HSupID);
if (ClsPub.isLong(oItemSub2.HMaterID) != 0)
{
long sMaterID = ClsPub.isLong(oItemSub2.HMaterID);
@@ -825,6 +824,252 @@
objJsonResult.data = null;
return objJsonResult;
}
+
+ //妫�鏌ユ槸鍚﹀凡缁忕敓鎴愭潯鐮�
+ public bool CheckBarCode(Int64 HSourceInterID, Int64 HSourceEntryID)
+ {
+ DataSet Ds;
+ Ds = oCn.RunProcReturn("select * from Gy_BarCodeBill where HSourceInterID=" + HSourceInterID + " and HSourceEntryID=" + HSourceEntryID, "Gy_BarCodeBill");
+ if (Ds == null)
+ {
+ return false;
+ }
+ if (Ds.Tables[0].Rows.Count == 0)
+ {
+ return true;
+ }
+ else
+ {
+ return false;
+ }
+ }
+
+ [Route("GetBarcodeSaveBillOnlyInnerBox")]
+ [HttpPost]
+ /// <summary>
+ /// 鐢熸垚鏉＄爜(浠呭唴绠�)
+ /// </summary>
+ /// <param name="msg"></param>
+ /// <param name="msg2"></param>
+ /// <returns></returns>
+ public object GetBarcodeSaveBillOnlyInnerBox([FromBody] JObject msg)
+ {
+ var _value = msg["msg"].ToString();
+ string msg1 = _value.ToString();
+ string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
+ string msg2 = sArray[0].ToString();
+ string msg3 = sArray[1].ToString();
+ //LogService.Write(msg3);
+ string UserName = "";
+ ListModels oListModels = new ListModels();
+ try
+ {
+ List<Model.ClsCg_POInStockBillMain> lsmain = new List<Model.ClsCg_POInStockBillMain>();
+ msg2 = msg2.Replace("\\", "");
+ msg2 = msg2.Replace("\n", ""); //\n
+ lsmain = oListModels.getObjectByJson_POInStockMain(msg2);
+ foreach (Model.ClsCg_POInStockBillMain oItem in lsmain)
+ {
+ UserName = oItem.HMaker;
+ }
+ DAL.ClsWeb_BarCodeBill oBill = new DAL.ClsWeb_BarCodeBill();
+
+ msg3 = msg3.Substring(1, msg3.Length - 2);
+ msg3 = msg3.Replace("\\", "");
+ msg3 = msg3.Replace("\n", ""); //\n
+
+ List<Model.ClsGy_MaterialList_WMS_Model> ls = new List<Model.ClsGy_MaterialList_WMS_Model>();
+ List<Model.ClsGy_BarCodeBill_WMS_Model> ls2 = new List<Model.ClsGy_BarCodeBill_WMS_Model>();
+ List<Model.ClsGy_BarCodeBill_WMS_Model> ls3 = new List<Model.ClsGy_BarCodeBill_WMS_Model>();
+ ls = oListModels.getObjectByJson_MaterialList(msg3);
+
+ foreach (Model.ClsGy_MaterialList_WMS_Model oItemSub in ls)
+ {
+ if (CheckBarCode(oItemSub.HSourceInterID, oItemSub.HSourceEntryID) == false)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "宸插瓨鍦ㄦ潯鐮侊紝涓嶅厑璁搁噸澶嶇敓鎴愶紒";
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ if (msg2 != string.Empty)
+ {
+ if (oItemSub.HBQty == 0 || oItemSub.HMinQty == 0)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "鍐呯鍖呰鏁颁笉鑳戒负0锛�";
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ if (oItemSub.HBQty > oItemSub.HBQty)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "鍐呯鍖呰鏁颁笉鑳戒负0锛�";
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ }
+ }
+ long linterid = Pub_Class.ClsPub.CreateBillID_SRMProd("8888", ref DBUtility.ClsPub.sExeReturnInfo);
+ int LSHlen = 6; //娴佹按鍙烽暱搴�
+ int SumLen = 10; //鎬婚暱搴�
+ string TM = ""; //鏉＄爜
+ int LSH = 0; //娴佹按鍙�
+ string LSH2 = ""; //娴佹按鍙疯浆鎹㈡垚瀛楃
+ string sDate = ""; //鏃ユ湡
+ string sYear = ""; //骞�
+ string sPeriod = ""; //鏈�
+ string sDay = ""; //鏃�
+ DataSet Ds;
+ SQLHelper.ClsCNSRM oCn = new SQLHelper.ClsCNSRM();
+ Ds = oCn.RunProcReturn("exec GetLSH '" + DateTime.Today + "'", "GetLSH");
+ LSH = ClsPub.isInt(Ds.Tables[0].Rows[0][0]);
+ foreach (Model.ClsGy_MaterialList_WMS_Model oItemSub in ls)
+ {
+ //鍐呯
+ if (ClsPub.isLong(oItemSub.HMaterID) != 0)
+ {
+ var WeiShu = "";
+ var HNumber = oItemSub.HMaterID.ToString();
+ var HSumQty = ClsPub.isDoule(oItemSub.HQty);//浜у搧鏁伴噺
+ var HMinQty = ClsPub.isDoule(oItemSub.HMinQty);//鍐呯鍖呰鏁伴噺
+ var HBQty = ClsPub.isDoule(oItemSub.HBQty); //鍐呯鏁�
+ for (int i = 1; i <= HBQty; i++)
+ {
+ if ((double)i == HBQty)
+ {
+ WeiShu = "灏炬暟";
+ HMinQty = HSumQty - (HBQty - 1) * HMinQty;
+ }
+ TM = $"{oItemSub.HMaterID}#{HMinQty}";
+ Model.ClsGy_BarCodeBill_WMS_Model bar = new Model.ClsGy_BarCodeBill_WMS_Model();
+ bar.HBarCode = TM;
+ bar.HMaterID = oItemSub.HMaterID;
+ bar.HUnitID = oItemSub.HUnitID;
+ bar.HQty = HMinQty;
+ bar.HBatchNo = oItemSub.HBatchNo;
+ bar.HKFDate = oItemSub.HKFDate;
+ bar.HKFPeriod = oItemSub.HKFPeriod;
+ bar.HKFDQDate = oItemSub.HKFDQDate;
+ bar.HSourceInterID = oItemSub.HSourceInterID;
+ bar.HSourceEntryID = oItemSub.HSourceEntryID;
+ bar.HSourceBillNo = oItemSub.HSourceBillNo;
+ bar.HSourceBillType = oItemSub.HSourceBillType;
+ bar.HMinQty = oItemSub.HMinQty;
+ bar.HSupID = oItemSub.HSupID;
+ bar.HEndQty = WeiShu;
+ bar.HMTONO = oItemSub.HMTONO;
+ ls2.Add(bar);
+ }
+ }
+ }
+ string HBarCode = "";
+ string HBarCodeType = "";
+ Int64 HMaterID = 0;
+ Int64 HUnitID = 0;
+ double HQty2 = 0;
+ string HBatchNo = "";
+ Int64 HSupID = 0;
+ Int64 HGroupID = 0;
+ int HPrintQty = 0;
+ Int64 HSourceInterID = 0;
+ Int64 HSourceEntryID = 0;
+ string HSourceBillNo = "";
+ string HSourceBillType = "";
+ Int64 HKFPeriod = 0;
+ string HKFDate = "";
+ string HKFDQDate = "";
+ string HWei = "";
+ string HMTONO = "";
+ oCn.BeginTran();
+ foreach (Model.ClsGy_BarCodeBill_WMS_Model oItemSub in ls2)
+ {
+ if (ClsPub.isLong(oItemSub.HMaterID) != 0)
+ {
+ HBarCode = oItemSub.HBarCode.ToString();
+ HMTONO = ClsPub.isStrNull(oItemSub.HMTONO);
+ HBarCodeType = "绠卞彿鍐呮潯鐮�";
+ HMaterID = ClsPub.isLong(oItemSub.HMaterID);
+ HUnitID = ClsPub.isLong(oItemSub.HUnitID);
+ HQty2 = ClsPub.isDoule(oItemSub.HQty);
+ HBatchNo = ClsPub.isStrNull(oItemSub.HBatchNo);
+ HSupID = oItemSub.HSupID;
+ //LogService.Write("HSupID:" + oItemSub.HSupID);
+ HKFPeriod = ClsPub.isInt(oItemSub.HKFPeriod);
+ HKFDate = ClsPub.isStrNull(oItemSub.HKFDate);
+ HKFDQDate = ClsPub.isStrNull(oItemSub.HKFDQDate);
+ HSourceInterID = ClsPub.isLong(oItemSub.HSourceInterID);
+ HSourceEntryID = ClsPub.isLong(oItemSub.HSourceEntryID);
+ HSourceBillNo = ClsPub.isStrNull(oItemSub.HSourceBillNo);
+ HSourceBillType = ClsPub.isStrNull(oItemSub.HSourceBillType);
+ HWei = ClsPub.isStrNull(oItemSub.HEndQty);
+ string sql = "insert into Gy_BarCodeBill (HInterID,HBarCode,HBarCodeType,HMaterID,HUnitID,HQty,HKFDate,HKFPeriod,HKFDQDate" +
+ ",HBatchNo,HSupID,HGroupID,HMaker,HMakeDate,HPrintQty,HEndQty,HSupflag" +
+ ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HMTONO " +
+ ") values ("
+ + linterid.ToString() + ",'" + HBarCode + "','" + HBarCodeType + "'," + HMaterID + "," + HUnitID + "," + HQty2 + ",'" + HKFDate + "'," + HKFPeriod + ",'" + HKFDQDate
+ + "','" + HBatchNo + "'," + HSupID + "," + HGroupID + ",'" + ClsPub.CurUserName + "','" + DateTime.Today + "'," + HPrintQty + ",'" + HWei + "',1"
+ + "," + HSourceInterID + "," + HSourceEntryID + ",'" + HSourceBillNo + "','" + HSourceBillType + "','" + HMTONO + "')";
+ oCn.RunProc(sql);
+ sql = "exec setLSH '" + DateTime.Today + "'";
+ oCn.RunProc(sql);
+ }
+ }
+ foreach (Model.ClsGy_BarCodeBill_WMS_Model oItemSub in ls3)
+ {
+ //LogService.Write("寰幆绗笁娆�:" + oItemSub.HSupID);
+ if (ClsPub.isLong(oItemSub.HMaterID) != 0)
+ {
+ HBarCode = oItemSub.HBarCode.ToString();
+ HMTONO = ClsPub.isStrNull(oItemSub.HMTONO);
+ HBarCodeType = "绠卞彿鍐呮潯鐮�";
+ HMaterID = ClsPub.isLong(oItemSub.HMaterID);
+ HUnitID = ClsPub.isLong(oItemSub.HUnitID);
+ HQty2 = ClsPub.isDoule(oItemSub.HQty);
+ HBatchNo = ClsPub.isStrNull(oItemSub.HBatchNo);
+ HSupID = oItemSub.HSupID;
+ HKFPeriod = ClsPub.isInt(oItemSub.HKFPeriod);
+ HKFDate = ClsPub.isStrNull(oItemSub.HKFDate);
+ HKFDQDate = ClsPub.isStrNull(oItemSub.HKFDQDate);
+ HSourceInterID = ClsPub.isLong(oItemSub.HSourceInterID);
+ HSourceEntryID = ClsPub.isLong(oItemSub.HSourceEntryID);
+ HSourceBillNo = ClsPub.isStrNull(oItemSub.HSourceBillNo);
+ HSourceBillType = ClsPub.isStrNull(oItemSub.HSourceBillType);
+ HWei = ClsPub.isStrNull(oItemSub.HEndQty);
+ string sql = "insert into Gy_BarCodeBill (HInterID,HBarCode,HBarCodeType,HMaterID,HUnitID,HQty,HKFDate,HKFPeriod,HKFDQDate" +
+ ",HBatchNo,HSupID,HGroupID,HMaker,HMakeDate,HPrintQty,HEndQty,HSupflag" +
+ ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HMTONO " +
+ ") values ("
+ + linterid.ToString() + ",'" + HBarCode + "','" + HBarCodeType + "'," + HMaterID + "," + HUnitID + "," + HQty2 + ",'" + HKFDate + "'," + HKFPeriod + ",'" + HKFDQDate
+ + "','" + HBatchNo + "'," + HSupID + "," + HGroupID + ",'" + ClsPub.CurUserName + "','" + DateTime.Today + "'," + HPrintQty + ",'" + HWei + "',1"
+ + "," + HSourceInterID + "," + HSourceEntryID + ",'" + HSourceBillNo + "','" + HSourceBillType + "','" + HMTONO + "')";
+ oCn.RunProc(sql);
+ }
+ }
+ //鏆傛椂鍙洖濉叧鑱旀暟閲�
+ string _sql = "exec H_p_SRM_BarCodeBill_Update_UpdateBillRelateData " + linterid.ToString();
+ oCn.RunProc(_sql);
+ oCn.Commit();
+ }
+ catch (Exception e)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "" + e.Message + DBUtility.ClsPub.sExeReturnInfo;
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+
+ objJsonResult.code = "0";
+ objJsonResult.count = 1;
+ objJsonResult.Message = "鐢熸垚鏉＄爜鎴愬姛锛�";
+ WebAPIController.Add_Log("鏉＄爜涓嬫帹", UserName, "鐢熸垚鏉＄爜");
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
[Route("GetHBarCodeShowBillSub2")]
[HttpGet]
/// <summary>
diff --git a/WebAPI/Controllers/POInStockController.cs b/WebAPI/Controllers/POInStockController.cs
index 5baffa2..083dd91 100644
--- a/WebAPI/Controllers/POInStockController.cs
+++ b/WebAPI/Controllers/POInStockController.cs
@@ -455,19 +455,17 @@
if (msg.Trim() == "")
{
msg = " Where hsupid in (select HSupID from h_v_Gy_UserSupplierList where 鐢ㄦ埛 =^^" + HSupNo.Trim() + "^^) " + sqlWhere;
- // msg = " Where hsupid in (select hsupid from Gy_UserSupplierRelation where HUserID=^^" + System.Web.HttpContext.Current.Session["HUserName"].ToString() + "^^)";
}
else
{
msg = msg + " and hsupid in (select HSupID from h_v_Gy_UserSupplierList where 鐢ㄦ埛 =^^" + HSupNo.Trim() + "^^) " + sqlWhere;
- // msg = msg + " Where hsupid in (select hsupid from Gy_UserSupplierRelation where HUserID=^^" + System.Web.HttpContext.Current.Session["HUserName"].ToString() + "^^)";
}
//杞崲鐗规畩瀛楃
if (Common.SQLtoChange(msg, ref VsWhere, ref PcWhere) == false)
{
objjson.code = "0";
objjson.count = 0;
- objjson.Message = "鑾峰彇澶辫触";
+ objjson.Message = "杞崲鐗规畩瀛楃澶辫触";
objjson.data = null;
return objjson;
}
@@ -475,12 +473,12 @@
Int64 RowTotal = Common.GetRowTotal("H_v_SRM_POInStockBillList", VsWhere, ref DBUtility.ClsPub.sExeReturnInfo);
//鑾峰彇杩斿洖鏁版嵁
ds = oCn.RunProcReturn("exec H_p_SRM_POInStockBillList '" + PcWhere + "'", "H_p_SRM_POInStockBillList");
- //LogService.Write("exec H_p_SRM_POInStockBillList '" + PcWhere + "'");
+ LogService.Write("閫佽揣鍗曞垪琛ㄥ姞杞絪ql:exec H_p_SRM_POInStockBillList '" + PcWhere + "'");
if (ds == null || ds.Tables[0].Rows.Count == 0)
{
objjson.code = "0";
objjson.count = 0;
- objjson.Message = "鑾峰彇澶辫触";
+ objjson.Message = "鑾峰彇鎴愬姛锛屾棤鏁版嵁";
objjson.data = null;
return objjson;
}
--
Gitblit v1.9.1