예제 #1
0
    /// <summary>
    /// 获取监测任务列表信息
    /// </summary>
    /// <returns></returns>
    protected void selectTask()
    {
        string strSortname  = Request.Params["sortname"];
        string strSortorder = Request.Params["sortorder"];
        int    intPageIdx   = Convert.ToInt32(Request.Params["page"]);
        int    intPagesize  = Convert.ToInt32(Request.Params["pagesize"]);

        //任务单号
        string strTICKET_NUM = !string.IsNullOrEmpty(Request.QueryString["SrhTICKET_NUM"]) ? Request.QueryString["SrhTICKET_NUM"].ToString() : "";
        //项目名称
        string strProjectName = !string.IsNullOrEmpty(Request.QueryString["SrhProjectName"]) ? Request.QueryString["SrhProjectName"].ToString() : "";

        //构造查询对象
        TMisMonitorTaskVo    objTask      = new TMisMonitorTaskVo();
        TMisMonitorTaskLogic objTaskLogic = new TMisMonitorTaskLogic();

        if (strSortname == null || strSortname.Length == 0)
        {
            strSortname = TMisMonitorTaskVo.ID_FIELD;
        }

        //objTask.SORT_FIELD = strSortname;
        //objTask.SORT_TYPE = strSortorder;
        objTask.CONTRACT_TYPE = "07";
        objTask.SORT_FIELD    = "CREATE_DATE";
        objTask.SORT_TYPE     = "desc";
        //objTask.CONTRACT_YEAR = strYear;
        //objTask.CONTRACT_TYPE = strContractType;
        objTask.TICKET_NUM   = strTICKET_NUM;
        objTask.PROJECT_NAME = strProjectName;
        //objTask.CONTRACT_TYPE = contract_type;

        //string strJson = "";
        //int intTotalCount = objTaskLogic.GetSelectResultCount(objTask);//总计的数据条数
        //DataTable dt = objTaskLogic.SelectByTable(objTask, intPageIdx, intPagesize);

        //strJson = CreateToJson(dt, intTotalCount);


        DataTable dt            = objTaskLogic.SelectByTable(objTask, 0, 0);
        int       intTotalCount = dt.Rows.Count;
        //int intTotalCount = objContractLogic.GetSelectResultCountEx(objContract, strStatus);//总计的数据条数
        //DataTable dt = objContractLogic.SelectByTableEx(objContract, strStatus, intPageIdx, intPagesize);
        //string strJson = CreateToJson(dt, intTotalCount);

        //by lhm
        //int intTotalCount;
        //DataTable dt = objContractLogic.SelectByTable(objContract);

        var ccflowDt = CCFlowFacade.GetCCFLowStatus(this.LogInfo.UserInfo.USER_NAME, dt, null, intPageIdx, intPagesize, out intTotalCount);

        string strJson = CreateToJson(ccflowDt, intTotalCount);


        Response.Write(strJson);
        Response.End();
    }
예제 #2
0
    /// <summary>
    /// 获得委托书信息
    /// </summary>
    protected void SelectContract()
    {
        string strSortname  = Request.Params["sortname"];
        string strSortorder = Request.Params["sortorder"];
        int    intPageIdx   = Convert.ToInt32(Request.Params["page"]);
        int    intPagesize  = Convert.ToInt32(Request.Params["pagesize"]);

        //未办、已办状态 0:未办,1:已办
        string strStatus = !string.IsNullOrEmpty(Request.QueryString["Status"]) ? Request.QueryString["Status"].ToString() : "";
        //委托年度
        string strYear = !string.IsNullOrEmpty(Request.QueryString["SrhYear"]) ? Request.QueryString["SrhYear"].ToString() : "";
        //委托类型
        string strContractType = !string.IsNullOrEmpty(Request.QueryString["SrhContractType"]) ? Request.QueryString["SrhContractType"].ToString() : "";
        //合同号
        string strContractCode = !string.IsNullOrEmpty(Request.QueryString["SrhContractCode"]) ? Request.QueryString["SrhContractCode"].ToString() : "";
        //任务单号
        string strDutyCode = !string.IsNullOrEmpty(Request.QueryString["DutyCode"]) ? Request.QueryString["DutyCode"].ToString() : "";
        //报告号
        string strReportCode = !string.IsNullOrEmpty(Request.QueryString["ReportCode"]) ? Request.QueryString["ReportCode"].ToString() : "";
        //委托客户
        string strClientName = !string.IsNullOrEmpty(Request.QueryString["ClientName"]) ? Request.QueryString["ClientName"].ToString() : "";
        //合同类别
        string strItemType = !string.IsNullOrEmpty(Request.QueryString["ItemType"]) ? Request.QueryString["ItemType"].ToString() : "";
        //项目名称
        string strProjectName = !string.IsNullOrEmpty(Request.QueryString["SrhProjectName"]) ? Request.QueryString["SrhProjectName"].ToString() : "";

        //构造查询对象
        TMisContractVo    objContract      = new TMisContractVo();
        TMisContractLogic objContractLogic = new TMisContractLogic();

        if (strSortname == null || strSortname.Length == 0)
        {
            strSortname = TMisContractVo.CONTRACT_CODE_FIELD;
        }

        //objContract.SORT_FIELD = strSortname;
        //objContract.SORT_TYPE = strSortorder;
        objContract.SORT_FIELD        = "ID";
        objContract.SORT_TYPE         = "desc";
        objContract.CONTRACT_YEAR     = strYear;
        objContract.CONTRACT_TYPE     = strContractType;
        objContract.CONTRACT_CODE     = strContractCode;
        objContract.CLIENT_COMPANY_ID = strClientName;
        objContract.TEST_TYPE         = strItemType;
        objContract.PROJECT_NAME      = strProjectName;

        //int intTotalCount = objContractLogic.GetSelectResultCountEx(objContract, strStatus);//总计的数据条数
        //DataTable dt = objContractLogic.SelectByTableEx(objContract, strStatus, intPageIdx, intPagesize);

        //string strJson = CreateToJson(dt, intTotalCount);


        string strJson = "";
        //int intTotalCount = objTaskLogic.GetSelectResultCount(objTask);//总计的数据条数
        DataTable dt            = objContractLogic.SelectByTableEx(objContract, strStatus, 0, 0);
        int       intTotalCount = dt.Rows.Count;
        var       ccflowDt      = CCFlowFacade.GetCCFLowStatus(this.LogInfo.UserInfo.USER_NAME, dt, strStatus, intPageIdx, intPagesize, out intTotalCount);

        strJson = CreateToJson(ccflowDt, intTotalCount);

        Response.Write(strJson);
        Response.End();
    }