public HttpResponseMessage AddWaterSource(tblEQIW_D_Point_Details info)
{
string result = string.Empty;
var ret = 0;
try
{
using (EntityContext db = new EntityContext())
{
db.tblEQIW_D_Point_Details.Add(info);
ret = db.SaveChanges();
}
if (ret <= 0)
{
result = rule.JsonStr("error", "添加失败！", ret);
}
else
{
result = rule.JsonStr("ok", "", info);
}
}
catch (Exception e)
{
result = rule.JsonStr("error", e.Message, "");
}
return(new HttpResponseMessage {
Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json")
});
}
public HttpResponseMessage GetUpdateWaterSource(GetUpdateWaterSourceInfo info)
{
string result = string.Empty;
var ret = 0;
try
{
tblEQIW_D_Point_Details detailsInfo = new tblEQIW_D_Point_Details();
using (EntityContext db = new EntityContext())
{
detailsInfo = (from x in db.tblEQIW_D_Point_Details
where x.fldAutoID == info.fldAutoID
select x).FirstOrDefault();
detailsInfo.fldWSCode = info.fldWSCode;
detailsInfo.fldWSName = info.fldWSName;
detailsInfo.fldAliasName = info.fldAliasName;
detailsInfo.fldSCategory = info.fldSCategory;
detailsInfo.fldState = short.Parse(info.fldState.ToString());
detailsInfo.fldLevel = info.fldLevel;
detailsInfo.fldRSTown = info.fldRSTown;
detailsInfo.fldAddress = info.fldAddress;
detailsInfo.fldLongitude = info.fldLongitude;
detailsInfo.fldLatitude = info.fldLatitude;
detailsInfo.fldSynopsis = info.fldSynopsis;
detailsInfo.fldFirstWaterSys = info.fldFirstWaterSys;
detailsInfo.fldSecondWaterSys = info.fldSecondWaterSys;
detailsInfo.fldThirdWaterSys = info.fldThirdWaterSys;
detailsInfo.fldProvideType = info.fldProvideType;
detailsInfo.fldStand = info.fldStand;
detailsInfo.fldServicePeople = info.fldServicePeople;
detailsInfo.fldSupplyWater = info.fldSupplyWater;
detailsInfo.fldDesignQuantity = info.fldDesignQuantity;
detailsInfo.fldActualQuantity = info.fldActualQuantity;
detailsInfo.fldBuildYear = info.fldBuildYear;
db.tblEQIW_D_Point_Details.AddOrUpdate(detailsInfo);
ret = db.SaveChanges();
}
if (ret <= 0)
{
result = rule.JsonStr("error", "修改失败！", "");
}
else
{
result = rule.JsonStr("ok", "", detailsInfo);
}
}
catch (Exception e)
{
result = rule.JsonStr("error", e.Message, "");
}
return(new HttpResponseMessage {
Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json")
});
}
public HttpResponseMessage GetEQIW_D_Point_Details(GetEQIW_D_Point_DetailsInfo info)
{
string result = string.Empty;
try
{
tblEQIW_D_Point_Details list_Details = new tblEQIW_D_Point_Details();
List <tblEQIW_D_Waterworks> list_Works = new List <tblEQIW_D_Waterworks>();
List <tblEQIW_D_WaterIntake> list_Intake = new List <tblEQIW_D_WaterIntake>();
List <tblEQIW_D_MonitorSection> list_Section = new List <tblEQIW_D_MonitorSection>();
RetuenEQIW_D_Point_Details return_list = new RetuenEQIW_D_Point_Details();
using (EntityContext db = new EntityContext())
{
list_Details = (from x in db.tblEQIW_D_Point_Details
where x.fldAutoID == info.fldAutoID
select x).FirstOrDefault();
if (list_Details != null)
{
list_Works = (from x in db.tblEQIW_D_Waterworks
where x.fldFKID == list_Details.fldAutoID
select x).ToList();
list_Intake = (from x in db.tblEQIW_D_WaterIntake
where x.fldFKID == list_Details.fldAutoID
select x).ToList();
list_Section = (from x in db.tblEQIW_D_MonitorSection
where x.fldFKID == list_Details.fldAutoID
select x).ToList();
}
}
return_list.deInfo = list_Details;
return_list.woList = list_Works;
return_list.inList = list_Intake;
return_list.seList = list_Section;
if (list_Details != null)
{
result = rule.JsonStr("ok", "", return_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")
});
}