private void GetData()
{
string strWhere = "1=1";
string year = Request["year"];
string month = Request["month"];
string pointId = Request["pointId"];
if (year != "")
{
strWhere += " and YEAR='" + year + "'";
}
if (month.ToString() != "")
{
strWhere += " and MONTH='" + month + "'";
}
if (pointId != "")
{
strWhere += " and ID='" + pointId + "'";
}
DataTable dtShow = new DataTable();
dtShow = new TEnvFillAirLogic().CreateShowDT();
DataTable dt = new TEnvFillAirLogic().GetFillData(strWhere, dtShow, TEnvPAirVo.T_ENV_P_AIR_TABLE, TEnvPNoiseFunctionItemVo.T_ENV_P_NOISE_FUNCTION_ITEM_TABLE, TEnvFillAirVo.T_ENV_FILL_AIR_TABLE,
TEnvFillAirHourVo.T_ENV_FILL_AIR_ITEM_TABLE, SerialType.T_ENV_FILL_AIR, SerialType.T_ENV_FILL_AIR_ITEM);
string json = DataTableToJsonUnsureColAirHour(dt);
Response.ContentType = "application/json;charset=utf-8";
Response.Write(json);
Response.End();
}
private void ComputeAQI()
{
string year = Request["year"];
string month = Request["month"];
int Rtnresult = new TEnvFillAirLogic().ExcelOutCal(year, month, TEnvFillAirHourVo.T_ENV_FILL_AIR_ITEM_TABLE);
Response.ContentType = "application/json";
Response.Write("{\"result\":\"success\"}");
Response.End();
}
private void SaveData()
{
bool result = false;
string data = "[" + Request["data"] + "]";
string itemName = Request["itemname"];//列名
string value = Request["value"];
string Fill_ID = Request["fill_id"];
result = new TEnvFillAirLogic().UpdateAirValue(Fill_ID, value, itemName);
Response.ContentType = "application/json";
Response.Write("{\"result\":\"" + (result ? "success" : "fail") + "\"}");
Response.End();
}
private void GetFillID()
{
string year = Request["year"];
string month = Request["month"];
TEnvFillAirVo envFillAirVo = new TEnvFillAirVo();
envFillAirVo.YEAR = year;
envFillAirVo.MONTH = month;
envFillAirVo = new TEnvFillAirLogic().Details(envFillAirVo);
string json = "{\"ID\":\"" + envFillAirVo.ID + "\",\"STATUS\":\"" + envFillAirVo.STATUS + "\"}";
Response.ContentType = "application/json;charset=utf-8";
Response.Write(json);
Response.End();
}