//
public HttpResponseMessage ItemSave(eqia_rdsavedata itemvalue)
{
string result = string.Empty;
try
{
if (itemvalue.fldUserID == null || itemvalue.fldUserName == null)
{
itemvalue.fldUserID = rule.ConductUserinfo(itemvalue.fldUserID);
itemvalue.fldUserName = "";
}
if (itemvalue.BeginDate != null && itemvalue.EndDate != null)
{
if (itemvalue.fldSTCode != null)
{
if (itemvalue.fldPCode != null)
{
if (itemvalue.fldItemData.Count > 0)
{
List <tblEQIA_RDPI_Basedata_Pre> lstData = new List <tblEQIA_RDPI_Basedata_Pre>();
tblEQIA_RDPI_Basedata_Pre objData = new tblEQIA_RDPI_Basedata_Pre();
tblEQI_InputDate inputdate_new = new tblEQI_InputDate();
objData.fldSTCode = itemvalue.fldSTCode;
objData.fldPCode = itemvalue.fldPCode;
objData.fldSYear = inputdate_new.fldSYear = decimal.Parse(Convert.ToDateTime(itemvalue.BeginDate).Year.ToString());
objData.fldSMonth = inputdate_new.fldSMonth = decimal.Parse(Convert.ToDateTime(itemvalue.BeginDate).Month.ToString());
objData.fldSDay = inputdate_new.fldSDay = decimal.Parse(Convert.ToDateTime(itemvalue.BeginDate).Day.ToString());
objData.fldSHour = inputdate_new.fldSHour = decimal.Parse(Convert.ToDateTime(itemvalue.BeginDate).Hour.ToString());
objData.fldSMinute = inputdate_new.fldSMinute = decimal.Parse(Convert.ToDateTime(itemvalue.BeginDate).Minute.ToString());
objData.fldEYear = inputdate_new.fldEYear = decimal.Parse(Convert.ToDateTime(itemvalue.EndDate).Year.ToString());
objData.fldEMonth = inputdate_new.fldEMonth = decimal.Parse(Convert.ToDateTime(itemvalue.EndDate).Month.ToString());
objData.fldEDay = inputdate_new.fldEDay = decimal.Parse(Convert.ToDateTime(itemvalue.EndDate).Day.ToString());
objData.fldEHour = inputdate_new.fldEHour = decimal.Parse(Convert.ToDateTime(itemvalue.EndDate).Hour.ToString());
objData.fldEMinute = inputdate_new.fldEMinute = decimal.Parse(Convert.ToDateTime(itemvalue.EndDate).Minute.ToString());
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;
inputdate_new.fldObject = "eqia_rd";
Regex regexvalue2 = new Regex(@"^(\d*\.?\d+)?[lL]$");
for (int i = 0; i < itemvalue.fldItemData.Count; i++)
{
decimal dValue = -1;
RuletblEQIA_R_Item rule_item = new RuletblEQIA_R_Item();
DataTable dataTable = rule_item.GetItemAndSTDDataByItemCode(itemvalue.fldItemData[i].itemcode);
if (dataTable.Rows.Count > 0)
{
if (itemvalue.fldItemData[i].itemvalue.Trim() != "")
{
if (regexvalue2.IsMatch(itemvalue.fldItemData[i].itemvalue.ToString().Trim()))
{
if (itemvalue.fldItemData[i].itemvalue.ToString().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.ToString().Trim().Replace("l", "").Replace("L", ""));
}
if (dValue == -1)
{
dValue = Convert.ToDecimal(-0.99999999);
}
}
else
{
dValue = Convert.ToDecimal(itemvalue.fldItemData[i].itemvalue.ToString().Trim());
}
}
}
tblEQIA_RDPI_Basedata_Pre objTmp = objData.Clone();
objTmp.fldItemCode = itemvalue.fldItemData[i].itemcode.ToString();
objTmp.fldItemValue = dValue;
objTmp.fldCityID_Operate = Int32.Parse(itemvalue.fldCityID_Operate);
objTmp.fldCityID_Submit = itemvalue.fldCityID_Submit;
lstData.Add(objTmp);
}
RuletblEQIA_RDPI_Basedata_Pre rule_basedata = new RuletblEQIA_RDPI_Basedata_Pre();
bool issave = rule_basedata.InsertAll(lstData, inputdate_new);
if (issave)
{
RuleWriteOperateLog rule_wol = new RuleWriteOperateLog();
rule_wol.WriteLog(0, "录入降尘数据到临时表，测点代码：" + itemvalue.fldPCode +
";时间：" + 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", "缺少监测时间", "");
}
}
catch (InputException ex)
{
result = rule.JsonStr("error", "数据保存失败，" + ex.Message, "");
}
catch (InsertException ex)
{
PageException pagex = new PageException(int.Parse(itemvalue.fldUserID), ex.Message,
"Eqia_rdPointInputController", "ItemSave", "");
result = rule.JsonStr("error", "数据写入数据库失败，" + ex.Message, "");
}
catch (Exception ex)
{
PageException pagex = new PageException(int.Parse(itemvalue.fldUserID), ex.Message,
"Eqia_rdPointInputController", "ItemSave", "");
result = rule.JsonStr("error", "数据保存时出现了错误，" + ex.Message, "");
}
return(new HttpResponseMessage {
Content = new StringContent(result, 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>
/// 功能描述：数据插入到临时表
/// 创建 人：周文卿
/// 创建时间：2017/07/11
/// 修改原因：
/// 修改时间：
/// 修改 人：
/// </summary>
/// <param name="inputdata">插入的实体类</param>
/// <returns>json（是否成功）</returns>
public HttpResponseMessage ItemSave(List <tbleqia_r_table> inputdata)
{
string returntext = "";
try
{
Regex regexvalue = new Regex(@"^(\d*\.?\d+)+$");
Regex regexvalue2 = new Regex(@"^(\d*\.?\d+)?[lL]$");
List <tblEQIA_RPI_Basedata_Pre> lstData = new List <tblEQIA_RPI_Basedata_Pre>();
tblEQIA_RPI_Basedata_Pre objData = new tblEQIA_RPI_Basedata_Pre();//临时表
for (int i = 0; i < inputdata.Count; i++)
{
List <tbaeqia_r_value> valueall = inputdata[i].valueall;
for (int j = 0; j < valueall.Count; j++)
{
objData.fldSTCode = valueall[j].fldSTCode;
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;
RuletblEQIA_R_Item rule_item = new RuletblEQIA_R_Item();
DataTable dataTable = rule_item.GetItemAndSTDDataByItemCode(inputdata[i].itemcode);
decimal dValue = -1;
if (dataTable.Rows.Count > 0)
{
if (valueall[j].monitorvalue != "")
{
if (regexvalue2.IsMatch(valueall[j].monitorvalue))
{
if (valueall[j].monitorvalue.ToString().Trim().ToLower() == "l")
{
decimal temp = Convert.ToDecimal(dataTable.Rows[0]["fldSense"].ToString());
if (temp <= 0)
{
returntext = rule.JsonStr("error", "项目[" + dataTable.Rows[0]["fldItemName"].ToString() + "]的检出限<=0，不能输入 L 作为监测值", "");
return(new HttpResponseMessage {
Content = new StringContent(returntext, System.Text.Encoding.UTF8, "application/json")
});
}
dValue = -temp;
}
else
{
dValue = -Convert.ToDecimal(valueall[j].monitorvalue.ToString().Trim().Replace("l", "").Replace("L", ""));
}
if (dValue == -1)
{
dValue = Convert.ToDecimal(-0.99999999);
}
}
else
{
dValue = Convert.ToDecimal(valueall[j].monitorvalue.ToString().Trim());
}
}
}
tblEQIA_RPI_Basedata_Pre objTmp = objData.Clone();
objTmp.fldPCode = valueall[j].fldPCode;
DateTime time = DateTime.Parse(valueall[j].fldDate.ToString());
objTmp.fldSYear = time.Year;
objTmp.fldSMonth = time.Month;
objTmp.fldSDay = time.Day;
objTmp.fldSHour = 0;
objTmp.fldSMinute = 0;
objTmp.fldEYear = time.Year;
objTmp.fldEMonth = time.Month;
objTmp.fldEDay = time.Day;
objTmp.fldEHour = 0;
objTmp.fldEMinute = 0;
objTmp.fldFlag = 0;
objTmp.fldImport = false;
objTmp.fldItemCode = inputdata[i].itemcode;
objTmp.fldItemValue = dValue;
lstData.Add(objTmp);
}
}
RuletblEQIA_RPI_Basedata_Pre rule_basedata = new RuletblEQIA_RPI_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")
});
}
/// <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 PointSave(List <tbleqin_a_data> alldata)
{
string returntext = "";
try
{
tblEQI_InputDate inputdate_new = new tblEQI_InputDate();
List <tblEQIN_A_BaseData_Pre> lstData = new List <tblEQIN_A_BaseData_Pre>();
List <inputeqin_a_data> inputdata = alldata[0].inputdata;
DateTime dts = DateTime.Parse(alldata[0].datetime);
for (int i = 0; i < inputdata.Count; i++)
{
tblEQIN_A_BaseData_Pre objData = new tblEQIN_A_BaseData_Pre();
objData.fldSTCode = inputdata[i].fldSTCode;
objData.fldGDCODE = inputdata[i].fldGDCODE;
objData.fldYear = dts.Year;
objData.fldMonth = dts.Month;
objData.fldDay = dts.Day;
objData.fldHour = dts.Hour.ToString() == "" ? -1 : Convert.ToDecimal(dts.Hour.ToString());
objData.fldMinute = dts.Minute.ToString() == "" ? -1 : Convert.ToDecimal(dts.Minute.ToString());
objData.fldTimelen = inputdata[i].fldTimelen.ToString() == "" ? -1 : Convert.ToInt32(inputdata[i].fldTimelen.ToString());
objData.fldDN = inputdata[i].fldDN.ToString();
objData.fldNDISC = inputdata[i].fldNDISC.ToString();
objData.fldNSC = inputdata[i].fldNSC.ToString();
objData.fldApparatus_Grade = inputdata[i].fldApparatus_Grade;
objData.fldLEQA = inputdata[i].fldLEQA.ToString() == "" ? -1 : Convert.ToDecimal(inputdata[i].fldLEQA.ToString());
objData.fldL10A = inputdata[i].fldL10A.ToString() == "" ? -1 : Convert.ToDecimal(inputdata[i].fldL10A.ToString());
objData.fldL50A = inputdata[i].fldL50A.ToString() == "" ? -1 : Convert.ToDecimal(inputdata[i].fldL50A.ToString());
objData.fldL90A = inputdata[i].fldL90A.ToString() == "" ? -1 : Convert.ToDecimal(inputdata[i].fldL90A.ToString());
objData.fldLmin = inputdata[i].fldLmin.ToString() == "" ? -1 : Convert.ToDecimal(inputdata[i].fldLmin.ToString());
objData.fldLmax = inputdata[i].fldLmax.ToString() == "" ? -1 : Convert.ToDecimal(inputdata[i].fldLmax.ToString());
objData.fldSD = inputdata[i].fldSD.ToString() == "" ? -1 : Convert.ToDecimal(inputdata[i].fldSD.ToString());
objData.fldMph = inputdata[i].fldMph.ToString() == "" ? -1 : decimal.Parse(inputdata[i].fldMph.ToString());
objData.fldApparatus_Type = inputdata[i].fldApparatus_Type.ToString();
objData.fldApparatus_Id = inputdata[i].fldApparatus_Id.ToString();
objData.fldFlag = 0;
objData.fldCityID_Operate = int.Parse(alldata[0].CityID);
objData.fldCityID_Submit = alldata[0].CityID;
objData.fldSource = 0;
objData.fldImport = 0;
objData.fldFlag = 0;
objData.fldBatch = "0";
objData.fldMatching_Data = false;
objData.fldSPressureValue = 0;
objData.fldCalibrationVluesEnd = 0;
objData.fldCalibrationVluesOn = 0;
objData.fldDeleteState = 0;
objData.fldSPressureType = "0";
objData.fldSPressureID = "0";
objData.fldDate_Operate = DateTime.Now;
objData.fldUserID = int.Parse(alldata[0].UserID);
lstData.Add(objData);
if (i == 0)
{
inputdate_new.fldSYear = objData.fldYear;
inputdate_new.fldSMonth = objData.fldMonth;
inputdate_new.fldSDay = objData.fldDay;
inputdate_new.fldCityID = objData.fldCityID_Operate;
inputdate_new.fldUserID = objData.fldUserID;
inputdate_new.fldObject = "eqin_a";
}
}
tblEQI_InputDate inputdate_old = new tblEQI_InputDate();
RuletblEQIN_A_Basedata_Pre rule_basedata = new RuletblEQIN_A_Basedata_Pre();
bool issave = rule_basedata.InsertAll(lstData, inputdate_new, inputdate_old);
if (issave)
{
RuleWriteOperateLog rule_wol = new RuleWriteOperateLog();
rule_wol.WriteLog(0, "录入区域噪声数据到临时表", "", int.Parse(alldata[0].UserID), int.Parse(alldata[0].CityID));
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 string Update(string fldAutoId, string typemodel, string userId, string userName, string cityId, string NewFlag = null)
{
try
{
userId = rule.ConductUserinfo(userId);
RuletblDictionary dic = new RuletblDictionary();
if (typemodel.ToString() == "eqise")
{
typemodel = "eqiw_r";
}
string list = dic.ByParentIDAndValue("数据审核视图", typemodel.ToString());
string listone = list.Split(',')[0].ToString().Substring(2);
string listones = null;
if (listone.ToLower().Contains("auto"))
{
listones = listone.Substring(0, listone.Length - 12);
}
else
{
listones = listone.Substring(0, listone.Length - 7);
}
string table = "";
if (typemodel.ToString() == "eqib_v")
{
table = "tbl_" + listones;
}
else
{
table = "tbl" + listones;
}
List <long> lstDelID = new List <long>();
string[] fld = fldAutoId.ToString().Split(',');
for (int i = 0; i < fld.Length; i++)
{
string[] pk = fld[i].Split('_');
for (int j = 0; j < pk.Length; j++)
{
lstDelID.Add(Convert.ToInt64(pk[j].ToString()));
}
}
RuletblEQIA_RPI_Basedata_Pre rule_basedata = new RuletblEQIA_RPI_Basedata_Pre();
RuleWriteOperateLog rule_wol = new RuleWriteOperateLog();
if (NewFlag == null)
{
NewFlag = "1";
}
bool isb = rule_basedata.delBytable(lstDelID, table, NewFlag.ToString());
if (isb)
{
rule_wol.WriteLog(0, "提交审核选中的数据数据，进入监测数据审核状态录入这ID=" + userId.ToString(), userName.ToString(), int.Parse(userId.ToString()), int.Parse(cityId.ToString()));
return("提交审核数据成功！");
}
else
{
return("提交审核数据失败，请重试！");
}
}
catch (Exception e)
{
throw new Exception("提交审核数据失败！");
}
}
/// <summary>
/// 功能描述：数据插入到临时表
/// 创建 人：周文卿
/// 创建时间：2017/07/11
/// 修改原因：
/// 修改时间：
/// 修改 人：
/// </summary>
/// <param name="inputdata">插入的实体类</param>
/// <returns>json（是否成功）</returns>
public HttpResponseMessage ItemSave(List <tbleqia_rd_table> inputdata)
{
string returntext = "";
try
{
Regex regexvalue = new Regex(@"^(\d*\.?\d+)+$");
Regex regexvalue2 = new Regex(@"^(\d*\.?\d+)?[lL]$");
List <tblEQIA_RDPI_Basedata_Pre> lstData = new List <tblEQIA_RDPI_Basedata_Pre>();
tblEQIA_RDPI_Basedata_Pre objData = new tblEQIA_RDPI_Basedata_Pre();
tblEQI_InputDate inputdate_new = new tblEQI_InputDate();
RuletblEQI_publi ruleSense = new RuletblEQI_publi();
for (int i = 0; i < inputdata.Count; i++)
{
List <tbaeqia_rd_value> valueall = inputdata[i].valueall;
for (int j = 0; j < valueall.Count; j++)
{
RuletblDictionary ruleDict = new RuletblDictionary();
objData.fldSTCode = valueall[j].fldSTCode;
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")
{
string itemname = "";
itemname = ruleSense.GetSenseNameBytbl("EQIA_RD", inputdata[i].itemcode);
decimal temp = Convert.ToDecimal(valueall[j].monitorvalue);
if (temp <= 0)
{
returntext = "项目的检出限<=0，不能输入 L 作为监测值'";
}
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
tblEQIA_RDPI_Basedata_Pre objTmp = objData.Clone();
objTmp.fldPCode = valueall[j].fldPCode;
DateTime time = DateTime.Parse(valueall[j].fldDate.ToString());
objTmp.fldSYear = time.Year;
objTmp.fldSMonth = time.Month;
objTmp.fldSDay = time.Day;
objTmp.fldSHour = 0;
objTmp.fldSMinute = 0;
objTmp.fldEYear = time.Year;
objTmp.fldEMonth = time.Month;
objTmp.fldEDay = time.Day;
objTmp.fldEHour = 0;
objTmp.fldEMinute = 0;
objTmp.fldFlag = 0;
objTmp.fldImport = 0;
objTmp.fldItemCode = inputdata[i].itemcode;
objTmp.fldItemValue = dValue;
lstData.Add(objTmp);
}
}
RuletblEQIA_RDPI_Basedata_Pre rule_basedata = new RuletblEQIA_RDPI_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")
});
}
