public HttpResponseMessage Getcityata(DataParameter DP) { string result = ""; string defwhere = "1=1"; string defwhere2 = "1=1"; string where1 = ""; string where2 = ""; string where3 = ""; string where4 = ""; string where5 = ""; try { if (rule.Judge(DP.stcode)) { defwhere += " and fldSTCode='" + DP.stcode + "'"; defwhere2 += " and fldSTCode='" + DP.stcode + "'"; } if (rule.JudgeLevel(DP.level)) { defwhere += " and fldLevel='" + DP.level + "'"; defwhere2 += " and fldLevel='" + DP.level + "'"; } if (rule.Judge(DP.TimeType)) { defwhere += " and fldDType='" + DP.TimeType + "'"; defwhere2 += " and fldDType='累计'"; } else { result = rule.JsonStr("error", "时间类型不正确!", ""); return(new HttpResponseMessage { Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json") }); } if (rule.istime(DP.BeginDate) && rule.istime(DP.EndDate)) { if (DP.TimeType == "month") { DateTime dtime = DateTime.Parse(DP.BeginDate); if (dtime.Month < 10) { string ti = dtime.Year + "年0" + dtime.Month + "月"; where1 += " and fldDate='" + ti + "'"; where2 += rule.strtime(ti, "累计"); where3 += " and fldDate='" + (dtime.Year - 1) + "年0" + dtime.Month + "月" + "'"; where4 += " and fldDate<='" + ti + "' and fldDate>='" + dtime.Year + "年01'"; where5 += " and fldDate<='" + (dtime.Year - 1) + "年0" + dtime.Month + "月" + "' and fldDate>='" + (dtime.Year - 1) + "年01月'"; } else { string ti = dtime.Year + "年" + dtime.Month + "月"; where1 += " and fldDate='" + ti + "'"; where2 += rule.strtime(ti, "累计"); where3 += " and fldDate='" + (dtime.Year - 1) + "年" + dtime.Month + "月" + "'"; where4 += " and fldDate<='" + ti + "' and fldDate>='" + dtime.Year + "年01'"; where5 += " and fldDate<='" + (dtime.Year - 1) + "年" + dtime.Month + "月" + "' and fldDate>='" + (dtime.Year - 1) + "年01月'"; } } if (DP.TimeType == "sea") { DateTime dtime = DateTime.Parse(DP.EndDate); string ti3 = dtime.Year + "年" + dtime.Month + "月"; string ti = ""; string ti2 = ""; if (dtime.Month == 3) { ti = dtime.Year + "年1季度"; ti2 = (dtime.Year - 1) + "年1季度"; } if (dtime.Month == 6) { ti = dtime.Year + "年2季度"; ti2 = (dtime.Year - 1) + "年2季度"; } if (dtime.Month == 9) { ti = dtime.Year + "年3季度"; ti2 = (dtime.Year - 1) + "年3季度"; } if (dtime.Month == 12) { ti = dtime.Year + "年4季度"; ti2 = (dtime.Year - 1) + "年4季度"; } where1 += " and fldDate='" + ti + "'"; where2 += rule.strtime(ti3, "累计"); where3 += " and fldDate='" + ti2 + "'"; where4 += " and fldDate<='" + ti + "' and fldDate>='" + dtime.Year + "年1季度'"; where5 += " and fldDate<='" + ti2 + "' and fldDate>='" + (dtime.Year - 1) + "年1季度'"; } if (DP.TimeType == "year") { DateTime dtime = DateTime.Parse(DP.EndDate); string ti3 = dtime.Year + "年"; string ti = ""; string ti2 = (dtime.Year - 1) + "年"; where1 += " and fldDate='" + ti3 + "'"; where2 += rule.strtime(ti3, "累计"); where3 += " and fldDate='" + ti2 + "'"; } } else { result = rule.JsonStr("error", "时间格式不正确!", ""); return(new HttpResponseMessage { Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json") }); } //当期 string sql = "select * from tblEQIW_R_CityData where " + defwhere + where1; //累计 string sql2 = "select * from tblEQIW_R_CityData where " + defwhere2 + where2; //同期 string sql3 = "select * from tblEQIW_R_CityData where " + defwhere + where3; string sql4 = "select * from tblEQIW_R_CityData where " + defwhere + where4; string sql5 = "select * from tblEQIW_R_CityData where " + defwhere + where5; DataTable dt = rule.GetMiddleData(sql); DataTable dt2 = rule.GetMiddleData(sql2); DataTable dt3 = rule.GetMiddleData(sql3); DataTable dt4 = rule.GetMiddleData(sql4); DataTable dt5 = rule.GetMiddleData(sql5); retudt tt = new retudt(); tt.DQ = dt; tt.LJ = dt2; tt.TQ = dt3; tt.DQFW = dt4; tt.TQFW = dt5; result = rule.JsonStr("ok", "", tt); } catch (Exception e) { result = rule.JsonStr("error", e.Message, ""); } return(new HttpResponseMessage { Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json") }); }
public HttpResponseMessage GetItemOver(DataParameter DP) { string result = ""; string defwhere = "1=1"; string defwhere2 = "1=1"; string where1 = ""; string where2 = ""; string where3 = ""; try { if (rule.Judge(DP.spacecode)) { defwhere += " and fldSpaceCode='" + DP.spacecode + "'"; defwhere2 += " and fldSpaceCode='" + DP.spacecode + "'"; } if (rule.Judge(DP.spacename)) { defwhere += " and fldSpaceName='" + DP.spacename + "'"; defwhere2 += " and fldSpaceName='" + DP.spacename + "'"; } if (rule.Judge(DP.stattype)) { defwhere += " and fldStatType='" + DP.stattype + "'"; defwhere2 += " and fldStatType='" + DP.stattype + "'"; } if (rule.JudgeLevel(DP.level)) { defwhere += " and fldLevel='" + DP.level + "'"; defwhere2 += " and fldLevel='" + DP.level + "'"; } if (rule.Judge(DP.TimeType)) { defwhere += " and fldDType='" + DP.TimeType + "'"; defwhere2 += " and fldDType='累计'"; } else { result = rule.JsonStr("error", "时间类型不正确!", ""); return(new HttpResponseMessage { Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json") }); } #region if (rule.istime(DP.BeginDate) && rule.istime(DP.EndDate)) { if (DP.TimeType == "month") { DateTime dtime = DateTime.Parse(DP.BeginDate); if (dtime.Month < 10) { string ti = dtime.Year + "年0" + dtime.Month + "月"; where1 += " and fldDate='" + ti + "'"; where2 += rule.strtime(ti, "累计"); where3 += " and fldDate='" + (dtime.Year - 1) + "年0" + dtime.Month + "月" + "'"; } else { string ti = dtime.Year + "年" + dtime.Month + "月"; where1 += " and fldDate='" + ti + "'"; where2 += rule.strtime(ti, "累计"); where3 += " and fldDate='" + (dtime.Year - 1) + "年" + dtime.Month + "月" + "'"; } } if (DP.TimeType == "sea") { DateTime dtime = DateTime.Parse(DP.EndDate); string ti3 = dtime.Year + "年" + dtime.Month + "月"; string ti = ""; string ti2 = ""; if (dtime.Month == 3) { ti = dtime.Year + "年1季度"; ti2 = (dtime.Year - 1) + "年1季度"; } if (dtime.Month == 6) { ti = dtime.Year + "年2季度"; ti2 = (dtime.Year - 1) + "年2季度"; } if (dtime.Month == 9) { ti = dtime.Year + "年3季度"; ti2 = (dtime.Year - 1) + "年3季度"; } if (dtime.Month == 12) { ti = dtime.Year + "年4季度"; ti2 = (dtime.Year - 1) + "年4季度"; } where1 += " and fldDate='" + ti + "'"; where2 += rule.strtime(ti3, "累计"); where3 += " and fldDate='" + ti2 + "'"; } if (DP.TimeType == "year") { DateTime dtime = DateTime.Parse(DP.EndDate); string ti3 = dtime.Year + "年"; string ti = ""; string ti2 = (dtime.Year - 1) + "年"; where1 += " and fldDate='" + ti3 + "'"; where2 += rule.strtime(ti3, "累计"); where3 += " and fldDate='" + ti2 + "'"; } } else { result = rule.JsonStr("error", "时间格式不正确!", ""); return(new HttpResponseMessage { Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json") }); } #endregion string sql = ""; string sql2 = ""; string sql3 = ""; if (DP.stattype != "流域") { sql = "select * from vwtblEQIW_R_ItemOver where " + defwhere + where1; sql2 = "select * from vwtblEQIW_R_ItemOver where " + defwhere2 + where2; sql3 = "select * from vwtblEQIW_R_ItemOver where " + defwhere + where3; } else { sql = "select * from tblEQIW_R_ItemOver where " + defwhere + where1; sql2 = "select * from tblEQIW_R_ItemOver where " + defwhere2 + where2; sql3 = "select * from tblEQIW_R_ItemOver where " + defwhere + where3; } DataTable dt = rule.GetMiddleData(sql); DataTable dt2 = rule.GetMiddleData(sql2); DataTable dt3 = rule.GetMiddleData(sql3); retudt tt = new retudt(); tt.DQ = dt; tt.LJ = dt2; tt.TQ = dt3; result = rule.JsonStr("ok", "", tt); } catch (Exception e) { result = rule.JsonStr("error", e.Message, ""); } return(new HttpResponseMessage { Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json") }); }
public HttpResponseMessage GetRiverTabledata(DataParameter DP) { string result = ""; string defwhere = "1=1"; string defwhere2 = "1=1"; string where1 = ""; string where2 = ""; string where3 = ""; try { if (rule.JudgeLevel(DP.level)) { defwhere += " and fldLevel='" + DP.level + "'"; defwhere2 += " and fldLevel='" + DP.level + "'"; } if (rule.Judge(DP.TimeType)) { defwhere += " and fldDType='" + DP.TimeType + "'"; defwhere2 += " and fldDType='" + DP.TimeType + "'"; } else { result = rule.JsonStr("error", "时间类型不正确!", ""); return(new HttpResponseMessage { Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json") }); } if (rule.istime(DP.BeginDate) && rule.istime(DP.EndDate)) { if (DP.TimeType == "month") { DateTime dtime = DateTime.Parse(DP.BeginDate); if (dtime.Month < 10) { string ti = dtime.Year + "年0" + dtime.Month + "月"; where1 += " and fldDate='" + ti + "'"; if (dtime.Month == 1) { where2 += " and fldDate='" + (dtime.Year - 1) + "年12月'"; } else { where2 += " and fldDate='" + dtime.Year + "年0" + (dtime.Month - 1) + "月'"; } } else { string ti = dtime.Year + "年" + dtime.Month + "月"; where1 += " and fldDate='" + ti + "'"; where2 += " and fldDate='" + dtime.Year + "年" + (dtime.Month - 1) + "月'"; } } if (DP.TimeType == "sea") { DateTime dtime = DateTime.Parse(DP.EndDate); string ti3 = dtime.Year + "年" + dtime.Month + "月"; string ti = ""; string ti2 = ""; if (dtime.Month == 3) { ti = dtime.Year + "年1季度"; ti2 = (dtime.Year - 1) + "年4季度"; } if (dtime.Month == 6) { ti = dtime.Year + "年2季度"; ti2 = (dtime.Year) + "年1季度"; } if (dtime.Month == 9) { ti = dtime.Year + "年3季度"; ti2 = (dtime.Year) + "年2季度"; } if (dtime.Month == 12) { ti = dtime.Year + "年4季度"; ti2 = (dtime.Year) + "年3季度"; } where1 += " and fldDate='" + ti + "'"; where2 += " and fldDate='" + ti2 + "'"; } if (DP.TimeType == "year") { DateTime dtime = DateTime.Parse(DP.EndDate); string ti3 = dtime.Year + "年"; string ti = ""; string ti2 = (dtime.Year - 1) + "年"; where1 += " and fldDate='" + ti3 + "'"; where2 += " and fldDate='" + ti2 + "'"; } } else { result = rule.JsonStr("error", "时间格式不正确!", ""); return(new HttpResponseMessage { Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json") }); } //当期 string sql = "select * from tblEQIW_R_Province_Data where " + defwhere + where1; //累计 string sql2 = "select * from tblEQIW_R_Province_Data where " + defwhere2 + where2; //同期 string sql3 = "select * from tblEQIW_R_Province_Data where " + defwhere + where3; //城市 string sql4 = "select * from tblEQIW_R_CityData where " + defwhere + where1 + " order by fldSTCode"; //上期城市 string sql5 = "select * from tblEQIW_R_CityData where " + defwhere2 + where2 + " order by fldSTCode"; DataTable dt4 = rule.GetMiddleData(sql4); DataTable dt5 = rule.GetMiddleData(sql5); DataTable dt6 = dt4.Copy(); for (int i = 0; i < dt4.Rows.Count; i++) { if (dt4.Rows[i]["fldSTCode"].ToString() == dt5.Rows[i]["fldSTCode"].ToString()) { if (rule.ismtch(dt5.Rows[i]["fldApprise"].ToString())) { dt6.Rows[i]["fldApprise"] = (decimal.Parse(dt4.Rows[i]["fldApprise"].ToString()) - decimal.Parse(dt5.Rows[i]["fldApprise"].ToString())) / decimal.Parse(dt5.Rows[i]["fldApprise"].ToString()) * 100; } else { dt6.Rows[i]["fldApprise"] = "0"; } } } DataTable dt = rule.GetMiddleData(sql); DataTable dt2 = rule.GetMiddleData(sql2); DataTable dt3 = rule.GetMiddleData(sql3); retudt tt = new retudt(); tt.DQ = dt; tt.LJ = dt2; tt.TQ = dt3; tt.city = dt4; tt.BHcity = dt6; result = rule.JsonStr("ok", "", tt); } catch (Exception e) { result = rule.JsonStr("error", e.Message, ""); } return(new HttpResponseMessage { Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json") }); }