/// <summary> /// 功能描述:数据插入到临时表 /// 创建 人:周文卿 /// 创建时间:2017/07/12 /// </summary> /// <param name="inputdata">插入的实体类</param> /// <returns>json(是否成功)</returns> public HttpResponseMessage ItemSave(List<tbleqiw_r_table> inputdata) { string returntext = ""; try { Regex regexvalue = new Regex(@"^(\d*\.?\d+)+$"); Regex regexvalue2 = new Regex(@"^(\d*\.?\d+)?[lL]$"); //赋值点位时间信息 List<tblEQIW_R_Basedata_Pre> lstData = new List<tblEQIW_R_Basedata_Pre>(); tblEQIW_R_Basedata_Pre objData = new tblEQIW_R_Basedata_Pre(); List<tblEQIW_D_Basedata_Pre> lstDataD = new List<tblEQIW_D_Basedata_Pre>(); for (int i = 0; i < inputdata.Count; i++) { List<tbaeqiw_r_value> valueall = inputdata[i].valueall; for (int j = 0; j < valueall.Count; j++) { objData.fldSTCode = valueall[j].fldSTCode; objData.fldRSC = inputdata[i].fldRSC; objData.fldUserID = int.Parse(inputdata[i].fldUserID); objData.fldFlag = 0; objData.fldCityID_Operate = int.Parse(inputdata[i].fldCityID_Operate); objData.fldCityID_Submit = inputdata[i].fldCityID_Submit; objData.fldDate_Operate = DateTime.Now; decimal dValue = -1; string samphvalue = valueall[j].monitorvalue; #region 修改监测值 if (samphvalue != "") { if (regexvalue2.IsMatch(samphvalue)) { if (samphvalue.ToLower() == "l") { decimal temp = Convert.ToDecimal(valueall[j].monitorvalue); if (temp <= 0) { returntext = rule.JsonStr("error", "项目的检出限<=0,不能输入 L 作为监测值", ""); return new HttpResponseMessage { Content = new StringContent(returntext, System.Text.Encoding.UTF8, "application/json") }; } dValue = -temp; } else { dValue = -Convert.ToDecimal(samphvalue.Replace("l", "").Replace("L", "")); } if (dValue == -1) { dValue = Convert.ToDecimal(-0.99999999); } } else { dValue = Convert.ToDecimal(samphvalue); } } #endregion tblEQIW_R_Basedata_Pre objTmp = objData.Clone(); DateTime time = DateTime.Parse(valueall[j].fldDate.ToString()); objTmp.fldYear = time.Year; objTmp.fldMonth = time.Month; objTmp.fldDay = time.Day; objTmp.fldHour = 0; objTmp.fldMinute = 0; objTmp.fldSAMPH = "1"; objTmp.fldRCode = valueall[j].fldRCode; objTmp.fldRSCode = valueall[j].fldRSCode; objTmp.fldSAMPR = "1"; objTmp.fldItemCode = inputdata[i].itemcode; objTmp.fldItemValue = dValue; lstData.Add(objTmp); } } RuletblEQIW_R_Basedata_Pre rule_basedata = new RuletblEQIW_R_Basedata_Pre(); bool issave = rule_basedata.InsertAll(lstData); if (issave) { RuleWriteOperateLog rule_wol = new RuleWriteOperateLog(); rule_wol.WriteLog(0, "录入河流数据到临时表", "", int.Parse(inputdata[0].fldUserID), int.Parse(inputdata[0].fldCityID_Operate)); returntext = rule.JsonStr("ok", "录入成功!您保存的数据,已进入“待提交审核的数据”状态", ""); } else { returntext = rule.JsonStr("error", "保存数据失败!请重试!", ""); } } catch (InputException ex) { returntext = rule.JsonStr("error", ex.Message, ""); } catch (InsertException ex) { returntext = rule.JsonStr("error", ex.Message, ""); } catch (Exception ex) { returntext = rule.JsonStr("error", ex.Message, ""); } return new HttpResponseMessage { Content = new StringContent(returntext, System.Text.Encoding.UTF8, "application/json") }; }
// public HttpResponseMessage ItemSave(eqia_rsavedata itemvalue) { string result = string.Empty; if (itemvalue.fldUserID == null || itemvalue.fldUserName == null) { itemvalue.fldUserID = rule.ConductUserinfo(itemvalue.fldUserID); itemvalue.fldUserName = ""; } try { if (itemvalue.BeginDate != null && itemvalue.EndDate != null) { if (itemvalue.fldSTCode != null) { if (itemvalue.fldRCode != null) { if (itemvalue.fldRSCode != null) { if (itemvalue.fldItemData.Count > 0) { List <tblEQIW_R_Basedata_Pre> lstData = new List <tblEQIW_R_Basedata_Pre>(); tblEQIW_R_Basedata_Pre objData = new tblEQIW_R_Basedata_Pre(); List <tblEQIW_D_Basedata_Pre> lstDataD = new List <tblEQIW_D_Basedata_Pre>(); tblEQI_InputDate inputdate_new = new tblEQI_InputDate(); objData.fldSTCode = itemvalue.fldSTCode; objData.fldRCode = itemvalue.fldRCode; objData.fldRSCode = itemvalue.fldRSCode; objData.fldRSC = itemvalue.fldRSC; objData.fldSAMPH = "1"; objData.fldSAMPR = "1"; objData.fldYear = inputdate_new.fldSYear = decimal.Parse(Convert.ToDateTime(itemvalue.BeginDate).Year.ToString()); objData.fldMonth = inputdate_new.fldSMonth = decimal.Parse(Convert.ToDateTime(itemvalue.BeginDate).Month.ToString()); objData.fldDay = inputdate_new.fldSDay = decimal.Parse(Convert.ToDateTime(itemvalue.BeginDate).Day.ToString()); objData.fldHour = inputdate_new.fldSHour = decimal.Parse(Convert.ToDateTime(itemvalue.BeginDate).Hour.ToString()); objData.fldMinute = inputdate_new.fldSMinute = decimal.Parse(Convert.ToDateTime(itemvalue.BeginDate).Minute.ToString()); objData.fldSource = 0; objData.fldUserID = inputdate_new.fldUserID = int.Parse(itemvalue.fldUserID); objData.fldFlag = 0; objData.fldCityID_Operate = inputdate_new.fldCityID = int.Parse(itemvalue.fldCityID_Operate); objData.fldCityID_Submit = itemvalue.fldCityID_Submit; objData.fldDate_Operate = DateTime.Now; objData.fldBatch = itemvalue.BeginDate + Guid.NewGuid().ToString(); inputdate_new.fldObject = "eqiw_r"; Regex regexvalue = new Regex(@"^(\d*\.?\d+)+$"); Regex regexvalue2 = new Regex(@"^(\d*\.?\d+)?[lL]$"); for (int i = 0; i < itemvalue.fldItemData.Count; i++) { decimal dValue = -1; DataTable dataTable = rule.GetItem("地表水", itemvalue.fldItemData[i].itemcode); if (dataTable.Rows.Count > 0) { if (itemvalue.fldItemData[i].itemvalue.Trim() != "") { //if (!regexvalue.IsMatch(itemvalue.fldItemData[i].itemvalue) && !regexvalue2.IsMatch(itemvalue.fldItemData[i].itemvalue)) //{ // result = rule.JsonStr("error", "项目[" + dataTable.Rows[0]["fldItemName"].ToString() + "]的监测值只能输入数字或字符L和l!", ""); // return new HttpResponseMessage { Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json") }; //} if (!regexvalue2.IsMatch(itemvalue.fldItemData[i].itemvalue)) { dValue = Convert.ToDecimal(itemvalue.fldItemData[i].itemvalue); decimal dMinValue = Convert.ToDecimal(dataTable.Rows[0]["fldMinValue"].ToString()); if (dMinValue >= 0 && dValue < dMinValue) { result = rule.JsonStr("error", "" + dataTable.Rows[0]["fldItemName"] + "的监测值应 >=" + dMinValue, ""); return(new HttpResponseMessage { Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json") }); } decimal dMaxValue = Convert.ToDecimal(dataTable.Rows[0]["fldMaxValue"].ToString()); if (dMaxValue > 0 && dValue > dMaxValue) { result = rule.JsonStr("error", "" + dataTable.Rows[0]["fldItemName"] + "的监测值应 <=" + dMaxValue, ""); return(new HttpResponseMessage { Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json") }); } } if (regexvalue2.IsMatch(itemvalue.fldItemData[i].itemvalue.Trim())) { if (itemvalue.fldItemData[i].itemvalue.Trim().ToLower() == "l") { decimal temp = Convert.ToDecimal(dataTable.Rows[0]["fldSense"].ToString()); if (temp <= 0) { result = rule.JsonStr("error", "项目[" + dataTable.Rows[0]["fldItemName"].ToString() + "]的检出限<=0,不能输入 L 作为监测值", ""); return(new HttpResponseMessage { Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json") }); } dValue = -temp; } else { dValue = -Convert.ToDecimal(itemvalue.fldItemData[i].itemvalue.Trim().Replace("l", "").Replace("L", "")); } if (dValue == -1) { dValue = Convert.ToDecimal(-0.99999999); } } else { dValue = Convert.ToDecimal(itemvalue.fldItemData[i].itemvalue.ToString().Trim()); } } tblEQIW_R_Basedata_Pre objTmp = objData.Clone(); objTmp.fldItemCode = itemvalue.fldItemData[i].itemcode; objTmp.fldItemValue = dValue; objTmp.fldCityID_Operate = Int32.Parse(itemvalue.fldCityID_Operate); objTmp.fldCityID_Submit = itemvalue.fldCityID_Submit; lstData.Add(objTmp); } } RuletblEQIW_R_Basedata_Pre rule_basedata = new RuletblEQIW_R_Basedata_Pre(); bool issave = rule_basedata.InsertAll(lstData, inputdate_new); if (issave) { RuleWriteOperateLog rule_wol = new RuleWriteOperateLog(); rule_wol.WriteLog(0, "录入河流数据到临时表,断面" + itemvalue.fldRSCode + ";时间:" + itemvalue.BeginDate + " " + itemvalue.EndDate + ";录入者ID:" + int.Parse(itemvalue.fldUserID), itemvalue.fldUserName, int.Parse(itemvalue.fldUserID), int.Parse(itemvalue.fldCityID_Submit)); result = rule.JsonStr("error", "录入成功!您保存的数据,已进入“待提交审核的数据”状态", ""); } else { result = rule.JsonStr("error", "数据保存失败,请重试", ""); } } else { result = rule.JsonStr("error", "缺少因子监测值", ""); } } else { result = rule.JsonStr("error", "缺少断面代码", ""); } } else { result = rule.JsonStr("error", "缺少河流代码", ""); } } else { result = rule.JsonStr("error", "缺少城市代码", ""); } } else { result = rule.JsonStr("error", "缺少监测时间", ""); } } catch (InputException ex) { result = rule.JsonStr("error", "数据保存失败," + ex.Message, ""); } catch (InsertException ex) { PageException pagex = new PageException(int.Parse(itemvalue.fldUserID), ex.Message, "Eqiw_rPointInputController", "ItemSave", ""); result = rule.JsonStr("error", "数据写入数据库失败," + ex.Message, ""); } catch (Exception ex) { PageException pagex = new PageException(int.Parse(itemvalue.fldUserID), ex.Message, "Eqiw_rPointInputController", "ItemSave", ""); result = rule.JsonStr("error", "数据保存时出现了错误," + ex.Message, ""); } return(new HttpResponseMessage { Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json") }); }
/// <summary> /// 功能描述 : 批量添加[tblEQIW_D_Basedata]表的记录 /// 创建者 : 张浩 /// 创建日期 : 2009-12-29 /// 修改者 : /// 修改日期 : /// 修改原因 : /// </summary> /// <param name="lstData">要添加的tblEQIW_D_Basedata的实体数组</param> /// <param name="lstCurrentData">需要更新的本城市的实体类数组</param> /// <param name="lstJuniorData">需要更新的下级城市的实体类数组</param> /// <param name="lstAud">审核未通过原因的实体类数组</param> /// <param name="new_CityID_Operate">更新后的操作城市ID</param> /// <param name="new_CityID_Submit">更新后的提交城市ID</param> /// <returns>操作是否成功</returns> public bool InsertAllOrUpdateNoPassAll(List <tblEQIW_D_Basedata> lstData, List <tblEQIW_D_Basedata_Pre> lstCurrentData, List <tblEQIW_D_Basedata_Pre> lstJuniorData, List <tblEQIW_D_Auditing> lstAud, List <tblFW_AuditingLog> lstAudLog, string new_CityID_Operate, string new_CityID_Submit, int grade, string comment, string operID2, string submit2, string flag2) { int iRowIndex = 0; string isading = ""; string dateAll = "", date = ""; using (SqlConnection conn = new SqlConnection(DataAccessConfig.ConnString)) { conn.Open(); using (SqlTransaction tran = conn.BeginTransaction()) { try { //更新 for (iRowIndex = 0; iRowIndex < lstCurrentData.Count; iRowIndex++) { usp_tblEQIW_D_Basedata_Pre_UpdateCity uspUpdate = new usp_tblEQIW_D_Basedata_Pre_UpdateCity(); uspUpdate.ReceiveParameter_Old(lstCurrentData[iRowIndex]); uspUpdate.new_fldFlag = Int16.Parse(flag2.Split(',')[iRowIndex].ToString()); uspUpdate.new_fldCityID_Operate = Int32.Parse(operID2.Split(',')[iRowIndex].ToString()); uspUpdate.new_fldCityID_Submit = submit2.Split(',')[iRowIndex]; uspUpdate.new_fldDate_Operate = lstCurrentData[iRowIndex].fldDate_Operate; int iResultInsert = uspUpdate.ExecNoQuery(conn, tran); if (iResultInsert <= 0) { throw new Exception("修改记录失败,未找到对应的记录"); } date = lstCurrentData[iRowIndex].fldYear.ToString() + lstCurrentData[iRowIndex].fldMonth.ToString(); if (dateAll.IndexOf(date) == -1) { usp_tblEQI_VerifyIdea_UpdateOrInsert usp_upin = new usp_tblEQI_VerifyIdea_UpdateOrInsert(); usp_upin.fldType = eqiType; usp_upin.fldGrade = grade; usp_upin.fldYear = lstCurrentData[iRowIndex].fldYear; usp_upin.fldMonth = lstCurrentData[iRowIndex].fldMonth; usp_upin.fldDay = lstCurrentData[iRowIndex].fldDay; usp_upin.fldComment = comment; int iResultUpIn = usp_upin.ExecNoQuery(conn, tran); if (iResultUpIn <= 0) { throw new Exception("修改或添加失败"); } } dateAll += date + ","; } //数据录入到原始表 for (iRowIndex = 0; iRowIndex < lstData.Count; iRowIndex++) { //if (lstData[iRowIndex].fldItemValue != -1) //{ //把数据录入到_RAW 表中 usp_tblEQI_InsertByType usp_ins = new usp_tblEQI_InsertByType(); usp_ins.autoid = lstData[iRowIndex].fldAutoID; usp_ins.type = eqiType; int iResultInsertByType = usp_ins.ExecNoQuery(conn, tran); if (iResultInsertByType <= 0) { throw new Exception("添加记录失败,未找到对应的记录"); } //判断是否是删除数据, 把没有删除的数据录入到原始表里面去 usp_tblEQI_GetByType usp_get = new usp_tblEQI_GetByType(); usp_get.autoid = lstData[iRowIndex].fldAutoID; usp_get.type = eqiType; DataTable dt = usp_get.ExecDataTable(); if (dt != null && dt.Rows.Count > 0 && dt.Rows[0][0].ToString() == "0") { usp_tblEQIW_D_Basedata_Insert uspInsert = new usp_tblEQIW_D_Basedata_Insert(); uspInsert.ReceiveParameter(lstData[iRowIndex]); int iResultInsert = uspInsert.ExecNoQuery(conn, tran); if (iResultInsert <= 0) { throw new Exception("添加记录失败,未找到对应的记录"); } } //} usp_tblEQIW_D_Basedata_Pre_Delete usp_pre_Delete = new usp_tblEQIW_D_Basedata_Pre_Delete(); usp_pre_Delete.fldAutoID = lstData[iRowIndex].fldAutoID; int iResultdelete = usp_pre_Delete.ExecNoQuery(conn, tran); if (iResultdelete <= 0) { throw new Exception("删除临时表记录失败,未找到对应的记录"); } date = lstData[iRowIndex].fldYear.ToString() + lstData[iRowIndex].fldMonth.ToString(); if (dateAll.IndexOf(date) == -1) { usp_tblEQI_VerifyIdea_UpdateOrInsert usp_upin = new usp_tblEQI_VerifyIdea_UpdateOrInsert(); usp_upin.fldType = eqiType; usp_upin.fldGrade = grade; usp_upin.fldYear = lstData[iRowIndex].fldYear; usp_upin.fldMonth = lstData[iRowIndex].fldMonth; usp_upin.fldDay = lstData[iRowIndex].fldDay; usp_upin.fldComment = comment; int iResultUpIn = usp_upin.ExecNoQuery(conn, tran); if (iResultUpIn <= 0) { throw new Exception("修改或添加失败"); } } dateAll += date + ","; } //数据改为本级城市审核未通过状态 for (iRowIndex = 0; iRowIndex < lstCurrentData.Count; iRowIndex++) { usp_tblEQIW_D_Basedata_Pre_UpdateFlag uspUpdate = new usp_tblEQIW_D_Basedata_Pre_UpdateFlag(); uspUpdate.ReceiveParameter_Old(lstCurrentData[iRowIndex]); uspUpdate.new_fldFlag = 12; uspUpdate.new_fldDate_Operate = lstCurrentData[iRowIndex].fldDate_Operate; int iResultInsert = uspUpdate.ExecNoQuery(conn, tran); //if (iResultInsert <= 0) // throw new Exception("修改记录失败,未找到对应的记录"); } //数据改为下级城市审核未通过状态 for (iRowIndex = 0; iRowIndex < lstJuniorData.Count; iRowIndex++) { int isb = this.selectWY(lstJuniorData[iRowIndex].fldSTCode, lstJuniorData[iRowIndex].fldRCode, lstJuniorData[iRowIndex].fldRSCode, lstJuniorData[iRowIndex].fldYear); //如果是河流 if (isb == 0) { #region 给实体类赋值 tblEQIW_R_Basedata_Pre tblr = new tblEQIW_R_Basedata_Pre(); tblr.fldSTCode = lstJuniorData[iRowIndex].fldSTCode; tblr.fldRCode = lstJuniorData[iRowIndex].fldRCode; tblr.fldRSCode = lstJuniorData[iRowIndex].fldRSCode; tblr.fldYear = lstJuniorData[iRowIndex].fldYear; tblr.fldMonth = lstJuniorData[iRowIndex].fldMonth; tblr.fldDay = lstJuniorData[iRowIndex].fldDay; tblr.fldHour = lstJuniorData[iRowIndex].fldHour; tblr.fldMinute = lstJuniorData[iRowIndex].fldMinute; tblr.fldSAMPH = lstJuniorData[iRowIndex].fldSAMPH; tblr.fldSAMPR = lstJuniorData[iRowIndex].fldSAMPR; tblr.fldRSC = lstJuniorData[iRowIndex].fldRSC; tblr.fldItemCode = lstJuniorData[iRowIndex].fldItemCode; tblr.fldItemValue = lstJuniorData[iRowIndex].fldItemValue; tblr.fldBatch = lstJuniorData[iRowIndex].fldBatch; tblr.fldImport = lstJuniorData[iRowIndex].fldImport; tblr.fldSource = lstJuniorData[iRowIndex].fldSource; tblr.fldUserID = lstJuniorData[iRowIndex].fldUserID; #endregion tblr.fldFlag = -2; tblr.fldDate_Operate = DateTime.Now; tblr.fldCityID_Operate = Convert.ToInt32(new_CityID_Operate.Split(',')[iRowIndex]); tblr.fldCityID_Submit = new_CityID_Submit.Split(',')[iRowIndex]; //新增河流的记录 usp_tblEQIW_R_Basedata_Pre_InsertD uspInsert = new usp_tblEQIW_R_Basedata_Pre_InsertD(); uspInsert.ReceiveParameter(tblr); for (int i = 0; i < lstAud.Count; i++) { if (lstAud[i].fldBaseDataID == lstJuniorData[iRowIndex].fldAutoID) { uspInsert.fldComment = lstAud[i].fldComment; isading += lstAud[i].fldBaseDataID + ","; break; } } int iResultInsertD = uspInsert.ExecNoQuery(conn, tran); if (iResultInsertD <= 0) { throw new Exception("新增河流失败!"); } //删除饮用水里面饮用水的记录 usp_tblEQIW_D_Basedata_Pre_Delete deleteR = new usp_tblEQIW_D_Basedata_Pre_Delete(); deleteR.fldAutoID = Convert.ToInt32(lstJuniorData[iRowIndex].fldAutoID); int isr = deleteR.ExecNoQuery(conn, tran); if (isr <= 0) { throw new Exception("删除记录失败"); } } //如果是湖库 else if (isb == 1) { #region 给实体类赋值 tblEQIW_L_Basedata_Pre tbll = new tblEQIW_L_Basedata_Pre(); tbll.fldSTCode = lstJuniorData[iRowIndex].fldSTCode; tbll.fldRCode = lstJuniorData[iRowIndex].fldRCode; tbll.fldRSCode = lstJuniorData[iRowIndex].fldRSCode; tbll.fldYear = lstJuniorData[iRowIndex].fldYear; tbll.fldMonth = lstJuniorData[iRowIndex].fldMonth; tbll.fldDay = lstJuniorData[iRowIndex].fldDay; tbll.fldHour = lstJuniorData[iRowIndex].fldHour; tbll.fldMinute = lstJuniorData[iRowIndex].fldMinute; tbll.fldSAMPH = lstJuniorData[iRowIndex].fldSAMPH; tbll.fldSAMPR = lstJuniorData[iRowIndex].fldSAMPR; tbll.fldRSC = lstJuniorData[iRowIndex].fldRSC; tbll.fldItemCode = lstJuniorData[iRowIndex].fldItemCode; tbll.fldItemValue = lstJuniorData[iRowIndex].fldItemValue; tbll.fldBatch = lstJuniorData[iRowIndex].fldBatch; //tbll.fldImport = lstJuniorData[iRowIndex].fldImport; tbll.fldSource = lstJuniorData[iRowIndex].fldSource; tbll.fldUserID = lstJuniorData[iRowIndex].fldUserID; #endregion tbll.fldFlag = -2; tbll.fldDate_Operate = DateTime.Now; tbll.fldCityID_Operate = Convert.ToInt32(new_CityID_Operate.Split(',')[iRowIndex]); tbll.fldCityID_Submit = new_CityID_Submit.Split(',')[iRowIndex]; //新增湖库的记录 usp_tblEQIW_L_Basedata_Pre_InsertD uspInsert = new usp_tblEQIW_L_Basedata_Pre_InsertD(); uspInsert.ReceiveParameter(tbll); for (int i = 0; i < lstAud.Count; i++) { if (lstAud[i].fldBaseDataID == lstJuniorData[iRowIndex].fldAutoID) { uspInsert.fldComment = lstAud[i].fldComment; isading += lstAud[i].fldBaseDataID + ","; break; } } int iResultInsertD = uspInsert.ExecNoQuery(conn, tran); if (iResultInsertD <= 0) { throw new Exception("新增湖库失败!"); } //删除饮用水里面饮用水的记录 usp_tblEQIW_D_Basedata_Pre_Delete deleteR = new usp_tblEQIW_D_Basedata_Pre_Delete(); deleteR.fldAutoID = Convert.ToInt32(lstJuniorData[iRowIndex].fldAutoID); int isr = deleteR.ExecNoQuery(conn, tran); if (isr <= 0) { throw new Exception("删除记录失败"); } } else { usp_tblEQIW_D_Basedata_Pre_UpdateCity uspUpdate = new usp_tblEQIW_D_Basedata_Pre_UpdateCity(); uspUpdate.ReceiveParameter_Old(lstJuniorData[iRowIndex]); uspUpdate.new_fldCityID_Operate = Convert.ToInt32(new_CityID_Operate.Split(',')[iRowIndex]); uspUpdate.new_fldCityID_Submit = new_CityID_Submit.Split(',')[iRowIndex]; uspUpdate.new_fldFlag = -2; uspUpdate.new_fldDate_Operate = DateTime.Now; int iResultInsert = uspUpdate.ExecNoQuery(conn, tran); if (iResultInsert <= 0) { throw new Exception("修改记录失败,未找到对应的记录"); } } } //审核未通过原因写入数据表 for (iRowIndex = 0; iRowIndex < lstAud.Count; iRowIndex++) { if (isading.IndexOf(lstAud[iRowIndex].fldBaseDataID.ToString()) == -1) { usp_tblEQIW_D_Auditing_Insert uspInsert = new usp_tblEQIW_D_Auditing_Insert(); uspInsert.ReceiveParameter(lstAud[iRowIndex]); int iResultInsert = uspInsert.ExecNoQuery(conn, tran); if (iResultInsert <= 0) { throw new Exception("添加审核未通过原因失败,未找到对应的记录"); } } } //审批操作记录保存到审核日志 for (iRowIndex = 0; iRowIndex < lstAudLog.Count; iRowIndex++) { usp_tblFW_AuditingLog_Insert uspInsert = new usp_tblFW_AuditingLog_Insert(); uspInsert.ReceiveParameter(lstAudLog[iRowIndex]); int iResultInsert = uspInsert.ExecNoQuery(conn, tran); if (iResultInsert <= 0) { throw new Exception("添加审核日志未通过原因失败,未找到对应的记录"); } } tran.Commit(); return(true); } catch (DBOpenException e) { throw new InsertException("打开数据库连接失败", "RuletblEQIW_D_Basedata", "InsertAllOrUpdateNoPassAll", ""); } catch (DBPKException e) { throw new InputException(iRowIndex, "错误发生行号:" + (lstData[iRowIndex].fldErrorRowIndex) + ",错误原因:同一测点同一时间同一项目的数据已经存在", "RuletblEQIW_D_Basedata", "InsertAllOrUpdateNoPassAll", "new_CityID_Operate:" + new_CityID_Operate.ToString() + ",new_CityID_Submit:" + new_CityID_Submit); } catch (DBQueryException e) { throw new InsertException("执行Sql语句失败", "RuletblEQIW_D_Basedata", "InsertAllOrUpdateNoPassAll", "new_CityID_Operate:" + new_CityID_Operate.ToString() + ",new_CityID_Submit:" + new_CityID_Submit); } catch (DBException e) { throw new InsertException("写入数据库失败", "RuletblEQIW_D_Basedata", "InsertAllOrUpdateNoPassAll", "new_CityID_Operate:" + new_CityID_Operate.ToString() + ",new_CityID_Submit:" + new_CityID_Submit); } catch (Exception e) { tran.Rollback(); throw new InsertException(e.Message, "RuletblEQIW_D_Basedata", "InsertAllOrUpdateNoPassAll", "new_CityID_Operate:" + new_CityID_Operate.ToString() + ",new_CityID_Submit:" + new_CityID_Submit); } } } }