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