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 + "'";
}
//填报表需要显示信息(注：这Table里面的第一列数据要与填报表的列名一致)
DataTable dtShow = new DataTable();
dtShow = new TEnvFillRiverLogic().CreateShowDT();
CommonLogic com = new CommonLogic();
DataTable dt = com.GetFillData(strWhere,
dtShow,
TEnvPRiverVo.T_ENV_P_RIVER_TABLE,
TEnvPRiverVVo.T_ENV_P_RIVER_V_TABLE,
TEnvPRiverVItemVo.T_ENV_P_RIVER_V_ITEM_TABLE,
TEnvFillRiverVo.T_ENV_FILL_RIVER_TABLE,
TEnvFillRiverItemVo.T_ENV_FILL_RIVER_ITEM_TABLE,
SerialType.T_ENV_FILL_RIVER,
SerialType.T_ENV_FILL_RIVER_ITEM,
"1");
//DataTable dt = new TEnvFillRiverLogic().GetRiverFillData(year, month, pointId, ref dtAllItem, unSureMark);
string json = DataTableToJsonUnsureCol(dt);
Response.ContentType = "application/json";
Response.Write(json);
Response.End();
}
private void GetFillID()
{
string year = Request["year"];
string month = Request["month"];
TEnvFillRiverVo envFillRiverVo = new TEnvFillRiverVo();
envFillRiverVo.YEAR = year;
envFillRiverVo.MONTH = month;
envFillRiverVo = new TEnvFillRiverLogic().Details(envFillRiverVo);
string json = "{\"ID\":\"" + envFillRiverVo.ID + "\",\"STATUS\":\"" + envFillRiverVo.STATUS + "\"}";
Response.ContentType = "application/json;charset=utf-8";
Response.Write(json);
Response.End();
}
