예제 #1
0
        private void ChackDate()
        {
            string where          = this.GetWhere();
            this.btnQuery.Enabled = false;
            if (string.IsNullOrEmpty(where))
            {
                MessageBox.Show("请选择查询条件!", "查询条件", MessageBoxButtons.OK, MessageBoxIcon.Hand);
                this.btnQuery.Enabled = true;
            }
            else
            {
                RecordsBaseInfoBLL archive_baseinfo = new RecordsBaseInfoBLL();
                this.totalCount = archive_baseinfo.GetRecordCount(where);
                this.totalPages = (this.totalCount <= this.pageCount) ? 1 : ((this.totalCount / this.pageCount) +
                                                                             (((this.totalCount % this.pageCount) > 0) ? 1 : 0));
                this.lbTotalCount.Text = string.Format("共计{0}条", this.totalCount.ToString());
                if (this.currentPage > totalPages - 1)
                {
                    this.currentPage--;
                }

                DataSet ds = archive_baseinfo.GetListByPage(where, "", this.currentPage * this.pageCount, this.pageCount);
                this.lbPages.Text = string.Format("{0}/{1}页", this.currentPage + 1, this.totalPages);
                if (ds.Tables.Count > 0)
                {
                    this.TransDs(ds);
                    this.bds.DataSource     = ds.Tables[0];
                    this.dgvData.DataSource = this.bds;
                }
                this.groupBox1.Enabled = false;
                this.btnQuery.Enabled  = true;
                this.btnQuery.Text     = "重置条件";
            }
        }
 private void btnQuery_Click(object sender, EventArgs e)
 {
     if (this.btnQuery.Text == "重置条件")
     {
         this.groupBox1.Enabled = true;
         this.btnQuery.Text     = "查询";
         txtIdNum.Text          = "";
         tbAddr.Text            = "";
         dtpSt.Text             = "";
         dtpEd.Text             = "";
         dtpCreatedDateSt.Text  = "";
         dtpCreatedDateEd.Text  = "";
     }
     else if (this.ckCheckDate.Checked && (this.dtpSt.Value.Date > this.dtpEd.Value.Date))
     {
         MessageBox.Show(" 体检日期:开始日期大于结束日期!", "日期错误", MessageBoxButtons.OK, MessageBoxIcon.Hand);
     }
     else if (this.ckxCreatedDate.Checked && (this.dtpCreatedDateSt.Value.Date > this.dtpCreatedDateEd.Value.Date))
     {
         MessageBox.Show(" 建档日期:开始日期大于结束日期!", "日期错误", MessageBoxButtons.OK, MessageBoxIcon.Hand);
     }
     else
     {
         this.btnQuery.Enabled = false;
         string where          = this.GetWhere();
         if (string.IsNullOrEmpty(where))
         {
             MessageBox.Show("请选择查询条件!", "查询条件", MessageBoxButtons.OK, MessageBoxIcon.Hand);
             this.btnQuery.Enabled = true;
         }
         else
         {
             RecordsBaseInfoBLL archive_baseinfo = new RecordsBaseInfoBLL();
             this.totalCount        = archive_baseinfo.GetRecordCount(where);
             this.totalPages        = (this.totalCount <= this.pageCount) ? 1 : ((this.totalCount / this.pageCount) + (((this.totalCount % this.pageCount) > 0) ? 1 : 0));
             this.currentPage       = 0;
             this.lbTotalCount.Text = string.Format("共计{0}条", this.totalCount.ToString());
             DataSet ds = archive_baseinfo.GetListByPage(where, "B.CheckDate DESC,B.ID ASC", 0, this.pageCount);
             this.lbPages.Text = string.Format("{0}/{1}页", this.currentPage + 1, this.totalPages);
             if (ds.Tables.Count > 0)
             {
                 this.TransDs(ds);
                 this.bds.DataSource     = ds.Tables[0];
                 this.dgvData.DataSource = this.bds;
             }
             else
             {
                 this.dgvData.DataSource = null;
             }
             this.groupBox1.Enabled = false;
             this.btnQuery.Enabled  = true;
             this.btnQuery.Text     = "重置条件";
         }
     }
 }