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(); }