Esempio n. 1
0
 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);
        }
Esempio n. 3
0
        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);
        }