From d9bd374b84fe72bf99cac958d0f80117e5ba59db Mon Sep 17 00:00:00 2001
From: chenhaozhe <cgz@hz-kingdee.com>
Date: 星期二, 24 二月 2026 15:46:01 +0800
Subject: [PATCH] 华舟 添加 模具出库、首件、巡检、末检、取样 消息推送 锦隆 金蝶云 新增 添加字段
---
WebAPI/Controllers/CJGL/Cj_CheckBarcodeController.cs | 104 +++++++++++++++++++++++++++++++++++++++++++++------
1 files changed, 91 insertions(+), 13 deletions(-)
diff --git a/WebAPI/Controllers/CJGL/Cj_CheckBarcodeController.cs b/WebAPI/Controllers/CJGL/Cj_CheckBarcodeController.cs
index 66a42cd..e220215 100644
--- a/WebAPI/Controllers/CJGL/Cj_CheckBarcodeController.cs
+++ b/WebAPI/Controllers/CJGL/Cj_CheckBarcodeController.cs
@@ -22,7 +22,7 @@
#region 涓夌爜鍚堜竴锛屽垽鏂壂鎻忕墿鏂欐潯鐮佺粦瀹氫俊鎭槸鍚︿竴鑷�
[Route("CheckBarcodeController/Get_BarCode_BarcodeCheck")]
[HttpGet]
- public object CheckBarcode(string HBarCode_Pallet, string HBarCode_Destination, string HBarCode_MiddleBox, string HBarCode_SN, int HBarCodeType,int HInterID, string HBillNo,string HMaker,string HBillType)
+ public object CheckBarcode(string HBarCode_Pallet, string HBarCode_Destination, string HBarCode_MiddleBox, string HBarCode_SN, int HBarCodeType, int HInterID, string HBillNo, string HMaker, string HBillType)
{
try
{
@@ -68,7 +68,7 @@
[Route("CheckBarcodeController/Save_BarCode_BarcodeCheck")]
[HttpGet]
- public object Save_BarCode_BarcodeCheck(Int64 HInterID, string HBillNo,string HBillType)
+ public object Save_BarCode_BarcodeCheck(Int64 HInterID, string HBillNo, string HBillType)
{
try
{
@@ -76,7 +76,7 @@
DataSet ds = oCn.RunProcReturn("exec h_p_WMS_BarCodeBingCheckBill_Insert " + HInterID.ToString() + ",'" + HBillNo + "','" + HBillType + "'", "h_p_WMS_BarCodeBingCheckBill_Insert");
if (ds == null || ds.Tables[0].Rows.Count == 0)
- {
+ {
oCn.RollBack();
objJsonResult.code = "0";
@@ -126,14 +126,14 @@
#region 鎷嗙灏忓崼
[Route("CheckBarcodeController/UnpackMiddleBox")]
[HttpGet]
- public object UnpackMiddleBox(string HBarCode_Middle,int signal,string HMaker,string HDate)
+ public object UnpackMiddleBox(string HBarCode_Middle, int signal, string HMaker, string HDate)
{
try
{
- if(signal==1)//鎵爜
+ if (signal == 1)//鎵爜
{
DataSet ds = oCn.RunProcReturn("select a.HCaseCode 涓鐮�,a.HBarCode 瀵瑰簲鐨凷N鐮�,b.HNumber 鐗╂枡浠ｇ爜,b.HName 鐗╂枡鍚嶇О from Gy_CaseCodeRelation a left join Gy_Material b on a.HMaterID=b.HItemID where HCaseCode='" + HBarCode_Middle + "'", "Gy_CaseCodeRelation");
- if (ds.Tables[0].Rows[0]["涓鐮�"].ToString() =="" || ds == null)
+ if (ds.Tables[0].Rows[0]["涓鐮�"].ToString() == "" || ds == null)
{
objJsonResult.code = "0";
objJsonResult.count = 0;
@@ -148,16 +148,17 @@
return objJsonResult;
}
+
else
{
oCn.BeginTran();
- oCn.RunProc("delete from Gy_CaseCodeRelation where HCaseCode='"+ HBarCode_Middle+"'");
- DataSet dss = oCn.RunProcReturn("select * from Gy_BarCodeBill where HBarCode=' "+ HBarCode_Middle + "'", "Gy_BarCodeBill");
- if(dss!=null&&dss.Tables.Count>0)
+ oCn.RunProc("delete from Gy_CaseCodeRelation where HCaseCode='" + HBarCode_Middle + "'");
+ DataSet dss = oCn.RunProcReturn("select * from Gy_BarCodeBill where HBarCode=' " + HBarCode_Middle + "'", "Gy_BarCodeBill");
+ if (dss != null && dss.Tables.Count > 0)
{
- oCn.RunProc("delete from Gy_BarCodeBill where HBarCode='"+ HBarCode_Middle + "'");
+ oCn.RunProc("delete from Gy_BarCodeBill where HBarCode='" + HBarCode_Middle + "'");
}
- oCn.RunProc("insert into System_log VALUES('"+ HDate + "','"+HMaker+"','',"+ "'灏忓崼鎷嗙鏉＄爜"+ HBarCode_Middle + "',"+ "'APP-涓鐮佹媶绠�'"+",'',"+ "'鍒犻櫎鏉＄爜')");
+ oCn.RunProc("insert into System_log VALUES('" + HDate + "','" + HMaker + "',''," + "'灏忓崼鎷嗙鏉＄爜" + HBarCode_Middle + "'," + "'APP-涓鐮佹媶绠�'" + ",''," + "'鍒犻櫎鏉＄爜')");
oCn.Commit();
objJsonResult.code = "1";
objJsonResult.count = 1;
@@ -165,8 +166,8 @@
objJsonResult.data = null;
return objJsonResult;
}
-
-
+
+
}
catch (Exception)
{
@@ -179,5 +180,82 @@
}
#endregion
+ #region sn瑁呯灏忓崼
+ [Route("CheckBarcodeController/PackedBoxSn")]
+ [HttpGet]
+ public object PackedBoxSn(string HBarCode, string HMaker, string HDate)
+ {
+ try
+ {
+ DataSet ds = oCn.RunProcReturn("select a.HBarCode sn鐮�,a.HItemID,b.Hname 鐗╂枡鍚嶇О,b.hnumber 鐗╂枡浠ｇ爜 from Gy_BarCodeBill a LEFT JOIN Gy_Material b on a.hmaterid=b.hitemid where HBarCode='" + HBarCode + "'", "Gy_BarCodeBill");
+ if(ds.Tables[0].Rows.Count==0)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "璇n鐮佷笉瀛樺湪锛岃妫�鏌ワ紒锛�";
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ DataSet dss = oCn.RunProcReturn("select * from Gy_CaseCodeRelation where HBarCode='" + HBarCode + "'", "Gy_CaseCodeRelation");
+ int counts=dss.Tables[0].Rows.Count;
+ if (counts > 0)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "璇n鐮佸凡缁忚绠憋紝璇锋鏌ワ紒锛�";
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ objJsonResult.code = "1";
+ objJsonResult.count = 1;
+ objJsonResult.Message = "鎴愬姛";
+ objJsonResult.data = ds.Tables[0];
+ return objJsonResult;
+ }
+ catch (Exception e)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = e.ToString();
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ }
+ #endregion
+
+
+ #region sn瑁呯灏忓崼鎻愪氦
+ [Route("CheckBarcodeController/submitPackedBoxSn")]
+ [HttpGet]
+ public object submitPackedBoxSn(string HItemIDs, string HMaker, string HDate)
+ {
+ try
+ {
+ DataSet ds = oCn.RunProcReturn("exec h_p_Gy_CaseCodeBySN '"+ HItemIDs+ "'", "h_p_Gy_CaseCodeBySN");
+ if (ds.Tables[0].Rows[0]["HBack"] == "2")
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "涓鐮佸凡瀛樺湪璇烽噸鏂扮敓鎴�";
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+
+ objJsonResult.code = "1";
+ objJsonResult.count = 1;
+ objJsonResult.Message = "鎴愬姛";
+ objJsonResult.data = ds.Tables[0];
+ return objJsonResult;
+ }
+ catch (Exception e)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = e.ToString();
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ }
+ #endregion
}
}
\ No newline at end of file
--
Gitblit v1.9.1