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

        TEnvFillMudSeaVo envFillMudSeaVo = new TEnvFillMudSeaVo();

        envFillMudSeaVo.YEAR  = year;
        envFillMudSeaVo.MONTH = month;

        envFillMudSeaVo = new TEnvFillMudSeaLogic().Details(envFillMudSeaVo);

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

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

        CommonLogic com = new CommonLogic();
        DataTable   dt  = com.GetFillData(strWhere,
                                          dtShow,
                                          TEnvPMudSeaVo.T_ENV_P_MUD_SEA_TABLE,
                                          TEnvPMudSeaVVo.T_ENV_P_MUD_SEA_V_TABLE,
                                          TEnvPMudSeaVItemVo.T_ENV_P_MUD_SEA_V_ITEM_TABLE,
                                          TEnvFillMudSeaVo.T_ENV_FILL_MUD_SEA_TABLE,
                                          TEnvFillMudSeaItemVo.T_ENV_FILL_MUD_SEA_ITEM_TABLE,
                                          SerialType.T_ENV_FILL_MUD_SEA,
                                          SerialType.T_ENV_FILL_MUD_SEA_ITEM,
                                          "1");

        string json = DataTableToJsonUnsureCol(dt);

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