protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { Entities.QueryKLQuestion query = new Entities.QueryKLQuestion(); query.KLID = 51; int totalCount = 0; DataTable dt = BLL.KLQuestion.Instance.GetKLQuestion(query, "", 1, 1000, out totalCount); rptQuestion.DataSource = dt; rptQuestion.DataBind(); } }
public void BindData() { Entities.QueryKLQuestion query = new Entities.QueryKLQuestion(); if (RequestTitle != "") { query.Title = RequestTitle; } if (RequestKCID != "") { query.KCID = int.Parse(RequestKCID); } if (RequestProperty != "") { query.Property = RequestProperty; } if (RequestStatus != "") { query.LibStatus = int.Parse(RequestStatus); } if (RequestCreateUserID != "") { query.LibCreateUserID = int.Parse(RequestCreateUserID); } if (query.BeginTime != "") { query.BeginTime = query.BeginTime; } if (query.EndTime != "") { query.EndTime = query.EndTime; } if (RequestCategory != "") { query.Category = RequestCategory; } DataTable dt = BLL.KLQuestion.Instance.GetKLQuestion(query, "KLQuestion.CreateTime DESC", 1, PageSize, out RecordCount); repeaterTableList.DataSource = dt; repeaterTableList.DataBind(); litPagerDown.Text = BLL.PageCommon.Instance.LinkStringByPost(BLL.Util.GetUrl(), GroupLength, RecordCount, PageSize, BLL.PageCommon.Instance.PageIndex, 1); }
public void BindData() { Entities.QueryKLQuestion query = new Entities.QueryKLQuestion(); //if (!right_Approval && !right_Reject && !right_Disable) //如果不具备 审核通过、驳回、停用的权限 则只能查看到自己提交的信息 //{ // query.CreateUserID = userID; //} if (RequestTitle != "") { query.Ask = RequestTitle; } if (RequestKCID != "") { query.KCID = int.Parse(RequestKCID); } //if (RequestProperty != "") //{ // query.Property = RequestProperty; //} if (RequestStatus != "") { query.StatusS = RequestStatus; } if (RequestCreateUserID != "") { query.CreateUserID = int.Parse(RequestCreateUserID); } if (RequestBeginTime != "") { query.BeginTime = RequestBeginTime; } if (RequestEndTime != "") { query.EndTime = RequestEndTime; } if (RequestMBeginTime != "") { query.MBeginTime = RequestMBeginTime; } if (RequestMEndTime != "") { query.MEndTime = RequestMEndTime; } if (RequestModifyUserID != "") { query.ModifyUserID = Convert.ToInt32(RequestModifyUserID); } if (RequestCategory != "") { query.AskCategorys = RequestCategory; } if (RequestQuestionStatus != "") { query.QuestionStatusS = RequestQuestionStatus; } string wherePlug = BLL.UserGroupDataRigth.Instance.GetSqlRightstr("a", "BGID", "CreateUserID", BLL.Util.GetLoginUserID()); DataTable dt = BLL.KLQuestion.Instance.GetKLQuestionManage(query, "a.CreateTime DESC", BLL.PageCommon.Instance.PageIndex, PageSize, wherePlug, out RecordCount); repeaterTableList.DataSource = dt; repeaterTableList.DataBind(); litPagerDown.Text = BLL.PageCommon.Instance.LinkStringByPost(BLL.Util.GetUrl(), GroupLength, RecordCount, PageSize, BLL.PageCommon.Instance.PageIndex, 1); }