//[SupportFilter]
public HttpResponseMessage DeleteItemGroup(dynamic obj)
{
string result = string.Empty;
try
{
if (string.IsNullOrEmpty(Convert.ToString(obj.id)) || Convert.ToString(obj.id) == "0")
{
result = rule.JsonStr("error", "请先选择要删除的项目信息", "");
}
else
{
try
{
RuletblEQI_Item_Group rule_group = new RuletblEQI_Item_Group();
bool isdelete = rule_group.Delete(Convert.ToInt32(obj.id));
if (isdelete)
{
result = rule.JsonStr("ok", "删除组成功", "");
}
}
catch (DeleteException ex)
{
PageException pagex = new PageException(Convert.ToInt32(obj.id), ex.Message, "input", "DeleteItemProject", "");
result = rule.JsonStr("error", "删除项目信息时出现了错误", "");
}
catch (Exception ex)
{
PageException pagex = new PageException(Convert.ToInt32(obj.id), ex.Message, "input", "DeleteItemProject", "");
result = rule.JsonStr("error", "删除项目信息时出现了错误", "");
}
}
}
catch (Exception e)
{
result = rule.JsonStr("error", e.Message, "");
}
return(new HttpResponseMessage {
Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json")
});
}
public ErrorPage(PageContext context) : this()
{
m_context = context;
if ((m_exception = this.Context.Request.UserState as PageException) != null)
{
m_title = m_exception.Title;
this.DataContext = m_exception;
#if DEBUG
Request request = null;
if (m_exception.Request is Request)
{
request = m_exception.Request as Request;
}
else if (m_exception.Request is PageContext)
{
request = (m_exception.Request as PageContext).Request;
}
TextBlockContent.Text = string.Format("{0}\r\n ● Target URL:" + (request != null ? request.URL : string.Empty), m_exception is PageException ? m_exception.Message : m_exception.ToString());
#endif
}
}
//
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")
});
}
//
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")
});
}
//[SupportFilter]
public HttpResponseMessage UpdateItemGroup(dynamic obj)
{
string result = string.Empty;
try
{
if (string.IsNullOrEmpty(Convert.ToString(obj.id)) || Convert.ToString(obj.id) == "0")
{
result = rule.JsonStr("error", "id参数错误", "缺少更新的项目信息");
}
else if (string.IsNullOrEmpty(Convert.ToString(obj.flditemcontent)))
{
result = rule.JsonStr("error", "flditemcontent参数错误", "缺少要保存在分组中的项目");
}
else if (string.IsNullOrEmpty(Convert.ToString(obj.modeltype)))
{
result = rule.JsonStr("error", "fldobject参数错误", "缺少业务类型");
}
else
{
try
{
string type = gettype(HttpUtility.UrlDecode(Convert.ToString(obj.modeltype)));
RuletblEQI_Item_Group rule_group = new RuletblEQI_Item_Group();
tblEQI_Item_Group objObject_old = rule_group.ByPK(Convert.ToInt32(rule.ConductUserinfo(obj.id)));
tblEQI_Item_Group objObject_new = new tblEQI_Item_Group();
objObject_new.fldObject = type;
objObject_new.fldUserID = objObject_old.fldUserID;
objObject_new.fldName = objObject_old.fldName;
objObject_new.fldItemContent = HttpUtility.UrlDecode(Convert.ToString(obj.flditemcontent));
bool isdelete = rule_group.Update(objObject_old, objObject_new);
if (isdelete)
{
objObject_new.fldAutoID = Convert.ToInt32(obj.id);
result = rule.JsonStr("ok", "更新组成功", objObject_new);
}
}
catch (UpdatePKException ex)
{
result = rule.JsonStr("error", "flditemcontent参数错误", "请选择要保存在分组中的项目");
}
catch (DDYZ.Ensis.Library.Exception.DataRule.UpdateException ex)
{
PageException pagex = new PageException(Convert.ToInt32(obj.UserID), ex.Message, "input", "UpdateItemProject", "");
result = rule.JsonStr("error", "更新项目信息时出现了错误", "");
}
catch (Exception ex)
{
PageException pagex = new PageException(Convert.ToInt32(obj.UserID), ex.Message, "input", "UpdateItemProject", "");
result = rule.JsonStr("error", "更新项目信息时出现了错误", "");
}
}
}
catch (Exception e)
{
result = rule.JsonStr("error", e.Message, "");
}
return(new HttpResponseMessage {
Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json")
});
}
//[SupportFilter]
public HttpResponseMessage AddItemGroup(dynamic obj)
{
string result = string.Empty;
try
{
//验证字符串是否符合要求
if (!string.IsNullOrEmpty(Convert.ToString(obj.fldname)))
{
if (!string.IsNullOrEmpty(Convert.ToString(obj.flditemcontent)))
{
if (!string.IsNullOrEmpty(Convert.ToString(obj.modeltype)))
{
try
{
string type = gettype(HttpUtility.UrlDecode(Convert.ToString(obj.modeltype)));
tblEQI_Item_Group item_group = new tblEQI_Item_Group();
item_group.fldName = HttpUtility.UrlDecode(Convert.ToString(obj.fldname));
item_group.fldObject = type;
item_group.fldUserID = Convert.ToInt32(rule.ConductUserinfo(obj.UserID));
item_group.fldItemContent = Convert.ToString(obj.flditemcontent);
RuletblEQI_Item_Group rule_group = new RuletblEQI_Item_Group();
int returnID = rule_group.Insert(item_group);
if (returnID > 0)
{
item_group.fldAutoID = returnID;
result = rule.JsonStr("ok", "", item_group);
}
}
catch (InsertPKException ex)
{
result = rule.JsonStr("error", "相同名称的分组已经存在,请输入其它名称", "");
}
catch (InsertException ex)
{
PageException pagex = new PageException(Convert.ToInt32(obj.UserID), ex.Message, "input", "AddItemProject", "");
result = rule.JsonStr("error", "项目分组信息写入数据库失败", "");
}
catch (Exception ex)
{
PageException pagex = new PageException(Convert.ToInt32(obj.UserID), ex.Message, "input", "AddItemProject", "");
result = rule.JsonStr("error", "新增项目分组失败", "");
}
}
else
{
result = rule.JsonStr("error", "fldobject参数错误", "");
}
}
else
{
result = rule.JsonStr("error", "flditemcontent参数错误", "请选择要保存在分组中的项目");
}
}
else
{
result = rule.JsonStr("error", "fldname参数错误", "请输入要保存的名称");
}
}
catch (Exception e)
{
result = rule.JsonStr("error", e.Message, "");
}
return(new HttpResponseMessage {
Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json")
});
}
