From ec69ec14439c3d79dc951a093bb5b698ff424a40 Mon Sep 17 00:00:00 2001 From: wtt <1985833171@qq.com> Date: 星期一, 28 十月 2024 13:41:31 +0800 Subject: [PATCH] 添康工资车间报表添加,异常工时申请单修改 --- WebAPI/Controllers/CJGL/Sc_WorkBeginDotCheckBillController.cs | 40 ++++++++++++++++++++++++++++++++++++++++ 1 files changed, 40 insertions(+), 0 deletions(-) diff --git a/WebAPI/Controllers/CJGL/Sc_WorkBeginDotCheckBillController.cs b/WebAPI/Controllers/CJGL/Sc_WorkBeginDotCheckBillController.cs index d1bcb5d..f4b7e03 100644 --- a/WebAPI/Controllers/CJGL/Sc_WorkBeginDotCheckBillController.cs +++ b/WebAPI/Controllers/CJGL/Sc_WorkBeginDotCheckBillController.cs @@ -318,6 +318,7 @@ oCN.BeginTran(); oCN.RunProc("delete from Sc_WorkBeginDotCheckBillMain where HInterID = " + HInterID); + oCN.RunProc("delete from Sc_WorkBeginDotCheckBillSub where HInterID = " + HInterID); oCN.Commit(); @@ -824,6 +825,44 @@ } #endregion + #region 鏍规嵁鐢熶骇璧勬簮鑾峰彇鏈�鏂扮殑妯″叿 + [Route("Sc_WorkBeginDotCheckBill/锘縎c_WorkBeginDotCheckBill_HMould")] + [HttpGet] + public object Sc_WorkBeginDotCheckBill_HMould(string HSourceID, string User) + { + try + { + List<DataTable> tableList = new List<DataTable>(); + + //鏌ョ湅鏉冮檺 + if (!DBUtility.ClsPub.Security_Log("Sc_WorkBeginDotCheckBillMain_Edit", 1, false, User)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏌ヨ澶辫触!"; + objJsonResult.data = null; + return objJsonResult; + } + + ds = oCN.RunProcReturn("select top 1 a.*,b.HName 妯″叿鍚嶇О from Sc_MouldUpperBillSub a left join Gy_MouldFileMain b on a.HMouldID=b.HInterID where a.HSourceID='" + HSourceID + "'order by HScanDate desc", "Sc_MouldUpperBillSub"); + + 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 = "Exception锛�" + e.ToString(); + objJsonResult.data = null; + return objJsonResult; + } + } + #endregion + #region 璁惧鍚姩鐐规娓呭崟鍒楄〃 鏌ヨ [Route("Sc_WorkBeginDotCheckBill/getGy_WorkBeginDotCheckListBillMainList")] [HttpGet] @@ -1117,6 +1156,7 @@ oCN.BeginTran(); oCN.RunProc("delete from Gy_WorkBeginDotCheckListBillMain where HInterID = " + HInterID); + oCN.RunProc("delete from Gy_WorkBeginDotCheckListBillSub where HInterID = " + HInterID); oCN.Commit(); -- Gitblit v1.9.1