//[SupportFilter] public string Delete(dynamic obj) { try { if (obj.typemodel.ToString() == "eqise") { obj.typemodel = "eqiw_r"; } RuletblDictionary dic = new RuletblDictionary(); string list = dic.ByParentIDAndValue("数据审核视图", obj.typemodel.ToString()); string listone = list.Split(',')[0].ToString().Substring(2); string listones = listone.Substring(0, listone.Length - 7); string table = ""; if (obj.typemodel.ToString() == "eqib_v") { table = "tbl_" + listones; } else if (obj.typemodel.ToString() == "eqiw_r_auto") { table = "tblEQIW_R_Basedata_Pre_Auto"; } else { table = "tbl" + listones; } List <long> lstDelID = new List <long>(); string[] fld = obj.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(); bool isb = rule_basedata.delById(lstDelID, table); if (isb) { 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_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") }); }
// 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.fldPCode != null) { if (itemvalue.fldItemData.Count > 0) { List <tblEQIA_RPI_Basedata_Pre> lstData = new List <tblEQIA_RPI_Basedata_Pre>(); tblEQIA_RPI_Basedata_Pre objData = new tblEQIA_RPI_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.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 = "eqia_r"; 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.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()); } } tblEQIA_RPI_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); } } RuletblEQIA_RPI_Basedata_Pre rule_basedata = new RuletblEQIA_RPI_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_rPointInputController", "ItemSave", ""); result = rule.JsonStr("error", "数据写入数据库失败," + ex.Message, ""); } catch (Exception ex) { PageException pagex = new PageException(int.Parse(itemvalue.fldUserID), ex.Message, "Eqia_rPointInputController", "ItemSave", ""); result = rule.JsonStr("error", "数据保存时出现了错误," + ex.Message, ""); } return(new HttpResponseMessage { Content = new StringContent(result, 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("提交审核数据失败!"); } }