private DataTable BindData() { string areaTypeWhereStr = string.Empty; Entities.QueryProjectTask_AuditContrastInfo query = new Entities.QueryProjectTask_AuditContrastInfo(); if (!string.IsNullOrEmpty(RequestCreateBeginTime)) { query.CreateStartDate = RequestCreateBeginTime; } if (!string.IsNullOrEmpty(RequestCreateEndTime)) { query.CreateEndDate = RequestCreateEndTime; } if (!string.IsNullOrEmpty(RequestCustIDORMemberID)) { query.CustIDORMemberID = RequestCustIDORMemberID; } if (!string.IsNullOrEmpty(RequestCustNameORMemberName)) { query.CustNameORMemberName = RequestCustNameORMemberName; } //if (RequestExportStatus != -1) //{ // query.ExportStatus = RequestExportStatus; //} if (RequestContrastType != -1) { query.ContrastType = RequestContrastType; } if (RequestDisposeStatus != -1) { query.DisposeStatus = RequestDisposeStatus; } if (!string.IsNullOrEmpty(RequestSeatTrueName)) { query.SeatTrueName = RequestSeatTrueName; } if (RequestTaskBatch != -1) { query.TaskBatch = RequestTaskBatch; } //**add by qizhiqiang 2012-5-21 if (RequestMemberProvinceID > 0) { query.MemberProvinceID = RequestMemberProvinceID.ToString(); } if (RequestMemberCityID > 0) { query.MemberCityID = RequestMemberCityID.ToString(); } if (RequestMemberCountyID > 0) { query.MemberCountyID = RequestMemberCountyID.ToString(); } //** //BLL.CC_AuditContrastInfo.Instance.BatchUpdateExportStatusByWhere(query, 1); int CountOfRecords = 0; DataTable dt = BLL.ProjectTask_AuditContrastInfo.Instance.GetProjectTask_AuditContrastInfo(query, "ac.CreateTime Desc", 1, 1000000, out CountOfRecords); if (dt != null && dt.Rows.Count > 0) { //add by qizhiqiang 过滤StatID!='' and StatID!='0' AND StatID!='-2' DataView dv = new DataView(dt); dv.RowFilter = "StatID<>'' and StatID<>'0' AND StatID<>'-2'"; DataTable dt_New = dv.ToTable(); return(dt_New); //this.repterExportList.DataSource = dt_New; } else { return(null); } ////绑定列表数据 //this.repterExportList.DataBind(); }
private void BindDMSData() { string areaTypeWhereStr = string.Empty; Entities.QueryProjectTask_AuditContrastInfo query = new Entities.QueryProjectTask_AuditContrastInfo(); if (!string.IsNullOrEmpty(RequestCustIDORMemberID)) { query.CustIDORMemberID = RequestCustIDORMemberID; } if (!string.IsNullOrEmpty(RequestCustNameORMemberName)) { query.CustNameORMemberName = RequestCustNameORMemberName; } if (!string.IsNullOrEmpty(RequestCreateBeginTime)) { query.CreateStartDate = RequestCreateBeginTime; } if (!string.IsNullOrEmpty(RequestCreateEndTime)) { query.CreateEndDate = RequestCreateEndTime; } //if (RequestExportStatus != -1) //{ // query.ExportStatus = RequestExportStatus; //} if (RequestContrastType != -1) { query.ContrastType = RequestContrastType; } if (RequestDisposeStatus != -1) { query.DisposeStatus = RequestDisposeStatus; } if (!string.IsNullOrEmpty(RequestSeatTrueName)) { query.SeatTrueName = RequestSeatTrueName; } //**add by qizhiqiang 2012-5-21 if (RequestMemberProvinceID > 0) { query.MemberProvinceID = RequestMemberProvinceID.ToString(); } if (RequestMemberCityID > 0) { query.MemberCityID = RequestMemberCityID.ToString(); } if (RequestMemberCountyID > 0) { query.MemberCountyID = RequestMemberCountyID.ToString(); } //** //if (!string.IsNullOrEmpty(RequestCarType)) //{ // query.CarType = RequestCarType; //} query.TaskBatch = RequestTaskBatch; DataTable dt = BLL.ProjectTask_AuditContrastInfo.Instance.GetProjectTask_AuditContrastInfo(query, "ac.CreateTime Desc", PageCommon.Instance.PageIndex, BLL.PageCommon.Instance.PageSize, out CountOfRecords); //DataTable dt = BLL.CC_AuditContrastInfo.Instance.GetCC_AuditContrastInfoForChange(query, "ac.CreateTime Desc", PageCommon.Instance.PageIndex, PageSize, out CountOfRecords); if (dt != null && dt.Rows.Count > 0) { //add by qizhiqiang 过滤StatID!='' and StatID!='0' AND StatID!='-2' DataView dv = new DataView(dt); dv.RowFilter = "StatID<>'' and StatID<>'0' AND StatID<>'-2'"; DataTable dt_New = dv.ToTable(); this.Repeater_ExportChanged.DataSource = dt_New; //this.Repeater_ExportChanged.DataSource = dt; } //绑定列表数据 this.Repeater_ExportChanged.DataBind(); //分页控件(要明确页面容器ID,这里没有写是因为请求页面在Request参数中声明了) litPagerDown.Text = BLL.PageCommon.Instance.LinkStringByPost(BLL.Util.GetUrl(), GroupLength, CountOfRecords, BLL.PageCommon.Instance.PageSize, BLL.PageCommon.Instance.PageIndex, 1); }