private void AllPets_Load(object sender, EventArgs e)
{
DateTime dateTime = DateTime.Now.AddDays(-7);
dateTimePicker2.Value = dateTime;
//图标显示控件设定
axTChart1.Legend.DividingLines.Visible = true;
axTChart1.Environment.MouseWheelScroll = false; //取消鼠标滚轮滑动
axTChart1.Scroll.Enable = TeeChart.EChartScroll.pmHorizontal; //水平滚动
axTChart1.Scroll.MouseButton = TeeChart.EMouseButton.mbRight; //右键滚动
axTChart1.Zoom.Enable = true; //开启缩放
try
{
//初始化显示一周内的病人记录
QueryParameter queryParameter = getQueryParameter();
DataTable table = SqlDeal.getPatientsByParameters(queryParameter);
foreach (DataRow row in table.Rows)
{
rows.Add(row["hospitalnumber"].ToString(), row);
}
DataTable dat = table.DefaultView.ToTable(false, new string[] { "hospitalnumber", "name", "sex", "category", "ifchecked" });
renameTable(dat);
dataGridView1.DataSource = dat;
}
catch (Exception e1)
{
}
}
/// <summary>
/// Button删除记录
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnDelete_Click_1(object sender, EventArgs e)
{
if (dataGridView1.Rows.Count <= 0)
{
return;
}
if (dataGridView1.CurrentRow.Index >= 0)
{
if (MessageBox.Show("确定删除？", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning) == DialogResult.OK)
{
string hospitalNumber = dataGridView1.CurrentRow.Cells["住院号"].Value.ToString();
SqlDeal.deleteItem(hospitalNumber);
try
{
rows.Clear();
QueryParameter queryParameter = getQueryParameter();
DataTable table = SqlDeal.getPatientsByParameters(queryParameter);
foreach (DataRow row in table.Rows)
{
rows.Add(row["hospitalnumber"].ToString(), row);
}
DataTable dat = table.DefaultView.ToTable(false, new string[] { "hospitalnumber", "name", "sex", "category", "ifchecked" });
renameTable(dat);
dataGridView1.DataSource = dat;
}
catch (Exception e1)
{
throw e1;
}
}
}
}
/// <summary>
/// 数据库查询
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnCertain_Click(object sender, EventArgs e)
{
QueryParameter queryParameter = getQueryParameter();
if (chcTimeSelect.Checked && dateTimePicker2.Value > dateTimePicker3.Value)
{
MessageBox.Show("起始日期需在结束日期之前", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning);
return;
}
//查询数据库
DataTable table1 = SqlDeal.getPatientsByParameters(queryParameter);
rows.Clear();
foreach (DataRow row in table1.Rows)
{
rows.Add(row["hospitalnumber"].ToString(), row);
}
DataTable dat1 = table1.DefaultView.ToTable(false, new string[] { "hospitalnumber", "name", "sex", "category", "ifchecked" });
renameTable(dat1);
dataGridView1.DataSource = dat1;
}
