Exemple #1
0
    private void GetFillID()
    {
        string year  = Request["year"];
        string month = Request["month"];

        TEnvFillSoilVo envFillSoilVo = new TEnvFillSoilVo();

        envFillSoilVo.YEAR  = year;
        envFillSoilVo.MONTH = month;

        envFillSoilVo = new TEnvFillSoilLogic().Details(envFillSoilVo);

        string json = "{\"ID\":\"" + envFillSoilVo.ID + "\",\"STATUS\":\"" + envFillSoilVo.STATUS + "\"}";

        Response.ContentType = "application/json;charset=utf-8";
        Response.Write(json);
        Response.End();
    }
Exemple #2
0
    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 TEnvFillSoilLogic().CreateShowDT();

        CommonLogic com = new CommonLogic();
        DataTable   dt  = com.GetFillData(strWhere,
                                          dtShow,
                                          "",
                                          TEnvPSoilVo.T_ENV_P_SOIL_TABLE,
                                          TEnvPSoilItemVo.T_ENV_P_SOIL_ITEM_TABLE,
                                          TEnvFillSoilVo.T_ENV_FILL_SOIL_TABLE,
                                          TEnvFillSoilItemVo.T_ENV_FILL_SOIL_ITEM_TABLE,
                                          SerialType.T_ENV_FILL_SOIL,
                                          SerialType.T_ENV_FILL_SOIL_ITEM,
                                          "0");

        string json = DataTableToJsonUnsureCol(dt);

        Response.ContentType = "application/json";
        Response.Write(json);
        Response.End();
    }