Exemplo n.º 1
0
 private void GetDataView()
 {
     string where = this.GetWhere();
     if (string.IsNullOrEmpty(where))
     {
         MessageBox.Show("请选择查询条件!", "查询条件", MessageBoxButtons.OK, MessageBoxIcon.Hand);
     }
     else
     {
         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, this.strorderby, 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;
         }
         this.groupBox1.Enabled = false;
         this.btnQuery.Text     = "重置条件";
     }
 }
Exemplo n.º 2
0
 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
     {
         string where = this.GetWhere();
         if (string.IsNullOrEmpty(where))
         {
             MessageBox.Show("请选择查询条件!", "查询条件", MessageBoxButtons.OK, MessageBoxIcon.Hand);
         }
         else
         {
             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, "", 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;
             }
             this.groupBox1.Enabled = false;
             this.btnQuery.Text     = "重置条件";
         }
     }
 }