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