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 = "重置条件";
}
}
}