public HttpResponseMessage GetData_EQIA_R(Info_EQIA_R info)
{
string result = null;
try
{
DateTime BeginDate = DateTime.Parse(info.fldBeginDate);
DateTime EndDate = DateTime.Parse(info.fldEndDate);
using (MiddleContext db = new MiddleContext())
{
List <tblHM_EQIA_R_Midd> query = new List <tblHM_EQIA_R_Midd>();
query = (from x in db.tblHM_EQIA_R_Midd
select x).ToList();
ReturnData3 rd = new ReturnData3();
rd.dangqi = query;
if (info.IsYear == "1")
{
int year = int.Parse(info.fldYear) - 1;
List <tblHM_EQIA_R_Midd> query2 = new List <tblHM_EQIA_R_Midd>();
query2 = (from x in db.tblHM_EQIA_R_Midd
select x).ToList();
rd.tongqi = query2;
}
result = rule.JsonStr("ok", "", rd);
}
}
catch (Exception e)
{
result = rule.JsonStr("error", e.Message, "");
}
return(new HttpResponseMessage {
Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json")
});
}
public HttpResponseMessage GetData(Info info)
{
string result = null;
try
{
if (info.type == "City_DayStat")
{
using (MiddleContext db = new MiddleContext())
{
List <tblV_EQIA_R_City_DayStat_Midd> query = new List <tblV_EQIA_R_City_DayStat_Midd>();
List <tblV_EQIA_R_City_DayStat_Item_Midd> query_Item = new List <tblV_EQIA_R_City_DayStat_Item_Midd>();
DateTime BeginDate = DateTime.Parse(info.fldBeginDate);
DateTime EndDate = DateTime.Parse(info.fldEndDate);
if (info.fldSTCode == "-1")
{
query = (from x in db.tblV_EQIA_R_City_DayStat_Midd
where x.fldAppDate >= BeginDate &&
x.fldAppDate <= EndDate
select x).ToList();
}
else
{
query = (from x in db.tblV_EQIA_R_City_DayStat_Midd
where info.fldSTCode.Contains(x.fldSTCode) &&
x.fldAppDate >= BeginDate &&
x.fldAppDate <= EndDate
select x).ToList();
}
if (info.fldItemCode != null)
{
query_Item = (from x in query
join y in db.tblV_EQIA_R_City_DayStat_Item_Midd
on new { x.fldSTCode, x.fldAppDate }
equals new { y.fldSTCode, y.fldAppDate }
select y).ToList();
if (info.fldItemCode != "All")
{
string[] ItemCodeList = info.fldItemCode.Split(',');
query_Item = (from x in query_Item
where ItemCodeList.Contains(x.fldItemCode)
select x).ToList();
}
}
ReturnData rd = new ReturnData();
rd.dangqi = query;
rd.dangqi_Item = query_Item;
if (info.IsYear == "1")
{
List <tblV_EQIA_R_City_DayStat_Midd> query2 = new List <tblV_EQIA_R_City_DayStat_Midd>();
List <tblV_EQIA_R_City_DayStat_Item_Midd> query_Item2 = new List <tblV_EQIA_R_City_DayStat_Item_Midd>();
BeginDate = BeginDate.AddYears(-1);
EndDate = EndDate.AddYears(-1);
if (info.fldSTCode == "-1")
{
query2 = (from x in db.tblV_EQIA_R_City_DayStat_Midd
where x.fldAppDate >= BeginDate &&
x.fldAppDate <= EndDate
select x).ToList();
}
else
{
query2 = (from x in db.tblV_EQIA_R_City_DayStat_Midd
where info.fldSTCode.Contains(x.fldSTCode) &&
x.fldAppDate >= BeginDate &&
x.fldAppDate <= EndDate
select x).ToList();
}
if (info.fldItemCode != null)
{
query_Item2 = (from x in query
join y in db.tblV_EQIA_R_City_DayStat_Item_Midd
on new { x.fldSTCode, x.fldAppDate }
equals new { y.fldSTCode, y.fldAppDate }
select y).ToList();
if (info.fldItemCode != "All")
{
string[] ItemCodeList = info.fldItemCode.Split(',');
query_Item2 = (from x in query_Item2
where ItemCodeList.Contains(x.fldItemCode)
select x).ToList();
}
}
rd.tongqi = query2;
rd.tongqi_Item = query_Item2;
}
result = rule.JsonStr("ok", "", rd);
}
}
if (info.type == "City_TotalDateStat")
{
using (MiddleContext db = new MiddleContext())
{
List <tblV_EQIA_R_City_TotalDateStat_Midd> query = new List <tblV_EQIA_R_City_TotalDateStat_Midd>();
List <tblV_EQIA_R_City_TotalDateStat_Item_Midd> query_Item = new List <tblV_EQIA_R_City_TotalDateStat_Item_Midd>();
DateTime BeginDate = DateTime.Parse(info.fldBeginDate);
DateTime EndDate = DateTime.Parse(info.fldEndDate);
List <string> list = ConvertDate(info.fldTimeType, BeginDate, EndDate);
if (info.fldSTCode == "-1")
{
query = (from x in db.tblV_EQIA_R_City_TotalDateStat_Midd
where x.fldTimeType == info.fldTimeType &&
list.Contains(x.fldAppDate)
select x).ToList();
}
else
{
query = (from x in db.tblV_EQIA_R_City_TotalDateStat_Midd
where x.fldTimeType == info.fldTimeType &&
list.Contains(x.fldAppDate) &&
info.fldSTCode.Contains(x.fldSTCode)
select x).ToList();
}
if (info.fldItemCode != null)
{
query_Item = (from x in query
join y in db.tblV_EQIA_R_City_TotalDateStat_Item_Midd
on new { x.fldSTCode, x.fldAppDate, x.fldTimeType }
equals new { y.fldSTCode, y.fldAppDate, y.fldTimeType }
select y).ToList();
if (info.fldItemCode != "All")
{
string[] ItemCodeList = info.fldItemCode.Split(',');
query_Item = (from x in query_Item
where ItemCodeList.Contains(x.fldItemCode)
select x).ToList();
}
}
ReturnData1 rd = new ReturnData1();
rd.dangqi = query;
rd.dangqi_Item = query_Item;
if (info.IsYear == "1")
{
List <tblV_EQIA_R_City_TotalDateStat_Midd> query2 = new List <tblV_EQIA_R_City_TotalDateStat_Midd>();
List <tblV_EQIA_R_City_TotalDateStat_Item_Midd> query_Item2 = new List <tblV_EQIA_R_City_TotalDateStat_Item_Midd>();
BeginDate = BeginDate.AddYears(-1);
EndDate = EndDate.AddYears(-1);
list = ConvertDate(info.fldTimeType, BeginDate, EndDate);
if (info.fldSTCode == "-1")
{
query2 = (from x in db.tblV_EQIA_R_City_TotalDateStat_Midd
where x.fldTimeType == info.fldTimeType &&
list.Contains(x.fldAppDate)
select x).ToList();
}
else
{
query2 = (from x in db.tblV_EQIA_R_City_TotalDateStat_Midd
where x.fldTimeType == info.fldTimeType &&
list.Contains(x.fldAppDate) &&
info.fldSTCode.Contains(x.fldSTCode)
select x).ToList();
}
if (info.fldItemCode != null)
{
query_Item2 = (from x in query
join y in db.tblV_EQIA_R_City_TotalDateStat_Item_Midd
on new { x.fldSTCode, x.fldAppDate, x.fldTimeType }
equals new { y.fldSTCode, y.fldAppDate, y.fldTimeType }
select y).ToList();
if (info.fldItemCode != "All")
{
string[] ItemCodeList = info.fldItemCode.Split(',');
query_Item2 = (from x in query_Item2
where ItemCodeList.Contains(x.fldItemCode)
select x).ToList();
}
}
rd.tongqi = query2;
rd.tongqi_Item = query_Item2;
}
result = rule.JsonStr("ok", "", rd);
}
}
if (info.type == "Point_DayStat")
{
using (MiddleContext db = new MiddleContext())
{
List <tblV_EQIA_R_Point_DayStat_Midd> query = new List <tblV_EQIA_R_Point_DayStat_Midd>();
List <tblV_EQIA_R_Point_DayStat_Item_Midd> query_Item = new List <tblV_EQIA_R_Point_DayStat_Item_Midd>();
DateTime BeginDate = DateTime.Parse(info.fldBeginDate);
DateTime EndDate = DateTime.Parse(info.fldEndDate);
List <string> list = ConvertDate(info.fldTimeType, BeginDate, EndDate);
if (info.fldSTCode == "-1")
{
query = (from x in db.tblV_EQIA_R_Point_DayStat_Midd
where x.fldAppDate >= BeginDate &&
x.fldAppDate <= EndDate
select x).ToList();
}
else
{
query = (from x in db.tblV_EQIA_R_Point_DayStat_Midd
where info.fldSTCode.Contains(x.fldSTCode + "." + x.fldPCode) &&
x.fldAppDate >= BeginDate &&
x.fldAppDate <= EndDate
select x).ToList();
}
if (info.fldItemCode != null)
{
query_Item = (from x in query
join y in db.tblV_EQIA_R_Point_DayStat_Item_Midd
on new { x.fldSTCode, x.fldPCode, x.fldAppDate }
equals new { y.fldSTCode, y.fldPCode, y.fldAppDate }
select y).ToList();
if (info.fldItemCode != "All")
{
string[] ItemCodeList = info.fldItemCode.Split(',');
query_Item = (from x in query_Item
where ItemCodeList.Contains(x.fldItemCode)
select x).ToList();
}
}
ReturnData2 rd = new ReturnData2();
rd.dangqi = query;
rd.dangqi_Item = query_Item;
if (info.IsYear == "1")
{
List <tblV_EQIA_R_Point_DayStat_Midd> query2 = new List <tblV_EQIA_R_Point_DayStat_Midd>();
List <tblV_EQIA_R_Point_DayStat_Item_Midd> query_Item2 = new List <tblV_EQIA_R_Point_DayStat_Item_Midd>();
BeginDate = BeginDate.AddYears(-1);
EndDate = EndDate.AddYears(-1);
list = ConvertDate(info.fldTimeType, BeginDate, EndDate);
if (info.fldSTCode == "-1")
{
query2 = (from x in db.tblV_EQIA_R_Point_DayStat_Midd
where x.fldAppDate >= BeginDate &&
x.fldAppDate <= EndDate
select x).ToList();
}
else
{
query2 = (from x in db.tblV_EQIA_R_Point_DayStat_Midd
where info.fldSTCode.Contains(x.fldSTCode + "." + x.fldPCode) &&
x.fldAppDate >= BeginDate &&
x.fldAppDate <= EndDate
select x).ToList();
}
if (info.fldItemCode != null)
{
query_Item2 = (from x in query
join y in db.tblV_EQIA_R_Point_DayStat_Item_Midd
on new { x.fldSTCode, x.fldPCode, x.fldAppDate }
equals new { y.fldSTCode, y.fldPCode, y.fldAppDate }
select y).ToList();
if (info.fldItemCode != "All")
{
string[] ItemCodeList = info.fldItemCode.Split(',');
query_Item2 = (from x in query_Item2
where ItemCodeList.Contains(x.fldItemCode)
select x).ToList();
}
}
rd.tongqi = query2;
rd.tongqi_Item = query_Item2;
}
result = rule.JsonStr("ok", "", rd);
}
}
if (info.type == "Point_TotalDateStat")
{
using (MiddleContext db = new MiddleContext())
{
List <tblV_EQIA_R_Point_TotalDateStat_Midd> query = new List <tblV_EQIA_R_Point_TotalDateStat_Midd>();
List <tblV_EQIA_R_Point_TotalDateStat_Item_Midd> query_Item = new List <tblV_EQIA_R_Point_TotalDateStat_Item_Midd>();
DateTime BeginDate = DateTime.Parse(info.fldBeginDate);
DateTime EndDate = DateTime.Parse(info.fldEndDate);
List <string> list = ConvertDate(info.fldTimeType, BeginDate, EndDate);
if (info.fldSTCode == "-1")
{
query = (from x in db.tblV_EQIA_R_Point_TotalDateStat_Midd
where list.Contains(x.fldAppDate)
select x).ToList();
}
else
{
query = (from x in db.tblV_EQIA_R_Point_TotalDateStat_Midd
where info.fldSTCode.Contains(x.fldSTCode + "." + x.fldPCode) &&
list.Contains(x.fldAppDate)
select x).ToList();
}
if (info.fldItemCode != null)
{
query_Item = (from x in query
join y in db.tblV_EQIA_R_Point_TotalDateStat_Item_Midd
on new { x.fldSTCode, x.fldPCode, x.fldAppDate }
equals new { y.fldSTCode, y.fldPCode, y.fldAppDate }
select y).ToList();
if (info.fldItemCode != "All")
{
string[] ItemCodeList = info.fldItemCode.Split(',');
query_Item = (from x in query_Item
where ItemCodeList.Contains(x.fldItemCode)
select x).ToList();
}
}
ReturnData3 rd = new ReturnData3();
rd.dangqi = query;
rd.dangqi_Item = query_Item;
if (info.IsYear == "1")
{
List <tblV_EQIA_R_Point_TotalDateStat_Midd> query2 = new List <tblV_EQIA_R_Point_TotalDateStat_Midd>();
List <tblV_EQIA_R_Point_TotalDateStat_Item_Midd> query_Item2 = new List <tblV_EQIA_R_Point_TotalDateStat_Item_Midd>();
BeginDate = BeginDate.AddYears(-1);
EndDate = EndDate.AddYears(-1);
list = ConvertDate(info.fldTimeType, BeginDate, EndDate);
if (info.fldSTCode == "-1")
{
query2 = (from x in db.tblV_EQIA_R_Point_TotalDateStat_Midd
where list.Contains(x.fldAppDate)
select x).ToList();
}
else
{
query2 = (from x in db.tblV_EQIA_R_Point_TotalDateStat_Midd
where info.fldSTCode.Contains(x.fldSTCode + "." + x.fldPCode) &&
list.Contains(x.fldAppDate)
select x).ToList();
}
if (info.fldItemCode != null)
{
query_Item2 = (from x in query
join y in db.tblV_EQIA_R_Point_TotalDateStat_Item_Midd
on new { x.fldSTCode, x.fldPCode, x.fldAppDate }
equals new { y.fldSTCode, y.fldPCode, y.fldAppDate }
select y).ToList();
if (info.fldItemCode != "All")
{
string[] ItemCodeList = info.fldItemCode.Split(',');
query_Item2 = (from x in query_Item2
where ItemCodeList.Contains(x.fldItemCode)
select x).ToList();
}
}
rd.tongqi = query2;
rd.tongqi_Item = query_Item2;
}
result = rule.JsonStr("ok", "", rd);
}
}
}
catch (Exception e)
{
result = rule.JsonStr("error", e.Message, "");
}
return(new HttpResponseMessage {
Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json")
});
}
public HttpResponseMessage GetData(Info info)
{
string result = null;
try
{
List <string> YearList = info.fldYear.Split(',').ToList();
if (info.type == "City_TotalDateStat")
{
using (MiddleContext db = new MiddleContext())
{
List <tblEQIN_A_City_TotalDateStat_Midd> query;
if (info.fldSTCode == "-1")
{
query = (from x in db.tblEQIN_A_City_TotalDateStat_Midd
where YearList.Contains(x.fldYear) &&
x.ReportType == info.ReportType &&
x.STatType == info.STatType
select x).ToList();
}
else
{
query = (from x in db.tblEQIN_A_City_TotalDateStat_Midd
where info.fldSTCode.Contains(x.fldSTCode) &&
YearList.Contains(x.fldYear) &&
x.ReportType == info.ReportType &&
x.STatType == info.STatType
select x).ToList();
}
ReturnData rd = new ReturnData();
rd.dangqi = query;
if (info.IsYear == "1" && YearList.Count == 1)
{
int year = int.Parse(info.fldYear) - 1;
List <tblEQIN_A_City_TotalDateStat_Midd> query2;
if (info.fldSTCode == "-1")
{
query2 = (from x in db.tblEQIN_A_City_TotalDateStat_Midd
where x.fldYear == year.ToString() &&
x.ReportType == info.ReportType &&
x.STatType == info.STatType
select x).ToList();
}
else
{
query2 = (from x in db.tblEQIN_A_City_TotalDateStat_Midd
where info.fldSTCode.Contains(x.fldSTCode) &&
x.fldYear == year.ToString() &&
x.ReportType == info.ReportType &&
x.STatType == info.STatType
select x).ToList();
}
rd.tongqi = query2;
}
result = rule.JsonStr("ok", "", rd);
}
}
else if (info.type == "Point_HourStat")
{
using (MiddleContext db = new MiddleContext())
{
DateTime fldBeginDate = DateTime.Parse(info.fldBeginDate);
DateTime fldEndDate = DateTime.Parse(info.fldEndDate);
List <tblEQIN_A_Point_HourStat_Midd> query;
if (info.fldSTCode == "-1" && info.fldGDCode == "-1")
{
query = (from x in db.tblEQIN_A_Point_HourStat_Midd
where x.fldappdate >= fldBeginDate &&
x.fldappdate <= fldEndDate
select x).ToList();
}
else if (info.fldSTCode != "-1")
{
query = (from x in db.tblEQIN_A_Point_HourStat_Midd
where info.fldSTCode.Contains(x.fldSTCode) &&
x.fldappdate >= fldBeginDate &&
x.fldappdate <= fldEndDate
select x).ToList();
}
else
{
query = (from x in db.tblEQIN_A_Point_HourStat_Midd
where info.fldSTCode.Contains(x.fldSTCode) &&
info.fldGDCode.Contains(x.fldGDCode) &&
x.fldappdate >= fldBeginDate &&
x.fldappdate <= fldEndDate
select x).ToList();
}
result = rule.JsonStr("ok", "", query);
}
}
else if (info.type == "Point_TotalDateStat")
{
using (MiddleContext db = new MiddleContext())
{
List <tblEQIN_A_Point_TotalDateStat_Midd> query;
if (info.fldSTCode == "-1" && info.fldGDCode == "-1")
{
query = (from x in db.tblEQIN_A_Point_TotalDateStat_Midd
where YearList.Contains(x.fldYear)
select x).ToList();
}
else
{
List <string> pointlist = new List <string>();
pointlist = info.PointFormat.Split(',').ToList();
query = (from x in db.tblEQIN_A_Point_TotalDateStat_Midd
where pointlist.Contains(x.fldSTCode.ToString() + "." + x.fldGDCode.ToString()) &&
YearList.Contains(x.fldYear)
select x).ToList();
}
ReturnData1 rd = new ReturnData1();
rd.dangqi = query;
if (info.IsYear == "1" && YearList.Count == 1)
{
int year = int.Parse(info.fldYear) - 1;
List <tblEQIN_A_Point_TotalDateStat_Midd> query2;
if (info.fldSTCode == "-1" && info.fldGDCode == "-1")
{
query2 = (from x in db.tblEQIN_A_Point_TotalDateStat_Midd
where x.fldYear == year.ToString()
select x).ToList();
}
else
{
List <string> pointlist = new List <string>();
pointlist = info.PointFormat.Split(',').ToList();
query2 = (from x in db.tblEQIN_A_Point_TotalDateStat_Midd
where pointlist.Contains(x.fldSTCode.ToString() + "." + x.fldGDCode.ToString()) &&
x.fldYear == year.ToString()
select x).ToList();
}
rd.tongqi = query2;
}
result = rule.JsonStr("ok", "", rd);
}
}
else if (info.type == "City_AverageData")
{
using (MiddleContext db = new MiddleContext())
{
List <tblEQIN_A_City_AverageData_Midd> query;
if (info.fldSTCode == "-1")
{
query = (from x in db.tblEQIN_A_City_AverageData_Midd
where YearList.Contains(x.fldYear) &&
x.ReportType == info.ReportType
select x).ToList();
}
else
{
query = (from x in db.tblEQIN_A_City_AverageData_Midd
where info.fldSTCode.Contains(x.fldSTCode) &&
YearList.Contains(x.fldYear) &&
x.ReportType == info.ReportType
select x).ToList();
}
ReturnData2 rd = new ReturnData2();
rd.dangqi = query;
if (info.IsYear == "1" && YearList.Count == 1)
{
int year = int.Parse(info.fldYear) - 1;
List <tblEQIN_A_City_AverageData_Midd> query2;
if (info.fldSTCode == "-1")
{
query2 = (from x in db.tblEQIN_A_City_AverageData_Midd
where x.fldYear == year.ToString() &&
x.ReportType == info.ReportType
select x).ToList();
}
else
{
query2 = (from x in db.tblEQIN_A_City_AverageData_Midd
where info.fldSTCode.Contains(x.fldSTCode) &&
x.fldYear == year.ToString() &&
x.ReportType == info.ReportType
select x).ToList();
}
rd.tongqi = query2;
}
result = rule.JsonStr("ok", "", rd);
}
}
else if (info.type == "City_ProvinceData")
{
using (MiddleContext db = new MiddleContext())
{
var query = (from x in db.tblEQIN_A_City_ProvinceData_Midd
where YearList.Contains(x.fldYear) &&
x.STatType == info.STatType
select x).ToList();
ReturnData3 rd = new ReturnData3();
rd.dangqi = query;
if (info.IsYear == "1" && YearList.Count == 1)
{
int year = int.Parse(info.fldYear) - 1;
var query2 = (from x in db.tblEQIN_A_City_ProvinceData_Midd
where x.fldYear == year.ToString() &&
x.STatType == info.STatType
select x).ToList();
rd.tongqi = query2;
}
result = rule.JsonStr("ok", "", rd);
}
}
}
catch (Exception e)
{
result = rule.JsonStr("error", e.Message, "");
}
return(new HttpResponseMessage {
Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json")
});
}
public HttpResponseMessage GetData(Info info)
{
string result = null;
try
{
if (info.type == "ItemOverStat")
{
using (MiddleContext db = new MiddleContext())
{
List <tblEQIW_R_ItemOverStat_Midd> query = new List <tblEQIW_R_ItemOverStat_Midd>();
DateTime BeginDate = DateTime.Parse(info.fldBeginDate);
DateTime EndDate = DateTime.Parse(info.fldEndDate);
List <string> list = ConvertDate(info.fldTimeType, BeginDate, EndDate);
query = (from x in db.tblEQIW_R_ItemOverStat_Midd
where x.fldTimeType == info.fldTimeType &&
x.fldValueType == info.fldValueType &&
list.Contains(x.fldAppDate)
select x).ToList();
ReturnData rd = new ReturnData();
rd.dangqi = query;
if (info.IsYear == "1")
{
List <tblEQIW_R_ItemOverStat_Midd> query2 = new List <tblEQIW_R_ItemOverStat_Midd>();
query2 = (from x in db.tblEQIW_R_ItemOverStat_Midd
where x.fldTimeType == info.fldTimeType &&
x.fldValueType == info.fldValueType &&
list.Contains(x.fldAppDate)
select x).ToList();
rd.tongqi = query2;
}
result = rule.JsonStr("ok", "", rd);
}
}
if (info.type == "SectionStat")
{
using (MiddleContext db = new MiddleContext())
{
List <tblEQIW_R_SectionStat_Midd> query = new List <tblEQIW_R_SectionStat_Midd>();
List <tblEQIW_R_SectionStat_Item_Midd> query_Item = new List <tblEQIW_R_SectionStat_Item_Midd>();
DateTime BeginDate = DateTime.Parse(info.fldBeginDate);
DateTime EndDate = DateTime.Parse(info.fldEndDate);
List <string> list = ConvertDate(info.fldTimeType, BeginDate, EndDate);
if (info.fldSTCode == "-1")
{
query = (from x in db.tblEQIW_R_SectionStat_Midd
where x.fldTimeType == info.fldTimeType &&
list.Contains(x.fldAppDate)
select x).ToList();
}
else
{
query = (from x in db.tblEQIW_R_SectionStat_Midd
where x.fldTimeType == info.fldTimeType &&
list.Contains(x.fldAppDate) &&
info.fldSTCode.Contains(x.fldSTCode)
select x).ToList();
}
if (info.fldItemCode != null)
{
query_Item = (from x in query
join y in db.tblEQIW_R_SectionStat_Item_Midd
on x.fldAutoID equals y.fldFKID
select y).ToList();
if (info.fldItemCode != "All")
{
string[] ItemCodeList = info.fldItemCode.Split(',');
query_Item = (from x in query_Item
where ItemCodeList.Contains(x.fldItemCode)
select x).ToList();
}
}
ReturnData1 rd = new ReturnData1();
rd.dangqi = query;
rd.dangqi_Item = query_Item;
if (info.IsYear == "1")
{
List <tblEQIW_R_SectionStat_Midd> query2 = new List <tblEQIW_R_SectionStat_Midd>();
List <tblEQIW_R_SectionStat_Item_Midd> query_Item2 = new List <tblEQIW_R_SectionStat_Item_Midd>();
BeginDate = BeginDate.AddYears(-1);
EndDate = EndDate.AddYears(-1);
list = ConvertDate(info.fldTimeType, BeginDate, EndDate);
if (info.fldSTCode == "-1")
{
query2 = (from x in db.tblEQIW_R_SectionStat_Midd
where x.fldTimeType == info.fldTimeType &&
list.Contains(x.fldAppDate)
select x).ToList();
}
else
{
query2 = (from x in db.tblEQIW_R_SectionStat_Midd
where x.fldTimeType == info.fldTimeType &&
list.Contains(x.fldAppDate) &&
info.fldSTCode.Contains(x.fldSTCode)
select x).ToList();
}
if (info.fldItemCode != null)
{
query_Item2 = (from x in query2
join y in db.tblEQIW_R_SectionStat_Item_Midd
on x.fldAutoID equals y.fldFKID
select y).ToList();
if (info.fldItemCode != "All")
{
string[] ItemCodeList = info.fldItemCode.Split(',');
query_Item2 = (from x in query_Item2
where ItemCodeList.Contains(x.fldItemCode)
select x).ToList();
}
}
rd.tongqi = query2;
rd.tongqi_Item = query_Item2;
}
result = rule.JsonStr("ok", "", rd);
}
}
if (info.type == "TatalSectStat")
{
using (MiddleContext db = new MiddleContext())
{
List <tblEQIW_R_TatalSectStat_Midd> query = new List <tblEQIW_R_TatalSectStat_Midd>();
List <tblEQIW_R_TatalSectStat_Item_Midd> query_Item = new List <tblEQIW_R_TatalSectStat_Item_Midd>();
DateTime BeginDate = DateTime.Parse(info.fldBeginDate);
DateTime EndDate = DateTime.Parse(info.fldEndDate);
List <string> list = ConvertDate(info.fldTimeType, BeginDate, EndDate);
query = (from x in db.tblEQIW_R_TatalSectStat_Midd
where x.fldTimeType == info.fldTimeType &&
list.Contains(x.fldAppDate) &&
x.fldSpaceType == info.fldSpaceType
select x).ToList();
if (info.fldItemCode != null && info.fldItemCode != "null")
{
query_Item = (from x in query
join y in db.tblEQIW_R_TatalSectStat_Item_Midd
on x.fldAutoID equals y.fldFKID
select y).ToList();
if (info.fldItemCode != "All")
{
string[] ItemCodeList = info.fldItemCode.Split(',');
query_Item = (from x in query_Item
where ItemCodeList.Contains(x.fldItemCode)
select x).ToList();
}
}
ReturnData2 rd = new ReturnData2();
rd.dangqi = query;
rd.dangqi_Item = query_Item;
if (info.IsYear == "1")
{
List <tblEQIW_R_TatalSectStat_Midd> query2 = new List <tblEQIW_R_TatalSectStat_Midd>();
List <tblEQIW_R_TatalSectStat_Item_Midd> query_Item2 = new List <tblEQIW_R_TatalSectStat_Item_Midd>();
BeginDate = BeginDate.AddYears(-1);
EndDate = EndDate.AddYears(-1);
list = ConvertDate(info.fldTimeType, BeginDate, EndDate);
query2 = (from x in db.tblEQIW_R_TatalSectStat_Midd
where x.fldTimeType == info.fldTimeType &&
list.Contains(x.fldAppDate) &&
x.fldSpaceType == info.fldSpaceType
select x).ToList();
if (info.fldItemCode != null && info.fldItemCode != "null")
{
query_Item2 = (from x in query2
join y in db.tblEQIW_R_TatalSectStat_Item_Midd
on x.fldAutoID equals y.fldFKID
select y).ToList();
if (info.fldItemCode != "All")
{
string[] ItemCodeList = info.fldItemCode.Split(',');
query_Item2 = (from x in query_Item2
where ItemCodeList.Contains(x.fldItemCode)
select x).ToList();
}
}
rd.tongqi = query2;
rd.tongqi_Item = query_Item2;
}
result = rule.JsonStr("ok", "", rd);
}
}
if (info.type == "STAData")
{
using (MiddleContext db = new MiddleContext())
{
List <tblEQIW_R_STAData_MIdd> query = new List <tblEQIW_R_STAData_MIdd>();
DateTime BeginDate = DateTime.Parse(info.fldBeginDate);
DateTime EndDate = DateTime.Parse(info.fldEndDate);
query = (from x in db.tblEQIW_R_STAData_MIdd
where DateTime.Parse(x.fldYear + "-" + x.fldMonth + "-" + x.fldDay) >= BeginDate &&
DateTime.Parse(x.fldYear + "-" + x.fldMonth + "-" + x.fldDay) <= BeginDate
select x).ToList();
ReturnData3 rd = new ReturnData3();
rd.dangqi = query;
if (info.IsYear == "1")
{
List <tblEQIW_R_STAData_MIdd> query2 = new List <tblEQIW_R_STAData_MIdd>();
BeginDate = BeginDate.AddYears(-1);
EndDate = EndDate.AddYears(-1);
query2 = (from x in db.tblEQIW_R_STAData_MIdd
where DateTime.Parse(x.fldYear + "-" + x.fldMonth + "-" + x.fldDay) >= BeginDate &&
DateTime.Parse(x.fldYear + "-" + x.fldMonth + "-" + x.fldDay) <= BeginDate
select x).ToList();
rd.tongqi = query2;
}
result = rule.JsonStr("ok", "", rd);
}
}
}
catch (Exception e)
{
result = rule.JsonStr("error", e.Message, "");
}
return(new HttpResponseMessage {
Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json")
});
}
public HttpResponseMessage GetData(Info info)
{
string result = null;
try
{
if (info.type == "ItemOver")
{
using (MiddleContext db = new MiddleContext())
{
List <tblV_EQIW_D_ItemOver_Midd> query;
query = (from x in db.tblV_EQIW_D_ItemOver_Midd
where x.fldTimeType == info.fldTimeType &&
x.fldDate.Contains(info.fldYear)
select x).ToList();
ReturnData rd = new ReturnData();
rd.dangqi = query;
if (info.IsYear == "1")
{
int year = int.Parse(info.fldYear) - 1;
List <tblV_EQIW_D_ItemOver_Midd> query2;
query2 = (from x in db.tblV_EQIW_D_ItemOver_Midd
where x.fldTimeType == info.fldTimeType &&
x.fldDate.Contains(year.ToString())
select x).ToList();
rd.tongqi = query2;
}
result = rule.JsonStr("ok", "", rd);
}
}
if (info.type == "CityItemOver")
{
using (MiddleContext db = new MiddleContext())
{
List <tblV_EQIW_D_CityItemOver_Midd> query;
query = (from x in db.tblV_EQIW_D_CityItemOver_Midd
where x.fldTimeType == info.fldTimeType &&
x.fldDate.Contains(info.fldYear) &&
info.fldSTCode.Contains(x.fldSTCode)
select x).ToList();
ReturnData2 rd = new ReturnData2();
rd.dangqi = query;
if (info.IsYear == "1")
{
int year = int.Parse(info.fldYear) - 1;
List <tblV_EQIW_D_CityItemOver_Midd> query2;
query2 = (from x in db.tblV_EQIW_D_CityItemOver_Midd
where x.fldTimeType == info.fldTimeType &&
x.fldDate.Contains(year.ToString()) &&
info.fldSTCode.Contains(x.fldSTCode)
select x).ToList();
rd.tongqi = query2;
}
result = rule.JsonStr("ok", "", rd);
}
}
if (info.type == "BaseData")
{
using (MiddleContext db = new MiddleContext())
{
List <tblEQIW_D_BaseData_Midd> query;
List <tblEQIW_D_BaseData_Item_Midd> query_Item;
DateTime fldBeginDate = DateTime.Parse(info.fldBeginDate);
DateTime fldEndDate = DateTime.Parse(info.fldEndDate);
if (info.fldSTCode == "-1")
{
query = (from x in db.tblEQIW_D_BaseData_Midd
where x.fldappdate >= fldBeginDate &&
x.fldappdate <= fldEndDate
select x).ToList();
}
else
{
query = (from x in db.tblEQIW_D_BaseData_Midd
where x.fldappdate >= fldBeginDate &&
x.fldappdate <= fldEndDate
select x).ToList();
}
query_Item = (from x in query
join y in db.tblEQIW_D_BaseData_Item_Midd
on x.fldAutoID equals y.fldFKID
select y).ToList();
ReturnData3 rd = new ReturnData3();
rd.dangqi = query;
rd.dangqi_Item = query_Item;
result = rule.JsonStr("ok", "", rd);
}
}
if (info.type == "DayOfData")
{
using (MiddleContext db = new MiddleContext())
{
List <tblEQIW_D_DayOfData_Midd> query;
List <tblEQIW_D_DayOfData_Item_Midd> query_Item;
DateTime fldBeginDate = DateTime.Parse(info.fldBeginDate);
DateTime fldEndDate = DateTime.Parse(info.fldEndDate);
if (info.fldSTCode == "-1")
{
query = (from x in db.tblEQIW_D_DayOfData_Midd
where DateTime.Parse(x.fldDate) >= fldBeginDate &&
DateTime.Parse(x.fldDate) <= fldEndDate
select x).ToList();
}
else
{
query = (from x in db.tblEQIW_D_DayOfData_Midd
where DateTime.Parse(x.fldDate) >= fldBeginDate &&
DateTime.Parse(x.fldDate) <= fldEndDate
select x).ToList();
}
query_Item = (from x in query
join y in db.tblEQIW_D_DayOfData_Item_Midd
on x.fldAutoID equals y.fldFKID
select y).ToList();
ReturnData4 rd = new ReturnData4();
rd.dangqi = query;
rd.dangqi_Item = query_Item;
result = rule.JsonStr("ok", "", rd);
}
}
if (info.type == "YearBook")
{
using (MiddleContext db = new MiddleContext())
{
List <tblV_EQIW_D_YearBook_Midd> query = new List <tblV_EQIW_D_YearBook_Midd>();
List <tblV_EQIW_D_YearBook_Item_Midd> query_Item = new List <tblV_EQIW_D_YearBook_Item_Midd>();
if (info.fldSTCode == "-1")
{
query = (from x in db.tblV_EQIW_D_YearBook_Midd
where x.STatType == info.STatType &&
x.fldTimeType == info.fldTimeType
select x).ToList();
}
else
{
query = (from x in db.tblV_EQIW_D_YearBook_Midd
where x.STatType == info.STatType &&
x.fldTimeType == info.fldTimeType &&
info.fldSTCode.Contains(x.fldCityCode + "." + x.fldSTCode + "." + x.fldRCode + "." + x.fldRSCode)
select x).ToList();
}
if (info.fldItemCode != null)
{
query_Item = (from x in query
join y in db.tblV_EQIW_D_YearBook_Item_Midd
on x.fldAutoID equals y.fldFKID
select y).ToList();
if (info.fldItemCode != "All")
{
string[] ItemCodeList = info.fldItemCode.Split(',');
query_Item = (from x in query_Item
where ItemCodeList.Contains(x.fldItemCode)
select x).ToList();
}
}
ReturnData5 rd = new ReturnData5();
rd.dangqi = query;
rd.dangqi_Item = query_Item;
if (info.IsYear == "1")
{
int year = int.Parse(info.fldYear) - 1;
List <tblV_EQIW_D_YearBook_Midd> query2 = new List <tblV_EQIW_D_YearBook_Midd>();
List <tblV_EQIW_D_YearBook_Item_Midd> query_Item2 = new List <tblV_EQIW_D_YearBook_Item_Midd>();
if (info.fldSTCode == "-1")
{
query2 = (from x in db.tblV_EQIW_D_YearBook_Midd
where x.STatType == info.STatType &&
x.fldTimeType == info.fldTimeType
select x).ToList();
}
else
{
query2 = (from x in db.tblV_EQIW_D_YearBook_Midd
where x.STatType == info.STatType &&
x.fldTimeType == info.fldTimeType &&
info.fldSTCode.Contains(x.fldCityCode + "." + x.fldSTCode + "." + x.fldRCode + "." + x.fldRSCode)
select x).ToList();
}
if (info.fldItemCode != null)
{
query_Item2 = (from x in query2
join y in db.tblV_EQIW_D_YearBook_Item_Midd
on x.fldAutoID equals y.fldFKID
select y).ToList();
if (info.fldItemCode != "All")
{
string[] ItemCodeList = info.fldItemCode.Split(',');
query_Item2 = (from x in query_Item2
where ItemCodeList.Contains(x.fldItemCode)
select x).ToList();
}
}
rd.tongqi = query2;
rd.tongqi_Item = query_Item2;
}
result = rule.JsonStr("ok", "", rd);
}
}
if (info.type == "City")
{
using (MiddleContext db = new MiddleContext())
{
List <tblV_EQIW_D_City_Midd> query = new List <tblV_EQIW_D_City_Midd>();
List <tblV_EQIW_D_City_Item_Midd> query_Item = new List <tblV_EQIW_D_City_Item_Midd>();
DateTime BeginDate = DateTime.Parse(info.fldBeginDate);
DateTime EndDate = DateTime.Parse(info.fldEndDate);
List <string> list = ConvertDate(info.fldTimeType, BeginDate, EndDate);
if (info.fldSTCode == "-1")
{
query = (from x in db.tblV_EQIW_D_City_Midd
where x.fldTimeType == info.fldTimeType &&
list.Contains(x.fldAppDate) &&
x.STatType == info.STatType
select x).ToList();
}
else
{
query = (from x in db.tblV_EQIW_D_City_Midd
where x.fldTimeType == info.fldTimeType &&
info.fldSTCode.Contains(x.fldSTCode) &&
list.Contains(x.fldAppDate) &&
x.STatType == info.STatType
select x).ToList();
}
if (info.fldItemCode != null)
{
query_Item = (from x in query
join y in db.tblV_EQIW_D_City_Item_Midd
on x.fldAutoID equals y.fldFKID
select y).ToList();
if (info.fldItemCode != "All")
{
string[] ItemCodeList = info.fldItemCode.Split(',');
query_Item = (from x in query_Item
where ItemCodeList.Contains(x.fldItemCode)
select x).ToList();
}
}
ReturnData6 rd = new ReturnData6();
rd.dangqi = query;
rd.dangqi_Item = query_Item;
if (info.IsYear == "1")
{
int year = int.Parse(info.fldYear) - 1;
List <tblV_EQIW_D_City_Midd> query2 = new List <tblV_EQIW_D_City_Midd>();
List <tblV_EQIW_D_City_Item_Midd> query_Item2 = new List <tblV_EQIW_D_City_Item_Midd>();
BeginDate = BeginDate.AddYears(-1);
EndDate = EndDate.AddYears(-1);
list = ConvertDate(info.fldTimeType, BeginDate, EndDate);
if (info.fldSTCode == "-1")
{
query2 = (from x in db.tblV_EQIW_D_City_Midd
where x.fldTimeType == info.fldTimeType &&
list.Contains(x.fldAppDate) &&
x.STatType == info.STatType
select x).ToList();
}
else
{
query2 = (from x in db.tblV_EQIW_D_City_Midd
where x.fldTimeType == info.fldTimeType &&
info.fldSTCode.Contains(x.fldSTCode) &&
list.Contains(x.fldAppDate) &&
x.STatType == info.STatType
select x).ToList();
}
if (info.fldItemCode != null)
{
query_Item2 = (from x in query2
join y in db.tblV_EQIW_D_City_Item_Midd
on x.fldAutoID equals y.fldFKID
select y).ToList();
if (info.fldItemCode != "All")
{
string[] ItemCodeList = info.fldItemCode.Split(',');
query_Item2 = (from x in query_Item2
where ItemCodeList.Contains(x.fldItemCode)
select x).ToList();
}
}
rd.tongqi = query2;
rd.tongqi_Item = query_Item2;
}
result = rule.JsonStr("ok", "", rd);
}
}
if (info.type == "Section")
{
using (MiddleContext db = new MiddleContext())
{
List <tblV_EQIW_D_Section_Midd> query = new List <tblV_EQIW_D_Section_Midd>();
List <tblV_EQIW_D_Section_Item_Midd> query_Item = new List <tblV_EQIW_D_Section_Item_Midd>();
DateTime BeginDate = DateTime.Parse(info.fldBeginDate);
DateTime EndDate = DateTime.Parse(info.fldEndDate);
List <string> list = ConvertDate(info.fldTimeType, BeginDate, EndDate);
if (info.fldSTCode == "-1")
{
query = (from x in db.tblV_EQIW_D_Section_Midd
where x.fldTimeType == info.fldTimeType &&
list.Contains(x.fldAppDate) &&
x.STatType == info.STatType
select x).ToList();
}
else
{
query = (from x in db.tblV_EQIW_D_Section_Midd
where x.fldTimeType == info.fldTimeType &&
list.Contains(x.fldAppDate) &&
info.fldSTCode.Contains(x.fldSTCode + "." + x.fldRCode + "." + x.fldRSCode) &&
x.STatType == info.STatType
select x).ToList();
}
if (info.fldItemCode != null)
{
query_Item = (from x in query
join y in db.tblV_EQIW_D_Section_Item_Midd
on x.fldAutoID equals y.fldFKID
select y).ToList();
if (info.fldItemCode != "All")
{
string[] ItemCodeList = info.fldItemCode.Split(',');
query_Item = (from x in query_Item
where ItemCodeList.Contains(x.fldItemCode)
select x).ToList();
}
}
ReturnData7 rd = new ReturnData7();
rd.dangqi = query;
rd.dangqi_Item = query_Item;
if (info.IsYear == "1")
{
int year = int.Parse(info.fldYear) - 1;
List <tblV_EQIW_D_Section_Midd> query2 = new List <tblV_EQIW_D_Section_Midd>();
List <tblV_EQIW_D_Section_Item_Midd> query_Item2 = new List <tblV_EQIW_D_Section_Item_Midd>();
BeginDate = BeginDate.AddYears(-1);
EndDate = EndDate.AddYears(-1);
list = ConvertDate(info.fldTimeType, BeginDate, EndDate);
if (info.fldSTCode == "-1")
{
query2 = (from x in db.tblV_EQIW_D_Section_Midd
where x.fldTimeType == info.fldTimeType &&
list.Contains(x.fldAppDate) &&
x.STatType == info.STatType
select x).ToList();
}
else
{
query2 = (from x in db.tblV_EQIW_D_Section_Midd
where x.fldTimeType == info.fldTimeType &&
list.Contains(x.fldAppDate) &&
info.fldSTCode.Contains(x.fldSTCode + "." + x.fldRCode + "." + x.fldRSCode) &&
x.STatType == info.STatType
select x).ToList();
}
if (info.fldItemCode != null)
{
query_Item2 = (from x in query2
join y in db.tblV_EQIW_D_Section_Item_Midd
on x.fldAutoID equals y.fldFKID
select y).ToList();
if (info.fldItemCode != "All")
{
string[] ItemCodeList = info.fldItemCode.Split(',');
query_Item2 = (from x in query_Item2
where ItemCodeList.Contains(x.fldItemCode)
select x).ToList();
}
}
rd.tongqi = query2;
rd.tongqi_Item = query_Item2;
}
result = rule.JsonStr("ok", "", rd);
}
}
}
catch (Exception e)
{
result = rule.JsonStr("error", e.Message, "");
}
return(new HttpResponseMessage {
Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json")
});
}
public HttpResponseMessage GetData(Info info)
{
string result = null;
try
{
DateTime BeginDate = DateTime.Parse(info.fldBeginDate);
DateTime EndDate = DateTime.Parse(info.fldEndDate);
if (info.type == "SpaceID0")
{
using (MiddleContext db = new MiddleContext())
{
List <tblEQISO_SpaceID0_Midd> query = new List <tblEQISO_SpaceID0_Midd>();
List <tblEQISO_SpaceID0_Item_Midd> query_Item = new List <tblEQISO_SpaceID0_Item_Midd>();
if (info.fldSTCode == "-1")
{
query = (from x in db.tblEQISO_SpaceID0_Midd
where x.fldDate >= BeginDate &&
x.fldDate <= EndDate
select x).ToList();
}
else
{
query = (from x in db.tblEQISO_SpaceID0_Midd
where x.fldDate >= BeginDate &&
x.fldDate <= EndDate &&
info.fldSTCode.Contains(x.fldCityCode + "." + x.fldSTCode + "." + x.fldEntCode + "." + x.fldPCode)
select x).ToList();
}
if (info.fldItemCode != null)
{
query_Item = (from x in query
join y in db.tblEQISO_SpaceID0_Item_Midd
on x.fldAutoID equals y.fldFKID
select y).ToList();
if (info.fldItemCode != "All")
{
string[] ItemCodeList = info.fldItemCode.Split(',');
query_Item = (from x in query_Item
where ItemCodeList.Contains(x.fldItemCode)
select x).ToList();
}
}
ReturnData rd = new ReturnData();
rd.dangqi = query;
rd.dangqi_Item = query_Item;
if (info.IsYear == "1")
{
int year = int.Parse(info.fldYear) - 1;
List <tblEQISO_SpaceID0_Midd> query2 = new List <tblEQISO_SpaceID0_Midd>();
List <tblEQISO_SpaceID0_Item_Midd> query_Item2 = new List <tblEQISO_SpaceID0_Item_Midd>();
if (info.fldSTCode == "-1")
{
query2 = (from x in db.tblEQISO_SpaceID0_Midd
where x.fldDate >= BeginDate &&
x.fldDate <= EndDate
select x).ToList();
}
else
{
query2 = (from x in db.tblEQISO_SpaceID0_Midd
where x.fldDate >= BeginDate &&
x.fldDate <= EndDate &&
info.fldSTCode.Contains(x.fldCityCode + "." + x.fldSTCode + "." + x.fldEntCode + "." + x.fldPCode)
select x).ToList();
}
if (info.fldItemCode != null)
{
query_Item2 = (from x in query2
join y in db.tblEQISO_SpaceID0_Item_Midd
on x.fldAutoID equals y.fldFKID
select y).ToList();
if (info.fldItemCode != "All")
{
string[] ItemCodeList = info.fldItemCode.Split(',');
query_Item2 = (from x in query_Item2
where ItemCodeList.Contains(x.fldItemCode)
select x).ToList();
}
}
rd.tongqi = query2;
rd.tongqi_Item = query_Item2;
}
result = rule.JsonStr("ok", "", rd);
}
}
if (info.type == "SpaceID1")
{
using (MiddleContext db = new MiddleContext())
{
List <tblEQISO_SpaceID1_Midd> query = new List <tblEQISO_SpaceID1_Midd>();
List <tblEQISO_SpaceID1_Item_Midd> query_Item = new List <tblEQISO_SpaceID1_Item_Midd>();
if (info.fldSTCode == "-1")
{
query = (from x in db.tblEQISO_SpaceID1_Midd
where x.fldYear == info.fldYear
select x).ToList();
}
else
{
query = (from x in db.tblEQISO_SpaceID1_Midd
where x.fldYear == info.fldYear &&
info.fldSTCode.Contains(x.fldCityCode + "." + x.fldSTCode + "." + x.fldEntCode)
select x).ToList();
}
if (info.fldItemCode != null)
{
query_Item = (from x in query
join y in db.tblEQISO_SpaceID1_Item_Midd
on x.fldAutoID equals y.fldFKID
select y).ToList();
if (info.fldItemCode != "All")
{
string[] ItemCodeList = info.fldItemCode.Split(',');
query_Item = (from x in query_Item
where ItemCodeList.Contains(x.fldItemCode)
select x).ToList();
}
}
ReturnData1 rd = new ReturnData1();
rd.dangqi = query;
rd.dangqi_Item = query_Item;
if (info.IsYear == "1")
{
int year = int.Parse(info.fldYear) - 1;
List <tblEQISO_SpaceID1_Midd> query2 = new List <tblEQISO_SpaceID1_Midd>();
List <tblEQISO_SpaceID1_Item_Midd> query_Item2 = new List <tblEQISO_SpaceID1_Item_Midd>();
if (info.fldSTCode == "-1")
{
query2 = (from x in db.tblEQISO_SpaceID1_Midd
where x.fldYear == info.fldYear
select x).ToList();
}
else
{
query2 = (from x in db.tblEQISO_SpaceID1_Midd
where x.fldYear == info.fldYear &&
info.fldSTCode.Contains(x.fldCityCode + "." + x.fldSTCode + "." + x.fldEntCode)
select x).ToList();
}
if (info.fldItemCode != null)
{
query_Item2 = (from x in query2
join y in db.tblEQISO_SpaceID1_Item_Midd
on x.fldAutoID equals y.fldFKID
select y).ToList();
if (info.fldItemCode != "All")
{
string[] ItemCodeList = info.fldItemCode.Split(',');
query_Item2 = (from x in query_Item2
where ItemCodeList.Contains(x.fldItemCode)
select x).ToList();
}
}
rd.tongqi = query2;
rd.tongqi_Item = query_Item2;
}
result = rule.JsonStr("ok", "", rd);
}
}
if (info.type == "SpaceID2")
{
using (MiddleContext db = new MiddleContext())
{
List <tblEQISO_SpaceID2_Midd> query = new List <tblEQISO_SpaceID2_Midd>();
List <tblEQISO_SpaceID2_Item_Midd> query_Item = new List <tblEQISO_SpaceID2_Item_Midd>();
if (info.fldSTCode == "-1")
{
query = (from x in db.tblEQISO_SpaceID2_Midd
where x.fldYear == info.fldYear
select x).ToList();
}
else
{
query = (from x in db.tblEQISO_SpaceID2_Midd
where x.fldYear == info.fldYear &&
info.fldSTCode.Contains(x.fldCityCode + "." + x.fldSTCode + "." + x.fldEntCode)
select x).ToList();
}
if (info.fldItemCode != null)
{
query_Item = (from x in query
join y in db.tblEQISO_SpaceID2_Item_Midd
on x.fldAutoID equals y.fldFKID
select y).ToList();
if (info.fldItemCode != "All")
{
string[] ItemCodeList = info.fldItemCode.Split(',');
query_Item = (from x in query_Item
where ItemCodeList.Contains(x.fldItemCode)
select x).ToList();
}
}
ReturnData2 rd = new ReturnData2();
rd.dangqi = query;
rd.dangqi_Item = query_Item;
if (info.IsYear == "1")
{
int year = int.Parse(info.fldYear) - 1;
List <tblEQISO_SpaceID2_Midd> query2 = new List <tblEQISO_SpaceID2_Midd>();
List <tblEQISO_SpaceID2_Item_Midd> query_Item2 = new List <tblEQISO_SpaceID2_Item_Midd>();
if (info.fldSTCode == "-1")
{
query2 = (from x in db.tblEQISO_SpaceID2_Midd
where x.fldYear == info.fldYear
select x).ToList();
}
else
{
query2 = (from x in db.tblEQISO_SpaceID2_Midd
where x.fldYear == info.fldYear &&
info.fldSTCode.Contains(x.fldCityCode + "." + x.fldSTCode + "." + x.fldEntCode)
select x).ToList();
}
if (info.fldItemCode != null)
{
query_Item2 = (from x in query2
join y in db.tblEQISO_SpaceID2_Item_Midd
on x.fldAutoID equals y.fldFKID
select y).ToList();
if (info.fldItemCode != "All")
{
string[] ItemCodeList = info.fldItemCode.Split(',');
query_Item2 = (from x in query_Item2
where ItemCodeList.Contains(x.fldItemCode)
select x).ToList();
}
}
rd.tongqi = query2;
rd.tongqi_Item = query_Item2;
}
result = rule.JsonStr("ok", "", rd);
}
}
if (info.type == "SpaceID3")
{
using (MiddleContext db = new MiddleContext())
{
List <tblEQISO_SpaceID3_Midd> query;
query = (from x in db.tblEQISO_SpaceID3_Midd
select x).ToList();
ReturnData3 rd = new ReturnData3();
rd.dangqi = query;
if (info.IsYear == "1")
{
int year = int.Parse(info.fldYear) - 1;
List <tblEQISO_SpaceID3_Midd> query2;
query2 = (from x in db.tblEQISO_SpaceID3_Midd
select x).ToList();
rd.tongqi = query2;
}
result = rule.JsonStr("ok", "", rd);
}
}
if (info.type == "SpaceID4")
{
using (MiddleContext db = new MiddleContext())
{
List <tblEQISO_SpaceID4_Midd> query;
query = (from x in db.tblEQISO_SpaceID4_Midd
where info.fldSTCode.Contains(x.fldCityCode + "." + x.fldSTCode + "." + x.fldEntCode)
select x).ToList();
ReturnData4 rd = new ReturnData4();
rd.dangqi = query;
if (info.IsYear == "1")
{
int year = int.Parse(info.fldYear) - 1;
List <tblEQISO_SpaceID4_Midd> query2;
query2 = (from x in db.tblEQISO_SpaceID4_Midd
where info.fldSTCode.Contains(x.fldCityCode + "." + x.fldSTCode + "." + x.fldEntCode)
select x).ToList();
rd.tongqi = query2;
}
result = rule.JsonStr("ok", "", rd);
}
}
if (info.type == "SpaceID5")
{
using (MiddleContext db = new MiddleContext())
{
List <tblEQISO_SpaceID5_Midd> query = new List <tblEQISO_SpaceID5_Midd>();
List <tblEQISO_SpaceID5_Item_Midd> query_Item = new List <tblEQISO_SpaceID5_Item_Midd>();
if (info.fldSTCode == "-1")
{
query = (from x in db.tblEQISO_SpaceID5_Midd
where x.fldYear == info.fldYear
select x).ToList();
}
else
{
query = (from x in db.tblEQISO_SpaceID5_Midd
where x.fldYear == info.fldYear &&
info.fldSTCode.Contains(x.fldCityCode + "." + x.fldSTCode + "." + x.fldEntCode)
select x).ToList();
}
if (info.fldItemCode != null)
{
query_Item = (from x in query
join y in db.tblEQISO_SpaceID5_Item_Midd
on x.fldAutoID equals y.fldFKID
select y).ToList();
if (info.fldItemCode != "All")
{
string[] ItemCodeList = info.fldItemCode.Split(',');
query_Item = (from x in query_Item
where ItemCodeList.Contains(x.fldItemCode)
select x).ToList();
}
}
ReturnData5 rd = new ReturnData5();
rd.dangqi = query;
rd.dangqi_Item = query_Item;
if (info.IsYear == "1")
{
int year = int.Parse(info.fldYear) - 1;
List <tblEQISO_SpaceID5_Midd> query2 = new List <tblEQISO_SpaceID5_Midd>();
List <tblEQISO_SpaceID5_Item_Midd> query_Item2 = new List <tblEQISO_SpaceID5_Item_Midd>();
if (info.fldSTCode == "-1")
{
query2 = (from x in db.tblEQISO_SpaceID5_Midd
where x.fldYear == info.fldYear
select x).ToList();
}
else
{
query2 = (from x in db.tblEQISO_SpaceID5_Midd
where x.fldYear == info.fldYear &&
info.fldSTCode.Contains(x.fldCityCode + "." + x.fldSTCode + "." + x.fldEntCode)
select x).ToList();
}
if (info.fldItemCode != null)
{
query_Item2 = (from x in query2
join y in db.tblEQISO_SpaceID5_Item_Midd
on x.fldAutoID equals y.fldFKID
select y).ToList();
if (info.fldItemCode != "All")
{
string[] ItemCodeList = info.fldItemCode.Split(',');
query_Item2 = (from x in query_Item2
where ItemCodeList.Contains(x.fldItemCode)
select x).ToList();
}
}
rd.tongqi = query2;
rd.tongqi_Item = query_Item2;
}
result = rule.JsonStr("ok", "", rd);
}
}
if (info.type == "SpaceID6")
{
using (MiddleContext db = new MiddleContext())
{
List <tblEQISO_SpaceID6_Midd> query;
query = (from x in db.tblEQISO_SpaceID6_Midd
select x).ToList();
ReturnData6 rd = new ReturnData6();
rd.dangqi = query;
if (info.IsYear == "1")
{
int year = int.Parse(info.fldYear) - 1;
List <tblEQISO_SpaceID6_Midd> query2;
query2 = (from x in db.tblEQISO_SpaceID6_Midd
select x).ToList();
rd.tongqi = query2;
}
result = rule.JsonStr("ok", "", rd);
}
}
}
catch (Exception e)
{
result = rule.JsonStr("error", e.Message, "");
}
return(new HttpResponseMessage {
Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json")
});
}
public HttpResponseMessage GetData(Info info)
{
string result = null;
try
{
if (info.type == "BaseData")
{
using (MiddleContext db = new MiddleContext())
{
List <tblEQIA_P_BaseData_Midd> query = new List <tblEQIA_P_BaseData_Midd>();
DateTime BeginDate = DateTime.Parse(info.fldBeginDate);
DateTime EndDate = DateTime.Parse(info.fldEndDate);
List <string> list = ConvertDate(info.TimeType, BeginDate, EndDate);
if (info.fldSTCode == "-1")
{
query = (from x in db.tblEQIA_P_BaseData_Midd
where x.STatType == info.STatType &&
x.fldSDate >= BeginDate &&
x.fldEDate <= EndDate
select x).ToList();
}
else
{
query = (from x in db.tblEQIA_P_BaseData_Midd
where x.STatType == info.STatType &&
x.fldSDate >= BeginDate &&
x.fldEDate <= EndDate &&
info.fldSTCode.Contains(x.fldSTCode + "." + x.fldPCode)
select x).ToList();
}
ReturnData rd = new ReturnData();
rd.dangqi = query;
if (info.IsYear == "1")
{
List <tblEQIA_P_BaseData_Midd> query2 = new List <tblEQIA_P_BaseData_Midd>();
BeginDate = BeginDate.AddYears(-1);
EndDate = EndDate.AddYears(-1);
int year = int.Parse(info.fldYear) - 1;
list = ConvertDate(info.TimeType, BeginDate, EndDate);
if (info.fldSTCode == "-1")
{
query2 = (from x in db.tblEQIA_P_BaseData_Midd
where x.STatType == info.STatType &&
x.fldSDate >= BeginDate &&
x.fldEDate <= EndDate
select x).ToList();
}
else
{
query2 = (from x in db.tblEQIA_P_BaseData_Midd
where x.STatType == info.STatType &&
x.fldSDate >= BeginDate &&
x.fldEDate <= EndDate &&
info.fldSTCode.Contains(x.fldSTCode + "." + x.fldPCode)
select x).ToList();
}
rd.tongqi = query2;
}
result = rule.JsonStr("ok", "", rd);
}
}
if (info.type == "ResultStat")
{
using (MiddleContext db = new MiddleContext())
{
List <tblEQIA_P_ResultStat_Midd> query = new List <tblEQIA_P_ResultStat_Midd>();
DateTime BeginDate = DateTime.Parse(info.fldBeginDate);
DateTime EndDate = DateTime.Parse(info.fldEndDate);
List <string> list = ConvertDate(info.TimeType, BeginDate, EndDate);
if (info.fldSTCode == "-1")
{
query = (from x in db.tblEQIA_P_ResultStat_Midd
where x.TimeType == info.TimeType &&
x.AppriseID == info.AppriseID &&
list.Contains(x.fldAppDate)
select x).ToList();
}
else
{
if (info.AppriseID == "0")
{
query = (from x in db.tblEQIA_P_ResultStat_Midd
where x.TimeType == info.TimeType &&
x.AppriseID == info.AppriseID &&
list.Contains(x.fldAppDate) &&
info.fldSTCode.Contains(x.fldSTCode + "." + x.fldPCode)
select x).ToList();
}
if (info.AppriseID == "1")
{
query = (from x in db.tblEQIA_P_ResultStat_Midd
where x.TimeType == info.TimeType &&
x.AppriseID == info.AppriseID &&
list.Contains(x.fldAppDate) &&
info.fldSTCode.Contains(x.fldSTCode)
select x).ToList();
}
}
ReturnData1 rd = new ReturnData1();
rd.dangqi = query;
if (info.IsYear == "1")
{
List <tblEQIA_P_ResultStat_Midd> query2 = new List <tblEQIA_P_ResultStat_Midd>();
BeginDate = BeginDate.AddYears(-1);
EndDate = EndDate.AddYears(-1);
list = ConvertDate(info.TimeType, BeginDate, EndDate);
if (info.fldSTCode == "-1")
{
query2 = (from x in db.tblEQIA_P_ResultStat_Midd
where x.TimeType == info.TimeType &&
x.AppriseID == info.AppriseID &&
list.Contains(x.fldAppDate)
select x).ToList();
}
else
{
if (info.AppriseID == "0")
{
query2 = (from x in db.tblEQIA_P_ResultStat_Midd
where x.TimeType == info.TimeType &&
x.AppriseID == info.AppriseID &&
list.Contains(x.fldAppDate) &&
info.fldSTCode.Contains(x.fldSTCode + "." + x.fldPCode)
select x).ToList();
}
if (info.AppriseID == "1")
{
query2 = (from x in db.tblEQIA_P_ResultStat_Midd
where x.TimeType == info.TimeType &&
x.AppriseID == info.AppriseID &&
list.Contains(x.fldAppDate) &&
info.fldSTCode.Contains(x.fldSTCode)
select x).ToList();
}
}
rd.tongqi = query2;
}
result = rule.JsonStr("ok", "", rd);
}
}
if (info.type == "STatType2")
{
using (MiddleContext db = new MiddleContext())
{
List <tblEQIA_P_STatType2_Midd> query = new List <tblEQIA_P_STatType2_Midd>();
DateTime BeginDate = DateTime.Parse(info.fldBeginDate);
DateTime EndDate = DateTime.Parse(info.fldEndDate);
List <string> list = ConvertDate(info.TimeType, BeginDate, EndDate);
if (info.fldSTCode == "-1")
{
query = (from x in db.tblEQIA_P_STatType2_Midd
where x.TimeType == info.TimeType &&
x.AppriseID == info.AppriseID
select x).ToList();
}
else
{
if (info.AppriseID == "0")
{
query = (from x in db.tblEQIA_P_STatType2_Midd
where x.TimeType == info.TimeType &&
x.AppriseID == info.AppriseID &&
info.fldSTCode.Contains(x.fldSTCode + "." + x.fldPCode)
select x).ToList();
}
if (info.AppriseID == "1")
{
query = (from x in db.tblEQIA_P_STatType2_Midd
where x.TimeType == info.TimeType &&
x.AppriseID == info.AppriseID &&
info.fldSTCode.Contains(x.fldSTCode)
select x).ToList();
}
}
ReturnData2 rd = new ReturnData2();
rd.dangqi = query;
if (info.IsYear == "1")
{
List <tblEQIA_P_STatType2_Midd> query2 = new List <tblEQIA_P_STatType2_Midd>();
BeginDate = BeginDate.AddYears(-1);
EndDate = EndDate.AddYears(-1);
list = ConvertDate(info.TimeType, BeginDate, EndDate);
if (info.fldSTCode == "-1")
{
query2 = (from x in db.tblEQIA_P_STatType2_Midd
where x.TimeType == info.TimeType &&
x.AppriseID == info.AppriseID
select x).ToList();
}
else
{
if (info.AppriseID == "0")
{
query2 = (from x in db.tblEQIA_P_STatType2_Midd
where x.TimeType == info.TimeType &&
x.AppriseID == info.AppriseID &&
info.fldSTCode.Contains(x.fldSTCode + "." + x.fldPCode)
select x).ToList();
}
if (info.AppriseID == "1")
{
query2 = (from x in db.tblEQIA_P_STatType2_Midd
where x.TimeType == info.TimeType &&
x.AppriseID == info.AppriseID &&
info.fldSTCode.Contains(x.fldSTCode)
select x).ToList();
}
}
rd.tongqi = query2;
}
result = rule.JsonStr("ok", "", rd);
}
}
if (info.type == "STatType3")
{
using (MiddleContext db = new MiddleContext())
{
List <tblEQIA_P_STatType3_Midd> query = new List <tblEQIA_P_STatType3_Midd>();
DateTime BeginDate = DateTime.Parse(info.fldBeginDate);
DateTime EndDate = DateTime.Parse(info.fldEndDate);
List <string> list = ConvertDate(info.TimeType, BeginDate, EndDate);
query = (from x in db.tblEQIA_P_STatType3_Midd
where x.TimeType == info.TimeType &&
x.AppriseID == info.AppriseID &&
list.Contains(x.fldDate)
select x).ToList();
ReturnData3 rd = new ReturnData3();
rd.dangqi = query;
if (info.IsYear == "1")
{
List <tblEQIA_P_STatType3_Midd> query2 = new List <tblEQIA_P_STatType3_Midd>();
BeginDate = BeginDate.AddYears(-1);
EndDate = EndDate.AddYears(-1);
list = ConvertDate(info.TimeType, BeginDate, EndDate);
query2 = (from x in db.tblEQIA_P_STatType3_Midd
where x.TimeType == info.TimeType &&
x.AppriseID == info.AppriseID &&
list.Contains(x.fldDate)
select x).ToList();
rd.tongqi = query2;
}
result = rule.JsonStr("ok", "", rd);
}
}
if (info.type == "STatType4")
{
using (MiddleContext db = new MiddleContext())
{
List <tblEQIA_P_STatType4_Midd> query = new List <tblEQIA_P_STatType4_Midd>();
DateTime BeginDate = DateTime.Parse(info.fldBeginDate);
DateTime EndDate = DateTime.Parse(info.fldEndDate);
List <string> list = ConvertDate(info.TimeType, BeginDate, EndDate);
if (info.fldSTCode == "-1")
{
query = (from x in db.tblEQIA_P_STatType4_Midd
where x.fldSDate >= BeginDate &&
x.fldEDate <= EndDate
select x).ToList();
}
else
{
query = (from x in db.tblEQIA_P_STatType4_Midd
where x.fldSDate >= BeginDate &&
x.fldEDate <= EndDate &&
info.fldSTCode.Contains(x.fldSTCode)
select x).ToList();
}
ReturnData4 rd = new ReturnData4();
rd.dangqi = query;
if (info.IsYear == "1")
{
List <tblEQIA_P_STatType4_Midd> query2 = new List <tblEQIA_P_STatType4_Midd>();
BeginDate = BeginDate.AddYears(-1);
EndDate = EndDate.AddYears(-1);
list = ConvertDate(info.TimeType, BeginDate, EndDate);
if (info.fldSTCode == "-1")
{
query2 = (from x in db.tblEQIA_P_STatType4_Midd
where x.fldSDate >= BeginDate &&
x.fldEDate <= EndDate
select x).ToList();
}
else
{
query2 = (from x in db.tblEQIA_P_STatType4_Midd
where x.fldSDate >= BeginDate &&
x.fldEDate <= EndDate &&
info.fldSTCode.Contains(x.fldSTCode)
select x).ToList();
}
rd.tongqi = query2;
}
result = rule.JsonStr("ok", "", rd);
}
}
if (info.type == "STatType5")
{
using (MiddleContext db = new MiddleContext())
{
List <tblEQIA_P_STatType5_Midd> query = new List <tblEQIA_P_STatType5_Midd>();
DateTime BeginDate = DateTime.Parse(info.fldBeginDate);
DateTime EndDate = DateTime.Parse(info.fldEndDate);
List <string> list = ConvertDate(info.TimeType, BeginDate, EndDate);
if (info.fldSTCode == "-1")
{
query = (from x in db.tblEQIA_P_STatType5_Midd
where x.TimeType == info.TimeType &&
x.AppriseID == info.AppriseID &&
x.fldYear == info.fldYear
select x).ToList();
}
else
{
if (info.AppriseID == "0")
{
query = (from x in db.tblEQIA_P_STatType5_Midd
where x.TimeType == info.TimeType &&
x.AppriseID == info.AppriseID &&
info.fldSTCode.Contains(x.fldSTCode + "." + x.fldPCode) &&
x.fldYear == info.fldYear
select x).ToList();
}
if (info.AppriseID == "1")
{
query = (from x in db.tblEQIA_P_STatType5_Midd
where x.TimeType == info.TimeType &&
x.AppriseID == info.AppriseID &&
info.fldSTCode.Contains(x.fldSTCode) &&
x.fldYear == info.fldYear
select x).ToList();
}
}
ReturnData5 rd = new ReturnData5();
rd.dangqi = query;
if (info.IsYear == "1")
{
List <tblEQIA_P_STatType5_Midd> query2 = new List <tblEQIA_P_STatType5_Midd>();
BeginDate = BeginDate.AddYears(-1);
EndDate = EndDate.AddYears(-1);
int year = int.Parse(info.fldYear) - 1;
list = ConvertDate(info.TimeType, BeginDate, EndDate);
if (info.fldSTCode == "-1")
{
query2 = (from x in db.tblEQIA_P_STatType5_Midd
where x.TimeType == info.TimeType &&
x.AppriseID == info.AppriseID &&
x.fldYear == year.ToString()
select x).ToList();
}
else
{
if (info.AppriseID == "0")
{
query2 = (from x in db.tblEQIA_P_STatType5_Midd
where x.TimeType == info.TimeType &&
x.AppriseID == info.AppriseID &&
info.fldSTCode.Contains(x.fldSTCode + "." + x.fldPCode) &&
x.fldYear == year.ToString()
select x).ToList();
}
if (info.AppriseID == "1")
{
query2 = (from x in db.tblEQIA_P_STatType5_Midd
where x.TimeType == info.TimeType &&
x.AppriseID == info.AppriseID &&
info.fldSTCode.Contains(x.fldSTCode) &&
x.fldYear == year.ToString()
select x).ToList();
}
}
rd.tongqi = query2;
}
result = rule.JsonStr("ok", "", rd);
}
}
if (info.type == "STatType6")
{
using (MiddleContext db = new MiddleContext())
{
List <tblEQIA_P_STatType6_Midd> query = new List <tblEQIA_P_STatType6_Midd>();
DateTime BeginDate = DateTime.Parse(info.fldBeginDate);
DateTime EndDate = DateTime.Parse(info.fldEndDate);
List <string> list = ConvertDate(info.TimeType, BeginDate, EndDate);
if (info.fldSTCode == "-1")
{
query = (from x in db.tblEQIA_P_STatType6_Midd
where x.TimeType == info.TimeType &&
x.AppriseID == info.AppriseID &&
x.fldYear == info.fldYear
select x).ToList();
}
else
{
if (info.AppriseID == "0")
{
query = (from x in db.tblEQIA_P_STatType6_Midd
where x.TimeType == info.TimeType &&
x.AppriseID == info.AppriseID &&
info.fldSTCode.Contains(x.fldSTCode + "." + x.fldPCode) &&
x.fldYear == info.fldYear
select x).ToList();
}
if (info.AppriseID == "1")
{
query = (from x in db.tblEQIA_P_STatType6_Midd
where x.TimeType == info.TimeType &&
x.AppriseID == info.AppriseID &&
info.fldSTCode.Contains(x.fldSTCode) &&
x.fldYear == info.fldYear
select x).ToList();
}
}
ReturnData6 rd = new ReturnData6();
rd.dangqi = query;
if (info.IsYear == "1")
{
List <tblEQIA_P_STatType6_Midd> query2 = new List <tblEQIA_P_STatType6_Midd>();
BeginDate = BeginDate.AddYears(-1);
EndDate = EndDate.AddYears(-1);
int year = int.Parse(info.fldYear) - 1;
list = ConvertDate(info.TimeType, BeginDate, EndDate);
if (info.fldSTCode == "-1")
{
query2 = (from x in db.tblEQIA_P_STatType6_Midd
where x.TimeType == info.TimeType &&
x.AppriseID == info.AppriseID &&
x.fldYear == year.ToString()
select x).ToList();
}
else
{
if (info.AppriseID == "0")
{
query2 = (from x in db.tblEQIA_P_STatType6_Midd
where x.TimeType == info.TimeType &&
x.AppriseID == info.AppriseID &&
info.fldSTCode.Contains(x.fldSTCode + "." + x.fldPCode) &&
x.fldYear == year.ToString()
select x).ToList();
}
if (info.AppriseID == "1")
{
query2 = (from x in db.tblEQIA_P_STatType6_Midd
where x.TimeType == info.TimeType &&
x.AppriseID == info.AppriseID &&
info.fldSTCode.Contains(x.fldSTCode) &&
x.fldYear == year.ToString()
select x).ToList();
}
}
rd.tongqi = query2;
}
result = rule.JsonStr("ok", "", rd);
}
}
if (info.type == "STatType7")
{
using (MiddleContext db = new MiddleContext())
{
List <tblEQIA_P_STatType7_Midd> query = new List <tblEQIA_P_STatType7_Midd>();
DateTime BeginDate = DateTime.Parse(info.fldBeginDate);
DateTime EndDate = DateTime.Parse(info.fldEndDate);
List <string> list = ConvertDate(info.TimeType, BeginDate, EndDate);
if (info.fldSTCode == "-1")
{
query = (from x in db.tblEQIA_P_STatType7_Midd
where x.TimeType == info.TimeType &&
x.AppriseID == info.AppriseID &&
x.fldYear == info.fldYear
select x).ToList();
}
else
{
if (info.AppriseID == "0")
{
query = (from x in db.tblEQIA_P_STatType7_Midd
where x.TimeType == info.TimeType &&
x.AppriseID == info.AppriseID &&
info.fldSTCode.Contains(x.fldSTCode + "." + x.fldPCode) &&
x.fldYear == info.fldYear
select x).ToList();
}
if (info.AppriseID == "1")
{
query = (from x in db.tblEQIA_P_STatType7_Midd
where x.TimeType == info.TimeType &&
x.AppriseID == info.AppriseID &&
info.fldSTCode.Contains(x.fldSTCode) &&
x.fldYear == info.fldYear
select x).ToList();
}
}
ReturnData7 rd = new ReturnData7();
rd.dangqi = query;
if (info.IsYear == "1")
{
List <tblEQIA_P_STatType7_Midd> query2 = new List <tblEQIA_P_STatType7_Midd>();
BeginDate = BeginDate.AddYears(-1);
EndDate = EndDate.AddYears(-1);
int year = int.Parse(info.fldYear) - 1;
list = ConvertDate(info.TimeType, BeginDate, EndDate);
if (info.fldSTCode == "-1")
{
query2 = (from x in db.tblEQIA_P_STatType7_Midd
where x.TimeType == info.TimeType &&
x.AppriseID == info.AppriseID &&
x.fldYear == year.ToString()
select x).ToList();
}
else
{
if (info.AppriseID == "0")
{
query2 = (from x in db.tblEQIA_P_STatType7_Midd
where x.TimeType == info.TimeType &&
x.AppriseID == info.AppriseID &&
info.fldSTCode.Contains(x.fldSTCode + "." + x.fldPCode) &&
x.fldYear == year.ToString()
select x).ToList();
}
if (info.AppriseID == "1")
{
query2 = (from x in db.tblEQIA_P_STatType7_Midd
where x.TimeType == info.TimeType &&
x.AppriseID == info.AppriseID &&
info.fldSTCode.Contains(x.fldSTCode) &&
x.fldYear == year.ToString()
select x).ToList();
}
}
rd.tongqi = query2;
}
result = rule.JsonStr("ok", "", rd);
}
}
}
catch (Exception e)
{
result = rule.JsonStr("error", e.Message, "");
}
return(new HttpResponseMessage {
Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json")
});
}
