| | |
| | | { |
| | | try |
| | | { |
| | | ds = oCN.RunProcReturn("select * from Gy_DotCheck where HItemID=" + HInterID, "Gy_DotCheck"); |
| | | ds = oCN.RunProcReturn("select * from h_v_Gy_DotCheck_Edit where HItemID=" + HInterID, "h_v_Gy_DotCheck_Edit"); |
| | | |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | |
| | | string HRemark = list[0].HRemark; |
| | | bool HStopflag = list[0].HStopflag; |
| | | string HUseFlag = list[0].HUseFlag; |
| | | Int64 HDotCheckItemClassID = list[0].HDotCheckItemClassID; |
| | | |
| | | //夿æé |
| | | if (!ClsPub.Security_Log("Gy_DotCheck_Edit", 1, false, msg3)) |
| | |
| | | ",HShortNumber='" + HShortNumber + "'" + |
| | | ",HHelpCode='" + HHelpCode + "'" + |
| | | ",HStopflag='" + HStopflag + "'" + |
| | | ",HDotCheckItemClassID=" + HDotCheckItemClassID + |
| | | ",HRemark= '" + HRemark + "' Where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | //ä¿®æ¹å项ç®ä»£ç |
| | | //oCN.RunProc("exec h_p_Gy_UpdateNumber Gy_RepairCheck,'" + HNumber + ".','" + this.HOldNumber + ".'", ref DBUtility.ClsPub.sExeReturnInfo); |
| | |
| | | bool HStopflag = list[0].HStopflag; |
| | | string HUseFlag = list[0].HUseFlag; |
| | | bool HEndFlag = list[0].HEndFlag; |
| | | |
| | | Int64 HDotCheckItemClassID = list[0].HDotCheckItemClassID; |
| | | //夿æé |
| | | if (!ClsPub.Security_Log("Gy_DotCheck_Edit", 1, false, msg3)) |
| | | { |
| | |
| | | //主表 |
| | | oCN.RunProc("Insert into Gy_DotCheck " + |
| | | " (HNumber,HName,HHelpCode,HShortNumber" + |
| | | ",HLevel,HEndFlag,HStopflag,HRemark,HParentID) " + |
| | | ",HLevel,HEndFlag,HStopflag,HRemark,HParentID,HDotCheckItemClassID ) " + |
| | | " Values('" + HNumber + "','" + HName + "','" + HHelpCode + "','" + HShortNumber + "'," + |
| | | +HLevel + ",1," + Convert.ToString(HStopflag ? 1 : 0) + ",'" + HRemark + "',0)", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | +HLevel + ",1," + Convert.ToString(HStopflag ? 1 : 0) + ",'" + HRemark + "',0," + HDotCheckItemClassID + ")", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | //ä¿®æ¹ä¸çº§ä¸ºéæ«çº§ä»£ç |
| | | //oCN.RunProc("Update Gy_MouldType set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | oCN.Commit(); |