private void GetFillID() { string year = Request["year"]; string month = Request["month"]; TEnvFillAirksVo envFillAirKsVo = new TEnvFillAirksVo(); envFillAirKsVo.YEAR = year; envFillAirKsVo.MONTH = month; envFillAirKsVo = new TEnvFillAirksLogic().Details(envFillAirKsVo); string json = "{\"ID\":\"" + envFillAirKsVo.ID + "\",\"STATUS\":\"" + envFillAirKsVo.STATUS + "\"}"; Response.ContentType = "application/json;charset=utf-8"; Response.Write(json); Response.End(); }
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 i3.BusinessLogic.Channels.Env.Fill.AirKS.TEnvFillAirksLogic().CreateShowDT(); //CommonLogic com = new CommonLogic(); //DataTable dt = com.GetFillData(strWhere, // dtShow, // "", // TEnvPAirVo.T_ENV_P_AIR_TABLE, // TEnvPNoiseFunctionItemVo.T_ENV_P_NOISE_FUNCTION_ITEM_TABLE, // i3.ValueObject.Channels.Env.Fill.AirKS.TEnvFillAirksVo.T_ENV_FILL_AIRKS_TABLE, // TEnvFillAirksItemVo.T_ENV_FILL_AIRKS_ITEM_TABLE, // SerialType.T_ENV_FILL_AIRKS, // SerialType.T_ENV_FILL_AIRKS_ITEM, // "0"); DataTable dt = new TEnvFillAirksLogic().GetFillData(strWhere, dtShow, TEnvPAirVo.T_ENV_P_AIR_TABLE, TEnvPNoiseFunctionItemVo.T_ENV_P_NOISE_FUNCTION_ITEM_TABLE, TEnvFillAirksVo.T_ENV_FILL_AIRKS_TABLE, TEnvFillAirksItemVo.T_ENV_FILL_AIRKS_ITEM_TABLE, SerialType.T_ENV_FILL_AIRKS, SerialType.T_ENV_FILL_AIRKS_ITEM); string json = DataTableToJsonUnsureCol(dt); Response.ContentType = "application/json;charset=utf-8"; Response.Write(json); Response.End(); }