Beispiel #1
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.ckBirthday.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();
                RecordsBaseInfoBLL archive_baseinfo = new RecordsBaseInfoBLL();
                DataSet            ds = archive_baseinfo.GetNoVistRecordCount(where, "", "");
                if (ds.Tables.Count > 0)
                {
                    dtTmp = ds.Tables[0];
                }
                this.totalCount        = dtTmp.Rows.Count;
                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());

                this.lbPages.Text = string.Format("{0}/{1}页", this.currentPage + 1, this.totalPages);

                if (ds.Tables.Count > 0)
                {
                    DataTable dtTemp = dtTmp.Clone();
                    int       nextV  = (this.currentPage + 1) * this.pageCount;

                    if (nextV > this.totalCount)
                    {
                        nextV = this.totalCount;
                    }

                    for (int i = (this.currentPage) * this.pageCount; i < nextV; i++)
                    {
                        dtTemp.ImportRow(dtTmp.Rows[i]);
                    }

                    this.bds.DataSource     = dtTemp;
                    this.dgvData.DataSource = this.bds;
                }

                this.groupBox1.Enabled = false;
                this.btnQuery.Text     = "重置条件";

                lblOldManCount.Text = archive_baseinfo.GetOLDNoVisitCount(where, "") + " 人";
                lblHypCount.Text    = archive_baseinfo.GetHyperNoVisitCount(where, "") + " 人";
                lblDiaCount.Text    = archive_baseinfo.GetDiaNoVisitCount(where, "") + " 人";
                lblPsyCount.Text    = archive_baseinfo.GetMentalNoVisitCount(where, "") + " 人";
                lblTbCount.Text     = archive_baseinfo.GetLungerNoVisitCount(where, "") + " 人";
                lblNczCount.Text    = archive_baseinfo.GetStrokeNoVisitCount(where, "") + " 人";
                lblHeaCount.Text    = archive_baseinfo.GetChdNoVisitCount(where, "") + " 人";
            }
        }