//绑定数据列表 private void BindList() { Entities.QueryUserActionLog query = new Entities.QueryUserActionLog(); if (RequestStartTime != "") { query.StartTime = StringHelper.SqlFilter(RequestStartTime); } if (RequestEndTime != "") { query.EndTime = StringHelper.SqlFilter(RequestEndTime); } if (RequestUserName != "") { query.TrueName = StringHelper.SqlFilter(RequestUserName); } if (RequestLoginInfo != "") { query.Loginfo = StringHelper.SqlFilter(RequestLoginInfo); } DataTable dt = BLL.UserActionLog.Instance.GetUserActionLog(query, " CreateTime desc", BLL.PageCommon.Instance.PageIndex, PageSize, out RecordCount); repeaterTableList.DataSource = dt; repeaterTableList.DataBind(); AjaxPager_Custs.PageSize = 20; AjaxPager_Custs.InitPager(RecordCount); }
private void CustBaseInfoDataBind() { QueryCustBasicInfo query = new QueryCustBasicInfo(); query.CustName = RequestCustName; query.Sexs = RequestSexs; query.CustTel = RequestCustTel; query.ProvinceID = CommonFunction.ObjectToInteger(RequestProvinceID, -1); query.CityID = CommonFunction.ObjectToInteger(RequestCityID, -1); query.CountyID = CommonFunction.ObjectToInteger(RequestCountyID, -1); repeaterTableList.DataSource = BLL.CustBasicInfo.Instance.GetCustBasicInfo(query, "cb.CreateTime Desc", BLL.PageCommon.Instance.PageIndex, pageSize, out RecordCount); repeaterTableList.DataBind(); AjaxPager_Custs.PageSize = 20; AjaxPager_Custs.InitPager(RecordCount); }
private void BindData(string custID) { DataTable dt = null; int count = 0; if (RequestAction.ToLower().Equals("viewcrmreturnvisit"))//查看CRM系统中所有回访记录 { BitAuto.YanFa.Crm2009.Entities.QueryReturnVisit QueryReturnVisit = new BitAuto.YanFa.Crm2009.Entities.QueryReturnVisit(); QueryReturnVisit.CustID = custID; dt = BitAuto.YanFa.Crm2009.BLL.ReturnVisit.Instance.GetReturnVisit(QueryReturnVisit, PageCommon.Instance.PageIndex, PageSize, out count); } else { Entities.QueryCallRecordInfo query = new Entities.QueryCallRecordInfo(); query.CustID = custID; dt = BLL.CallRecordInfo.Instance.GetCC_CallRecordsByRV(query, PageCommon.Instance.PageIndex, PageSize, out count); } repeaterList.DataSource = dt; repeaterList.DataBind(); AjaxPager_Custs.InitPager(count, "divReturnVisitRecordListPopup", PageSize); }
private void BindData() { Entities.ExamScoreManageQuery query = new Entities.ExamScoreManageQuery(); #region 条件 DateTime dateVal = new DateTime(); if (PaperName != string.Empty) { query.PaperName = PaperName; } if (ExamProjectName != string.Empty) { query.ProjectName = ExamProjectName; } if (ExamPerson != string.Empty) { query.TrueName = ExamPerson; } if (Catage != string.Empty) { query.ExamCategory = Catage; } if (BeginTime != string.Empty && DateTime.TryParse(BeginTime, out dateVal)) { query.BeginTime = dateVal; } if (EndTime != string.Empty && DateTime.TryParse(EndTime, out dateVal)) { query.EndTime = dateVal; } if (CommonFunction.ObjectToInteger(Bgid) > 0) { query.BGIDS = Bgid; } #endregion DataTable dt = BLL.ExamOnline.Instance.GetExamScoreManage(query, " BeginTime Desc", BLL.PageCommon.Instance.PageIndex, PageSize, out RecordCount); if (dt != null && dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i]["isMarking"].ToString() == "0") { dt.Rows[i]["zhuguan"] = ""; } else { if (dt.Rows[i]["zhuguan"] == DBNull.Value) { dt.Rows[i]["zhuguan"] = "0"; } } if (BLL.ExamBigQuestion.Instance.HaveAskCategoryByEPID(dt.Rows[i]["epid"].ToString(), 1) == false) { dt.Rows[i]["Onlyselect"] = "-"; } else { if (dt.Rows[i]["Onlyselect"] == DBNull.Value) { dt.Rows[i]["Onlyselect"] = "0"; } } if (BLL.ExamBigQuestion.Instance.HaveAskCategoryByEPID(dt.Rows[i]["epid"].ToString(), 2) == false) { dt.Rows[i]["moreselect"] = "-"; } else { if (dt.Rows[i]["moreselect"] == DBNull.Value) { dt.Rows[i]["moreselect"] = "0"; } } if (BLL.ExamBigQuestion.Instance.HaveAskCategoryByEPID(dt.Rows[i]["epid"].ToString(), 4) == false) { dt.Rows[i]["panduan"] = "-"; } else { if (dt.Rows[i]["panduan"] == DBNull.Value) { dt.Rows[i]["panduan"] = "0"; } } if (BLL.ExamBigQuestion.Instance.HaveAskCategoryByEPID(dt.Rows[i]["epid"].ToString(), 3) == false) { dt.Rows[i]["zhuguan"] = "-"; } } repeaterTableList.DataSource = dt; repeaterTableList.DataBind(); } AjaxPager_Custs.PageSize = PageSize; AjaxPager_Custs.InitPager(RecordCount); }
private void BindData() { Entities.QueryExamPaper query = new Entities.QueryExamPaper(); #region 条件 int intVal = 0; DateTime dateVal = new DateTime(); if (PaperName != string.Empty) { query.Name = PaperName; } if (Catage != string.Empty && int.TryParse(Catage, out intVal)) { query.ECID = intVal; } if (Catage != string.Empty && Catage != "-1") { query.ECID = int.Parse(Catage); } if (ECIDStr != string.Empty) { query.ECIDStr = ECIDStr; } if (BeginTime != string.Empty && DateTime.TryParse(BeginTime, out dateVal)) { query.CreateBeginTime = dateVal; } if (EndTime != string.Empty && DateTime.TryParse(EndTime, out dateVal)) { query.CreateEndTime = dateVal; } if (State != string.Empty) { query.Status = State; } if (BGID != string.Empty) { int _bgid = 0; if (int.TryParse(BGID, out _bgid)) { query.BGID = _bgid; } } if (CreateUser != string.Empty && CreateUser != "-1") { query.CreaetUserID = CreateUser; } #endregion DataTable dt = BLL.ExamPaper.Instance.GetExamPaper(query, "CreateTime DESC", BLL.PageCommon.Instance.PageIndex, PageSize, out RecordCount); if (dt != null && dt.Rows.Count > 0) { repeaterTableList.DataSource = dt; repeaterTableList.DataBind(); AjaxPager_Custs.PageSize = PageSize; AjaxPager_Custs.InitPager(RecordCount); } }