public HttpResponseMessage GetNAData(DataParameter DP)
{
string result = "";
string defwhere = "1=1";
string defwhere2 = "1=1";
string where1 = "";
string where2 = "";
string where3 = "";
try
{
if (rule.Judge(DP.stcode))
{
defwhere += " and fldSTCode='" + DP.stcode + "'";
}
if (rule.Judge(DP.gdcode))
{
defwhere += " and fldGDCode='" + DP.gdcode + "'";
}
if (rule.istime(DP.BeginDate) && rule.istime(DP.EndDate))
{
DateTime dtime = DateTime.Parse(DP.BeginDate);
where1 += " and fldYear='" + dtime.Year + "'";
where3 += " and fldYear='" + (dtime.Year - 1) + "'";
}
else
{
result = rule.JsonStr("error", "时间格式不正确！", "");
return(new HttpResponseMessage {
Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json")
});
}
//当期
string sql = "select * from vwtblEQIN_A_Data where " + defwhere + where1;
//同期
string sql3 = "select * from vwtblEQIN_A_Data where " + defwhere + where3;
DataTable dt = rule.GetMiddleData(sql);
DataTable dt2 = new DataTable();
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 GetCityWPI(GisParameter GP)
{
string result = "";
string where = "1=1";
string where2 = "1=1";
try
{
if (rule.Judge(GP.stcode))
{
where += " and fldSTCode='" + GP.stcode + "'";
}
if (rule.Judge(GP.stname))
{
where += " and fldSTName='" + GP.stname + "'";
}
if (rule.istime(GP.BeginDate))
{
DateTime dtime = DateTime.Parse(GP.BeginDate);
where += " and fldDate='" + dtime.Year + "年" + dtime.Month + "月'";
where2 += " and fldDate='" + dtime.Year + "年" + dtime.Month + "月'";
}
else
{
result = rule.JsonStr("error", "时间格式不正确！", "");
return(new HttpResponseMessage {
Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json")
});
}
string sql = "select * from tblEQIA_R_WPI where " + where;
DataTable dt = rule.GetMiddleData(sql);
retudt tt = new retudt();
tt.DQ = dt;
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 GetCityYL(GisParameter GP)
{
string result = "";
string defwhere = "1=1";
string where = "";
string where2 = "";
string where3 = "";
string where4 = "";
try
{
if (rule.Judge(GP.stcode))
{
defwhere += " and fldSTCode='" + GP.stcode + "'";
}
if (rule.Judge(GP.stname))
{
defwhere += " and fldSTName='" + GP.stname + "'";
}
if (rule.istime(GP.BeginDate))
{
DateTime dtime = DateTime.Parse(GP.BeginDate);
where += " and fldDate='" + dtime.Year + "年" + dtime.Month + "月'";
where2 += " and fldDate='" + dtime.Year + "年" + dtime.Month + "月'";
where3 += " and fldDate='" + (dtime.Year - 1) + "年" + dtime.Month + "月'";
if (dtime.Month - 1 < 0)
{
where4 += " and fldDate='" + (dtime.Year - 1) + "年12月'";
}
else
{
where4 += " and fldDate='" + (dtime.Year) + "年" + (dtime.Month - 1) + "月'";
}
}
else
{
result = rule.JsonStr("error", "时间格式不正确！", "");
return(new HttpResponseMessage {
Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json")
});
}
string sql = "select * from vwtblEQIA_R_YLData where " + defwhere + where;
DataTable dt = rule.GetMiddleData(sql);
string sql1 = "select * from tblEQIA_R_Province where 1=1 " + where2;
DataTable dt1 = rule.GetMiddleData(sql1);
string sql2 = "select * from vwtblEQIA_R_YLData where " + defwhere + where3;
DataTable dt2 = rule.GetMiddleData(sql2);
string sql13 = "select * from tblEQIA_R_Province where " + defwhere + where4;
DataTable dt3 = rule.GetMiddleData(sql13);
retudt tt = new retudt();
tt.DQ = dt;
tt.Province = dt1;
tt.TQ = dt2;
tt.QQ = 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 GetEQIA_R_Value(GisParameter GP)
{
string result = "";
string where = "1=1";
string where2 = "1=1";
string where3 = "";
string where4 = "";
try
{
if (rule.Judge(GP.type))
{
if (GP.type == "城市")
{
where += " and fldPName='全市'";
}
if (GP.type == "测点")
{
where += " and fldPName !='全市'";
}
}
else
{
result = rule.JsonStr("error", "测点类型不正确！", "");
return(new HttpResponseMessage {
Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json")
});
}
if (rule.Judge(GP.itemcode))
{
where += " and fldItemCode='" + GP.itemcode + "'";
where2 += " and fldItemCode='" + GP.itemcode + "'";
}
else
{
result = rule.JsonStr("error", "因子代码不正确！", "");
return(new HttpResponseMessage {
Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json")
});
}
if (rule.Judge(GP.stcode))
{
where += " and fldSTCode='" + GP.stcode + "'";
}
if (rule.Judge(GP.pcode))
{
where += " and fldPCode='" + GP.pcode + "'";
}
where3 += where2;
where4 += where2;
if (rule.istime(GP.BeginDate))
{
DateTime dtime = DateTime.Parse(GP.BeginDate);
if (GP.type == "城市")
{
where += " and fldDate='" + dtime.Year + "年" + dtime.Month + "月'";
where2 += " and fldDate='" + dtime.Year + "年" + dtime.Month + "月'";
where3 += " and fldDate='" + (dtime.Year - 1) + "年" + dtime.Month + "月'";
if (dtime.Month == 1)
{
where4 += " and fldDate='" + (dtime.Year - 1) + "年12月'";
}
else
{
where4 += " and fldDate='" + (dtime.Year) + "年" + (dtime.Month - 1) + "月'";
}
}
else
{
if (dtime.Month < 10)
{
where += " and fldDate='" + dtime.Year + "年" + dtime.Month + "月'";
where2 += " and fldDate='" + dtime.Year + "年0" + dtime.Month + "月'";
}
else
{
where += " and fldDate='" + dtime.Year + "年" + dtime.Month + "月'";
where2 += " and fldDate='" + dtime.Year + "年" + dtime.Month + "月'";
}
}
}
else
{
result = rule.JsonStr("error", "时间格式不正确！", "");
return(new HttpResponseMessage {
Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json")
});
}
string sql = "select * from vwtblEQIA_R_Value where " + where;
DataTable dt = rule.GetMiddleData(sql);
string sql1 = "select * from tblEQIA_R_CityWRW where " + where2;
DataTable dt1 = rule.GetMiddleData(sql1);
string sql3 = "select * from tblEQIA_R_CityWRW where " + where3;
DataTable dt3 = rule.GetMiddleData(sql3);
string sql4 = "select * from tblEQIA_R_CityWRW where " + where4;
DataTable dt4 = rule.GetMiddleData(sql4);
retudt tt = new retudt();
tt.DQ = dt;
tt.ALL = dt1;
tt.ALLTQ = dt3;
tt.ALLQQ = dt4;
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 GetEQIA_P_data(DataParameter DP)
{
string result = "";
string defwhere = "1=1";
try
{
if (rule.Judge(DP.pcode))
{
defwhere += " and fldCode='" + DP.pcode + "'";
}
if (rule.Judge(DP.stcode))
{
defwhere += " and fldSTCode='" + DP.stcode + "'";
}
if (rule.JudgeLevel(DP.type))
{
if (DP.type == "0")
{
defwhere += " and fldPName='全市'";
}
if (DP.type == "1")
{
defwhere += " and fldPName !='全市'";
}
}
if (rule.istime(DP.BeginDate) && rule.istime(DP.EndDate))
{
DateTime dtime = DateTime.Parse(DP.BeginDate);
if (dtime.Month < 10)
{
string ti = dtime.Year + "年0" + dtime.Month + "月";
defwhere += " and fldDate='" + ti + "'";
}
else
{
string ti = dtime.Year + "年" + dtime.Month + "月";
defwhere += " and fldDate='" + ti + "'";
}
}
else
{
result = rule.JsonStr("error", "时间格式不正确！", "");
return(new HttpResponseMessage {
Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json")
});
}
//当期
string sql = "select * from vwtblEQIA_P_Data where " + defwhere;
DataTable dt = rule.GetMiddleData(sql);
retudt tt = new retudt();
tt.DQ = dt;
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 Geteqiw_d_Indexdata(DataParameter DP)
{
string result = "";
string defwhere = "1=1";
string defwhere2 = "1=1";
string where1 = "";
string level = "";
string where2 = "";
string where3 = "";
try
{
if (rule.JudgeLevel(DP.level))
{
if (DP.level == "1")
{
DP.level = "市级";
}
if (DP.level == "2")
{
DP.level = "县级";
}
defwhere += " and fldSLevel='" + DP.level + "'";
defwhere2 += " and fldSLevel='" + DP.level + "'";
}
if (rule.Judge(DP.stcode))
{
defwhere += " and fldSTCode like '%" + DP.stcode.Substring(0, 4) + "%'";
defwhere2 += " and fldSTCode like '%" + DP.stcode.Substring(0, 4) + "%'";
}
if (rule.Judge(DP.stname))
{
defwhere += " and fldSTName='" + DP.stname + "'";
defwhere2 += " and fldSTName='" + DP.stname + "'";
}
if (rule.Judge(DP.rscode))
{
defwhere += " and fldRSCode='" + DP.rscode + "'";
defwhere2 += " and fldRSCode='" + DP.rscode + "'";
}
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 = "select * from talEQIW_D_CityData where " + defwhere + where1;
//水质
string sql2 = "select * from tblEQIW_D_CityStage where " + defwhere + where1;
string sql3 = "";
string sql4 = "";
if (DP.stcode == "-1")
{
sql3 = "select * from talEQIW_D_CityData where " + defwhere + where1; //当前
sql4 = "select * from talEQIW_D_CityData where " + defwhere2 + where2; //累计
}
else
{
sql3 = "select * from tblEQIW_D_SectionData_New where " + defwhere + where1; //当前
sql4 = "select * from tblEQIW_D_SectionData_New where " + defwhere2 + where2; //累计
}
DataTable dt = rule.GetMiddleData(sql);
DataTable dt2 = rule.GetMiddleData(sql2);
DataTable dt3 = rule.GetMiddleData(sql3);
DataTable dt4 = rule.GetMiddleData(sql4);
retudt tt = new retudt();
tt.Scale = dt;
tt.Stage = dt2;
tt.city = dt3;
tt.cityLJ = dt4;
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")
});
}
