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 saveButton_Click(object sender, EventArgs e)
{
HospitalDBEntities dbContext = new HospitalDBEntities();
try
{
for (int i = 0; i < dataGridView.Rows.Count; i++)
{
dbContext.Prescriptions.Add(new Prescription
{
EmployeeID = LoginForm.UserId,
PatientID = dbContext.Diagnosis1.AsEnumerable().Where(n => n.PatientName == dataGridView.Rows[i].Cells[1].Value.ToString()).Select(n => n.PatientId).First(),
PillsID = dbContext.Pills.AsEnumerable().Where(n => n.PillName == dataGridView.Rows[i].Cells[2].Value.ToString()).Select(n => n.Id).First(),
Count = Int32.Parse(dataGridView.Rows[i].Cells[3].Value.ToString()),
TotalPrice = (decimal)dataGridView.Rows[0].Cells[3].Value * dbContext.Pills.AsEnumerable().Where(n => n.PillName == dataGridView.Rows[i].Cells[2].Value.ToString()).Select(n => n.PillUnitPrice).First(),
CreateDate = DateTime.Now
});
dbContext.SaveChanges();
}
dataGridView.Rows.Clear();
MessageBox.Show("儲存成功!", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void ReLoad()
{
this.flowLayoutPanel.Controls.Clear();
HospitalDBEntities dbContext = new HospitalDBEntities();
var q = dbContext.Messageboards.OrderByDescending(n => n.Date).Select(n => n).ToList();
foreach (var n in q)
{
MessageControl messageControl = new MessageControl();
if (n.Name != LoginForm.UserName)
{
messageControl.button1.Enabled = false;
messageControl.button1.Visible = false;
}
messageControl.label1.Text = n.Id.ToString();
messageControl.linkLabel.Text = $"{n.Name}說：{n.Title}";
flowLayoutPanel.Controls.Add(messageControl);
messageControl.Width = this.flowLayoutPanel.Width - 10;
richTextBox.Text = n.Content;
label2.Text = $"【{n.Name.ToString()}】留言：";
messageControl.linkLabel.Click += delegate(object sender1, EventArgs e1)
{
richTextBox.Text = n.Content;
label2.Text = $"【{n.Name.ToString()}】留言：";
};
messageControl.button1.Click += delegate(object sender1, EventArgs e1)
{
MessageEdit messageEdit = new MessageEdit();
PostID = int.Parse(messageControl.label1.Text);
messageEdit.ShowDialog();
};
}
}
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 FundationForm_Load(object sender, EventArgs e)
{
HospitalDBEntities dbContext = new HospitalDBEntities();
var q = dbContext.Prescriptions.AsEnumerable().OrderByDescending(n => n.Diagnosi.PatientName).Select(n => n.Diagnosi.PatientName);
foreach (var n in q.Distinct())
{
comboBox.Items.Add(n);
}
var q1 = dbContext.Pills.AsEnumerable().OrderByDescending(n => n.PillName).Select(n => n.PillName);
foreach (var n in q1.Distinct())
{
comboBox1.Items.Add(n);
}
}
private void PillsForm_Load(object sender, EventArgs e)
{
HospitalDBEntities dbContext = new HospitalDBEntities();
var q = dbContext.Pills.OrderBy(n => n.PillName).Select(n => n.PillName);
var q1 = dbContext.Diagnosis1.OrderBy(n => n.PatientName).Select(n => n.PatientName);
foreach (var n in q)
{
comboBox.Items.Add(n);
}
foreach (var n in q1)
{
comboBox1.Items.Add(n);
}
comboBox.SelectedIndex = 0;
label2.Text = LoginForm.UserName;
}
private void comboBox_SelectedIndexChanged(object sender, EventArgs e)
{
HospitalDBEntities dbContext = new HospitalDBEntities();
var q = dbContext.Prescriptions.AsEnumerable().Where(n => n.Diagnosi.PatientName == comboBox.Text).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();
}
private void addButton_Click(object sender, EventArgs e)
{
HospitalDBEntities dbContext = new HospitalDBEntities();
var q = dbContext.Pills.Where(n => n.PillName == comboBox.Text).Select(n => n).First();
if (comboBox1.Text != "")
{
if (numericUpDown.Value < q.PillInstore)
{
dataGridView.Rows.Add("刪除", comboBox1.Text, comboBox.Text, numericUpDown.Value);
MessageBox.Show("新增成功", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("數量不足", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
else
{
MessageBox.Show("請選擇個案", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void confirmButton_Click(object sender, EventArgs e)
{
try
{
HospitalDBEntities dbContext = new HospitalDBEntities();
dbContext.Issues.Add(new Issue
{
Title = titleTextBox.Text,
Content = contentRichTextBox.Text,
Date = monthCalendar.SelectionStart,
EmployeeID = LoginForm.UserId
});
dbContext.SaveChanges();
MessageBox.Show("新增成功!", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information);
titleTextBox.Enabled = contentRichTextBox.Enabled = confirmButton.Enabled = monthCalendar.Enabled = false;
}catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
