/// <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") };
        }
示例#2
0
        //
        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);
                    }
                }
            }
        }