private void buyBtn_Click(object sender, EventArgs e)
{
if (comboBox1 != null)
{
try
{
HospitalDBEntities dbContext = new HospitalDBEntities();
var q = dbContext.Pills.AsEnumerable().Where(n => n.PillName == comboBox1.Text).Select(n => n);
foreach (var n in q)
{
n.PillName = comboBox1.Text;
n.PillInstore += (int)numericUpDown1.Value;
}
dbContext.SaveChanges();
MessageBox.Show("訂購成功!", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information);
dbContext.Dispose();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
else
{
MessageBox.Show("請選擇購買品項", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void searchBtn_Click(object sender, EventArgs e)
{
HospitalDBEntities dbContext = new HospitalDBEntities();
var q = dbContext.Pills.AsEnumerable().OrderByDescending(n => n.PillName).Select(n => new
{
藥品編號 = n.Id,
藥品名稱 = n.PillName,
藥品單價 = n.PillUnitPrice,
藥品庫存 = n.PillInstore
});
dataGridView1.DataSource = q.ToList();
dbContext.Dispose();
}
private void dateTimePicker1_ValueChanged(object sender, EventArgs e)
{
HospitalDBEntities dbContext = new HospitalDBEntities();
var q = dbContext.Prescriptions.AsEnumerable().Where(n => n.Diagnosi.PatientName == comboBox.Text && n.CreateDate.Date == dateTimePicker1.Value.Date).Select(n => new
{
編號 = n.Id,
藥品編號 = n.PillsID,
藥品名稱 = n.Pill.PillName,
藥品單價 = n.Pill.PillUnitPrice,
藥品數量 = n.Count,
總額 = n.TotalPrice,
案編號 = n.PatientID,
案姓名 = n.Diagnosi.PatientName,
開單日 = n.CreateDate
});
dataGridView.DataSource = q.ToList();
dbContext.Dispose();
}