public HttpResponseMessage Get_Eqiw_STS_DataAndItem(Get_Eqiw_STS_DataAndItem_Info info)
{
string result = string.Empty;
try
{
List <tblEQIW_STS_Data> list = new List <tblEQIW_STS_Data>();
List <tblEQIW_STS_Data_Item> list_item = new List <tblEQIW_STS_Data_Item>();
Get_Eqiw_STS_DataAndItem_Return rt = new Get_Eqiw_STS_DataAndItem_Return();
using (EntityContext db = new EntityContext())
{
list = (from x in db.tblEQIW_STS_Data
select x).ToList();
if (info.fldBeginDate != null && info.fldEndDate != null)
{
list = (from x in db.tblEQIW_STS_Data
where x.fldDate >= info.fldBeginDate && x.fldDate <= info.fldEndDate
select x).ToList();
}
if (info.fldSTCode != null && info.fldSTCode != "")
{
list = (from x in list
where info.fldSTCode.Contains(x.fldTaskName + "." + x.fldSTName + "." + x.fldRName + "." + x.fldRSName)
select x).ToList();
}
if (list.Count > 0)
{
if (info.fldItemCode != null && info.fldItemCode != "")
{
list_item = (from x in db.tblEQIW_STS_Data_Item
where info.fldItemCode.Contains(x.fldItemCode)
select x).ToList();
}
else
{
list_item = (from x in db.tblEQIW_STS_Data_Item
select x).ToList();
}
list_item = (from x in list
join y in list_item
on x.fldAutoID equals y.fldFKID
select y).ToList();
}
}
rt.Data = list;
rt.Data_Item = list_item;
List <Get_Eqiw_STS_DataAndItem_Return_Name> list_name = new List <Get_Eqiw_STS_DataAndItem_Return_Name>();
list_name.Add(new Get_Eqiw_STS_DataAndItem_Return_Name()
{
ColName = "fldTaskName", ShowName = "课题名称"
});
list_name.Add(new Get_Eqiw_STS_DataAndItem_Return_Name()
{
ColName = "fldSTName", ShowName = "所属区县名称"
});
list_name.Add(new Get_Eqiw_STS_DataAndItem_Return_Name()
{
ColName = "fldRName", ShowName = "所在河流名称"
});
list_name.Add(new Get_Eqiw_STS_DataAndItem_Return_Name()
{
ColName = "fldRSName", ShowName = "点位名称"
});
list_name.Add(new Get_Eqiw_STS_DataAndItem_Return_Name()
{
ColName = "fldDate", ShowName = "时间"
});
list_name.Add(new Get_Eqiw_STS_DataAndItem_Return_Name()
{
ColName = "fldSAMPH", ShowName = "水平向代码"
});
list_name.Add(new Get_Eqiw_STS_DataAndItem_Return_Name()
{
ColName = "fldSAMPR", ShowName = "垂直向代码"
});
//list_name.Add(new Get_Eqiw_STS_DataAndItem_Return_Name() { ColName = "fldItemCode", ShowName = "项目代码" });
//list_name.Add(new Get_Eqiw_STS_DataAndItem_Return_Name() { ColName = "fldItemName", ShowName = "项目名称" });
//list_name.Add(new Get_Eqiw_STS_DataAndItem_Return_Name() { ColName = "Value", ShowName = "项目值" });
rt.NameList = list_name;
result = rule.JsonStr("ok", "", rt);
}
catch (Exception e)
{
result = rule.JsonStr("error", e.Message, "");
}
return(new HttpResponseMessage {
Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json")
});
}
public HttpResponseMessage Get_Eqiw_STS_DataAndItem_WithObject(Get_Eqiw_STS_DataAndItem_WithObject_Info info)
{
string result = string.Empty;
try
{
List <tblEQIW_STS_Data> list = new List <tblEQIW_STS_Data>();
List <tblEQIW_STS_Data_Item> list_item = new List <tblEQIW_STS_Data_Item>();
Get_Eqiw_STS_DataAndItem_Return rt = new Get_Eqiw_STS_DataAndItem_Return();
using (EntityContext db = new EntityContext())
{
list = (from x in db.tblEQIW_STS_Data
select x).ToList();
if (info.fldBeginDate != null && info.fldEndDate != null)
{
list = (from x in db.tblEQIW_STS_Data
where x.fldDate >= info.fldBeginDate && x.fldDate <= info.fldEndDate
select x).ToList();
}
var temp = (from x in list
where x.fldTaskName.Contains(info.fldObject) ||
x.fldSTName.Contains(info.fldObject) ||
x.fldRName.Contains(info.fldObject) ||
x.fldRSName.Contains(info.fldObject)
select x).ToList();
if (temp.Count > 0)
{
list_item = (from x in db.tblEQIW_STS_Data_Item
select x).ToList();
list_item = (from x in temp
join y in list_item
on x.fldAutoID equals y.fldFKID
select y).ToList();
}
else
{
list_item = (from x in db.tblEQIW_STS_Data_Item
where x.fldItemName.Contains(info.fldObject)
select x).ToList();
list_item = (from x in list
join y in list_item
on x.fldAutoID equals y.fldFKID
select y).ToList();
}
}
rt.Data = list;
rt.Data_Item = list_item;
result = rule.JsonStr("ok", "", rt);
}
catch (Exception e)
{
result = rule.JsonStr("error", e.Message, "");
}
return(new HttpResponseMessage {
Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json")
});
}
