public HttpResponseMessage Delete_tblFWContact(Delete_tblFWContact_Info info) { string result = string.Empty; List <tblFWContact> list = new List <tblFWContact>(); int result2 = 0; try { using (LAPContext db = new LAPContext()) { list = (from x in db.tblFWContact where info.IDList.Contains(x.fldAutoID) select x).ToList(); db.tblFWContact.RemoveRange(list); result2 = db.SaveChanges(); } if (result2 > 0) { result = rule.JsonStr("ok", "", "删除了" + result2 + "条数据"); } else { result = rule.JsonStr("nodata", "没有可删除的数据!", ""); } } catch (Exception e) { result = rule.JsonStr("error", e.Message, ""); } return(new HttpResponseMessage { Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json") }); }
public HttpResponseMessage AddOrUpdate_tblFWContact(AddOrUpdate_tblFWContact_Info info) { string result = string.Empty; tblFWContact wc = new tblFWContact(); int result2 = 0; try { using (LAPContext db = new LAPContext()) { wc.fldAutoID = info.fldAutoID; wc.fldSTName = info.fldSTName; wc.fldName = info.fldName; wc.fldTittle = info.fldTittle; wc.fldWork = info.fldWork; wc.fldTel = info.fldTel; wc.fldQQ = info.fldQQ; wc.fldRemark = info.fldRemark; db.tblFWContact.AddOrUpdate(wc); result2 = db.SaveChanges(); } if (result2 > 0) { result = rule.JsonStr("ok", "", "新建成功!ID为:" + wc.fldAutoID); } else { result = rule.JsonStr("nodata", "未知错误!", ""); } } catch (Exception e) { result = rule.JsonStr("error", e.Message, ""); } return(new HttpResponseMessage { Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json") }); }
public HttpResponseMessage Query_tblFWContact(Query_tblFWContact_Info info) { string result = string.Empty; List <tblFWContact> list = new List <tblFWContact>(); try { using (LAPContext db = new LAPContext()) { if (info.fldSTName == null || info.fldName == null) { list = (from x in db.tblFWContact select x).ToList(); } else { list = (from x in db.tblFWContact where x.fldSTName == info.fldSTName && x.fldName == info.fldName select x).ToList(); } } if (list.Count() > 0) { result = rule.JsonStr("ok", "", list); } else { result = rule.JsonStr("nodata", "无数据!", ""); } } catch (Exception e) { result = rule.JsonStr("error", e.Message, ""); } return(new HttpResponseMessage { Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json") }); }
public HttpResponseMessage GetWaterSource(WaterSourceInfo info) { string result = string.Empty; try { List <tblEQIW_D_Point_Details> list_Details = new List <tblEQIW_D_Point_Details>(); List <tblEQIW_D_Point_Manage> list_Manage = new List <tblEQIW_D_Point_Manage>(); List <tblEQIW_D_MonitorSection> list_Section = new List <tblEQIW_D_MonitorSection>(); using (EntityContext db = new EntityContext()) { list_Details = (from x in db.tblEQIW_D_Point_Details select x).ToList(); list_Manage = (from x in db.tblEQIW_D_Point_Manage select x).ToList(); list_Section = (from x in db.tblEQIW_D_MonitorSection select x).ToList(); //根据水源地查询 if (info.fldSCategory != "" && info.fldSCategory != "全部") { list_Details = (from x in list_Details where x.fldSCategory == info.fldSCategory select x).ToList(); } //根据使用状态查询 if (info.fldState != "") { list_Details = (from x in list_Details where x.fldState == int.Parse(info.fldState) select x).ToList(); } //根据水源级别查询 if (info.fldLevel != "" && info.fldLevel != "全部") { list_Details = (from x in list_Details where x.fldLevel == info.fldLevel select x).ToList(); } //根据所属区县查询 if (info.fldRSTown != "" && info.fldRSTown != "全部") { list_Details = (from x in list_Details where x.fldRSTown == info.fldRSTown select x).ToList(); } //根据所属水系查询 if (info.fldWaterSys != "" && info.fldWaterSys != "全部") { list_Details = (from x in list_Details where x.fldFirstWaterSys == info.fldWaterSys select x).ToList(); } //根据达标状态查询 if (info.fldStand != "") { list_Details = (from x in list_Details where x.fldStand == int.Parse(info.fldStand) select x).ToList(); } //根据是否批复 if (info.fldReserveDelimit != "") { list_Manage = (from x in list_Manage where x.fldReserveDelimit == int.Parse(info.fldReserveDelimit) select x).ToList(); } //根据断面名称模糊查询 if (info.fldSectionName != "") { list_Details = (from x in list_Details join y in list_Section on x.fldAutoID equals y.fldFKID where y.fldSectionName.Contains(info.fldSectionName) select x).ToList(); } } string cityname = ""; int cityid = 0; using (LAPContext db = new LAPContext()) { if (info.fldusrid != 0) { var dt = db.tblFW_User.Join(db.tblFW_RegCity, m => m.fldCityID, f => f.fldAutoID, (m, f) => new { m.fldCityID, f.fldSTName, m.fldAutoID }).Where(e => e.fldAutoID == info.fldusrid).ToList(); if (dt.Count > 0) { cityname = dt[0].fldSTName; cityid = dt[0].fldCityID; } } } var query = (from x in list_Details group x by x.fldAutoID into g select new { detaillist = g, Managelist = (from y in list_Manage where y.fldFKID == g.Key select y).FirstOrDefault() }).ToList(); if (cityid != 0 && cityid != 2) { query = (from x in list_Details.Where(f => f.fldRSTown == cityname) group x by x.fldAutoID into g select new { detaillist = g, Managelist = (from y in list_Manage where y.fldFKID == g.Key select y).FirstOrDefault() }).ToList(); } if (query.Count > 0) { result = rule.JsonStr("ok", "", query); } else { result = rule.JsonStr("nodata", "没有数据!", ""); } } catch (Exception e) { result = rule.JsonStr("error", e.Message, ""); } return(new HttpResponseMessage { Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json") }); }