From 0ee98ee44a38178214d7bf14b93cec104d2b92c5 Mon Sep 17 00:00:00 2001
From: yusijie <ysj@hz-kingdee.com>
Date: 星期四, 09 三月 2023 14:59:39 +0800
Subject: [PATCH] 工序进出站,工序派工,发货通知单审核插件

---
 WebAPI/Controllers/CJGL/Cj_StationEntrustInBillController.cs |  129 +++++++++++++++++++++++++++++++++++++++++-
 1 files changed, 125 insertions(+), 4 deletions(-)

diff --git a/WebAPI/Controllers/CJGL/Cj_StationEntrustInBillController.cs b/WebAPI/Controllers/CJGL/Cj_StationEntrustInBillController.cs
index 9f2f099..ade9d19 100644
--- a/WebAPI/Controllers/CJGL/Cj_StationEntrustInBillController.cs
+++ b/WebAPI/Controllers/CJGL/Cj_StationEntrustInBillController.cs
@@ -141,10 +141,131 @@
         }
         #endregion
 
+        #region 濮斿宸ュ簭鍙戝嚭鍗曟祦姘村彿鍥炶溅鑾峰彇鏉$爜淇℃伅2锛堝澶栧伐搴忔帴鏀躲�佸伐搴忚繘绔欐帴鏀堕�氱敤锛�
+        [Route("Cj_StationBill/txtHBarCode_KeyDown2")]
+        [HttpGet]
+        public object txtHBarCode_KeyDown2(string HBarCode,string HInterID,string UserID)
+        {
+            try
+            {
+                if (HBarCode == null || HBarCode.Equals(""))
+                {
+                    objJsonResult.code = "0";
+                    objJsonResult.count = 0;
+                    objJsonResult.Message = "绌虹櫧鐮�,鏉″舰鐮佷笉鑳戒负绌猴紒";
+                    objJsonResult.data = null;
+                    return objJsonResult;
+                }
+                //鎷嗗垎鏉″舰鐮�
+                string sBillBarCode = HBarCode.Trim();
+                string[] NewBarCode;
+                if (sBillBarCode.CompareTo("#") > 0)
+                {
+                    NewBarCode = sBillBarCode.Split(Convert.ToChar("#"));
+                    sBillBarCode = NewBarCode[0];
+                }
+                string sBillNo = sBillBarCode;
+                //鎴彇鏉$爜绫诲瀷
+                string BillNoType = sBillNo.Substring(0, Math.Min(3, sBillNo.Length));
+                //鎴彇鍐呯爜
+                string BillNo = sBillNo.Substring(3, Math.Min(sBillNo.Length - 3,sBillNo.Length));
+
+                switch (BillNoType)
+                //寰楀埌淇℃伅
+                {
+                    case "HCX"://鐢熶骇璧勬簮鐮�
+                        ds = oCN.RunProcReturn("select * from h_v_Gy_SourceList  where 鏉$爜缂栧彿 = '" + BillNo + "'", "h_v_Gy_SourceList");
+                        break;
+                    case "SBM"://璁惧鐮�
+                        ds = oCN.RunProcReturn("select * from h_v_Gy_EquipMentList  where HItemID = '" + BillNo + "'", "h_v_Gy_EquipMentList");
+                        break;
+                    case "JYM"://鍛樺伐鐮�
+                        ds = oCN.RunProcReturn("select * from h_v_Gy_StaffList  where HItemID = '" + BillNo + "'", "h_v_Gy_StaffList");
+                        break;
+                    case "GRM"://鍛樺伐鐮�
+                        ds = oCN.RunProcReturn("select * from h_v_Gy_StaffList  where HItemID = '" + BillNo + "'", "h_v_Gy_StaffList");
+                        break;
+                    case "CGM"://鍛樺伐鐮�
+                        ds = oCN.RunProcReturn("select * from h_v_Gy_StaffList  where HItemID = '" + BillNo + "'", "h_v_Gy_StaffList");
+                        break;
+                    case "HWH"://浠撳簱鐮�
+                        ds = oCN.RunProcReturn("select * from h_v_Gy_WareHouseList  where 鏉$爜缂栧彿 = '" + HBarCode + "'", "h_v_Gy_WareHouseList");
+                        break;
+                    case "HSP"://浠撲綅鐮�
+                        ds = oCN.RunProcReturn("select * from h_v_Gy_StockPlaceList  where 鏉$爜缂栧彿 = '" + HBarCode + "'", "h_v_Gy_StockPlaceList");
+                        break;
+                    case "WKM"://宸ヤ綔涓績鐮�
+                        ds = oCN.RunProcReturn("select * from h_v_Gy_WorkCenterList  where HItemID = '" + BillNo + "'", "h_v_Gy_WorkCenterList");
+                        break;
+                    case "BZM"://鐝粍鐮�
+                        ds = oCN.RunProcReturn("select * from h_v_Gy_GroupList  where 鏉$爜缂栧彿 = '" + BillNo + "'", "h_v_Gy_GroupList");
+                        break;
+                    case "PRO"://宸ュ簭鐮�
+                        string sReturn = "";
+                        if (oSystemParameter.ShowBill(ref sReturn) == true)
+                        {
+                            //绯荤粺鍙傛暟鏄惁涓哄彧鏄剧ず褰撳墠鐧诲綍鐢ㄦ埛鍏宠仈鐨勫伐搴忎俊鎭�,N涓哄惁锛孻涓烘槸
+                            if (oSystemParameter.omodel.MES_StationBill_ProcNoByUser == "Y")
+                            {
+                                ds = oCN.RunProcReturn("select * from h_v_Gy_ProcessList_GetProcNoByUser  where HItemID = '" + BillNo + "' and HInterID = '" + HInterID + "' and 鐢ㄦ埛缂栫爜 = '" + UserID + "'", "h_v_Gy_ProcessList_GetProcNoByUser");
+                            }
+                            else
+                            {
+                                ds = oCN.RunProcReturn("select * from h_v_Gy_ProcessList_GetProcNo  where HItemID = '" + BillNo + "' and HInterID = '" + 
+                                  HInterID + "'", "h_v_Gy_ProcessList_GetProcNo");
+                            }
+                        }
+                        break;
+                    case "WLM"://鐗╂枡鐮�
+                        ds = oCN.RunProcReturn("select * from h_v_Gy_MaterialList  where HItemID = '" + BillNo + "'", "h_v_Gy_MaterialList");
+                        break;
+                    case "GXL"://娴佽浆鍗�
+                        ds = oCN.RunProcReturn("select top 1 * from h_v_Sc_ProcessExchangeBillList  where 鍗曟嵁鍙�= '" + sBillNo + "'", "h_v_Sc_ProcessExchangeBillList");
+                        break;
+                }
+
+                //鍐欏叆淇℃伅
+                if (ds == null || ds.Tables[0].Rows.Count == 0)
+                {
+                    objJsonResult.code = "0";
+                    objJsonResult.count = 0;
+                    objJsonResult.Message = "鏈煡璇㈠埌鏉$爜淇℃伅锛�";
+                    objJsonResult.data = null;
+                    if(BillNoType == "PRO")
+                    {
+                        ds = oCN.RunProcReturn("select * from h_v_Gy_ProcessList where HItemID = '" + BillNo + "'", "h_v_Gy_ProcessList");
+                        if (ds == null || ds.Tables[0].Rows.Count == 0)
+                        {
+                            objJsonResult.Message = "鏈煡璇㈠埌鏉$爜淇℃伅锛�";
+                        }
+                        else
+                        {
+                            objJsonResult.Message = "鐢ㄦ埛鏈叧鑱旂浉鍏冲伐搴忔垨娴佽浆鍗℃棤姝ゅ伐搴忥紝濡傛湁闇�瑕佽缁存姢";
+                        }
+                    }
+                    return objJsonResult;
+                }
+                objJsonResult.code = "1";
+                objJsonResult.count = 1;
+                objJsonResult.Message = "Sucess锛�";
+                objJsonResult.data = ds.Tables[0];
+                return objJsonResult;
+            }
+            catch (Exception e)
+            {
+                objJsonResult.code = "0";
+                objJsonResult.count = 0;
+                objJsonResult.Message = "Exception锛�" + e.ToString();
+                objJsonResult.data = null;
+                return objJsonResult;
+            }
+        }
+        #endregion
+
         #region 鏍规嵁鐧诲綍鐢ㄦ埛鑾峰彇宸ュ簭
         [Route("Sc_StationInBill/autoGetProcNo")]
         [HttpGet]
-        public object autoGetProcNo(string HUserName,string HInterID)
+        public object autoGetProcNo(string HUserID, string HInterID)
         {
             string sReturn = "";
             if (oSystemParameter.ShowBill(ref sReturn) == true)
@@ -154,16 +275,16 @@
                 {
                     try
                     {
-                        if (HUserName == null || HUserName.Equals(""))
+                        if (HUserID == null || HUserID.Equals(""))
                         {
                             objJsonResult.code = "0";
                             objJsonResult.count = 0;
-                            objJsonResult.Message = "鐢ㄦ埛鍚嶄笉鑳戒负绌猴紒";
+                            objJsonResult.Message = "鐢ㄦ埛缂栫爜涓嶈兘涓虹┖锛�";
                             objJsonResult.data = null;
                             return objJsonResult;
                         }
                         //寰楀埌淇℃伅
-                        ds = oCN.RunProcReturn("select  * from h_v_Sc_StationBill_autoGetProcNo  where HInterID = '" + HInterID + "' and 鐢ㄦ埛鍚嶇О ='" + HUserName + "'", "h_v_Sc_StationBill_autoGetProcNo");
+                        ds = oCN.RunProcReturn("select  * from h_v_Sc_StationBill_autoGetProcNo  where HInterID = '" + HInterID + "' and 鐢ㄦ埛缂栫爜 ='" + HUserID + "'", "h_v_Sc_StationBill_autoGetProcNo");
                         //鍐欏叆淇℃伅
                         if (ds == null || ds.Tables[0].Rows.Count == 0)
                         {

--
Gitblit v1.9.1