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 DelCacheData_EQIA_R(List <Del_Info_EQIA_R> info)
{
string result = null;
int num = 0;
try
{
using (MiddleContext db = new MiddleContext())
{
foreach (var item in info)
{
var query = (from x in db.tblHM_EQIA_R_Midd
where x.fldFKID == item.fldAutoID
select x).ToList();
//删除数据表数据
db.tblHM_EQIA_R_Midd.RemoveRange(query);
//删除参数表数据
var query3 = (from x in db.tblHM_EQIA_R_Info_Midd
where x.fldAutoID == item.fldAutoID
select x).ToList();
db.tblHM_EQIA_R_Info_Midd.RemoveRange(query3);
num = db.SaveChanges();
}
}
result = rule.JsonStr("ok", "执行成功！", num);
}
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 == "ZHAppraise")
{
using (MiddleContext db = new MiddleContext())
{
List <tblEQIA_RD_ZHAppraise_Midd> query = new List <tblEQIA_RD_ZHAppraise_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_RD_ZHAppraise_Midd
where x.TimeType == info.TimeType &&
x.fldYear == info.fldYear &&
list.Contains(x.fldDate) &&
x.AppriseID == info.AppriseID
select x).ToList();
}
else
{
if (info.AppriseID == "0")
{
query = (from x in db.tblEQIA_RD_ZHAppraise_Midd
where x.TimeType == info.TimeType &&
x.fldYear == info.fldYear &&
list.Contains(x.fldDate) &&
x.AppriseID == info.AppriseID &&
info.fldSTCode.Contains(x.fldSTCode + "." + x.fldPCode)
select x).ToList();
}
if (info.AppriseID == "1")
{
query = (from x in db.tblEQIA_RD_ZHAppraise_Midd
where x.TimeType == info.TimeType &&
x.fldYear == info.fldYear &&
list.Contains(x.fldDate) &&
x.AppriseID == info.AppriseID &&
info.fldSTCode.Contains(x.fldSTCode)
select x).ToList();
}
}
ReturnData rd = new ReturnData();
rd.dangqi = query;
if (info.IsYear == "1")
{
List <tblEQIA_RD_ZHAppraise_Midd> query2 = new List <tblEQIA_RD_ZHAppraise_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_RD_ZHAppraise_Midd
where x.TimeType == info.TimeType &&
x.fldYear == year.ToString() &&
list.Contains(x.fldDate) &&
x.AppriseID == info.AppriseID
select x).ToList();
}
else
{
if (info.AppriseID == "0")
{
query2 = (from x in db.tblEQIA_RD_ZHAppraise_Midd
where x.TimeType == info.TimeType &&
x.fldYear == year.ToString() &&
list.Contains(x.fldDate) &&
x.AppriseID == info.AppriseID &&
info.fldSTCode.Contains(x.fldSTCode + "." + x.fldPCode)
select x).ToList();
}
if (info.AppriseID == "1")
{
query2 = (from x in db.tblEQIA_RD_ZHAppraise_Midd
where x.TimeType == info.TimeType &&
x.fldYear == year.ToString() &&
list.Contains(x.fldDate) &&
x.AppriseID == info.AppriseID &&
info.fldSTCode.Contains(x.fldSTCode)
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
{
string Sea = null;
if (info.fldBeginDate == "-1" && info.fldEndDate == "-1")
{
Sea = "合计";
}
else
{
DateTime fldBeginDate = DateTime.Parse(info.fldBeginDate);
DateTime fldEndDate = DateTime.Parse(info.fldEndDate);
if (fldEndDate.Month == 3)
{
Sea += "一季度,";
}
else if (fldEndDate.Month == 6)
{
if (fldBeginDate.Month == 1)
{
Sea += "一季度,二季度";
}
else if (fldBeginDate.Month == 4)
{
Sea += "二季度";
}
}
else if (fldEndDate.Month == 9)
{
if (fldBeginDate.Month == 1)
{
Sea += "一季度,二季度,三季度";
}
else if (fldBeginDate.Month == 4)
{
Sea += ",二季度,三季度";
}
else if (fldBeginDate.Month == 7)
{
Sea += "三季度";
}
}
else if (fldEndDate.Month == 12)
{
if (fldBeginDate.Month == 1)
{
Sea += "一季度,二季度,三季度,四季度,合计";
}
else if (fldBeginDate.Month == 4)
{
Sea += "二季度,三季度,四季度";
}
else if (fldBeginDate.Month == 7)
{
Sea += "三季度,四季度";
}
else if (fldBeginDate.Month == 10)
{
Sea += "四季度";
}
}
}
List <string> YearList = info.fldYear.Split(',').ToList();
if (info.type == "City_TotalDateStat")
{
using (MiddleContext db = new MiddleContext())
{
var query = (from x in db.tblEQIN_F_City_TotalDateStat_Midd
where YearList.Contains(x.fldYear) &&
x.ReportType == info.ReportType &&
Sea.Contains(x.fldDate)
select x).ToList();
ReturnData rd = new ReturnData();
rd.dangqi = query;
if (info.IsYear == "1" && YearList.Count == 1)
{
int year = int.Parse(info.fldYear) - 1;
var query2 = (from x in db.tblEQIN_F_City_TotalDateStat_Midd
where x.fldYear == year.ToString() &&
x.ReportType == info.ReportType &&
Sea.Contains(x.fldDate)
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_F_Point_HourStat_Midd> query;
if (info.fldSTCode == "-1" && info.fldGDCode == "-1")
{
query = (from x in db.tblEQIN_F_Point_HourStat_Midd
where x.fldappdate >= fldBeginDate &&
x.fldappdate <= fldEndDate
select x).OrderBy(x => x.fldGDCode).OrderBy(x => x.fldappdate).ToList();
}
else
{
query = (from x in db.tblEQIN_F_Point_HourStat_Midd
where info.PointFormat.Contains(x.fldSTCode + "." + x.fldGDCode) &&
x.fldappdate >= fldBeginDate &&
x.fldappdate <= fldEndDate
select x).OrderBy(x => x.fldGDCode).OrderBy(x => x.fldappdate).ToList();
}
result = rule.JsonStr("ok", "", query);
}
}
else if (info.type == "Point_TotalDateStat")
{
using (MiddleContext db = new MiddleContext())
{
List <tblEQIN_F_Point_TotalDateStat_Midd> query;
if (info.fldSTCode == "-1" && info.fldPCode == "-1")
{
query = (from x in db.tblEQIN_F_Point_TotalDateStat_Midd
where YearList.Contains(x.fldYear) &&
Sea.Contains(x.fldDate) &&
x.ReportType == info.ReportType
select x).ToList();
}
else
{
query = (from x in db.tblEQIN_F_Point_TotalDateStat_Midd
where info.PointFormat.Contains(x.fldSTCode + "." + x.fldPCode) &&
YearList.Contains(x.fldYear) &&
Sea.Contains(x.fldDate) &&
x.ReportType == info.ReportType
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_F_Point_TotalDateStat_Midd> query2;
if (info.fldSTCode == "-1" && info.fldPCode == "-1")
{
query2 = (from x in db.tblEQIN_F_Point_TotalDateStat_Midd
where x.fldYear == year.ToString() &&
Sea.Contains(x.fldDate) &&
x.ReportType == info.ReportType
select x).ToList();
}
else
{
query2 = (from x in db.tblEQIN_F_Point_TotalDateStat_Midd
where info.PointFormat.Contains(x.fldSTCode + "." + x.fldPCode) &&
x.fldYear == year.ToString() &&
Sea.Contains(x.fldDate) &&
x.ReportType == info.ReportType
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_T_City_TotalDateStat_Midd> query;
if (info.fldSTCode == "-1")
{
query = (from x in db.tblEQIN_T_City_TotalDateStat_Midd
where YearList.Contains(x.fldYear)
select x).ToList();
}
else
{
query = (from x in db.tblEQIN_T_City_TotalDateStat_Midd
where info.fldSTCode.Contains(x.fldSTCode) &&
YearList.Contains(x.fldYear)
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_T_City_TotalDateStat_Midd> query2;
if (info.fldSTCode == "-1")
{
query2 = (from x in db.tblEQIN_T_City_TotalDateStat_Midd
where x.fldYear == year.ToString()
select x).ToList();
}
else
{
query2 = (from x in db.tblEQIN_T_City_TotalDateStat_Midd
where info.fldSTCode.Contains(x.fldSTCode) &&
x.fldYear == year.ToString()
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_T_Point_HourStat_Midd> query;
if (info.fldSTCode == "-1" && info.fldRDCode == "-1")
{
query = (from x in db.tblEQIN_T_Point_HourStat_Midd
where x.fldappdate >= fldBeginDate &&
x.fldappdate <= fldEndDate
select x).ToList();
}
else if (info.fldSTCode != "-1")
{
query = (from x in db.tblEQIN_T_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_T_Point_HourStat_Midd
where info.fldSTCode.Contains(x.fldSTCode) &&
info.fldRDCode.Contains(x.fldRDCode) &&
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_T_Point_TotalDateStat_Midd> query;
if (info.fldSTCode == "-1" && info.fldRDCode == "-1")
{
query = (from x in db.tblEQIN_T_Point_TotalDateStat_Midd
where YearList.Contains(x.fldYear)
select x).ToList();
}
else if (info.fldSTCode != "-1")
{
query = (from x in db.tblEQIN_T_Point_TotalDateStat_Midd
where info.fldSTCode.Contains(x.fldSTCode) &&
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_T_Point_TotalDateStat_Midd
where pointlist.Contains(x.fldSTCode.ToString() + "." + x.fldRDCode.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_T_Point_TotalDateStat_Midd> query2;
if (info.fldSTCode == "-1" && info.fldRDCode == "-1")
{
query2 = (from x in db.tblEQIN_T_Point_TotalDateStat_Midd
where x.fldYear == year.ToString()
select x).ToList();
}
else if (info.fldSTCode != "-1")
{
query2 = (from x in db.tblEQIN_T_Point_TotalDateStat_Midd
where info.fldSTCode.Contains(x.fldSTCode) &&
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_T_Point_TotalDateStat_Midd
where pointlist.Contains(x.fldSTCode.ToString() + "." + x.fldRDCode.ToString()) &&
x.fldYear == year.ToString()
select x).ToList();
}
rd.tongqi = query2;
}
result = rule.JsonStr("ok", "", rd);
}
}
else if (info.type == "City_Data")
{
using (MiddleContext db = new MiddleContext())
{
List <tblEQIN_T_City_Data_Midd> query;
if (info.fldSTCode == "-1")
{
if (info.DN == "All")
{
query = (from x in db.tblEQIN_T_City_Data_Midd
where YearList.Contains(x.fldYear) &&
x.ReportType == info.ReportType &&
x.STatType == info.STatType
select x).ToList();
}
else
{
query = (from x in db.tblEQIN_T_City_Data_Midd
where YearList.Contains(x.fldYear) &&
x.ReportType == info.ReportType &&
x.STatType == info.STatType &&
x.fldDN == info.DN
select x).ToList();
}
}
else
{
if (info.DN == "All")
{
query = (from x in db.tblEQIN_T_City_Data_Midd
where info.fldSTCode.Contains(x.fldSTCode) &&
YearList.Contains(x.fldYear) &&
x.ReportType == info.ReportType &&
x.STatType == info.STatType
select x).ToList();
}
else
{
query = (from x in db.tblEQIN_T_City_Data_Midd
where info.fldSTCode.Contains(x.fldSTCode) &&
YearList.Contains(x.fldYear) &&
x.ReportType == info.ReportType &&
x.STatType == info.STatType &&
x.fldDN == info.DN
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_T_City_Data_Midd> query2;
if (info.fldSTCode == "-1")
{
if (info.DN == "All")
{
query2 = (from x in db.tblEQIN_T_City_Data_Midd
where x.fldYear == year.ToString() &&
x.ReportType == info.ReportType &&
x.STatType == info.STatType
select x).ToList();
}
else
{
query2 = (from x in db.tblEQIN_T_City_Data_Midd
where x.fldYear == year.ToString() &&
x.ReportType == info.ReportType &&
x.STatType == info.STatType &&
x.fldDN == info.DN
select x).ToList();
}
}
else
{
if (info.DN == "All")
{
query2 = (from x in db.tblEQIN_T_City_Data_Midd
where info.fldSTCode.Contains(x.fldSTCode) &&
x.fldYear == year.ToString() &&
x.ReportType == info.ReportType &&
x.STatType == info.STatType
select x).ToList();
}
else
{
query2 = (from x in db.tblEQIN_T_City_Data_Midd
where info.fldSTCode.Contains(x.fldSTCode) &&
x.fldYear == year.ToString() &&
x.ReportType == info.ReportType &&
x.STatType == info.STatType &&
x.fldDN == info.DN
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 ExeCacheData(Info info)
{
string result = null;
DataTable dt = new DataTable();
int info_Midd_fldAutoID = 0;
try
{
//第一步
#region 初始化变量
tblEQIA_R_Info_Midd info_Midd = new tblEQIA_R_Info_Midd();
DateTime BeginDate = DateTime.Parse(info.BeginDate);
DateTime EndDate = DateTime.Parse(info.EndDate);
#endregion
//第二步
#region 处理参数表，检查此条件下是否已经进行过缓存
using (MiddleContext db = new MiddleContext())
{
var query = (from x in db.tblEQIA_R_Info_Midd
where x.TimeType == info.TimeType &&
x.BeginDate == BeginDate &&
x.EndDate == EndDate &&
x.fldPCode == info.fldPCode &&
x.fldStandardName == info.fldStandardName &&
x.fldLevel == info.fldLevel &&
x.fldItemCode == info.fldItemCode &&
x.DecCarry == info.DecCarry &&
x.IsPre == info.IsPre &&
x.IsYear == info.IsYear &&
x.IsTotal == info.IsTotal &&
x.IsDetail == info.IsDetail &&
x.fldSource == info.fldSource &&
x.AppriseID == info.AppriseID &&
x.STatType == info.STatType &&
x.CityID == info.CityID &&
x.CalculateID == info.CalculateID &&
x.ItemValueType == info.ItemValueType
select x).Count();
if (query > 0)
{
result = rule.JsonStr("ok", "此条件下已经进行过数据缓存。", "");
return(new HttpResponseMessage {
Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json")
});
}
}
#endregion
//第三步
#region 执行通用存储过程，返回数据
if (info.STatType == 0)
{
SqlParameter[] paras = new SqlParameter[]
{
new SqlParameter("@TimeType", info.TimeType),
new SqlParameter("@BeginDate", info.BeginDate),
new SqlParameter("@EndDate", info.EndDate),
new SqlParameter("@fldPCode", info.fldPCode),
new SqlParameter("@fldStandardName", info.fldStandardName),
new SqlParameter("@fldLevel", info.fldLevel),
new SqlParameter("@fldItemCode", info.fldItemCode),
new SqlParameter("@DecCarry", info.DecCarry),
new SqlParameter("@IsPre", info.IsPre),
new SqlParameter("@IsYear", info.IsYear),
new SqlParameter("@IsTotal", info.IsTotal),
new SqlParameter("@IsDetail", info.IsDetail),
new SqlParameter("@fldSource", info.fldSource),
new SqlParameter("@AppriseID", info.AppriseID),
new SqlParameter("@STatType", info.STatType),
new SqlParameter("@CityID", info.CityID),
new SqlParameter("@CalculateID", info.CalculateID),
new SqlParameter("@ItemValueType", info.ItemValueType)
};
dt = rule.RunProcedure("usp_tblEQIA_R_Report_AppriseStat", paras.ToList(), null);
}
if (dt == null || dt.Rows.Count == 0)
{
result = rule.JsonStr("ok", "此条件集合下并未返回数据", "");
return(new HttpResponseMessage {
Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json")
});
}
#endregion
//第四步
#region 如果存储过程返回数据，那么将条件写入参数表
using (MiddleContext db = new MiddleContext())
{
info_Midd.TimeType = info.TimeType;
info_Midd.BeginDate = BeginDate;
info_Midd.EndDate = EndDate;
info_Midd.fldPCode = info.fldPCode;
info_Midd.fldStandardName = info.fldStandardName;
info_Midd.fldLevel = info.fldLevel;
info_Midd.fldItemCode = info.fldItemCode;
info_Midd.DecCarry = info.DecCarry;
info_Midd.IsPre = info.IsPre;
info_Midd.IsYear = info.IsYear;
info_Midd.IsTotal = info.IsTotal;
info_Midd.IsDetail = info.IsDetail;
info_Midd.fldSource = info.fldSource;
info_Midd.AppriseID = info.AppriseID;
info_Midd.STatType = info.STatType;
info_Midd.CityID = info.CityID;
info_Midd.CalculateID = info.CalculateID;
info_Midd.ItemValueType = info.ItemValueType;
db.tblEQIA_R_Info_Midd.Add(info_Midd);
db.SaveChanges();
}
info_Midd_fldAutoID = info_Midd.fldAutoID;
#endregion
//第五步
#region 相关数据处理
List <Model.tblEQIA_R_Item> list_item = new List <tblEQIA_R_Item>();
using (MiddleContext db = new MiddleContext())
{
list_item = (from x in db.tblEQIA_R_Item
select x).ToList();
list_item = (from x in list_item
where info.fldItemCode.Split(',').Contains(x.fldItemCode)
select x).ToList();
}
// 日 - 城市评价
if (info.TimeType == "day" && info.AppriseID == 1)
{
using (MiddleContext db = new MiddleContext())
{
List <tblEQIA_R_City_DayStat_Midd> list = new List <tblEQIA_R_City_DayStat_Midd>();
foreach (DataRow item in dt.Rows)
{
tblEQIA_R_City_DayStat_Midd data = new tblEQIA_R_City_DayStat_Midd();
//将参数实体的主键值，设置给数据表的FKID，从而确定数据是从哪个参数下生成的
data.fldFKID = info_Midd.fldAutoID;
data.fldSTCode = item["fldSTCode"].ToString();
data.fldSTName = item["fldSTName"].ToString();
data.fldAppDate = DateTime.Parse(item["fldAppDate"].ToString());
data.fldMaxDAPI = item["fldMaxDAPI"].ToString();
data.fldItem = item["fldItem"].ToString();
data.fldOverItems = item["fldOverItems"].ToString();
data.fldDAQL = item["fldDAQL"].ToString();
list.Add(data);
db.tblEQIA_R_City_DayStat_Midd.Add(data);
db.SaveChanges();
// 因子表相关操作
List <tblEQIA_R_City_DayStat_Item_Midd> data_item_list = new List <tblEQIA_R_City_DayStat_Item_Midd>();
foreach (var item2 in info.fldItemCode.Split(','))
{
tblEQIA_R_City_DayStat_Item_Midd data_item = new tblEQIA_R_City_DayStat_Item_Midd();
data_item.fldFKID = int.Parse(data.fldAutoID.ToString());
data_item.fldItemCode = item2;
data_item.fldSTCode = item["fldSTCode"].ToString();
data_item.fldAppDate = DateTime.Parse(item["fldAppDate"].ToString());
data_item.fldItemAVG = item["AVG_" + (from x in list_item where item2 == x.fldItemCode select x.fldItemName).FirstOrDefault()].ToString();
data_item.fldItemAQI = item["AQI_" + (from x in list_item where item2 == x.fldItemCode select x.fldItemName).FirstOrDefault()].ToString();
data_item_list.Add(data_item);
}
db.tblEQIA_R_City_DayStat_Item_Midd.AddRange(data_item_list);
db.SaveChanges();
}
}
}
// 日 - 点位评价
if (info.TimeType == "day" && info.AppriseID == 0)
{
using (MiddleContext db = new MiddleContext())
{
List <tblEQIA_R_Point_DayStat_Midd> list = new List <tblEQIA_R_Point_DayStat_Midd>();
foreach (DataRow item in dt.Rows)
{
tblEQIA_R_Point_DayStat_Midd data = new tblEQIA_R_Point_DayStat_Midd();
//将参数实体的主键值，设置给数据表的FKID，从而确定数据是从哪个参数下生成的
data.fldFKID = info_Midd.fldAutoID;
data.fldSTCode = item["fldSTCode"].ToString();
data.fldSTName = item["fldSTName"].ToString();
data.fldPCode = item["fldPCode"].ToString();
data.fldPName = item["fldPName"].ToString();
data.fldPointLevel = item["fldPointLevel"].ToString();
data.fldAppDate = DateTime.Parse(item["fldAppDate"].ToString());
data.fldMaxDAPI = item["fldMaxDAPI"].ToString();
data.fldItem = item["fldItem"].ToString();
data.fldOverItems = item["fldOverItems"].ToString();
list.Add(data);
db.tblEQIA_R_Point_DayStat_Midd.Add(data);
db.SaveChanges();
// 因子表相关操作
List <tblEQIA_R_Point_DayStat_Item_Midd> data_item_list = new List <tblEQIA_R_Point_DayStat_Item_Midd>();
foreach (var item2 in info.fldItemCode.Split(','))
{
tblEQIA_R_Point_DayStat_Item_Midd data_item = new tblEQIA_R_Point_DayStat_Item_Midd();
data_item.fldFKID = int.Parse(data.fldAutoID.ToString());
data_item.fldItemCode = item2;
data_item.fldSTCode = item["fldSTCode"].ToString();
data_item.fldPCode = item["fldPCode"].ToString();
data_item.fldAppDate = DateTime.Parse(item["fldAppDate"].ToString());
data_item.fldItemAVG = item["AVG_" + (from x in list_item where item2 == x.fldItemCode select x.fldItemName).FirstOrDefault()].ToString();
data_item.fldItemAQI = item["AQI_" + (from x in list_item where item2 == x.fldItemCode select x.fldItemName).FirstOrDefault()].ToString();
data_item_list.Add(data_item);
}
db.tblEQIA_R_Point_DayStat_Item_Midd.AddRange(data_item_list);
db.SaveChanges();
}
}
}
// 季度、年、月 - 点位评价
if ((info.TimeType == "sea" && info.AppriseID == 0) || (info.TimeType == "month" && info.AppriseID == 0) || (info.TimeType == "year" && info.AppriseID == 0))
{
using (MiddleContext db = new MiddleContext())
{
List <tblEQIA_R_Point_TotalDateStat_Midd> list = new List <tblEQIA_R_Point_TotalDateStat_Midd>();
foreach (DataRow item in dt.Rows)
{
tblEQIA_R_Point_TotalDateStat_Midd data = new tblEQIA_R_Point_TotalDateStat_Midd();
//将参数实体的主键值，设置给数据表的FKID，从而确定数据是从哪个参数下生成的
data.fldFKID = info_Midd.fldAutoID;
data.fldTimeType = info.TimeType;
data.fldSTCode = item["fldSTCode"].ToString();
data.fldSTName = item["fldSTName"].ToString();
data.fldPCode = item["fldPCode"].ToString();
data.fldPName = item["fldPName"].ToString();
data.fldPointLevel = item["fldPointLevel"].ToString();
data.fldAppDate = item["fldAppDate"].ToString();
data.fldSumCount = item["fldSumCount"].ToString();
data.fldCount = item["fldCount"].ToString();
data.fldYLCount = item["fldYLCount"].ToString();
data.fldYCount = item["fld1Count"].ToString();
data.fldLCount = item["fld2Count"].ToString();
data.fldQDCount = item["fld3Count"].ToString();
data.fldZDCount = item["fld4Count"].ToString();
data.fldZZDCount = item["fld5Count"].ToString();
data.fldYZCount = item["fld6Count"].ToString();
data.fldWPI = item["fldWPI"].ToString();
data.fldMCPI = item["fldMCPI"].ToString();
data.fldCFI = item["fldCFI"].ToString();
data.fldLevel = item["fldLevel"].ToString();
list.Add(data);
db.tblEQIA_R_Point_TotalDateStat_Midd.Add(data);
db.SaveChanges();
// 因子表相关操作
List <tblEQIA_R_Point_TotalDateStat_Item_Midd> data_item_list = new List <tblEQIA_R_Point_TotalDateStat_Item_Midd>();
foreach (var item2 in info.fldItemCode.Split(','))
{
tblEQIA_R_Point_TotalDateStat_Item_Midd data_item = new tblEQIA_R_Point_TotalDateStat_Item_Midd();
data_item.fldFKID = int.Parse(data.fldAutoID.ToString());
data_item.fldItemCode = item2;
data_item.fldSTCode = item["fldSTCode"].ToString();
data_item.fldPCode = item["fldPCode"].ToString();
data_item.fldTimeType = item["fldType"].ToString();
data_item.fldAppDate = item["fldAppDate"].ToString();
data_item.fldItemAVG = item["AVG_" + item2].ToString();
data_item.fldItemSD = item["Sd_" + item2].ToString();
data_item.fldItemMin = item["Min_" + item2].ToString();
data_item.fldItemMax = item["Max_" + item2].ToString();
data_item.fldItemLevels = item["Levels_" + item2].ToString();
data_item.fldItemAllDays = item["AllDays_" + item2].ToString();
data_item.fldItemCurDays = item["CurDays_" + item2].ToString();
data_item.fldItemStdDays = item["StdDays_" + item2].ToString();
data_item.fldItem1LevelDays = item["1LevelDays" + item2].ToString();
data_item.fldItemStand = item["Stand" + item2].ToString();
data_item.fldItemOvers = item["Overs" + item2].ToString();
data_item.fldItemMinOut = item["MinOut" + item2].ToString();
data_item.fldItemMaxOut = item["MaxOut_" + item2].ToString();
data_item.fldItemCFI = item["CFI_" + item2].ToString();
data_item.fldItemCFIW = item["CFI_W_" + item2].ToString();
data_item.fldItemCPI = item["CPI_" + item2].ToString();
data_item.fldItemLoad = item["Load_" + item2].ToString();
data_item.fldItemBFW = item["BFW_" + item2].ToString();
data_item.fldItemBFW90 = item["BFW90_" + item2].ToString();
data_item.fldItemBFW98 = item["BFW98_" + item2].ToString();
data_item_list.Add(data_item);
}
db.tblEQIA_R_Point_TotalDateStat_Item_Midd.AddRange(data_item_list);
db.SaveChanges();
}
}
}
// 季度、年、月 - 城市评价
if ((info.TimeType == "sea" && info.AppriseID == 1) || (info.TimeType == "month" && info.AppriseID == 1) || (info.TimeType == "year" && info.AppriseID == 1))
{
using (MiddleContext db = new MiddleContext())
{
List <tblEQIA_R_City_TotalDateStat_Midd> list = new List <tblEQIA_R_City_TotalDateStat_Midd>();
foreach (DataRow item in dt.Rows)
{
tblEQIA_R_City_TotalDateStat_Midd data = new tblEQIA_R_City_TotalDateStat_Midd();
//将参数实体的主键值，设置给数据表的FKID，从而确定数据是从哪个参数下生成的
data.fldFKID = info_Midd.fldAutoID;
data.fldTimeType = info.TimeType;
data.fldSTCode = item["fldSTCode"].ToString();
data.fldSTName = item["fldSTName"].ToString();
data.fldAppDate = item["fldAppDate"].ToString();
data.fldSumCount = item["fldSumCount"].ToString();
data.fldCount = item["fldCount"].ToString();
data.fldYLCount = item["fldYLCount"].ToString();
data.fldYCount = item["fld1Count"].ToString();
data.fldLCount = item["fld2Count"].ToString();
data.fldQDCount = item["fld3Count"].ToString();
data.fldZDCount = item["fld4Count"].ToString();
data.fldZZDCount = item["fld5Count"].ToString();
data.fldYZCount = item["fld6Count"].ToString();
data.fldWPI = item["fldWPI"].ToString();
data.fldMCPI = item["fldMCPI"].ToString();
data.fldCFI = item["fldCFI"].ToString();
data.fldLevel = item["fldLevel"].ToString();
list.Add(data);
db.tblEQIA_R_City_TotalDateStat_Midd.Add(data);
db.SaveChanges();
// 因子表相关操作
List <tblEQIA_R_City_TotalDateStat_Item_Midd> data_item_list = new List <tblEQIA_R_City_TotalDateStat_Item_Midd>();
foreach (var item2 in info.fldItemCode.Split(','))
{
tblEQIA_R_City_TotalDateStat_Item_Midd data_item = new tblEQIA_R_City_TotalDateStat_Item_Midd();
data_item.fldFKID = int.Parse(data.fldAutoID.ToString());
data_item.fldItemCode = item2;
data_item.fldSTCode = item["fldSTCode"].ToString();
data_item.fldTimeType = item["fldType"].ToString();
data_item.fldAppDate = item["fldAppDate"].ToString();
data_item.fldItemAVG = item["AVG_" + item2].ToString();
data_item.fldItemSD = item["Sd_" + item2].ToString();
data_item.fldItemMin = item["Min_" + item2].ToString();
data_item.fldItemMax = item["Max_" + item2].ToString();
data_item.fldItemLevels = item["Levels_" + item2].ToString();
data_item.fldItemAllDays = item["AllDays_" + item2].ToString();
data_item.fldItemCurDays = item["CurDays_" + item2].ToString();
data_item.fldItemStdDays = item["StdDays_" + item2].ToString();
data_item.fldItem1LevelDays = item["1LevelDays" + item2].ToString();
data_item.fldItemStand = item["Stand" + item2].ToString();
data_item.fldItemOvers = item["Overs" + item2].ToString();
data_item.fldItemMinOut = item["MinOut" + item2].ToString();
data_item.fldItemMaxOut = item["MaxOut_" + item2].ToString();
data_item.fldItemCFI = item["CFI_" + item2].ToString();
data_item.fldItemCFIW = item["CFI_W_" + item2].ToString();
data_item.fldItemCPI = item["CPI_" + item2].ToString();
data_item.fldItemLoad = item["Load_" + item2].ToString();
data_item.fldItemBFW = item["BFW_" + item2].ToString();
data_item.fldItemBFW90 = item["BFW90_" + item2].ToString();
data_item.fldItemBFW98 = item["BFW98_" + item2].ToString();
data_item_list.Add(data_item);
}
db.tblEQIA_R_City_TotalDateStat_Item_Midd.AddRange(data_item_list);
db.SaveChanges();
}
}
}
#endregion
result = rule.JsonStr("ok", "执行成功！", info_Midd.fldAutoID);
}
catch (Exception e)
{
if (info_Midd_fldAutoID > 0)
{
using (MiddleContext db = new MiddleContext())
{
var query = (from x in db.tblEQIA_R_Info_Midd
where x.fldAutoID == info_Midd_fldAutoID
select x).FirstOrDefault();
db.tblEQIA_R_Info_Midd.Remove(query);
db.SaveChanges();
}
}
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 == "ItemOverStat")
{
using (MiddleContext db = new MiddleContext())
{
List <tblV_EQIW_RL_ItemOverStat_Midd> query = new List <tblV_EQIW_RL_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.tblV_EQIW_RL_ItemOverStat_Midd
where x.fldTimeType == info.fldTimeType &&
x.fldSectionType == info.fldSCategory &&
list.Contains(x.fldAppDate)
select x).ToList();
ReturnData rd = new ReturnData();
rd.dangqi = query;
if (info.IsYear == "1")
{
List <tblV_EQIW_RL_ItemOverStat_Midd> query2 = new List <tblV_EQIW_RL_ItemOverStat_Midd>();
query2 = (from x in db.tblV_EQIW_RL_ItemOverStat_Midd
where x.fldTimeType == info.fldTimeType &&
x.fldSectionType == info.fldSCategory &&
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 <tblV_EQIW_RL_SectionStat_Midd> query = new List <tblV_EQIW_RL_SectionStat_Midd>();
List <tblV_EQIW_RL_SectionStat_Item_Midd> query_Item = new List <tblV_EQIW_RL_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.tblV_EQIW_RL_SectionStat_Midd
where x.fldTimeType == info.fldTimeType &&
list.Contains(x.fldAppDate)
select x).ToList();
}
else
{
query = (from x in db.tblV_EQIW_RL_SectionStat_Midd
where x.fldTimeType == info.fldTimeType &&
list.Contains(x.fldAppDate) &&
info.fldSTCode.Contains(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_RL_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 <tblV_EQIW_RL_SectionStat_Midd> query2 = new List <tblV_EQIW_RL_SectionStat_Midd>();
List <tblV_EQIW_RL_SectionStat_Item_Midd> query_Item2 = new List <tblV_EQIW_RL_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.tblV_EQIW_RL_SectionStat_Midd
where x.fldTimeType == info.fldTimeType &&
list.Contains(x.fldAppDate)
select x).ToList();
}
else
{
query2 = (from x in db.tblV_EQIW_RL_SectionStat_Midd
where x.fldTimeType == info.fldTimeType &&
list.Contains(x.fldAppDate) &&
info.fldSTCode.Contains(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_RL_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 <tblV_EQIW_RL_TatalSectStat_Midd> query = new List <tblV_EQIW_RL_TatalSectStat_Midd>();
List <tblV_EQIW_RL_TatalSectStat_Item_Midd> query_Item = new List <tblV_EQIW_RL_TatalSectStat_Item_Midd>();
DateTime BeginDate = DateTime.Parse(info.fldBeginDate);
DateTime EndDate = DateTime.Parse(info.fldEndDate);
List <string> list = ConvertDate(info.fldTimeType, BeginDate, EndDate);
if (info.fldSpaceName == null)
{
query = (from x in db.tblV_EQIW_RL_TatalSectStat_Midd
where x.fldTimeType == info.fldTimeType &&
list.Contains(x.fldAppDate) &&
info.fldSpaceType == x.fldSpaceType &&
info.fldSCategory.Contains(x.fldSCategory)
select x).ToList();
}
else
{
query = (from x in db.tblV_EQIW_RL_TatalSectStat_Midd
where x.fldTimeType == info.fldTimeType &&
list.Contains(x.fldAppDate) &&
info.fldSpaceType == x.fldSpaceType &&
info.fldSpaceName.Contains(x.fldSpaceName) &&
info.fldSCategory.Contains(x.fldSCategory)
select x).ToList();
}
if (info.fldItemCode != null)
{
query_Item = (from x in query
join y in db.tblV_EQIW_RL_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 <tblV_EQIW_RL_TatalSectStat_Midd> query2 = new List <tblV_EQIW_RL_TatalSectStat_Midd>();
List <tblV_EQIW_RL_TatalSectStat_Item_Midd> query_Item2 = new List <tblV_EQIW_RL_TatalSectStat_Item_Midd>();
BeginDate = BeginDate.AddYears(-1);
EndDate = EndDate.AddYears(-1);
list = ConvertDate(info.fldTimeType, BeginDate, EndDate);
if (info.fldSpaceName == null)
{
query2 = (from x in db.tblV_EQIW_RL_TatalSectStat_Midd
where x.fldTimeType == info.fldTimeType &&
list.Contains(x.fldAppDate) &&
info.fldSpaceType == x.fldSpaceType &&
info.fldSCategory.Contains(x.fldSCategory)
select x).ToList();
}
else
{
query2 = (from x in db.tblV_EQIW_RL_TatalSectStat_Midd
where x.fldTimeType == info.fldTimeType &&
list.Contains(x.fldAppDate) &&
info.fldSpaceType == x.fldSpaceType &&
info.fldSpaceName.Contains(x.fldSpaceName) &&
info.fldSCategory.Contains(x.fldSCategory)
select x).ToList();
}
if (info.fldItemCode != null)
{
query_Item2 = (from x in query2
join y in db.tblV_EQIW_RL_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);
}
}
}
catch (Exception e)
{
result = rule.JsonStr("error", e.Message, "");
}
return(new HttpResponseMessage {
Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json")
});
}
public HttpResponseMessage ExeCacheData_EQISO(Info_EQISO info)
{
string result = null;
DataTable dt = new DataTable();
try
{
//第一步
#region 初始化变量
tblHM_EQISO_Info_Midd info_Midd = new tblHM_EQISO_Info_Midd();
DateTime BeginDate = DateTime.Parse(info.BeginDate);
DateTime EndDate = DateTime.Parse(info.EndDate);
#endregion
//第二步
#region 处理参数表，检查此条件下是否已经进行过缓存
using (MiddleContext db = new MiddleContext())
{
var query = (from x in db.tblHM_EQISO_Info_Midd
where x.BeginDate == BeginDate &&
x.EndDate == EndDate &&
x.fldPCode == info.fldPCode &&
x.fldStandardName == info.fldStandardName &&
x.fldLevel == info.fldLevel &&
x.fldItemCode == info.fldItemCode &&
x.DecCarry == info.DecCarry
select x).Count();
if (query > 0)
{
result = rule.JsonStr("ok", "此条件下已经进行过数据缓存。", "");
return(new HttpResponseMessage {
Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json")
});
}
}
#endregion
//第三步
#region 执行通用存储过程，返回数据
SqlParameter[] paras = new SqlParameter[]
{
new SqlParameter("@BeginDate", info.BeginDate),
new SqlParameter("@EndDate", info.EndDate),
new SqlParameter("@fldPCode", info.fldPCode),
new SqlParameter("@fldStandardName", info.fldStandardName),
new SqlParameter("@fldLevel", info.fldLevel),
new SqlParameter("@fldItemCode", info.fldItemCode),
new SqlParameter("@DecCarry", info.DecCarry)
};
dt = rule.RunProcedure_V2("usp_tblEQISO_Report_LevelApprise", paras.ToList(), null, "HMEntityContext");
if (dt == null || dt.Rows.Count == 0)
{
result = rule.JsonStr("ok", "此条件集合下并未返回数据", "");
return(new HttpResponseMessage {
Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json")
});
}
#endregion
//第四步
#region 如果存储过程返回数据，那么将条件写入参数表
using (MiddleContext db = new MiddleContext())
{
info_Midd.BeginDate = BeginDate;
info_Midd.EndDate = EndDate;
info_Midd.fldPCode = info.fldPCode;
info_Midd.fldStandardName = info.fldStandardName;
info_Midd.fldLevel = info.fldLevel;
info_Midd.fldItemCode = info.fldItemCode;
info_Midd.DecCarry = info.DecCarry;
db.tblHM_EQISO_Info_Midd.Add(info_Midd);
db.SaveChanges();
}
#endregion
//第五步
#region 相关数据处理
if (true)
{
using (MiddleContext db = new MiddleContext())
{
List <tblHM_EQISO_Midd> list = new List <tblHM_EQISO_Midd>();
foreach (DataRow item in dt.Rows)
{
tblHM_EQISO_Midd data = new tblHM_EQISO_Midd();
//将参数实体的主键值，设置给数据表的FKID，从而确定数据是从哪个参数下生成的
data.fldFKID = info_Midd.fldAutoID;
data.fldSTName = item["fldSTName"].ToString();
data.fldPCount = item["fldPCount"].ToString();
data.fldScale = item["fldScale"].ToString();
data.fldRange = item["fldRange"].ToString();
data.fldPiAvg = item["fldPiAvg"].ToString();
data.fld1Level = item["fld1Level"].ToString();
data.fld2Level = item["fld2Level"].ToString();
list.Add(data);
}
db.tblHM_EQISO_Midd.AddRange(list);
db.SaveChanges();
}
}
#endregion
result = rule.JsonStr("ok", "执行成功！", info_Midd.fldAutoID);
}
catch (Exception e)
{
result = rule.JsonStr("error", e.Message, "");
}
return(new HttpResponseMessage {
Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json")
});
}
public HttpResponseMessage ExeCacheData_EQIW_RLD(Info_EQIW_RLD info)
{
string result = null;
DataTable dt = new DataTable();
try
{
//第一步
#region 初始化变量
tblHM_EQIW_RLD_Info_Midd info_Midd = new tblHM_EQIW_RLD_Info_Midd();
DateTime BeginDate = DateTime.Parse(info.BeginDate);
DateTime EndDate = DateTime.Parse(info.EndDate);
DateTime?EBeginDate = null;
DateTime?EEndDate = null;
DateTime EBeginDate2 = new DateTime();
DateTime EEndDate2 = new DateTime();
if (!(info.EBeginDate == "" || info.EEndDate == ""))
{
DateTime.TryParse(info.EBeginDate, out EBeginDate2);
DateTime.TryParse(info.EEndDate, out EEndDate2);
EBeginDate = EBeginDate2;
EEndDate = EEndDate2;
}
#endregion
//第二步
#region 处理参数表，检查此条件下是否已经进行过缓存
using (MiddleContext db = new MiddleContext())
{
var query = (from x in db.tblHM_EQIW_RLD_Info_Midd
where x.TimeType == info.TimeType &&
x.BeginDate == BeginDate &&
x.EndDate == EndDate &&
x.EBeginDate == EBeginDate &&
x.EEndDate == EEndDate &&
x.fldRSC == info.fldRSC &&
x.fldRSCode == info.fldRSCode &&
x.fldStandardName == info.fldStandardName &&
x.fldLevel == info.fldLevel &&
x.fldStandardNameG == info.fldStandardNameG &&
x.fldLevelG == info.fldLevelG &&
x.fldItemCode == info.fldItemCode &&
x.DecCarry == info.DecCarry &&
x.IsPre == info.IsPre &&
x.IsYear == info.IsYear &&
x.IsTotal == info.IsTotal &&
x.IsDetail == info.IsDetail &&
x.AppriseID == info.AppriseID &&
x.SpaceID == info.SpaceID &&
x.STatType == info.STatType &&
x.Para1ID == info.Para1ID &&
x.Para2ID == info.Para2ID &&
x.Source == info.Source
select x).Count();
if (query > 0)
{
result = rule.JsonStr("ok", "此条件下已经进行过数据缓存。", "");
return(new HttpResponseMessage {
Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json")
});
}
}
#endregion
//第三步
#region 执行通用存储过程，返回数据
SqlParameter[] paras = new SqlParameter[]
{
new SqlParameter("@TimeType", info.TimeType),
new SqlParameter("@BeginDate", info.BeginDate),
new SqlParameter("@EndDate", info.EndDate),
new SqlParameter("@EBeginDate", info.EBeginDate),
new SqlParameter("@EEndDate", info.EEndDate),
new SqlParameter("@fldRSC", info.fldRSC),
new SqlParameter("@fldRSCode", info.fldRSCode),
new SqlParameter("@fldStandardName", info.fldStandardName),
new SqlParameter("@fldLevel", info.fldLevel),
new SqlParameter("@fldStandardNameG", info.fldStandardNameG),
new SqlParameter("@fldLevelG", info.fldLevelG),
new SqlParameter("@fldItemCode", info.fldItemCode),
new SqlParameter("@DecCarry", info.DecCarry),
new SqlParameter("@IsPre", info.IsPre),
new SqlParameter("@IsYear", info.IsYear),
new SqlParameter("@IsTotal", info.IsTotal),
new SqlParameter("@IsDetail", info.IsDetail),
new SqlParameter("@AppriseID", info.AppriseID),
new SqlParameter("@SpaceID", info.SpaceID),
new SqlParameter("@STatType", info.STatType),
new SqlParameter("@Para1ID", info.Para1ID),
new SqlParameter("@Para2ID", info.Para2ID),
new SqlParameter("@Source", info.Source)
};
dt = rule.RunProcedure_V2("usp_tblEQIW_RLD_Report_HMApprirse", paras.ToList(), null, "HMEntityContext");
if (dt == null || dt.Rows.Count == 0)
{
result = rule.JsonStr("ok", "此条件集合下并未返回数据", "");
return(new HttpResponseMessage {
Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json")
});
}
#endregion
//第四步
#region 如果存储过程返回数据，那么将条件写入参数表
using (MiddleContext db = new MiddleContext())
{
info_Midd.TimeType = info.TimeType;
info_Midd.BeginDate = BeginDate;
info_Midd.EndDate = EndDate;
info_Midd.EBeginDate = EBeginDate;
info_Midd.EEndDate = EEndDate;
info_Midd.fldRSC = info.fldRSC;
info_Midd.fldRSCode = info.fldRSCode;
info_Midd.fldStandardName = info.fldStandardName;
info_Midd.fldLevel = info.fldLevel;
info_Midd.fldStandardNameG = info.fldStandardNameG;
info_Midd.fldLevelG = info.fldLevelG;
info_Midd.fldItemCode = info.fldItemCode;
info_Midd.DecCarry = info.DecCarry;
info_Midd.IsPre = info.IsPre;
info_Midd.IsYear = info.IsYear;
info_Midd.IsTotal = info.IsTotal;
info_Midd.IsDetail = info.IsDetail;
info_Midd.AppriseID = info.AppriseID;
info_Midd.SpaceID = info.SpaceID;
info_Midd.STatType = info.STatType;
info_Midd.Para1ID = info.Para1ID;
info_Midd.Para2ID = info.Para2ID;
info_Midd.Source = info.Source;
db.tblHM_EQIW_RLD_Info_Midd.Add(info_Midd);
db.SaveChanges();
}
#endregion
//第五步
#region 相关数据处理
//年鉴格式
if (info.STatType == 1)
{
using (MiddleContext db = new MiddleContext())
{
List <tblHM_EQIW_RLD_STatType1_Midd> list = new List <tblHM_EQIW_RLD_STatType1_Midd>();
foreach (DataRow item in dt.Rows)
{
tblHM_EQIW_RLD_STatType1_Midd data = new tblHM_EQIW_RLD_STatType1_Midd();
//将参数实体的主键值，设置给数据表的FKID，从而确定数据是从哪个参数下生成的
data.fldFKID = info_Midd.fldAutoID;
data.fldWaterArea = item["fldWaterArea"].ToString();
data.fldLevel = item["fldLevel"].ToString();
data.fldAtt = item["fldAtt"].ToString();
data.fldSTCode = item["fldSTCode"].ToString();
data.fldSTName = item["fldSTName"].ToString();
data.fldRCode = item["fldRCode"].ToString();
data.fldRName = item["fldRName"].ToString();
data.fldRSCode = item["fldRSCode"].ToString();
data.fldRSName = item["fldRSName"].ToString();
data.fldDate = item["fldDate"].ToString();
data.fldFun = item["fldFun"].ToString();
data.fldStage = item["fldStage"].ToString();
db.tblHM_EQIW_RLD_STatType1_Midd.Add(data);
db.SaveChanges();
List <tblHM_EQIW_RLD_STatType1_Item_Midd> data_item_list = new List <tblHM_EQIW_RLD_STatType1_Item_Midd>();
foreach (var item2 in info.fldItemCode.Split(','))
{
if (item.Table.Columns.Contains("fld" + item2))
{
tblHM_EQIW_RLD_STatType1_Item_Midd data_item = new tblHM_EQIW_RLD_STatType1_Item_Midd();
data_item.fldFKID = data.fldAutoID;
data_item.fldItemCode = item2;
data_item.fldItemValue = item["fld" + item2].ToString();
data_item_list.Add(data_item);
}
}
db.tblHM_EQIW_RLD_STatType1_Item_Midd.AddRange(data_item_list);
db.SaveChanges();
}
}
}
//断面或者河流综合评价
if (info.STatType == 3)
{
using (MiddleContext db = new MiddleContext())
{
List <tblHM_EQIW_RLD_STatType3_Midd> list = new List <tblHM_EQIW_RLD_STatType3_Midd>();
foreach (DataRow item in dt.Rows)
{
tblHM_EQIW_RLD_STatType3_Midd data = new tblHM_EQIW_RLD_STatType3_Midd();
//将参数实体的主键值，设置给数据表的FKID，从而确定数据是从哪个参数下生成的
data.fldFKID = info_Midd.fldAutoID;
//data.AppriseID = info.AppriseID.ToString();
//data.STatType = info.STatType.ToString();
data.fldWaterArea = item["fldWaterArea"].ToString();
data.fldSTCode = item["fldSTCode"].ToString();
data.fldSTName = item["fldSTName"].ToString();
data.fldRCode = item["fldRCode"].ToString();
data.fldRName = item["fldRName"].ToString();
data.fldRSCode = item["fldRSCode"].ToString();
data.fldRSName = item["fldRSName"].ToString();
data.fldLevel = item["fldLevel"].ToString();
data.fldAtt = item["fldAtt"].ToString();
data.fldRSC = item["fldRSC"].ToString();
data.fldAppDate = item["fldAppDate"].ToString();
data.fldType = item["fldType"].ToString();
data.fldFun = item["fldFun"].ToString();
data.fldStage = item["fldStage"].ToString();
data.fldSectionApp = item["fldSectionApp"].ToString();
data.fldStand = item["fldStand"].ToString();
db.tblHM_EQIW_RLD_STatType3_Midd.Add(data);
db.SaveChanges();
List <tblHM_EQIW_RLD_STatType3_Item_Midd> data_item_list = new List <tblHM_EQIW_RLD_STatType3_Item_Midd>();
foreach (var item2 in info.fldItemCode.Split(','))
{
if (item.Table.Columns.Contains(item2 + "_Value"))
{
tblHM_EQIW_RLD_STatType3_Item_Midd data_item = new tblHM_EQIW_RLD_STatType3_Item_Midd();
data_item.fldFKID = data.fldAutoID;
data_item.fldItemCode = item2;
data_item.fld_Value = item[item2 + "_Value"].ToString();
if (item.Table.Columns.Contains(item2 + "_Stage"))
{
data_item.fld_Stage = item[item2 + "_Stage"].ToString();
}
if (item.Table.Columns.Contains(item2 + "_STG"))
{
data_item.fld_STG = item[item2 + "_STG"].ToString();
}
if (item.Table.Columns.Contains(item2 + "_Over"))
{
data_item.fld_Over = item[item2 + "_Over"].ToString();
}
if (item.Table.Columns.Contains(item2 + "_OutScale"))
{
data_item.fld_OutScale = item[item2 + "_OutScale"].ToString();
}
if (item.Table.Columns.Contains(item2 + "_Min"))
{
data_item.fld_Min = item[item2 + "_Min"].ToString();
}
if (item.Table.Columns.Contains(item2 + "_Max"))
{
data_item.fld_Max = item[item2 + "_Max"].ToString();
}
if (item.Table.Columns.Contains(item2 + "_MaxOut"))
{
data_item.fld_MaxOut = item[item2 + "_MaxOut"].ToString();
}
if (item.Table.Columns.Contains(item2 + "_MaxDate"))
{
data_item.fld_MaxDate = item[item2 + "_MaxDate"].ToString();
}
data_item_list.Add(data_item);
}
}
db.tblHM_EQIW_RLD_STatType3_Item_Midd.AddRange(data_item_list);
db.SaveChanges();
}
}
}
#endregion
result = rule.JsonStr("ok", "执行成功！", info_Midd.fldAutoID);
}
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 getdistinctdata(string tablename, string stname)
{
string result = "";
try
{
if (tablename == "city")
{
using (MiddleContext db = new MiddleContext())
{
List <object> retu = new List <object>();
var query = (from x in db.tblEQIW_D_City_Midd
select new
{
fldCityCode = x.fldCityCode,
fldCityName = x.fldCityName
}
).DistinctBy(x => new { x.fldCityCode, x.fldCityName }).OrderBy(x => x.fldCityCode);
var query2 = (from x in db.tblEQIW_D_City_Midd
select new
{
fldSCategory = x.fldSCategory,
fldSCategoryName = x.fldSCategory
}
).DistinctBy(x => new { x.fldSCategory }).OrderBy(x => x.fldSCategory);
retu.Add(query);
retu.Add(query2);
result = rule.JsonStr("ok", "成功", retu);
}
}
if (tablename == "section")
{
using (MiddleContext db = new MiddleContext())
{
List <object> retu = new List <object>();
var query = (from x in db.tblEQIW_D_Section_Midd
select new
{
fldCityCode = x.fldCityCode,
fldCityName = x.fldCityName
}
).DistinctBy(x => new { x.fldCityCode, x.fldCityName }).OrderBy(x => x.fldCityCode);
var query2 = (from x in db.tblEQIW_D_Section_Midd
select new
{
fldSCategory = x.fldSCategory
}
).DistinctBy(x => new { x.fldSCategory }).OrderBy(x => x.fldSCategory);
if (stname == "-1")
{
var query3 = (from x in db.tblEQIW_D_Section_Midd
select new
{
fldRSCode = x.fldRSCode,
fldRSName = x.fldRSName,
fldSTName = x.fldSTName
}
).DistinctBy(x => new { x.fldRSCode, x.fldRSName }).OrderBy(x => x.fldRSCode);
retu.Add(query);
retu.Add(query2);
retu.Add(query3);
}
else
{
var query3 = (from x in db.tblEQIW_D_Section_Midd
where stname.Contains(x.fldCityName)
select new
{
fldRSCode = x.fldRSCode,
fldRSName = x.fldRSName,
fldSTName = x.fldSTName
}
).DistinctBy(x => new { x.fldRSCode, x.fldRSName }).OrderBy(x => x.fldRSCode);
retu.Add(query);
retu.Add(query2);
retu.Add(query3);
}
result = rule.JsonStr("ok", "成功", retu);
}
}
}
catch (Exception e)
{
result = rule.JsonStr("error", e.Message, "");
}
return(new HttpResponseMessage {
Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json")
});
}
public HttpResponseMessage ExeCacheData(Info info)
{
string result = null;
DataTable dt = new DataTable();
try
{
//第一步
#region 初始化变量
tblEQISO_Info_Midd info_Midd = new tblEQISO_Info_Midd();
DateTime BeginDate = DateTime.Parse(info.BeginDate);
DateTime EndDate = DateTime.Parse(info.EndDate);
#endregion
//第二步
#region 处理参数表，检查此条件下是否已经进行过缓存
using (MiddleContext db = new MiddleContext())
{
var query = (from x in db.tblEQISO_Info_Midd
where x.TimeType == info.TimeType &&
x.BeginDate == BeginDate &&
x.EndDate == EndDate &&
x.fldRSCode == info.fldRSCode &&
x.fldStandardName == info.fldStandardName &&
x.fldLevel == info.fldLevel &&
x.fldItemCode == info.fldItemCode &&
x.DecCarry == info.DecCarry &&
x.AppriseID == info.AppriseID &&
x.SpaceID == info.SpaceID &&
x.STatType == info.STatType
select x).Count();
if (query > 0)
{
result = rule.JsonStr("ok", "此条件下已经进行过数据缓存。", "");
return(new HttpResponseMessage {
Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json")
});
}
}
#endregion
//第三步
#region 执行通用存储过程，返回数据
SqlParameter[] paras = new SqlParameter[]
{
new SqlParameter("@TimeType", info.TimeType),
new SqlParameter("@BeginDate", info.BeginDate),
new SqlParameter("@EndDate", info.EndDate),
new SqlParameter("@fldRSCode", info.fldRSCode),
new SqlParameter("@fldStandardName", info.fldStandardName),
new SqlParameter("@fldLevel", info.fldLevel),
new SqlParameter("@fldItemCode", info.fldItemCode),
new SqlParameter("@DecCarry", info.DecCarry),
new SqlParameter("@AppriseID", info.AppriseID),
new SqlParameter("@SpaceID", info.SpaceID),
new SqlParameter("@STatType", info.STatType)
};
dt = rule.RunProcedure("usp_tblEQISO_Report_Apprise", paras.ToList(), null);
if (dt == null || dt.Rows.Count == 0)
{
result = rule.JsonStr("ok", "此条件集合下并未返回数据", "");
return(new HttpResponseMessage {
Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json")
});
}
#endregion
//第四步
#region 如果存储过程返回数据，那么将条件写入参数表
using (MiddleContext db = new MiddleContext())
{
info_Midd.TimeType = info.TimeType;
info_Midd.BeginDate = BeginDate;
info_Midd.EndDate = EndDate;
info_Midd.fldRSCode = info.fldRSCode;
info_Midd.fldStandardName = info.fldStandardName;
info_Midd.fldLevel = info.fldLevel;
info_Midd.fldItemCode = info.fldItemCode;
info_Midd.DecCarry = info.DecCarry;
info_Midd.AppriseID = info.AppriseID;
info_Midd.SpaceID = info.SpaceID;
info_Midd.STatType = info.STatType;
db.tblEQISO_Info_Midd.Add(info_Midd);
db.SaveChanges();
}
#endregion
//第五步
#region 相关数据处理
//原始数据表
if (info.SpaceID == 0)
{
using (MiddleContext db = new MiddleContext())
{
List <tblEQISO_SpaceID0_Midd> list = new List <tblEQISO_SpaceID0_Midd>();
foreach (DataRow item in dt.Rows)
{
tblEQISO_SpaceID0_Midd data = new tblEQISO_SpaceID0_Midd();
//将参数实体的主键值，设置给数据表的FKID，从而确定数据是从哪个参数下生成的
data.fldFKID = info_Midd.fldAutoID;
data.fldCityCode = item["fldCityCode"].ToString();
data.fldCityName = item["fldCityName"].ToString();
data.fldSTCode = item["fldSTCode"].ToString();
data.fldSTName = item["fldSTName"].ToString();
data.fldEntCode = item["fldEntCode"].ToString();
data.fldEntName = item["fldEntName"].ToString();
data.fldAddress = item["fldAddress"].ToString();
data.fldPCode = item["fldPCode"].ToString();
data.fldPName = item["fldPName"].ToString();
data.fldLevel = item["fldLevel"].ToString();
data.fldDate = Convert.ToDateTime(item["fldYear"].ToString() + "-" + item["fldMonth"].ToString() + "-" + item["fldDay"].ToString());
db.tblEQISO_SpaceID0_Midd.Add(data);
db.SaveChanges();
List <tblEQISO_SpaceID0_Item_Midd> data_item_list = new List <tblEQISO_SpaceID0_Item_Midd>();
foreach (var item2 in info.fldItemCode.Split(','))
{
if (item.Table.Columns.Contains("fld" + item2))
{
tblEQISO_SpaceID0_Item_Midd data_item = new tblEQISO_SpaceID0_Item_Midd();
data_item.fldFKID = data.fldAutoID;
data_item.fldItemCode = item2;
data_item.fldItemValue = item["fld" + item2].ToString();
data_item_list.Add(data_item);
}
}
db.tblEQISO_SpaceID0_Item_Midd.AddRange(data_item_list);
db.SaveChanges();
}
}
}
//基本统计表
if (info.SpaceID == 1)
{
using (MiddleContext db = new MiddleContext())
{
List <tblEQISO_SpaceID1_Midd> list = new List <tblEQISO_SpaceID1_Midd>();
foreach (DataRow item in dt.Rows)
{
tblEQISO_SpaceID1_Midd data = new tblEQISO_SpaceID1_Midd();
//将参数实体的主键值，设置给数据表的FKID，从而确定数据是从哪个参数下生成的
data.fldFKID = info_Midd.fldAutoID;
data.AppriseID = info.AppriseID.ToString();
data.STatType = info.STatType.ToString();
data.fldYear = item["fldYear"].ToString();
data.fldCityCode = item["fldCityCode"].ToString();
data.fldCityName = item["fldCityName"].ToString();
data.fldSTCode = item["fldSTCode"].ToString();
data.fldSTName = item["fldSTName"].ToString();
data.fldEntCode = item["fldEntCode"].ToString();
data.fldEntName = item["fldEntName"].ToString();
data.fldAddress = item["fldAddress"].ToString();
data.fldDate = item["fldDate"].ToString();
db.tblEQISO_SpaceID1_Midd.Add(data);
db.SaveChanges();
List <tblEQISO_SpaceID1_Item_Midd> data_item_list = new List <tblEQISO_SpaceID1_Item_Midd>();
foreach (var item2 in info.fldItemCode.Split(','))
{
if (item.Table.Columns.Contains("fld" + item2))
{
tblEQISO_SpaceID1_Item_Midd data_item = new tblEQISO_SpaceID1_Item_Midd();
data_item.fldFKID = data.fldAutoID;
data_item.fldItemCode = item2;
data_item.fldItemValue = item["fld" + item2].ToString();
data_item_list.Add(data_item);
}
}
db.tblEQISO_SpaceID1_Item_Midd.AddRange(data_item_list);
db.SaveChanges();
}
}
}
//指数统计表
if (info.SpaceID == 2)
{
using (MiddleContext db = new MiddleContext())
{
List <tblEQISO_SpaceID2_Midd> list = new List <tblEQISO_SpaceID2_Midd>();
foreach (DataRow item in dt.Rows)
{
tblEQISO_SpaceID2_Midd data = new tblEQISO_SpaceID2_Midd();
//将参数实体的主键值，设置给数据表的FKID，从而确定数据是从哪个参数下生成的
data.fldFKID = info_Midd.fldAutoID;
data.AppriseID = info.AppriseID.ToString();
data.STatType = info.STatType.ToString();
data.fldYear = item["fldYear"].ToString();
data.fldCityCode = item["fldCityCode"].ToString();
data.fldCityName = item["fldCityName"].ToString();
data.fldSTCode = item["fldSTCode"].ToString();
data.fldSTName = item["fldSTName"].ToString();
data.fldEntCode = item["fldEntCode"].ToString();
data.fldEntName = item["fldEntName"].ToString();
data.fldAddress = item["fldAddress"].ToString();
data.fldPCode = item["fldPCode"].ToString();
data.fldPName = item["fldPName"].ToString();
data.fldLevel = item["fldLevel"].ToString();
data.fldSOType = item["fldSOType"].ToString();
data.fldWPI_W = item["fldWPI_W"].ToString();
data.fldWPI_Y = item["fldWPI_Y"].ToString();
data.fldWPI_Avg = item["fldWPI_Avg"].ToString();
data.fldWPI_Max = item["fldWPI_Max"].ToString();
data.fldWPI = item["fldWPI"].ToString();
data.fldLevelApp = item["fldLevelApp"].ToString();
data.fldPCount = item["fldPCount"].ToString();
data.fldStdCount = item["fldStdCount"].ToString();
data.fldStdScale = item["fldStdScale"].ToString();
data.fldItemOvers = item["fldItemOvers"].ToString();
data.fldMaxPiApp = item["fldMaxPiApp"].ToString();
data.fldPnItem = item["fldPnItem"].ToString();
data.fldPiItem = item["fldPiItem"].ToString();
db.tblEQISO_SpaceID2_Midd.Add(data);
db.SaveChanges();
List <tblEQISO_SpaceID2_Item_Midd> data_item_list = new List <tblEQISO_SpaceID2_Item_Midd>();
foreach (var item2 in info.fldItemCode.Split(','))
{
if (item.Table.Columns.Contains("fld" + item2))
{
tblEQISO_SpaceID2_Item_Midd data_item = new tblEQISO_SpaceID2_Item_Midd();
data_item.fldFKID = data.fldAutoID;
data_item.fldItemCode = item2;
data_item.fldItemValue = item["fld" + item2].ToString();
if (item.Table.Columns.Contains("fld" + item2 + "_Count"))
{
data_item.Count = item["fld" + item2 + "_Count"].ToString();
}
if (item.Table.Columns.Contains("fld" + item2 + "_Val"))
{
data_item.Val = item["fld" + item2 + "_Val"].ToString();
}
if (item.Table.Columns.Contains("fld" + item2 + "_OutCount"))
{
data_item.OutCount = item["fld" + item2 + "_OutCount"].ToString();
}
if (item.Table.Columns.Contains("fld" + item2 + "_OutScale"))
{
data_item.OutScale = item["fld" + item2 + "_OutScale"].ToString();
}
if (item.Table.Columns.Contains("fld" + item2 + "_CheckCount"))
{
data_item.CheckCount = item["fld" + item2 + "_CheckCount"].ToString();
}
if (item.Table.Columns.Contains("fld" + item2 + "_fldCheckScale"))
{
data_item.fldCheckScale = item["fld" + item2 + "_fldCheckScale"].ToString();
}
data_item_list.Add(data_item);
}
}
db.tblEQISO_SpaceID2_Item_Midd.AddRange(data_item_list);
db.SaveChanges();
}
}
}
//项目各级别统计
if (info.SpaceID == 3)
{
using (MiddleContext db = new MiddleContext())
{
List <tblEQISO_SpaceID3_Midd> list = new List <tblEQISO_SpaceID3_Midd>();
foreach (DataRow item in dt.Rows)
{
tblEQISO_SpaceID3_Midd data = new tblEQISO_SpaceID3_Midd();
//将参数实体的主键值，设置给数据表的FKID，从而确定数据是从哪个参数下生成的
data.fldFKID = info_Midd.fldAutoID;
data.fldItemName = item["fldItemName"].ToString();
data.fldSOType = item["fldSOType"].ToString();
data.fld1Count = item["fld1Count"].ToString();
data.fld1Scale = item["fld1Scale"].ToString();
data.fld2Count = item["fld2Count"].ToString();
data.fld2Scale = item["fld2Scale"].ToString();
data.fld3Count = item["fld3Count"].ToString();
data.fld3Scale = item["fld3Scale"].ToString();
data.fld4Count = item["fld4Count"].ToString();
data.fld4Scale = item["fld4Scale"].ToString();
data.fld5Count = item["fld5Count"].ToString();
data.fld5Scale = item["fld5Scale"].ToString();
data.fldCount = item["fldCount"].ToString();
data.fldOutScale = item["fldOutScale"].ToString();
data.fldCFI = item["fldCFI"].ToString();
data.fldMin = item["fldMin"].ToString();
data.fldMax = item["fldMax"].ToString();
data.fldAvg = item["fldAvg"].ToString();
data.fldMaxOut = item["fldMaxOut"].ToString();
list.Add(data);
}
db.tblEQISO_SpaceID3_Midd.AddRange(list);
db.SaveChanges();
}
}
//污染指数统计
if (info.SpaceID == 4)
{
using (MiddleContext db = new MiddleContext())
{
List <tblEQISO_SpaceID4_Midd> list = new List <tblEQISO_SpaceID4_Midd>();
foreach (DataRow item in dt.Rows)
{
tblEQISO_SpaceID4_Midd data = new tblEQISO_SpaceID4_Midd();
//将参数实体的主键值，设置给数据表的FKID，从而确定数据是从哪个参数下生成的
data.fldFKID = info_Midd.fldAutoID;
data.AppriseID = info.AppriseID.ToString();
data.STatType = info.STatType.ToString();
data.fldCityCode = item["fldCityCode"].ToString();
data.fldCityName = item["fldCityName"].ToString();
data.fldSTCode = item["fldSTCode"].ToString();
data.fldSTName = item["fldSTName"].ToString();
data.fldEntCode = item["fldEntCode"].ToString();
data.fldEntName = item["fldEntName"].ToString();
data.fldAddress = item["fldAddress"].ToString();
data.fldType = item["fldType"].ToString();
data.fldSOType = item["fldSOType"].ToString();
data.fldCount = item["fldCount"].ToString();
data.fld1Count = item["fld1Count"].ToString();
data.fld1Scale = item["fld1Scale"].ToString();
data.fld2Count = item["fld2Count"].ToString();
data.fld2Scale = item["fld2Scale"].ToString();
data.fld3Count = item["fld3Count"].ToString();
data.fld3Scale = item["fld3Scale"].ToString();
data.fld4Count = item["fld4Count"].ToString();
data.fld4Scale = item["fld4Scale"].ToString();
data.fld5Count = item["fld5Count"].ToString();
data.fld5Scale = item["fld5Scale"].ToString();
list.Add(data);
}
db.tblEQISO_SpaceID4_Midd.AddRange(list);
db.SaveChanges();
}
}
//污染级别统计表
if (info.SpaceID == 5)
{
using (MiddleContext db = new MiddleContext())
{
List <tblEQISO_SpaceID5_Midd> list = new List <tblEQISO_SpaceID5_Midd>();
foreach (DataRow item in dt.Rows)
{
tblEQISO_SpaceID5_Midd data = new tblEQISO_SpaceID5_Midd();
//将参数实体的主键值，设置给数据表的FKID，从而确定数据是从哪个参数下生成的
data.fldFKID = info_Midd.fldAutoID;
data.AppriseID = info.AppriseID.ToString();
data.STatType = info.STatType.ToString();
data.fldYear = item["fldYear"].ToString();
data.fldCityCode = item["fldCityCode"].ToString();
data.fldCityName = item["fldCityName"].ToString();
data.fldSTCode = item["fldSTCode"].ToString();
data.fldSTName = item["fldSTName"].ToString();
data.fldEntCode = item["fldEntCode"].ToString();
data.fldEntName = item["fldEntName"].ToString();
data.fldAddress = item["fldAddress"].ToString();
data.fldPCode = item["fldPCode"].ToString();
data.fldPName = item["fldPName"].ToString();
data.fldLevel = item["fldLevel"].ToString();
data.fldSOType = item["fldSOType"].ToString();
data.fldWPI_W = item["fldWPI_W"].ToString();
data.fldWPI_Y = item["fldWPI_Y"].ToString();
data.fldWPI_Avg = item["fldWPI_Avg"].ToString();
data.fldWPI_Max = item["fldWPI_Max"].ToString();
data.fldWPI = item["fldWPI"].ToString();
db.tblEQISO_SpaceID5_Midd.Add(data);
db.SaveChanges();
List <tblEQISO_SpaceID5_Item_Midd> data_item_list = new List <tblEQISO_SpaceID5_Item_Midd>();
foreach (var item2 in info.fldItemCode.Split(','))
{
if (item.Table.Columns.Contains("fld" + item2))
{
tblEQISO_SpaceID5_Item_Midd data_item = new tblEQISO_SpaceID5_Item_Midd();
data_item.fldFKID = data.fldAutoID;
data_item.fldItemCode = item2;
data_item.fldItemValue = item["fld" + item2].ToString();
data_item_list.Add(data_item);
}
}
db.tblEQISO_SpaceID5_Item_Midd.AddRange(data_item_list);
db.SaveChanges();
}
}
}
//土壤质量状况评价
if (info.SpaceID == 6)
{
using (MiddleContext db = new MiddleContext())
{
List <tblEQISO_SpaceID6_Midd> list = new List <tblEQISO_SpaceID6_Midd>();
foreach (DataRow item in dt.Rows)
{
tblEQISO_SpaceID6_Midd data = new tblEQISO_SpaceID6_Midd();
//将参数实体的主键值，设置给数据表的FKID，从而确定数据是从哪个参数下生成的
data.fldFKID = info_Midd.fldAutoID;
data.fldStatType = item["fldStatType"].ToString();
data.fldSOType = item["fldSOType"].ToString();
data.fld1Count = item["fld1Count"].ToString();
data.fld1Scale = item["fld1Scale"].ToString();
data.fld2Count = item["fld2Count"].ToString();
data.fld2Scale = item["fld2Scale"].ToString();
data.fld3Count = item["fld3Count"].ToString();
data.fld3Scale = item["fld3Scale"].ToString();
data.fld4Count = item["fld4Count"].ToString();
data.fld4Scale = item["fld4Scale"].ToString();
data.fld5Count = item["fld5Count"].ToString();
data.fld5Scale = item["fld5Scale"].ToString();
data.fldCount = item["fldCount"].ToString();
list.Add(data);
}
db.tblEQISO_SpaceID6_Midd.AddRange(list);
db.SaveChanges();
}
}
#endregion
result = rule.JsonStr("ok", "执行成功！", info_Midd.fldAutoID);
}
catch (Exception e)
{
result = rule.JsonStr("error", e.Message, "");
}
return(new HttpResponseMessage {
Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json")
});
}
public HttpResponseMessage ExeCacheData(Info info)
{
string result = null;
DataTable dt = new DataTable();
int info_Midd_fldAutoID = 0;
try
{
//第一步
#region 初始化变量
tblEQIW_D_Info_Midd info_Midd = new tblEQIW_D_Info_Midd();
DateTime BeginDate = DateTime.Parse(info.BeginDate);
DateTime EndDate = DateTime.Parse(info.EndDate);
#endregion
//第二步
#region 处理参数表，检查此条件下是否已经进行过缓存
using (MiddleContext db = new MiddleContext())
{
var query = (from x in db.tblEQIW_D_Info_Midd
where x.TimeType == info.TimeType &&
x.BeginDate == BeginDate &&
x.EndDate == EndDate &&
x.fldRSC == info.fldRSC &&
x.fldRSCode == info.fldRSCode &&
x.fldRStandardName == info.fldRStandardName &&
x.fldRLevel == info.fldRLevel &&
x.fldLStandardName == info.fldLStandardName &&
x.fldLLevel == info.fldLLevel &&
x.fldItemCode == info.fldItemCode &&
x.DecCarry == info.DecCarry &&
x.IsPre == info.IsPre &&
x.IsYear == info.IsYear &&
x.IsTotal == info.IsTotal &&
x.IsDetail == info.IsDetail &&
x.IsTLI == info.IsTLI &&
x.TLIType == info.TLIType &&
x.AppriseID == info.AppriseID &&
x.SpaceID == info.SpaceID &&
x.STatType == info.STatType &&
x.fldSource == info.fldSource &&
x.CalculateID == info.CalculateID
select x).Count();
if (query > 0)
{
result = rule.JsonStr("ok", "此条件下已经进行过数据缓存。", "");
return(new HttpResponseMessage {
Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json")
});
}
}
#endregion
//第三步
#region 执行通用存储过程，返回数据
if (info.STatType == 2)
{
SqlParameter[] paras = new SqlParameter[]
{
new SqlParameter("@TimeType", info.TimeType),
new SqlParameter("@BeginDate", info.BeginDate),
new SqlParameter("@EndDate", info.EndDate),
new SqlParameter("@fldRSC", info.fldRSC),
new SqlParameter("@fldRSCode", info.fldRSCode),
new SqlParameter("@fldRStandardName", info.fldRStandardName),
new SqlParameter("@fldRLevel", info.fldRLevel),
new SqlParameter("@fldLStandardName", info.fldLStandardName),
new SqlParameter("@fldLLevel", info.fldLLevel),
new SqlParameter("@fldItemCode", info.fldItemCode),
new SqlParameter("@DecCarry", info.DecCarry),
new SqlParameter("@IsPre", info.IsPre),
new SqlParameter("@IsYear", info.IsYear),
new SqlParameter("@IsTotal", info.IsTotal),
new SqlParameter("@IsDetail", info.IsDetail),
new SqlParameter("@IsTLI", info.IsTLI),
new SqlParameter("@TLIType", info.TLIType),
new SqlParameter("@AppriseID", info.AppriseID),
new SqlParameter("@SpaceID", info.SpaceID),
new SqlParameter("@STatType", info.STatType),
new SqlParameter("@fldSource", int.Parse(info.fldSource)),
new SqlParameter("@CalculateID", info.CalculateID),
new SqlParameter("@CategoryID", info.CategoryID)
};
dt = rule.RunProcedure("usp_tblEQIW_DX_Report_Apprise", paras.ToList(), null);
}
else
{
SqlParameter[] paras = new SqlParameter[]
{
new SqlParameter("@TimeType", info.TimeType),
new SqlParameter("@BeginDate", info.BeginDate),
new SqlParameter("@EndDate", info.EndDate),
new SqlParameter("@fldRSC", info.fldRSC),
new SqlParameter("@fldRSCode", info.fldRSCode),
new SqlParameter("@fldRStandardName", info.fldRStandardName),
new SqlParameter("@fldRLevel", info.fldRLevel),
new SqlParameter("@fldLStandardName", info.fldLStandardName),
new SqlParameter("@fldLLevel", info.fldLLevel),
new SqlParameter("@fldItemCode", info.fldItemCode),
new SqlParameter("@DecCarry", info.DecCarry),
new SqlParameter("@IsPre", info.IsPre),
new SqlParameter("@IsYear", info.IsYear),
new SqlParameter("@IsTotal", info.IsTotal),
new SqlParameter("@IsDetail", info.IsDetail),
new SqlParameter("@IsTLI", info.IsTLI),
new SqlParameter("@TLIType", info.TLIType),
new SqlParameter("@AppriseID", info.AppriseID),
new SqlParameter("@SpaceID", info.SpaceID),
new SqlParameter("@STatType", info.STatType),
new SqlParameter("@fldSource", int.Parse(info.fldSource)),
new SqlParameter("@CalculateID", info.CalculateID)
};
dt = rule.RunProcedure("usp_tblEQIW_D_Report_Apprise", paras.ToList(), null);
}
if (dt == null || dt.Rows.Count == 0)
{
result = rule.JsonStr("ok", "此条件集合下并未返回数据", "");
return(new HttpResponseMessage {
Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json")
});
}
#endregion
//第四步
#region 如果存储过程返回数据，那么将条件写入参数表
using (MiddleContext db = new MiddleContext())
{
info_Midd.TimeType = info.TimeType;
info_Midd.BeginDate = BeginDate;
info_Midd.EndDate = EndDate;
info_Midd.fldRSC = info.fldRSC;
info_Midd.fldRSCode = info.fldRSCode;
info_Midd.fldRStandardName = info.fldRStandardName;
info_Midd.fldRLevel = info.fldRLevel;
info_Midd.fldLStandardName = info.fldLStandardName;
info_Midd.fldLLevel = info.fldLLevel;
info_Midd.fldItemCode = info.fldItemCode;
info_Midd.DecCarry = info.DecCarry;
info_Midd.IsPre = info.IsPre;
info_Midd.IsYear = info.IsYear;
info_Midd.IsTotal = info.IsTotal;
info_Midd.IsDetail = info.IsDetail;
info_Midd.IsTLI = info.IsTLI;
info_Midd.TLIType = info.TLIType;
info_Midd.AppriseID = info.AppriseID;
info_Midd.SpaceID = info.SpaceID;
info_Midd.STatType = info.STatType;
info_Midd.fldSource = info.fldSource;
info_Midd.CalculateID = info.CalculateID;
db.tblEQIW_D_Info_Midd.Add(info_Midd);
db.SaveChanges();
}
info_Midd_fldAutoID = info_Midd.fldAutoID;
#endregion
//第五步
#region 相关数据处理
// 综合评价 - 城市评价
if (info.SpaceID == 3 && info.AppriseID == 1)
{
using (MiddleContext db = new MiddleContext())
{
List <tblEQIW_D_City_Midd> list = new List <tblEQIW_D_City_Midd>();
foreach (DataRow item in dt.Rows)
{
tblEQIW_D_City_Midd data = new tblEQIW_D_City_Midd();
//将参数实体的主键值，设置给数据表的FKID，从而确定数据是从哪个参数下生成的
data.fldFKID = info_Midd.fldAutoID;
data.STatType = info.STatType.ToString();
data.fldTimeType = info.TimeType;
if (item["fldAppDate"].ToString() == "平均")
{
data.fldBeginDate = DateTime.Parse(info.BeginDate);
data.fldEndDate = DateTime.Parse(info.EndDate);
}
data.fldCityCode = item["fldCityCode"].ToString();
data.fldCityName = item["fldCityName"].ToString();
data.fldSTCode = item["fldSTCode"].ToString();
data.fldSTName = item["fldSTName"].ToString();
data.fldAppDate = item["fldAppDate"].ToString();
data.fldSCategory = item["fldSCategory"].ToString();
data.fldSetCount = item["fldSetCount"].ToString();
data.fldRSCount = item["fldRSCount"].ToString();
data.fldYJCheckItem = item["fldYJCheckItem"].ToString();
data.fldWJCheckItem = item["fldWJCheckItem"].ToString();
data.fldAllSL = item["fldAllSL"].ToString();
data.fldStdSL = item["fldStdSL"].ToString();
data.fldScale = item["fldScale"].ToString();
data.fldFStdSL = item["fldFStdSL"].ToString();
data.fldFScale = item["fldFScale"].ToString();
data.fldCount = item["fldCount"].ToString();
data.fldStdCount = item["fldStdCount"].ToString();
data.fldstdScale = item["fldstdScale"].ToString();
data.fldFstdCount = item["fldFstdCount"].ToString();
data.fldFstdScale = item["fldFstdScale"].ToString();
data.fldStdSecion = item["fldStdSecion"].ToString();
data.fldSectionScale = item["fldSectionScale"].ToString();
data.fldFStdSecion = item["fldFStdSecion"].ToString();
data.fldFSectionScale = item["fldFSectionScale"].ToString();
data.fldSections = item["fldSections"].ToString();
data.fldFSections = item["fldFSections"].ToString();
data.fld1Count = item["fld1Count"].ToString();
data.fld1Scale = item["fld1Scale"].ToString();
data.fld2Count = item["fld2Count"].ToString();
data.fld2Scale = item["fld2Scale"].ToString();
data.fld3Count = item["fld3Count"].ToString();
data.fld3Scale = item["fld3Scale"].ToString();
data.fld4Count = item["fld4Count"].ToString();
data.fld4Scale = item["fld4Scale"].ToString();
data.fld5Count = item["fld5Count"].ToString();
data.fld5Scale = item["fld5Scale"].ToString();
data.fld6Count = item["fld6Count"].ToString();
data.fld6Scale = item["fld6Scale"].ToString();
list.Add(data);
db.tblEQIW_D_City_Midd.Add(data);
db.SaveChanges();
// 因子表相关操作
List <tblEQIW_D_City_Item_Midd> data_item_list = new List <tblEQIW_D_City_Item_Midd>();
foreach (var item2 in info.fldItemCode.Split(','))
{
if (item.Table.Columns.Contains(item2 + "_Value"))
{
tblEQIW_D_City_Item_Midd data_item = new tblEQIW_D_City_Item_Midd();
data_item.fldFKID = data.fldAutoID;
data_item.fldItemCode = item2;
data_item.fld_Value = item[item2 + "_Value"].ToString();
if (item.Table.Columns.Contains(item2 + "_Min"))
{
data_item.fld_Min = item[item2 + "_Min"].ToString();
}
if (item.Table.Columns.Contains(item2 + "_Max"))
{
data_item.fld_Max = item[item2 + "_Max"].ToString();
}
if (item.Table.Columns.Contains(item2 + "_AvgValueStage"))
{
data_item.fld_AvgValueStage = item[item2 + "_AvgValueStage"].ToString();
}
if (item.Table.Columns.Contains(item2 + "_MaxValueStage"))
{
data_item.fld_MaxValueStage = item[item2 + "_MaxValueStage"].ToString();
}
if (item.Table.Columns.Contains(item2 + "_Count"))
{
data_item.fld_MaxValueStage = item[item2 + "_Count"].ToString();
}
if (item.Table.Columns.Contains(item2 + "_OutCount"))
{
data_item.fld_OutCount = item[item2 + "_OutCount"].ToString();
}
if (item.Table.Columns.Contains(item2 + "_OutScale"))
{
data_item.fld_OutScale = item[item2 + "_OutScale"].ToString();
}
if (item.Table.Columns.Contains(item2 + "_AvgOut"))
{
data_item.fld_AvgOut = item[item2 + "_AvgOut"].ToString();
}
if (item.Table.Columns.Contains(item2 + "_MaxOut"))
{
data_item.fld_MaxOut = item[item2 + "_MaxOut"].ToString();
}
data_item_list.Add(data_item);
}
}
db.tblEQIW_D_City_Item_Midd.AddRange(data_item_list);
db.SaveChanges();
}
}
}
// 综合评价 - 断面评价
if (info.SpaceID == 3 && info.AppriseID == 0)
{
using (MiddleContext db = new MiddleContext())
{
List <tblEQIW_D_Section_Midd> list = new List <tblEQIW_D_Section_Midd>();
foreach (DataRow item in dt.Rows)
{
tblEQIW_D_Section_Midd data = new tblEQIW_D_Section_Midd();
//将参数实体的主键值，设置给数据表的FKID，从而确定数据是从哪个参数下生成的
data.fldFKID = info_Midd.fldAutoID;
data.STatType = info.STatType.ToString();
data.fldTimeType = info.TimeType;
if (item["fldAppDate"].ToString() == "平均")
{
data.fldBeginDate = DateTime.Parse(info.BeginDate);
data.fldEndDate = DateTime.Parse(info.EndDate);
}
data.fldSectionInfo = item["fldSectionInfo"].ToString();
data.fldWaterArea = item["fldWaterArea"].ToString();
data.fldRSWaterWork = item["fldRSWaterWork"].ToString();
data.fldCityCode = item["fldCityCode"].ToString();
data.fldCityName = item["fldCityName"].ToString();
data.fldSTCode = item["fldSTCode"].ToString();
data.fldSTName = item["fldSTName"].ToString();
data.fldRCode = item["fldRCode"].ToString();
data.fldRName = item["fldRName"].ToString();
data.fldRSCode = item["fldRSCode"].ToString();
data.fldRSName = item["fldRSName"].ToString();
data.fldJD = item["fldJD"].ToString();
data.fldWD = item["fldWD"].ToString();
data.fldSCategory = item["fldSCategory"].ToString();
data.fldLevel = item["fldLevel"].ToString();
data.fldRSC = item["fldRSC"].ToString();
data.fldAppDate = item["fldAppDate"].ToString();
data.fldFun = item["fldFun"].ToString();
data.fldItemCount = item["fldItemCount"].ToString();
data.fldOverCount = item["fldOverCount"].ToString();
data.fldTDCheckCount = item["fldTDCheckCount"].ToString();
data.fldYJCheckCount = item["fldYJCheckCount"].ToString();
//data.fldYJCheckItem = item["fldYJCheckItem"].ToString();
data.fldWJCheckCount = item["fldWJCheckCount"].ToString();
//data.fldWJCheckItem = item["fldWJCheckItem"].ToString();
data.fldAllCheckCount = item["fldAllCheckCount"].ToString();
data.fldAllSL = item["fldAllSL"].ToString();
data.fldAllScale = item["fldAllScale"].ToString();
data.fldStandSL = item["fldStandSL"].ToString();
data.fldScaleSL = item["fldScaleSL"].ToString();
data.fldFStandSL = item["fldFStandSL"].ToString();
data.fldFScaleSL = item["fldFScaleSL"].ToString();
data.fldPC = item["fldPC"].ToString();
data.fldStandPC = item["fldStandPC"].ToString();
data.fldScalePC = item["fldScalePC"].ToString();
data.fldFStandPC = item["fldFStandPC"].ToString();
data.fldFScalePC = item["fldFScalePC"].ToString();
data.fldStage = item["fldStage"].ToString();
data.fldSectionApp = item["fldSectionApp"].ToString();
data.fldStand = item["fldStand"].ToString();
data.fldSingleStageD = item["fldSingleStageD"].ToString();
data.fldSingleItemD = item["fldSingleItemD"].ToString();
data.fldSingleTimesD = item["fldSingleTimesD"].ToString();
data.fldSingleStageF = item["fldSingleStageF"].ToString();
data.fldSingleItemF = item["fldSingleItemF"].ToString();
data.fldSingleTimesF = item["fldSingleTimesF"].ToString();
data.fldWPI = item["fldWPI"].ToString();
data.fldAvgWPI = item["fldAvgWPI"].ToString();
data.fldOverItem = item["fldOverItem"].ToString();
data.fldFOverItem = item["fldFOverItem"].ToString();
data.fldOverTimes = item["fldOverTimes"].ToString();
data.fldOverScale = item["fldOverScale"].ToString();
data.fldOverNum = item["fldOverNum"].ToString();
//data.fldOverNum2 = item["fldOverNum2"].ToString();
data.fldFOverTimes = item["fldFOverTimes"].ToString();
data.fldFOverScale = item["fldFOverScale"].ToString();
data.fldFOverNum = item["fldFOverNum"].ToString();
data.C314_TLI = item["314_TLI"].ToString();
data.C313_TLI = item["313_TLI"].ToString();
data.C464_TLI = item["464_TLI"].ToString();
data.C501_TLI = item["501_TLI"].ToString();
data.C466_TLI = item["466_TLI"].ToString();
data.fldTSI = item["fldTSI"].ToString();
data.fldTSIRange = item["fldTSIRange"].ToString();
data.fldOutItem = item["fldOutItem"].ToString();
data.fldOverCheckItem = item["fldOverCheckItem"].ToString();
data.fldOverCheckItem_UN = item["fldOverCheckItem_UN"].ToString();
data.fldOverCheckTimes = item["fldOverCheckTimes"].ToString();
data.fldOverCheckTimes_UN = item["fldOverCheckTimes_UN"].ToString();
data.fldRemark = item["fldRemark"].ToString();
list.Add(data);
db.tblEQIW_D_Section_Midd.Add(data);
db.SaveChanges();
// 因子表相关操作
List <tblEQIW_D_Section_Item_Midd> data_item_list = new List <tblEQIW_D_Section_Item_Midd>();
foreach (var item2 in info.fldItemCode.Split(','))
{
if (item.Table.Columns.Contains(item2 + "_Value"))
{
tblEQIW_D_Section_Item_Midd data_item = new tblEQIW_D_Section_Item_Midd();
data_item.fldFKID = data.fldAutoID;
data_item.fldItemCode = item2;
data_item.fld_Value = item[item2 + "_Value"].ToString();
if (item.Table.Columns.Contains(item2 + "_Stage"))
{
data_item.fld_Stage = item[item2 + "_Stage"].ToString();
}
if (item.Table.Columns.Contains(item2 + "_CPI"))
{
data_item.fld_CPI = item[item2 + "_CPI"].ToString();
}
if (item.Table.Columns.Contains(item2 + "_CFI"))
{
data_item.fld_CFI = item[item2 + "_CFI"].ToString();
}
data_item_list.Add(data_item);
}
}
db.tblEQIW_D_Section_Item_Midd.AddRange(data_item_list);
db.SaveChanges();
}
}
}
// 因子超标
if (info.SpaceID == 2)
{
using (MiddleContext db = new MiddleContext())
{
List <tblEQIW_D_ItemOver_Midd> list = new List <tblEQIW_D_ItemOver_Midd>();
foreach (DataRow item in dt.Rows)
{
tblEQIW_D_ItemOver_Midd data = new tblEQIW_D_ItemOver_Midd();
//将参数实体的主键值，设置给数据表的FKID，从而确定数据是从哪个参数下生成的
data.fldFKID = info_Midd.fldAutoID;
data.fldTimeType = info.TimeType;
data.fldItemName = item["fldItemName"].ToString();
data.fldDate = item["fldDate"].ToString();
data.fldRCount = item["fldRCount"].ToString();
data.fldOutCount = item["fldOutCount"].ToString();
data.fldScale = item["fldScale"].ToString();
data.fldMin = item["fldMin"].ToString();
data.fldMax = item["fldMax"].ToString();
data.fldMaxOut = item["fldMaxOut"].ToString();
data.fldYPCount = item["fldYPCount"].ToString();
data.fldYPOutCount = item["fldYPOutCount"].ToString();
data.fldYPScale = item["fldYPScale"].ToString();
data.fldYPMaxScale = item["fldYPMaxScale"].ToString();
data.fldYPOutSection = item["fldYPOutSection"].ToString();
data.fldYPOutSectionScale = item["fldYPOutSectionScale"].ToString();
data.fldYPMinValue = item["fldYPMinValue"].ToString();
data.fldYPMaxValue = item["fldYPMaxValue"].ToString();
data.fldYPOverValue = item["fldYPOverValue"].ToString();
data.fldYPValue = item["fldYPValue"].ToString();
list.Add(data);
}
db.tblEQIW_D_ItemOver_Midd.AddRange(list);
db.SaveChanges();
}
}
// 城市因子超标
if (info.SpaceID == 20)
{
using (MiddleContext db = new MiddleContext())
{
List <tblEQIW_D_CityItemOver_Midd> list = new List <tblEQIW_D_CityItemOver_Midd>();
foreach (DataRow item in dt.Rows)
{
tblEQIW_D_CityItemOver_Midd data = new tblEQIW_D_CityItemOver_Midd();
//将参数实体的主键值，设置给数据表的FKID，从而确定数据是从哪个参数下生成的
data.fldFKID = info_Midd.fldAutoID;
data.fldTimeType = info.TimeType;
data.fldSTCode = item["fldSTCode"].ToString();
data.fldSTName = item["fldSTName"].ToString();
data.fldItemName = item["fldItemName"].ToString();
data.fldDate = item["fldDate"].ToString();
data.fldRCount = item["fldRCount"].ToString();
data.fldOutCount = item["fldOutCount"].ToString();
data.fldScale = item["fldScale"].ToString();
data.fldMin = item["fldMin"].ToString();
data.fldMax = item["fldMax"].ToString();
data.fldMaxOut = item["fldMaxOut"].ToString();
data.fldYPCount = item["fldYPCount"].ToString();
data.fldYPOutCount = item["fldYPOutCount"].ToString();
data.fldYPScale = item["fldYPScale"].ToString();
data.fldYPMaxScale = item["fldYPMaxScale"].ToString();
data.fldYPOutSection = item["fldYPOutSection"].ToString();
data.fldYPOutSectionScale = item["fldYPOutSectionScale"].ToString();
data.fldYPMinValue = item["fldYPMinValue"].ToString();
data.fldYPMaxValue = item["fldYPMaxValue"].ToString();
data.fldYPOverValue = item["fldYPOverValue"].ToString();
data.fldYPValue = item["fldYPValue"].ToString();
list.Add(data);
}
db.tblEQIW_D_CityItemOver_Midd.AddRange(list);
db.SaveChanges();
}
}
// 年鉴
if (info.SpaceID == 1)
{
using (MiddleContext db = new MiddleContext())
{
List <tblEQIW_D_YearBook_Midd> list = new List <tblEQIW_D_YearBook_Midd>();
foreach (DataRow item in dt.Rows)
{
tblEQIW_D_YearBook_Midd data = new tblEQIW_D_YearBook_Midd();
//将参数实体的主键值，设置给数据表的FKID，从而确定数据是从哪个参数下生成的
data.fldFKID = info_Midd.fldAutoID;
data.STatType = info.STatType.ToString();
data.fldTimeType = info.TimeType;
data.fldCityCode = item["fldCityCode"].ToString();
data.fldCityName = item["fldCityName"].ToString();
data.fldSTCode = item["fldSTCode"].ToString();
data.fldSTName = item["fldSTName"].ToString();
data.fldRCode = item["fldRCode"].ToString();
data.fldRName = item["fldRName"].ToString();
data.fldRSCode = item["fldRSCode"].ToString();
data.fldRSName = item["fldRSName"].ToString();
data.fldSCategory = item["fldSCategory"].ToString();
data.fldRSC = item["fldRSC"].ToString();
data.fldDate = item["fldDate"].ToString();
data.fldStage = item["fldStage"].ToString();
data.fldOutItems = item["fldOutItems"].ToString();
data.fldFOutItems = item["fldFOutItems"].ToString();
list.Add(data);
db.tblEQIW_D_YearBook_Midd.Add(data);
db.SaveChanges();
// 因子表相关操作
List <tblEQIW_D_YearBook_Item_Midd> data_item_list = new List <tblEQIW_D_YearBook_Item_Midd>();
foreach (var item2 in info.fldItemCode.Split(','))
{
if (item.Table.Columns.Contains("fld" + item2))
{
tblEQIW_D_YearBook_Item_Midd data_item = new tblEQIW_D_YearBook_Item_Midd();
data_item.fldFKID = data.fldAutoID;
data_item.fldItemCode = item2;
data_item.fld_Value = item["fld" + item2].ToString();
data_item_list.Add(data_item);
}
}
db.tblEQIW_D_YearBook_Item_Midd.AddRange(data_item_list);
db.SaveChanges();
}
}
}
#endregion
result = rule.JsonStr("ok", "执行成功！", info_Midd.fldAutoID);
}
catch (Exception e)
{
if (info_Midd_fldAutoID > 0)
{
using (MiddleContext db = new MiddleContext())
{
var query = (from x in db.tblEQIW_D_Info_Midd
where x.fldAutoID == info_Midd_fldAutoID
select x).FirstOrDefault();
db.tblEQIW_D_Info_Midd.Remove(query);
db.SaveChanges();
}
}
result = rule.JsonStr("error", e.Message, "");
}
return(new HttpResponseMessage {
Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json")
});
}
public HttpResponseMessage GetData_EQIW_RLD(Info_EQIW_RLD info)
{
string result = null;
try
{
DateTime BeginDate = DateTime.Parse(info.fldBeginDate);
DateTime EndDate = DateTime.Parse(info.fldEndDate);
if (info.type == "STatType1")
{
using (MiddleContext db = new MiddleContext())
{
List <tblHM_EQIW_RLD_STatType1_Midd> query = new List <tblHM_EQIW_RLD_STatType1_Midd>();
List <tblHM_EQIW_RLD_STatType1_Item_Midd> query_Item = new List <tblHM_EQIW_RLD_STatType1_Item_Midd>();
if (info.fldSTCode == "-1")
{
query = (from x in db.tblHM_EQIW_RLD_STatType1_Midd
select x).ToList();
}
else
{
query = (from x in db.tblHM_EQIW_RLD_STatType1_Midd
where info.fldSTCode.Contains(x.fldSTCode + "." + x.fldRCode + "." + x.fldRSCode)
select x).ToList();
}
if (info.fldItemCode != null)
{
query_Item = (from x in query
join y in db.tblHM_EQIW_RLD_STatType1_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 <tblHM_EQIW_RLD_STatType1_Midd> query2 = new List <tblHM_EQIW_RLD_STatType1_Midd>();
List <tblHM_EQIW_RLD_STatType1_Item_Midd> query_Item2 = new List <tblHM_EQIW_RLD_STatType1_Item_Midd>();
if (info.fldSTCode == "-1")
{
query2 = (from x in db.tblHM_EQIW_RLD_STatType1_Midd
select x).ToList();
}
else
{
query2 = (from x in db.tblHM_EQIW_RLD_STatType1_Midd
where info.fldSTCode.Contains(x.fldSTCode + "." + x.fldRCode + "." + x.fldRSCode)
select x).ToList();
}
if (info.fldItemCode != null)
{
query_Item2 = (from x in query2
join y in db.tblHM_EQIW_RLD_STatType1_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 == "STatType3")
{
using (MiddleContext db = new MiddleContext())
{
List <tblHM_EQIW_RLD_STatType3_Midd> query = new List <tblHM_EQIW_RLD_STatType3_Midd>();
List <tblHM_EQIW_RLD_STatType3_Item_Midd> query_Item = new List <tblHM_EQIW_RLD_STatType3_Item_Midd>();
if (info.fldSTCode == "-1")
{
query = (from x in db.tblHM_EQIW_RLD_STatType3_Midd
select x).ToList();
}
else
{
query = (from x in db.tblHM_EQIW_RLD_STatType3_Midd
where info.fldSTCode.Contains(x.fldSTCode + "." + x.fldRCode + "." + x.fldRSCode)
select x).ToList();
}
if (info.fldItemCode != null)
{
query_Item = (from x in query
join y in db.tblHM_EQIW_RLD_STatType3_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 <tblHM_EQIW_RLD_STatType3_Midd> query2 = new List <tblHM_EQIW_RLD_STatType3_Midd>();
List <tblHM_EQIW_RLD_STatType3_Item_Midd> query_Item2 = new List <tblHM_EQIW_RLD_STatType3_Item_Midd>();
if (info.fldSTCode == "-1")
{
query2 = (from x in db.tblHM_EQIW_RLD_STatType3_Midd
select x).ToList();
}
else
{
query2 = (from x in db.tblHM_EQIW_RLD_STatType3_Midd
where info.fldSTCode.Contains(x.fldSTCode + "." + x.fldRCode + "." + x.fldRSCode)
select x).ToList();
}
if (info.fldItemCode != null)
{
query_Item2 = (from x in query2
join y in db.tblHM_EQIW_RLD_STatType3_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 DelCacheData(List <Del_Info> info)
{
string result = null;
int num = 0;
try
{
using (MiddleContext db = new MiddleContext())
{
foreach (var item in info)
{
if (item.SpaceID == 0)
{
var query = (from x in db.tblEQISO_SpaceID0_Midd
where x.fldFKID == item.fldAutoID
select x).ToList();
//删除因子表数据
foreach (var item2 in query)
{
var query2 = (from x in db.tblEQISO_SpaceID0_Item_Midd
where x.fldFKID == item2.fldAutoID
select x).ToList();
db.tblEQISO_SpaceID0_Item_Midd.RemoveRange(query2);
}
//删除数据表数据
db.tblEQISO_SpaceID0_Midd.RemoveRange(query);
//删除参数表数据
var query3 = (from x in db.tblEQIW_D_Info_Midd
where x.fldAutoID == item.fldAutoID
select x).ToList();
db.tblEQIW_D_Info_Midd.RemoveRange(query3);
num = db.SaveChanges();
}
if (item.SpaceID == 1)
{
var query = (from x in db.tblEQISO_SpaceID1_Midd
where x.fldFKID == item.fldAutoID
select x).ToList();
//删除因子表数据
foreach (var item2 in query)
{
var query2 = (from x in db.tblEQISO_SpaceID1_Item_Midd
where x.fldFKID == item2.fldAutoID
select x).ToList();
db.tblEQISO_SpaceID1_Item_Midd.RemoveRange(query2);
}
//删除数据表数据
db.tblEQISO_SpaceID1_Midd.RemoveRange(query);
//删除参数表数据
var query3 = (from x in db.tblEQIW_D_Info_Midd
where x.fldAutoID == item.fldAutoID
select x).ToList();
db.tblEQIW_D_Info_Midd.RemoveRange(query3);
num = db.SaveChanges();
}
if (item.SpaceID == 2)
{
var query = (from x in db.tblEQISO_SpaceID2_Midd
where x.fldFKID == item.fldAutoID
select x).ToList();
//删除因子表数据
foreach (var item2 in query)
{
var query2 = (from x in db.tblEQISO_SpaceID2_Item_Midd
where x.fldFKID == item2.fldAutoID
select x).ToList();
db.tblEQISO_SpaceID2_Item_Midd.RemoveRange(query2);
}
//删除数据表数据
db.tblEQISO_SpaceID2_Midd.RemoveRange(query);
//删除参数表数据
var query3 = (from x in db.tblEQIW_D_Info_Midd
where x.fldAutoID == item.fldAutoID
select x).ToList();
db.tblEQIW_D_Info_Midd.RemoveRange(query3);
num = db.SaveChanges();
}
if (item.SpaceID == 3)
{
var query = (from x in db.tblEQISO_SpaceID3_Midd
where x.fldFKID == item.fldAutoID
select x).ToList();
//删除数据表数据
db.tblEQISO_SpaceID3_Midd.RemoveRange(query);
//删除参数表数据
var query3 = (from x in db.tblEQIW_D_Info_Midd
where x.fldAutoID == item.fldAutoID
select x).ToList();
db.tblEQIW_D_Info_Midd.RemoveRange(query3);
num = db.SaveChanges();
}
if (item.SpaceID == 4)
{
var query = (from x in db.tblEQISO_SpaceID4_Midd
where x.fldFKID == item.fldAutoID
select x).ToList();
//删除数据表数据
db.tblEQISO_SpaceID4_Midd.RemoveRange(query);
//删除参数表数据
var query3 = (from x in db.tblEQIW_D_Info_Midd
where x.fldAutoID == item.fldAutoID
select x).ToList();
db.tblEQIW_D_Info_Midd.RemoveRange(query3);
num = db.SaveChanges();
}
if (item.SpaceID == 5)
{
var query = (from x in db.tblEQISO_SpaceID5_Midd
where x.fldFKID == item.fldAutoID
select x).ToList();
//删除因子表数据
foreach (var item2 in query)
{
var query2 = (from x in db.tblEQISO_SpaceID5_Item_Midd
where x.fldFKID == item2.fldAutoID
select x).ToList();
db.tblEQISO_SpaceID5_Item_Midd.RemoveRange(query2);
}
//删除数据表数据
db.tblEQISO_SpaceID5_Midd.RemoveRange(query);
//删除参数表数据
var query3 = (from x in db.tblEQIW_D_Info_Midd
where x.fldAutoID == item.fldAutoID
select x).ToList();
db.tblEQIW_D_Info_Midd.RemoveRange(query3);
num = db.SaveChanges();
}
if (item.SpaceID == 6)
{
var query = (from x in db.tblEQISO_SpaceID6_Midd
where x.fldFKID == item.fldAutoID
select x).ToList();
//删除数据表数据
db.tblEQISO_SpaceID6_Midd.RemoveRange(query);
//删除参数表数据
var query3 = (from x in db.tblEQIW_D_Info_Midd
where x.fldAutoID == item.fldAutoID
select x).ToList();
db.tblEQIW_D_Info_Midd.RemoveRange(query3);
num = db.SaveChanges();
}
}
}
result = rule.JsonStr("ok", "执行成功！", num);
}
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")
});
}
