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