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