From 25849768b45e51a2f5ac0bd4df7bb98b24da9cd7 Mon Sep 17 00:00:00 2001 From: 杨乐 <yang.le.192@qq.com> Date: 星期一, 07 二月 2022 17:18:22 +0800 Subject: [PATCH] 工序管理 --- WebAPI/Controllers/BaseSet/Gy_MaterialController.cs | 35 +++++++++++++++++++++++++---------- 1 files changed, 25 insertions(+), 10 deletions(-) diff --git a/WebAPI/Controllers/BaseSet/Gy_MaterialController.cs b/WebAPI/Controllers/BaseSet/Gy_MaterialController.cs index 0c3a0cc..d1a9256 100644 --- a/WebAPI/Controllers/BaseSet/Gy_MaterialController.cs +++ b/WebAPI/Controllers/BaseSet/Gy_MaterialController.cs @@ -283,7 +283,7 @@ try { //鍒犻櫎鏉冮檺 - //if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 1, true, CurUserName)) + //if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 1, false, CurUserName)) //{ // objJsonResult.code = "0"; // objJsonResult.count = 0; @@ -353,7 +353,7 @@ { try { - if (!DBUtility.ClsPub.Security_Log(ModRightNameSelect, 1, true, user)) + if (!DBUtility.ClsPub.Security_Log(ModRightNameSelect, 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; @@ -457,10 +457,20 @@ /// </summary> [Route("Gy_BarCodeBillList/GetBarCodeBillList")] [HttpGet] - public object GetBarCodeBillList(string sWhere) + public object GetBarCodeBillList(string sWhere,string user) { try { + //鍒ゆ柇鏄惁鏈夋煡璇㈡潈闄� + if (!DBUtility.ClsPub.Security_Log("Gy_BarCodeBill_Query", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犳潈闄愭煡璇�!"; + objJsonResult.data = null; + return objJsonResult; + } + if (sWhere == null || sWhere.Equals("")) { ds = oCN.RunProcReturn("select * from h_v_IF_BarCodeBillList " + sWhere + "order by 鏃ユ湡 desc", "h_v_IF_BarCodeBillList"); @@ -517,7 +527,7 @@ string msg4 = sArray[2].ToString();//褰撳墠浜� oCN.BeginTran(); - if (!DBUtility.ClsPub.Security_Log(msg3, 1, true, msg4)) + if (!DBUtility.ClsPub.Security_Log(msg3, 1, false, msg4)) { objJsonResult.code = "0"; objJsonResult.count = 0; @@ -594,6 +604,8 @@ int HCaveQty = mainList[0].HCaveQty; int HMouldDotCheckRuleInterID= mainList[0].HMouldDotCheckRuleInterID; int HMouldMaintainRuleInterID= mainList[0].HMouldMaintainRuleInterID; + int HNowSupID = mainList[0].HNowSupID; + int HNowSupTypeID = mainList[0].HNowSupTypeID; @@ -606,7 +618,7 @@ ",HMaterID,HMaterNumber,HMouldType,HUnitID" + ",HOutComDate,HOutComNo,HDeptID,HSupID,HSupNumber" + ",HPrintQty,HMouldStatus,HWhID,HRoutingID,HCaveQty" + - ",HBomID,HVersion,HSPGroupID,HSPID,HDesignLife" + + ",HBomID,HVersion,HSPGroupID,HSPID,HDesignLife,HNowSupID,HNowSupTypeID" + ",HUseLife,HLeaveLife,HProdQty,HProdWeight,HMouldOWNER,HSaveLife,HMouldDotCheckRuleInterID,HMouldMaintainRuleInterID" + ") " + " values('" + BillType + "','" + BillType + "'," + HInterID + ",'" + HBillNo + "','" + HDate + "'" + @@ -616,7 +628,7 @@ "," + HMaterID + ",'" + HMaterNumber + "'," + HMouleTypeID + "," + HUnitID + ",'" + HOutComDate + "','" + HOutComNo + "'," + HDeptID + "," + HSupID + ",'" + HSupNumber + "'" + "," + HPrintQty + ",'" + HMouldStatus + "'," + HWHID + "," + HRoutingID +","+ HCaveQty+ - "," + HBOMID + ",'" + HVersion + "'," + HSPGroupID + "," + HSPID + ",'" + HDesignLife + "'" + + "," + HBOMID + ",'" + HVersion + "'," + HSPGroupID + "," + HSPID + ",'" + HDesignLife + "','" + HNowSupID+"','"+ HNowSupTypeID+"'"+ ",'" + HUseLife + "','" + HLeaveLife + "','" + HProdQty + "','" + HProdWeight + "','" + HMouldOWNER + "','" + HSaveLife + "','" + HMouldDotCheckRuleInterID+"','"+ HMouldMaintainRuleInterID+"'"+ ") "); @@ -673,7 +685,7 @@ string msg4 = sArray[2].ToString();//褰撳墠浜� try { - if (!DBUtility.ClsPub.Security_Log(msg3, 1, true, msg4)) + if (!DBUtility.ClsPub.Security_Log(msg3, 1, false, msg4)) { objJsonResult.code = "0"; objJsonResult.count = 0; @@ -732,7 +744,8 @@ int HCaveQty = mainList[0].HCaveQty; int HMouldDotCheckRuleInterID = mainList[0].HMouldDotCheckRuleInterID; int HMouldMaintainRuleInterID = mainList[0].HMouldMaintainRuleInterID; - + int HNowSupID = mainList[0].HNowSupID; + int HNowSupTypeID = mainList[0].HNowSupTypeID; //鑻AINDI閲嶅鍒欓噸鏂拌幏鍙� oCN.BeginTran(); @@ -781,6 +794,8 @@ ",HMouldDotCheckRuleInterID="+ HMouldDotCheckRuleInterID.ToString()+ ",HMouldMaintainRuleInterID=" + HMouldMaintainRuleInterID.ToString() + ",HMouldOWNER='" + HMouldOWNER + "'" + + ",HNowSupID="+HNowSupID.ToString()+ + ",HNowSupTypeID="+HNowSupTypeID.ToString()+ ",HProdWeight=" + HProdWeight.ToString() + " where HInterID=" + HInterID.ToString()); @@ -850,7 +865,7 @@ DAL.ClsGy_MouldFile oBill = new DAL.ClsGy_MouldFile(); try { - if (!DBUtility.ClsPub.Security_Log(ModRightNameDelete, 1, true, user)) + if (!DBUtility.ClsPub.Security_Log(ModRightNameDelete, 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; @@ -967,7 +982,7 @@ try { //瀹℃牳鏉冮檺 - if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 1, true, CurUserName)) + if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 1, false, CurUserName)) { objJsonResult.code = "0"; objJsonResult.count = 0; -- Gitblit v1.9.1