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 != "")
{
strWhere += " and MONTH='" + month + "'";
}
if (pointId != "")
{
strWhere += " and ID='" + pointId + "'";
}
DataTable dtShow = new DataTable();//填报表需要显示信息
dtShow = new TEnvFillDustLogic().CreateShowDT();
CommonLogic com = new CommonLogic();
DataTable dt = com.GetFillData(strWhere,
dtShow,
"",
TEnvPointDustVo.T_ENV_POINT_DUST_TABLE,
TEnvPDustItemVo.T_ENV_P_DUST_ITEM_TABLE,
TEnvFillDustVo.T_ENV_FILL_DUST_TABLE,
TEnvFillDustItemVo.T_ENV_FILL_DUST_ITEM_TABLE,
SerialType.T_ENV_FILL_DUST,
SerialType.T_ENV_FILL_DUST_ITEM,
"0");
string json = DataTableToJsonUnsureCol(dt);
//DataTable dtAllItem = new DataTable();//动态监测项目信息
//DataTable dt = new TEnvFillDustLogic().GetDustFillData(year, month, ref dtAllItem, pointId,SerialType.T_ENV_FILL_DUST, SerialType.T_ENV_FILL_DUST_ITEM);
// string json = DataTableToJsonUnsureCol(dt, dtAllItem,"T_ENV_FILL_DUST_ITEM@");
Response.ContentType = "application/json;charset=utf-8";
Response.Write(json);
Response.End();
}
private void GetFillID()
{
string year = Request["year"];
string month = Request["month"];
TEnvFillDustVo envFillDustVo = new TEnvFillDustVo();
envFillDustVo.YEAR = year;
envFillDustVo.MONTH = month;
envFillDustVo = new TEnvFillDustLogic().Details(envFillDustVo);
string json = "{\"ID\":\"" + envFillDustVo.ID + "\",\"STATUS\":\"" + envFillDustVo.STATUS + "\"}";
Response.ContentType = "application/json;charset=utf-8";
Response.Write(json);
Response.End();
}
