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")
});
}
