| | |
| | | |
| | | //è¥MAINDIéå¤åéæ°è·å |
| | | oCN.BeginTran(); |
| | | |
| | | DataSet ds1 = oCN.RunProcReturn("select * from h_v_Gy_PatrolCheckList where å·¡æ£é¡¹ç®ä»£ç = " + HNumber, "h_v_Gy_PatrolCheckList"); |
| | | if(ds1.Tables[0].Rows.Count > 0) |
| | | { |
| | | oCN.RollBack(); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "代ç éå¤ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | //ä¿ååæ§å¶========================================= |
| | | DataSet ds = oCN.RunProcReturn("Exec h_p_Gy_PatrolCheck_BeforeSaveCtrl " + msg3 + ",'1'", "h_p_Gy_PatrolCheck_BeforeSaveCtrl"); |
| | |
| | | //è¥MAINDIéå¤åéæ°è·å |
| | | oCN.BeginTran(); |
| | | |
| | | DataSet ds1 = oCN.RunProcReturn("select * from h_v_Gy_PatrolCheckList where å·¡æ£é¡¹ç®ä»£ç = " + HNumber, "h_v_Gy_PatrolCheckList"); |
| | | if(ds1.Tables[0].Rows.Count > 0) |
| | | { |
| | | oCN.RollBack(); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "代ç éå¤ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | //ä¿ååæ§å¶========================================= |
| | | DataSet ds = oCN.RunProcReturn("Exec h_p_Gy_PatrolCheck_BeforeSaveCtrl " + msg3 + ",'1'", "h_p_Gy_PatrolCheck_BeforeSaveCtrl"); |
| | | if (ds == null) |