private void BindData()
{
// url += '&VisitUserid=' + escape(SelectUserid);
// url += '&ProjectName=' + escapeStr(txtSearchProjectName);
//int totcount = 0;
if (!int.TryParse(RequestPageSize, out PageSize))
{
PageSize = 20;
}
Entities.QueryReturnVisitRecord query = new Entities.QueryReturnVisitRecord();
if (!string.IsNullOrEmpty(RequestCustName))
{
query.CustName = RequestCustName.Trim();
}
if (!string.IsNullOrEmpty(RequestCustID))
{
query.CustID = RequestCustID.Trim();
}
if (!string.IsNullOrEmpty(RequestCustType))
{
query.CustType = RequestCustType;
}
if (!string.IsNullOrEmpty(TypeID))
{
query.TypeID = TypeID;
}
if (!string.IsNullOrEmpty(VisitType))
{
query.VisitType = VisitType;
}
if (!string.IsNullOrEmpty(VisitUserid))
{
query.VisitUserid = VisitUserid;
}
if (!string.IsNullOrEmpty(RequestProvinceID) && int.Parse(RequestProvinceID) > 0)
{
query.ProvinceID = RequestProvinceID.Trim();
}
if (!string.IsNullOrEmpty(RequestCityID) && int.Parse(RequestCityID) > 0)
{
query.CityID = RequestCityID.Trim();
}
if (!string.IsNullOrEmpty(RequestCountyID) && int.Parse(RequestCountyID) > 0)
{
query.CountyID = RequestCountyID.Trim();
}
//add lxw 12.6.8 最近访问时间
if (!string.IsNullOrEmpty(StartTime))
{
query.StartTime = DateTime.Parse(StartTime);
}
if (!string.IsNullOrEmpty(EndTime))
{
query.EndTime = DateTime.Parse(EndTime);
}
//if (Contact != -2)
//{
// query.Contact = Contact;
//}
if (!string.IsNullOrEmpty(RequestProjectName))
{
query.ProjectName = RequestProjectName.Trim();
}
//if (!string.IsNullOrEmpty(ReqeustCCProjectName))
//{
// query.ReqeustCCProjectName = ReqeustCCProjectName;
//}
int count;
DataTable dt = BLL.ProjectTask_ReturnVisit.Instance.GetReturnVisitReCordList(query, "ReturnVisit.createtime desc", PageCommon.Instance.PageIndex, PageSize, out count);
RecordCount = count;
rplist.DataSource = dt;
rplist.DataBind();
litPagerDown1.Text = PageCommon.Instance.LinkStringByPost(BLL.Util.GetUrl(), GroupLength, count, PageSize, PageCommon.Instance.PageIndex, 1);
}
private DataTable BindData()
{
Entities.QueryReturnVisitRecord query = new Entities.QueryReturnVisitRecord();
if (!string.IsNullOrEmpty(RequestCustName))
{
query.CustName = RequestCustName.Trim();
}
if (!string.IsNullOrEmpty(RequestCustID))
{
query.CustID = RequestCustID.Trim();
}
if (!string.IsNullOrEmpty(RequestCustType))
{
query.CustType = RequestCustType;
}
if (!string.IsNullOrEmpty(TypeID))
{
query.TypeID = TypeID;
}
if (!string.IsNullOrEmpty(VisitType))
{
query.VisitType = VisitType;
}
if (!string.IsNullOrEmpty(VisitUserid))
{
query.VisitUserid = VisitUserid;
}
if (!string.IsNullOrEmpty(RequestProvinceID) && int.Parse(RequestProvinceID) > 0)
{
query.ProvinceID = RequestProvinceID.Trim();
}
if (!string.IsNullOrEmpty(RequestCityID) && int.Parse(RequestCityID) > 0)
{
query.CityID = RequestCityID.Trim();
}
if (!string.IsNullOrEmpty(RequestCountyID) && int.Parse(RequestCountyID) > 0)
{
query.CountyID = RequestCountyID.Trim();
}
//add lxw 12.6.8 最近访问时间
if (!string.IsNullOrEmpty(StartTime))
{
query.StartTime = DateTime.Parse(StartTime);
}
if (!string.IsNullOrEmpty(EndTime))
{
query.EndTime = DateTime.Parse(EndTime);
}
//if (Contact != -2)
//{
// query.Contact = Contact;
//}
if (!string.IsNullOrEmpty(RequestProjectName))
{
query.ProjectName = RequestProjectName.Trim();
}
//if (!string.IsNullOrEmpty(ReqeustCCProjectName))
//{
// query.ReqeustCCProjectName = ReqeustCCProjectName;
//}
//DataTable dt = BLL.ProjectTask_ReturnVisit.Instance.GetReturnVisitReCordListExport(query, "ReturnVisit.createtime desc", 1, 1000000, out count);
DataTable dt = BLL.ProjectTask_ReturnVisit.Instance.GetReturnVisitReCordListExport(query);
return(dt);
}
