From e1dd681c82cdde2b21c35eb091fc992202d6d339 Mon Sep 17 00:00:00 2001 From: zrg <z18737863051@163.com> Date: 星期三, 31 七月 2024 14:04:03 +0800 Subject: [PATCH] 设备工艺参数趋势图,制程绩效趋势图(一次合格率) --- WebAPI/Controllers/CJGL/Cj_StationEntrustInBillController.cs | 92 ++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 92 insertions(+), 0 deletions(-) diff --git a/WebAPI/Controllers/CJGL/Cj_StationEntrustInBillController.cs b/WebAPI/Controllers/CJGL/Cj_StationEntrustInBillController.cs index a989769..2410e0d 100644 --- a/WebAPI/Controllers/CJGL/Cj_StationEntrustInBillController.cs +++ b/WebAPI/Controllers/CJGL/Cj_StationEntrustInBillController.cs @@ -174,12 +174,28 @@ entryid_PGD = arr[1]; } + //鎴彇鏉$爜绫诲瀷 鍓嶄袱浣� + string BillNoType1 = BillNo_PGD.Substring(0, Math.Min(2, BillNo_PGD.Length)); //鎴彇鏉$爜绫诲瀷 鍓嶄笁浣� string BillNoType = BillNo_PGD.Substring(0, Math.Min(3, BillNo_PGD.Length)); //鎴彇鏉$爜绫诲瀷2 鍓嶅洓浣� string BillNoType2 = BillNo_PGD.Substring(0, Math.Min(4, BillNo_PGD.Length)); //鎴彇鍐呯爜 string BillNo = BillNo_PGD.Substring(3, Math.Min(BillNo_PGD.Length - 3, BillNo_PGD.Length)); + switch (BillNoType1) + { + case "20"://娴佽浆鍗� + string sErr = ""; + if (oSystemParameter.ShowBill(ref sErr)) + { + if (oSystemParameter.omodel.WMS_CampanyName == "鏉窞鏂帿灏�") + { + ds = oCN.RunProcReturn("select top 1 * from h_v_Sc_ProcessExchangeBillList where 鍗曟嵁鍙�= '" + BillNo_PGD + "'", "h_v_Sc_ProcessExchangeBillList"); + } + } + break; + } + switch (BillNoType2) { case "GXLZ"://宸ュ簭娴佽浆娲惧伐 @@ -316,6 +332,82 @@ } #endregion + #region 宸ュ簭杩涚珯鎵厤浠剁爜 + [Route("Cj_StationBill/txtHBarCode_Mater_KeyDown")] + [HttpGet] + public object txtHBarCode_Mater_KeyDown(string HBarCode, string HInterID) + { + try + { + if (HBarCode == null || HBarCode.Equals("")) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "绌虹櫧鐮�,鏉″舰鐮佷笉鑳戒负绌猴紒"; + objJsonResult.data = null; + return objJsonResult; + } + + //鍒ゆ柇鏉″舰鐮佹槸鍚﹀湪鏉$爜妗f涓紝鍒ゆ柇鏉″舰鐮佹槸鍚﹀悎鐞� + //鍏堝垽鏂� 涓存椂琛ㄤ腑鏄惁鏈夋暟鎹紝鏉″舰鐮佺殑鐗╂枡鏄惁鍦ㄦ竻鍗曚腑锛屽啓鍏� 鎵爜璁板綍琛� + //寰楀埌淇℃伅 + ds = oCN.RunProcReturn("exec h_p_MES_StationInBillSub_BindBarCode " + HInterID.ToString() + " ,'" + HBarCode + "'", "h_p_MES_StationInBillSub_BindBarCode"); + //鍐欏叆淇℃伅 + if (ds == null || ds.Tables[0].Rows.Count == 0) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏈煡璇㈠埌鏉″舰鐮佷俊鎭紒"; + objJsonResult.data = null; + return objJsonResult; + } + else if (DBUtility.ClsPub.isLong(ds.Tables[0].Rows[0][0]) == 2) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "閿欒锛�" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0][1]); + objJsonResult.data = null; + return objJsonResult; + } + + + DataSet Dsplay = oCN.RunProcReturn("exec h_p_MES_StationInBillSub_BindDisplay " + HInterID.ToString() + " ", "h_p_MES_StationInBillSub_BindDisplay"); + + //鍐欏叆淇℃伅 + if (Dsplay == null) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍒锋柊澶辫触,鏃犳暟鎹樉绀猴紒"; + objJsonResult.data = null; + return objJsonResult; + } + else if (Dsplay.Tables[0].Rows.Count == 0) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏌ユ棤鏁版嵁!"; + objJsonResult.data = null; + return objJsonResult; + } + + objJsonResult.code = "1"; + objJsonResult.count = 1; + objJsonResult.Message = "缁戝畾鎴愬姛锛�"; + objJsonResult.data = null; + return objJsonResult; + } + catch (Exception e) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "Exception锛�" + e.ToString(); + objJsonResult.data = null; + return objJsonResult; + } + } + #endregion + #region 鎸囧紩鍗℃壂鐮佽幏鍙栦俊鎭� [Route("MES_SampleRecordBill_PDA/SampleRecordBillHBarCode_KeyDown")] [HttpGet] -- Gitblit v1.9.1