//绑定数据列表
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);
}
}
