From 63610047f4921b0bdcb0042f54c5197b62746446 Mon Sep 17 00:00:00 2001 From: duhe <226547893@qq.com> Date: 星期二, 15 八月 2023 14:28:42 +0800 Subject: [PATCH] 异常工时申请单:添加子表重复校验,子表做颜色区分,子表单元格根据宽度隐藏内容,取消分页,添加合计行,根据职员带出工作中,取消上一行下一行 --- WebAPI/Controllers/LMESController.cs | 184 +++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 183 insertions(+), 1 deletions(-) diff --git a/WebAPI/Controllers/LMESController.cs b/WebAPI/Controllers/LMESController.cs index e4ae870..6b74fad 100644 --- a/WebAPI/Controllers/LMESController.cs +++ b/WebAPI/Controllers/LMESController.cs @@ -428,12 +428,79 @@ { string sql1 = "select * from h_v_Gy_RoutingBillList where 1 = 1 "; //瀹㈡埛鑷畾涔� - if (oSystemParameter.omodel.WMS_CampanyName == "鐟炰笌绁�") + if (oSystemParameter.omodel.WMS_CampanyName == "鐟炰笌绁�" || oSystemParameter.omodel.WMS_CampanyName == "鍑礉濂堢壒") { sql1 = "select top 1000 * from h_v_Gy_RoutingBillList where 1 = 1 "; } string sql = sql1 + sWhere + " order by hmainid desc,cast(宸ュ簭鍙� as int)"; ds = oCN.RunProcReturn(sql, "h_v_Gy_RoutingBillList"); + } + } + catch (Exception e) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "娌℃湁杩斿洖浠讳綍璁板綍锛�" + e.ToString(); + objJsonResult.data = null; + return objJsonResult; + } + return GetObjectJson(ds); + } + + #endregion + + #region 宸ヨ壓璺嚎鍘嗗彶鍒楄〃 + /// <summary> + /// 杩斿洖宸ヨ壓璺嚎鍘嗗彶鍒楄〃 + ///鍙傛暟锛歴tring sql銆� + ///杩斿洖鍊硷細object銆� + /// </summary> + [Route("LEMS/MES_Gy_RoutingBillList_His")] + [HttpGet] + public object MES_Gy_RoutingBillList_His(string sWhere, string user) + { + DataSet ds; + try + { + //鍒ゆ柇鏄惁鏈夋煡璇㈡潈闄� + if (!DBUtility.ClsPub.Security_Log("Gy_RoutingBill_Query", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犳潈闄愭煡璇�!"; + objJsonResult.data = null; + return objJsonResult; + } + + //鑾峰彇绯荤粺鍙傛暟 + string Ret = ""; + if (oSystemParameter.ShowBill(ref Ret)) + { + //鍒ゆ柇瀹㈡埛涓洪緳灞辨苯閰� + if (oSystemParameter.omodel.WMS_CampanyName == "榫欏北姹介厤") + { + //鑾峰彇闇�瑕佹嫾鎺ョ殑瀛楃涓� + string sql_splice = DBUtility.ClsPub.SpliceSQL(user, "宸ヨ壓璺嚎鍒楄〃"); + + sWhere += sql_splice; + } + } + + SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); + if (sWhere == null || sWhere.Equals("")) + { + ds = oCN.RunProcReturn("select * from h_v_Gy_RoutingBillList_His where 1 = 1" + sWhere + " order by hmainid desc", "h_v_Gy_RoutingBillList"); + } + else + { + string sql1 = "select * from h_v_Gy_RoutingBillList_His where 1 = 1 "; + //瀹㈡埛鑷畾涔� + if (oSystemParameter.omodel.WMS_CampanyName == "鐟炰笌绁�"|| oSystemParameter.omodel.WMS_CampanyName == "鍑礉濂堢壒") + { + sql1 = "select top 1000 * from h_v_Gy_RoutingBillList_His where 1 = 1 "; + } + string sql = sql1 + sWhere + " order by hmainid desc,cast(宸ュ簭鍙� as int)"; + ds = oCN.RunProcReturn(sql, "h_v_Gy_RoutingBillList_His"); } } catch (Exception e) @@ -801,6 +868,121 @@ return GetObjectJson(ds); } + #region 瀹㈡埛璁㈠崟 鐢熶骇璁㈠崟瀹屽伐 + [Route("LEMS/sc_ICOMReportClose")] + [HttpPost] + public object sc_ICOMReportClose([FromBody] JObject sMainSub) + { + DataSet ds; + try + { + var _value = sMainSub["sMainSub"].ToString(); + string[] sArray = _value.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); + string HICOMBillNoNum = sArray[0].ToString(); + string user = sArray[1].ToString(); + + //鍒ゆ柇鏄惁鏈夋煡璇㈡潈闄� + if (!DBUtility.ClsPub.Security_Log("Sc_ICMOBill_Edit", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犳潈闄愭煡璇�!"; + objJsonResult.data = null; + return objJsonResult; + } + var HICOMBillNo = HICOMBillNoNum.Split(','); + + oCN.BeginTran(); + for (int i = 0; i < HICOMBillNo.Length; i++) + { + ds = oCN.RunProcReturn("select * from Sc_ICMOBillMain where HBillNo='" + HICOMBillNo[i] + "'", "Sc_ICMOBillMain"); + if (ds.Tables[0].Rows.Count == 0) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏌ユ棤鏁版嵁锛�"; + objJsonResult.data = null; + return objJsonResult; + } + oCN.RunProc("update Sc_ICMOBillSub set HSTATUS=5 where HInterID=" + ds.Tables[0].Rows[0]["HInterID"].ToString()); + } + oCN.Commit(); + + objJsonResult.code = "1"; + objJsonResult.count = 1; + objJsonResult.Message = "鎴愬姛瀹屽伐璁㈠崟!"; + objJsonResult.data = null; + return objJsonResult; + } + catch (Exception e) + { + oCN.RollBack(); + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "娌℃湁杩斿洖浠讳綍璁板綍锛�" + e.ToString(); + objJsonResult.data = null; + return objJsonResult; + } + } + #endregion + + #region 瀹㈡埛璁㈠崟 鐢熶骇璁㈠崟娣诲姞澶囨敞 + [Route("LEMS/sc_ICOMReportAddHRemark")] + [HttpPost] + public object sc_ICOMReportAddHRemark([FromBody] JObject sMainSub) + { + DataSet ds; + try + { + var _value = sMainSub["sMainSub"].ToString(); + string[] sArray = _value.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); + string HICOMBillNo = sArray[0].ToString(); + string HRemark = sArray[1].ToString(); + string user = sArray[2].ToString(); + + //鍒ゆ柇鏄惁鏈夋煡璇㈡潈闄� + if (!DBUtility.ClsPub.Security_Log("Sc_ICMOBill_Edit", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犳潈闄愭煡璇�!"; + objJsonResult.data = null; + return objJsonResult; + } + + oCN.BeginTran(); + + ds = oCN.RunProcReturn("select * from Sc_ICMOBillMain where HBillNo='" + HICOMBillNo + "'", "Sc_ICMOBillMain"); + if (ds.Tables[0].Rows.Count == 0) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏌ユ棤鏁版嵁锛�"; + objJsonResult.data = null; + return objJsonResult; + } + oCN.RunProc("update Sc_ICMOBillMain set HRemark2='" + HRemark + "' where HBillNo='" + HICOMBillNo + "'"); + + oCN.Commit(); + + objJsonResult.code = "1"; + objJsonResult.count = 1; + objJsonResult.Message = "淇濆瓨鎴愬姛!"; + objJsonResult.data = null; + return objJsonResult; + } + catch (Exception e) + { + oCN.RollBack(); + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "娌℃湁杩斿洖浠讳綍璁板綍锛�" + e.ToString(); + objJsonResult.data = null; + return objJsonResult; + } + } + #endregion + #region 鍒ゆ柇涓嬫帹鐨勭敓浜ц鍗曟槸鍚﹀鏍� [Route("LEMS/ICMOBillCheck")] [HttpGet] -- Gitblit v1.9.1