| | |
| | | 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; |
| | |
| | | { |
| | | 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; |
| | |
| | | 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; |
| | |
| | | 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; |
| | | |
| | | |
| | | |
| | |
| | | ",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 + "'" + |
| | |
| | | "," + 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+"'"+ |
| | | ") "); |
| | | |
| | |
| | | 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; |
| | |
| | | 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; |
| | | |
| | | //若MAINDI重复则重新获取 |
| | | oCN.BeginTran(); |
| | |
| | | ",HMouldDotCheckRuleInterID="+ HMouldDotCheckRuleInterID.ToString()+ |
| | | ",HMouldMaintainRuleInterID=" + HMouldMaintainRuleInterID.ToString() + |
| | | ",HMouldOWNER='" + HMouldOWNER + "'" + |
| | | ",HNowSupID="+HNowSupID.ToString()+ |
| | | ",HNowSupTypeID="+HNowSupTypeID.ToString()+ |
| | | ",HProdWeight=" + HProdWeight.ToString() + |
| | | " where HInterID=" + HInterID.ToString()); |
| | | |
| | |
| | | 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; |
| | |
| | | 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; |