示例#1
0
        /// <summary>
        /// 綁定GirdView
        /// </summary>
        /// <param name="pageIndex"></param>
        private void BindGridView(int pageIndex)
        {
            Js.BLL.Sys.SysLabelNoDb dal = new Js.BLL.Sys.SysLabelNoDb();

            int RecordCount, PageCount;

            dtData = dal.SelectTable(FormID, pageIndex, strWhere, PageSize, "", out PageCount, out RecordCount).Tables[0];
            if (CurrentPage == 0)
                CurrentPage = PageCount;
            if (RecordCount != 0)
            {
                this.btnLast.Enabled = true;
                this.btnFirst.Enabled = true;
                this.btnToPage.Enabled = true;

                if (CurrentPage > 1)
                    this.btnPre.Enabled = true;
                else
                    this.btnPre.Enabled = false;

                if (CurrentPage < PageCount)
                    this.btnNext.Enabled = true;
                else
                    this.btnNext.Enabled = false;

                lblCurrentPage.Visible = true;
                lblCurrentPage.Text = "共 [" + RecordCount.ToString() + "] 筆記錄  第 [" + CurrentPage.ToString() + "] 頁  共 [" + PageCount.ToString() + "] 頁";
            }
            else
            {
                this.btnFirst.Enabled = false;
                this.btnPre.Enabled = false;
                this.btnNext.Enabled = false;
                this.btnLast.Enabled = false;
                this.btnToPage.Enabled = false;
                lblCurrentPage.Visible = false;
            }
            this.dataGridView1.DataSource = dtData.DefaultView;
        }
示例#2
0
 /// <summary>
 /// 綁定查詢
 /// </summary>
 private void dataSearch()
 {
     Js.BLL.Sys.SysLabelNoDb dal = new Js.BLL.Sys.SysLabelNoDb();
     DataTable dt = dal.SearchTable(FormID, false).Tables[0];
     this.cmbField.DataSource = dt;
     this.cmbField.DisplayMember = "FieldCName";
     this.cmbField.ValueMember = "FieldName";
 }