private void btnUpdate_Click(object sender, EventArgs e)
{
if (txtDname.Text == "")
{
MessageBox.Show("请选择需要修改的数据 !");
return;
}
Drug_insert Dupdate = new Drug_insert();
Dupdate.Dname = txtDname.Text;
Dupdate.Dtype = cboDtype.Text;
Dupdate.DcostName = cboDcostName.Text;
Dupdate.Dspec = cboDspec.Text;
Dupdate.DjiXing = cboDjiXing.Text;
Dupdate.DinsertPrice = int.Parse(txtDinsertPrice.Text);
Dupdate.DsellPrice = int.Parse(txtDsellPrice.Text);
Dupdate.Dstock = int.Parse(txtDstock.Text);
Dupdate.DstockMax = int.Parse(txtDstockMax.Text);
Dupdate.DstockMin = int.Parse(txtDstockMin.Text);
Dupdate.DeffectTime = dtpDproductTime.Text;
Dupdate.DproductTime = dtpDeffectTime.Text;
Dupdate.Efficay = txtEfficay.Text;
string mes = new Drug_insert_BLL().Update(Dupdate);
txtDname.Text = "";
btnSelect_Click(null, null);
MessageBox.Show(mes);
}
private void btnSelect_Click(object sender, EventArgs e)
{
if (txtDname.Text == "")
{
PromptingForm p = new PromptingForm("请输入药品名字！");
p.ShowDialog();
return;
}
lvwShow.Items.Clear();
List <Drug_insert> di = new Drug_insert_BLL().SelectAll(txtDname.Text);
if (di.Count == 0)
{
PromptingForm p = new PromptingForm("没有你要查找的数据！");
p.ShowDialog();
return;
}
for (int i = 0; i < di.Count; i++)
{
ListViewItem item = new ListViewItem(di[i].Dname + "");
item.SubItems.Add(di[i].Dtype + "");
item.SubItems.Add(di[i].DcostName + "");
item.SubItems.Add(di[i].Dspec + "");
item.SubItems.Add(di[i].DjiXing + "");
item.SubItems.Add(di[i].DinsertPrice + "");
item.SubItems.Add(di[i].DsellPrice + "");
item.SubItems.Add(di[i].Dstock + "");
item.SubItems.Add(di[i].DstockMax + "");
item.SubItems.Add(di[i].DstockMin + "");
item.SubItems.Add(di[i].DeffectTime + "");
item.SubItems.Add(di[i].DproductTime + "");
item.SubItems.Add(di[i].Efficay + "");
lvwShow.Items.Add(item);
}
}
private void Init_Load()
{
try
{
lvwShow.Items.Clear();
List <Drug_insert> di = new Drug_insert_BLL().SelectAll(txtDname.Text);
for (int i = 0; i < di.Count; i++)
{
lvwShow.Items.Add(new
{
drugname = di[i].Dname,
type = di[i].Dtype,
fare = di[i].DcostName,
dosetype = di[i].Dspec,
spec = di[i].DjiXing,
in_price = di[i].DinsertPrice,
sell_price = di[i].DsellPrice,
stock = di[i].Dstock,
stockMax = di[i].DstockMax,
stockMin = di[i].DstockMin,
proDate = di[i].DeffectTime,
effDate = di[i].DproductTime,
effect = di[i].Efficay
});
}
}
catch { }
}
private void button2_Click(object sender, EventArgs e)
{
if (txtDname.Text == "")
{
PromptingForm p = new PromptingForm("请选择需要修改的数据 !");
p.ShowDialog();
return;
}
Drug_insert Dupdate = new Drug_insert();
Dupdate.Dname = txtDname.Text;
Dupdate.Dtype = cboDtype.Text;
Dupdate.DcostName = cboDcostName.Text;
Dupdate.Dspec = cboDspec.Text;
Dupdate.DjiXing = cboDjiXing.Text;
Dupdate.DinsertPrice = int.Parse(txtDinsertPrice.Text);
Dupdate.DsellPrice = int.Parse(txtDsellPrice.Text);
Dupdate.Dstock = int.Parse(txtDstock.Text);
Dupdate.DstockMax = int.Parse(txtDstockMax.Text);
Dupdate.DstockMin = int.Parse(txtDstockMin.Text);
Dupdate.DeffectTime = dtpDproductTime.Text;
Dupdate.DproductTime = dtpDeffectTime.Text;
Dupdate.Efficay = txtEfficay.Text;
string mes = new Drug_insert_BLL().Update(Dupdate);
button3_Click(null, null);
PromptingForm pp = new PromptingForm(mes);
pp.ShowDialog();
}
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
lvwShow.Items.Clear();
List <Drug_insert> di = new Drug_insert_BLL().SelectAll(txtDname.Text);
for (int i = (int.Parse(comboBox1.Text) - 1) * 20; i < 20 * int.Parse(comboBox1.Text); i++)
{
if (i < di.Count)
{
ListViewItem item = new ListViewItem(di[i].Dname + "");
item.SubItems.Add(di[i].Dtype + "");
item.SubItems.Add(di[i].DcostName + "");
item.SubItems.Add(di[i].Dspec + "");
item.SubItems.Add(di[i].DjiXing + "");
item.SubItems.Add(di[i].DinsertPrice + "");
item.SubItems.Add(di[i].DsellPrice + "");
item.SubItems.Add(di[i].Dstock + "");
item.SubItems.Add(di[i].DstockMax + "");
item.SubItems.Add(di[i].DstockMin + "");
item.SubItems.Add(di[i].DeffectTime + "");
item.SubItems.Add(di[i].DproductTime + "");
item.SubItems.Add(di[i].Efficay + "");
lvwShow.Items.Add(item);
}
}
}
private void button1_Click(object sender, EventArgs e)
{
List <zhuyuan> zhu = new IdCard_BLL().p_zhuyuan_Select();
List <SectionRoom> se = new UsersBLL().Section();
txtID2.Text = "";
txtmingzi2.Text = "";
txtyujiao2.Text = "";
foreach (Control item in groupBox4.Controls)
{
if (item is TextBox)
{
item.Text = "";
}
}
foreach (Control item in groupBox3.Controls)
{
item.Enabled = false;
}
try
{
if (textBox1.Text == "")
{
PromptingForm p = new PromptingForm("请输入卡号!");
p.ShowDialog();
return;
}
if (zhu.Where(p => p.kId == int.Parse(textBox1.Text)).Count() == 0)
{
PromptingForm p = new PromptingForm("没有数据!");
p.ShowDialog();
return;
}
foreach (var z in zhu.Where(p => p.kId == int.Parse(textBox1.Text)))
{
txtId.Text = z.kId + "";
txtmingzi.Text = z.Kname;
txtkeshi.Text = (se[z.Sid].Sname);
txttime.Text = (z.Ztime + "");
txtyujiao.Text = (z.Imprest + "");
}
List <zhuyuanxiaofei> xfs = new IdCard_BLL().p_zhuyuanxiaofei_select(int.Parse(txtId.Text));
int i = 0;
foreach (zhuyuanxiaofei xf in xfs)
{
List <Drug_insert> di = new Drug_insert_BLL().SelectAll(xf.yaoName);
i = i + int.Parse(xf.yaonum + "") * int.Parse(di[0].DsellPrice + "");
}
txtyiyong.Text = i + "";
txtshengyu.Text = int.Parse(txtyujiao.Text) - int.Parse(txtyiyong.Text) + "";
}
catch
{
PromptingForm p = new PromptingForm("病人编号只能是数字!");
p.ShowDialog();
}
}
private void lvwzhuyuan_SelectedIndexChanged(object sender, EventArgs e)
{
int date = 0;
lvwselect.Items.Clear();
if (lvwzhuyuan.SelectedItems.Count > 0)
{
ListViewItem item = lvwzhuyuan.SelectedItems[0];
txtId.Text = item.SubItems[0].Text;
textBox4.Text = item.SubItems[3].Text;
textBox4.Tag = item.SubItems[4].Text;
txtkeshi.Text = item.SubItems[2].Text;
dTime.Value = DateTime.Parse(item.SubItems[8].Text);
//
date = int.Parse((dateTimePicker1.Value - dTime.Value + "").Substring(0, 1));
txtmingzi.Text = item.SubItems[1].Text;
txtyujiao.Text = item.SubItems[5].Text;
}
List <sickroom> ssic = new IdCard_BLL().sickroom_select();
foreach (sickroom item in ssic.Where(p => p.Idsickroom == int.Parse(textBox4.Text)))
{
txtyiyong.Text = item.Price * (date + 1) + "";
}
List <zhuyuanxiaofei> xfs = new IdCard_BLL().p_zhuyuanxiaofei_select(int.Parse(txtId.Text));
foreach (zhuyuanxiaofei xf in xfs)
{
List <Drug_insert> di = new Drug_insert_BLL().SelectAll(xf.yaoName);
int i = 0;
ListViewItem item = new ListViewItem(di[i].Dname + "");
item.SubItems.Add(di[i].Dtype + "");
item.SubItems.Add(di[i].DcostName + "");
item.SubItems.Add(xf.yaonum + "");
item.SubItems.Add(di[i].Dspec + "");
item.SubItems.Add(di[i].DjiXing + "");
item.SubItems.Add(di[i].DsellPrice + "");
item.SubItems.Add(di[i].DeffectTime + "");
item.SubItems.Add(di[i].DproductTime + "");
item.SubItems.Add(di[i].Efficay + "");
lvwselect.Items.Add(item);
i++;
}
int num = 0;
foreach (ListViewItem item in lvwselect.Items)
{
num += int.Parse(item.SubItems[6].Text);
}
textBox3.Text = num + "";
textBox2.Text = int.Parse(txtyiyong.Text) + int.Parse(textBox3.Text) - int.Parse(txtyujiao.Text) + "";
}
private void btnInsert_Click(object sender, EventArgs e)
{
foreach (Control item in groupBox1.Controls)
{
if (item is TextBox)
{
if (item.Text == "")
{
PromptingForm p = new PromptingForm("请把信息填写完整 !");
p.ShowDialog();
return;
}
}
if (item is ComboBox)
{
if (item.Text == "")
{
PromptingForm p = new PromptingForm("请把信息填写完整 !");
p.ShowDialog();
return;
}
}
}
Drug_insert Dinsert = new Drug_insert();
Dinsert.Dname = txtDname.Text;
Dinsert.Dtype = cboDtype.Text;
Dinsert.DcostName = cboDcostName.Text;
Dinsert.Dspec = cboDspec.Text;
Dinsert.DjiXing = cboDjiXing.Text;
Dinsert.DinsertPrice = int.Parse(txtDinsertPrice.Text);
Dinsert.DsellPrice = int.Parse(txtDsellPrice.Text);
Dinsert.Dstock = int.Parse(txtDstock.Text);
Dinsert.DstockMax = int.Parse(txtDstockMax.Text);
Dinsert.DstockMin = int.Parse(txtDstockMin.Text);
Dinsert.DeffectTime = dtpDproductTime.Text;
Dinsert.DproductTime = dtpDeffectTime.Text;
Dinsert.Efficay = txtEfficay.Text;
string mes = new Drug_insert_BLL().Insert(Dinsert);
txtDname.Text = "";
btnSelect_Click(null, null);
PromptingForm pp = new PromptingForm(mes);
pp.ShowDialog();
}
private void Drug_Delete_UI_Load(object sender, EventArgs e)
{
try
{
lvwShow.Items.Clear();
List <Drug_insert> di = new Drug_insert_BLL().SelectAll(txtDname.Text);
int m = (int)Math.Ceiling(di.Count / 20.0);
for (int i = 1; i <= m; i++)
{
comboBox1.Items.Add(i + "");
}
if (comboBox1.Text == "")
{
comboBox1.Text = "1";
return;
}
}
catch { }
}
private void txtyaoping_TextChanged(object sender, EventArgs e)
{
lvwxin.Items.Clear();
List <Drug_insert> di = new Drug_insert_BLL().SelectAll(txtyaoping.Text);
for (int i = 0; i < di.Count; i++)
{
ListViewItem item = new ListViewItem(di[i].Dname + "");
item.SubItems.Add(di[i].Dtype + "");
item.SubItems.Add(di[i].DcostName + "");
item.SubItems.Add(di[i].Dspec + "");
item.SubItems.Add(di[i].DjiXing + "");
item.SubItems.Add(di[i].DsellPrice + "");
item.SubItems.Add(di[i].DeffectTime + "");
item.SubItems.Add(di[i].DproductTime + "");
item.SubItems.Add(di[i].Efficay + "");
lvwxin.Items.Add(item);
}
}
private void listView1_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
if (listView1.SelectedItems.Count > 0)
{
string str = listView1.Items[listView1.SelectedIndex].ToString();
string[] ss = str.Split(',');
string tmp = ss[0].Substring(4).Replace("=", "").Trim();
string s = "";
foreach (var item in maidan.Where(p => p.Rid == tmp))
{
txtdoct.Text = item.Doctor;
txtidno.Text = item.IdcardNo;
txtname.Text = item.Name;
txtRid.Text = item.Rid;
cboroom.Text = item.SectionRoom;
cbosex.Text = item.Sex;
s = item.yaopinName;
break;
}
string[] arr = s.Split('-');
listView2.Items.Clear();
int num = 0;
foreach (string ite in arr)
{
if (ite != "")
{
List <Drug_insert> di = new Drug_insert_BLL().SelectAll(ite);
for (int i = 0; i < di.Count; i++)
{
listView2.Items.Add(new
{
c1 = di[i].Dname,
c2 = di[i].DsellPrice,
c3 = 1
});
num += int.Parse(di[i].DsellPrice + "") * 1;
}
}
}
textBox4.Text = num + "";
}
}
private void printDocument1_PrintPage(object sender, PrintPageEventArgs e)
{
Graphics g = e.Graphics;
// g.DrawImage(Image.FromFile(Application.StartupPath + "//imag//1234.jpg"), 2, 0, 500, 600);
g.DrawString("挂 单 号：" + txtRid.Text, label5.Font, new SolidBrush(label5.ForeColor), 150, 100);
g.DrawString("姓 名：" + txtname.Text, label5.Font, new SolidBrush(label5.ForeColor), 100, 160);
g.DrawString("药 品", label5.Font, new SolidBrush(label5.ForeColor), 100, 220);
g.DrawString("数 量", label5.Font, new SolidBrush(label5.ForeColor), 250, 220);
string s = "";
foreach (var item in maidan.Where(p => p.Rid == txtRid.Text))
{
s = item.yaopinName;
break;
}
string[] arr = s.Split('-');
int num = 220;
int num2 = 60;
foreach (string ite in arr)
{
if (ite != "")
{
List <Drug_insert> di = new Drug_insert_BLL().SelectAll(ite);
for (int i = 0; i < di.Count;)
{
g.DrawString(di[i].Dname + "", label5.Font, new SolidBrush(label5.ForeColor), 110, num + num2);
g.DrawString("1", label5.Font, new SolidBrush(label5.ForeColor), 250, num + num2);
num = num + num2;
break;
}
}
}
}
private void ListView1_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
listView2.Items.Clear();
if (listView1.SelectedItems.Count > 0)
{
string s = listView1.Items[listView1.SelectedIndex].ToString();
string[] ss = s.Split(',');
txtId.Text = ss[0].Substring(4).Replace("=", "").Trim();
txtkeshi.Text = ss[2].Substring(3).Replace("=", "").Trim();
txttime.Text = ss[8].Substring(4).Replace("=", "").Trim();
txtmingzi.Text = ss[1].Substring(3).Replace("=", "").Trim();
txtyujiao.Text = ss[5].Substring(3).Replace("=", "").Trim();
listView2.Visibility = Visibility.Visible;
txtyaopin.IsEnabled = false;
btninsert.Content = "新单";
num = 0;
txtyaopin.Text = "";
}
List <zhuyuanxiaofei> xfs = new IdCard_BLL().p_zhuyuanxiaofei_select(int.Parse(txtId.Text));
foreach (zhuyuanxiaofei xf in xfs)
{
List <Drug_insert> di = new Drug_insert_BLL().SelectAll(xf.yaoName);
int i = 0;
listView2.Items.Add(new
{
c1 = di[i].Dname,
c2 = di[i].Dtype,
c3 = di[i].DcostName,
c4 = xf.yaonum,
c5 = di[i].Dspec,
c6 = di[i].DjiXing,
c7 = di[i].DsellPrice,
c8 = di[i].DeffectTime,
c9 = di[i].DproductTime,
c10 = di[i].Efficay
});
i++;
}
}
private void Button1_Click(object sender, RoutedEventArgs e)
{
if (txtDname.Text == "")
{
var p = new Tip("请输入药品名字！");
p.ShowDialog();
return;
}
lvwShow.Items.Clear();
List <Drug_insert> di = new Drug_insert_BLL().SelectAll(txtDname.Text);
if (di.Count == 0)
{
var p = new Tip("没有你要查找的数据！");
p.ShowDialog();
return;
}
for (int i = 0; i < di.Count; i++)
{
#region 列表添加项
lvwShow.Items.Add(new
{
c1 = di[i].Dname,
c2 = di[i].Dtype,
c3 = di[i].DcostName,
c4 = di[i].Dspec,
c5 = di[i].DjiXing,
c6 = di[i].DinsertPrice,
c7 = di[i].DsellPrice,
c8 = di[i].Dstock,
c9 = di[i].DstockMax,
c10 = di[i].DstockMin,
c11 = di[i].DeffectTime,
c12 = di[i].DproductTime,
c13 = di[i].Efficay
});
#endregion
}
}
//药品智能搜索输入框改变
private void Txtyaopin_TextChanged(object sender, TextChangedEventArgs e)
{
listView2.Items.Clear();
List <Drug_insert> di = new Drug_insert_BLL().SelectAll(txtyaopin.Text);
for (int i = 0; i < di.Count; i++)
{
//listView2.Items.Add(new
//{
// c1 = di[i].Dname,
// c2 = di[i].Dtype,
// c3 = di[i].DcostName,
// // c4 = xf.yaonum,
// c5 = di[i].Dspec,
// c6 = di[i].DjiXing,
// c7 = di[i].DsellPrice,
// c8 = di[i].DeffectTime,
// c9 = di[i].DproductTime,
// c10 = di[i].Efficay
//});
}
}
private void lvwzhuyuan_SelectedIndexChanged(object sender, EventArgs e)
{
lvwselect.Items.Clear();
if (lvwzhuyuan.SelectedItems.Count > 0)
{
ListViewItem item = lvwzhuyuan.SelectedItems[0];
txtId.Text = item.SubItems[0].Text;
txtkeshi.Text = item.SubItems[2].Text;
txttime.Text = item.SubItems [8].Text;
txtmingzi.Text = item.SubItems [1].Text;
txtyujiao.Text = item.SubItems [5].Text;
lvwselect.Visible = true;
txtyaoping.Enabled = false;
btninsert.Text = "新单";
num = 0;
txtyaoping.Text = "";
}
List <zhuyuanxiaofei> xfs = new IdCard_BLL().p_zhuyuanxiaofei_select(int.Parse(txtId.Text));
foreach (zhuyuanxiaofei xf in xfs)
{
List <Drug_insert> di = new Drug_insert_BLL().SelectAll(xf.yaoName);
int i = 0;
ListViewItem item = new ListViewItem(di[i].Dname + "");
item.SubItems.Add(di[i].Dtype + "");
item.SubItems.Add(di[i].DcostName + "");
item.SubItems.Add(xf.yaonum + "");
item.SubItems.Add(di[i].Dspec + "");
item.SubItems.Add(di[i].DjiXing + "");
item.SubItems.Add(di[i].DsellPrice + "");
item.SubItems.Add(di[i].DeffectTime + "");
item.SubItems.Add(di[i].DproductTime + "");
item.SubItems.Add(di[i].Efficay + "");
lvwselect.Items.Add(item);
i++;
}
}
private void listView1_SelectedIndexChanged(object sender, EventArgs e)
{
if (listView1.SelectedItems.Count > 0)
{
string str = listView1.Items [listView1.SelectedItems [0].Index].Text;
string s = "";
foreach (var item in maidan.Where(p => p.Rid == str))
{
txtdoct.Text = item.Doctor;
txtidno.Text = item.IdcardNo;
txtname.Text = item.Name;
txtRid.Text = item.Rid;
cboroom.Text = item.SectionRoom;
cbosex.Text = item.Sex;
s = item.yaopinName;
break;
}
string [] arr = s.Split('-');
listView2.Items.Clear();
int num = 0;
foreach (string ite in arr)
{
if (ite != "")
{
List <Drug_insert> di = new Drug_insert_BLL().SelectAll(ite);
for (int i = 0; i < di.Count; i++)
{
ListViewItem item = new ListViewItem(di[i].Dname + "");
item.SubItems.Add(di[i].DsellPrice + "");
item.SubItems.Add("1");
listView2.Items.Add(item);
num += int.Parse(di[i].DsellPrice + "") * 1;
}
}
}
textBox4.Text = num + "";
}
}
private void btnSelect_Click(object sender, EventArgs e)
{
lvwShow.Items.Clear();
List <Drug_insert> di = new Drug_insert_BLL().SelectAll(txtDname.Text);
for (int i = 0; i < di.Count; i++)
{
ListViewItem item = new ListViewItem(di[i].Dname + "");
item.SubItems.Add(di[i].Dtype + "");
item.SubItems.Add(di[i].DcostName + "");
item.SubItems.Add(di[i].Dspec + "");
item.SubItems.Add(di[i].DjiXing + "");
item.SubItems.Add(di[i].DinsertPrice + "");
item.SubItems.Add(di[i].DsellPrice + "");
item.SubItems.Add(di[i].Dstock + "");
item.SubItems.Add(di[i].DstockMax + "");
item.SubItems.Add(di[i].DstockMin + "");
item.SubItems.Add(di[i].DeffectTime + "");
item.SubItems.Add(di[i].DproductTime + "");
item.SubItems.Add(di[i].Efficay + "");
lvwShow.Items.Add(item);
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (txtDname.Text == "" && lvwShow.SelectedItems.Count == 0)
{
PromptingForm p = new PromptingForm("请选择需要删除的数据 !");
p.ShowDialog();
return;
}
Drug_insert Ddelete = new Drug_insert();
Ddelete.Dname = txtDname.Text;
DialogResult dr = MessageBox.Show("确定要删除吗？", "系统提示", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (dr == DialogResult.Yes)
{
string mes = new Drug_insert_BLL().Delete(Ddelete);
txtDname.Text = "";
comboBox1_SelectedIndexChanged(null, null);
PromptingForm p = new PromptingForm(mes);
p.ShowDialog();
}
}
//药品查找
private void BtnSearch_Click(object sender, RoutedEventArgs e)
{
if (txtDname.Text == "")
{
var p = new Tip("请输入药品名字！");
p.ShowDialog();
return;
}
lvwShow.Items.Clear();
List <Drug_insert> di = new Drug_insert_BLL().SelectAll(txtDname.Text);
if (di.Count == 0)
{
var p = new Tip("没有你要查找的数据！");
p.ShowDialog();
return;
}
for (int i = 0; i < di.Count; i++)
{
lvwShow.Items.Add(new
{
drugname = di[i].Dname,
type = di[i].Dtype,
fare = di[i].DcostName,
dosetype = di[i].Dspec,
spec = di[i].DjiXing,
in_price = di[i].DinsertPrice,
sell_price = di[i].DsellPrice,
stock = di[i].Dstock,
stockMax = di[i].DstockMax,
stockMin = di[i].DstockMin,
proDate = di[i].DeffectTime,
effDate = di[i].DproductTime,
effect = di[i].Efficay
});
}
}
//药品入库
private void Drug_Insert()
{
#region 控件列表集合
List <Control> con_list = new List <Control>()
{
txtDinsertPrice,
txtDname,
txtDsellPrice,
txtDstock,
txtDstockMax,
txtDstockMin,
txtEfficay,
cboDcostName,
cboDjiXing,
cboDspec,
cboDtype,
dtpDeffectTime,
dtpDproductTime
};
#endregion
foreach (Control item in con_list)
{
if (item is TextBox)
{
if (((TextBox)item).Text == "")
{
Tip p = new Tip("请把信息填写完整 !");
p.ShowDialog();
return;
}
}
if (item is ComboBox)
{
if (((ComboBox)item).Text == "")
{
Tip p = new Tip("请把信息填写完整 !");
p.ShowDialog();
return;
}
}
}
Drug_insert Dinsert = new Drug_insert();
Dinsert.Dname = txtDname.Text;
Dinsert.Dtype = cboDtype.Text;
Dinsert.DcostName = cboDcostName.Text;
Dinsert.Dspec = cboDspec.Text;
Dinsert.DjiXing = cboDjiXing.Text;
Dinsert.DinsertPrice = int.Parse(txtDinsertPrice.Text);
Dinsert.DsellPrice = int.Parse(txtDsellPrice.Text);
Dinsert.Dstock = int.Parse(txtDstock.Text);
Dinsert.DstockMax = int.Parse(txtDstockMax.Text);
Dinsert.DstockMin = int.Parse(txtDstockMin.Text);
Dinsert.DeffectTime = dtpDproductTime.Text;
Dinsert.DproductTime = dtpDeffectTime.Text;
Dinsert.Efficay = txtEfficay.Text;
string mes = new Drug_insert_BLL().Insert(Dinsert);
txtDname.Text = "";
Method();
Tip pp = new Tip(mes);
pp.ShowDialog();
}
private void ListView1_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
int date = 0;
listView2.Items.Clear();
if (listView1.SelectedItems.Count > 0)
{
string s = listView1.Items[listView1.SelectedIndex].ToString();
string[] ss = s.Split(',');
txtId.Text = ss[0].Substring(4).Replace("=", "").Trim();
textBox4.Text = ss[3].Substring(3).Replace("=", "").Trim();
textBox4.Tag = ss[4].Substring(4).Replace("=", "").Replace("}", "").Trim();
txtkeshi.Text = ss[2].Substring(3).Replace("=", "").Trim();
dpTime1.Text = ss[8].Substring(3).Replace("=", "").Replace("}", "").Trim();
txtmingzi.Text = ss[1].Substring(3).Replace("=", "").Trim();
txtyujiao.Text = ss[5].Substring(3).Replace("=", "").Trim();
//计算两个日期间隔的天数
//DateTime st = Convert.ToDateTime(dpTime1.Text);
//DateTime et = Convert.ToDateTime(dpTime2.Text);
//TimeSpan span = et - st;
//date = span.Days;
}
List <Sickroom> ssic = new IdCard_BLL().sickroom_select();
foreach (Sickroom item in ssic.Where(p => p.Idsickroom == int.Parse(textBox4.Text)))
{
txtyiyong.Text = item.Price * (date + 1) + "";
}
List <zhuyuanxiaofei> xfs = new IdCard_BLL().p_zhuyuanxiaofei_select(int.Parse(txtId.Text));
foreach (zhuyuanxiaofei xf in xfs)
{
List <Drug_insert> di = new Drug_insert_BLL().SelectAll(xf.yaoName);
int i = 0;
listView2.Items.Add(new
{
c1 = di[i].Dname,
c2 = di[i].Dtype,
c3 = di[i].DcostName,
c4 = xf.yaonum,
c5 = di[i].Dspec,
c6 = di[i].DjiXing,
c7 = di[i].DsellPrice,
c8 = di[i].DeffectTime,
c9 = di[i].DproductTime,
c10 = di[i].Efficay
});
i++;
}
int num = 0;
foreach (ListViewItem item in listView2.Items)
{
string s = listView2.Items[listView2.SelectedIndex].ToString();
string[] ss = s.Split(',');
num += int.Parse(ss[6].Substring(3).Replace("=", "").Trim());
}
textBox3.Text = num + "";
textBox2.Text = int.Parse(txtyiyong.Text) + int.Parse(textBox3.Text) - int.Parse(txtyujiao.Text) + "";
}
private void Button1_Click(object sender, RoutedEventArgs e)
{
List <zhuyuan> zhu = new IdCard_BLL().p_zhuyuan_Select();
List <SectionRoom> se = new UsersBLL().Section();
txtId2.Text = "";
txtname2.Text = "";
txtyujiao2.Text = "";
List <Control> conList2 = new List <Control>()
{
txtId, txtkeshi, txttime, txtname, txtshengyu, txtyujiao, txtyiyong
};
List <Control> conList3 = new List <Control>()
{
txtname2, txtId2, txtyujiao2
};
foreach (Control item in conList2)
{
if (item is TextBox)
{
((TextBox)item).Text = "";
}
}
foreach (Control item in conList3)
{
item.IsEnabled = false;
}
try
{
if (textBox1.Text == "")
{
var p = new Tip("请输入卡号!");
p.ShowDialog();
return;
}
if (zhu.Where(p => p.kId == int.Parse(textBox1.Text)).Count() == 0)
{
var p = new Tip("没有数据!");
p.ShowDialog();
return;
}
foreach (var z in zhu.Where(p => p.kId == int.Parse(textBox1.Text)))
{
txtId.Text = z.kId + "";
txtname.Text = z.Kname;
txtkeshi.Text = (se[z.Sid].Sname);
txttime.Text = (z.Ztime + "");
txtyujiao.Text = (z.Imprest + "");
}
List <zhuyuanxiaofei> xfs = new IdCard_BLL().p_zhuyuanxiaofei_select(int.Parse(txtId.Text));
int i = 0;
foreach (zhuyuanxiaofei xf in xfs)
{
List <Drug_insert> di = new Drug_insert_BLL().SelectAll(xf.yaoName);
i = i + int.Parse(xf.yaonum + "") * int.Parse(di[0].DsellPrice + "");
}
txtyiyong.Text = i + "";
txtshengyu.Text = int.Parse(txtyujiao.Text) - int.Parse(txtyiyong.Text) + "";
}
catch
{
var p = new Tip("病人编号只能是数字!");
p.ShowDialog();
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
Button btn = e.Source as Button;
string s = btn.Content.ToString();
switch (s)
{
case "查找":
if (txtDname.Text == "")
{
var t1 = new Tip("请输入药品名字！");
t1.ShowDialog();
return;
}
lvwShow.Items.Clear();
List <Drug_insert> di = new Drug_insert_BLL().SelectAll(txtDname.Text);
if (di.Count == 0)
{
var t2 = new Tip("没有你要查找的数据！");
t2.ShowDialog();
return;
}
lvwShow.Items.Clear();
for (int i = 0; i < di.Count; i++)
{
lvwShow.Items.Add(new
{
drugname = di[i].Dname,
type = di[i].Dtype,
fare = di[i].DcostName,
dosetype = di[i].Dspec,
spec = di[i].DjiXing,
in_price = di[i].DinsertPrice,
sell_price = di[i].DsellPrice,
stock = di[i].Dstock,
stockMax = di[i].DstockMax,
stockMin = di[i].DstockMin,
proDate = di[i].DeffectTime,
effDate = di[i].DproductTime,
effect = di[i].Efficay
});
}
break;
case "药品出库":
if (txtDname.Text == "" && lvwShow.SelectedItems.Count == 0)
{
var t1 = new Tip("请选择需要删除的数据 !");
t1.ShowDialog();
return;
}
Drug_insert Ddelete = new Drug_insert();
Ddelete.Dname = txtDname.Text;
string mes = new Drug_insert_BLL().Delete(Ddelete);
lvwShow.Items.RemoveAt(lvwShow.SelectedIndex);
txtDname.Text = "";
Init_Load();
var p = new Tip(mes);
p.ShowDialog();
break;
case "清除":
txtDname.Text = "";
break;
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
Button btn = e.Source as Button;
string s = btn.Content.ToString();
switch (s)
{
case "清空全部":
txtDinsertPrice.Text = "";
txtDname.Text = "";
txtDsellPrice.Text = "";
txtDstock.Text = "";
txtDstockMax.Text = "";
txtDstockMin.Text = "";
txtEfficay.Text = "";
cboDcostName.Text = "";
cboDjiXing.Text = "";
cboDspec.Text = "";
cboDtype.Text = "";
dtpDeffectTime.Text = "";
dtpDproductTime.Text = "";
break;
case "显示全部":
#region 列表添加显示所有药品
List <Drug_insert> di = new Drug_insert_BLL().SelectAll("");
for (int i = 0; i < di.Count; i++)
{
lvwShow.Items.Add(new
{
drugname = di[i].Dname,
type = di[i].Dtype,
fare = di[i].DcostName,
dosetype = di[i].Dspec,
spec = di[i].DjiXing,
in_price = di[i].DinsertPrice,
sell_price = di[i].DsellPrice,
stock = di[i].Dstock,
stockMax = di[i].DstockMax,
stockMin = di[i].DstockMin,
proDate = di[i].DeffectTime,
effDate = di[i].DproductTime,
effect = di[i].Efficay
});
}
#endregion
break;
case "药品修改":
if (txtDname.Text == "")
{
Tip p = new Tip("请选择需要修改的数据 !");
p.ShowDialog();
return;
}
Drug_insert Dupdate = new Drug_insert();
Dupdate.Dname = txtDname.Text;
Dupdate.Dtype = cboDtype.Text;
Dupdate.DcostName = cboDcostName.Text;
Dupdate.Dspec = cboDspec.Text;
Dupdate.DjiXing = cboDjiXing.Text;
Dupdate.DinsertPrice = int.Parse(txtDinsertPrice.Text);
Dupdate.DsellPrice = int.Parse(txtDsellPrice.Text);
Dupdate.Dstock = int.Parse(txtDstock.Text);
Dupdate.DstockMax = int.Parse(txtDstockMax.Text);
Dupdate.DstockMin = int.Parse(txtDstockMin.Text);
Dupdate.DeffectTime = dtpDproductTime.Text;
Dupdate.DproductTime = dtpDeffectTime.Text;
Dupdate.Efficay = txtEfficay.Text;
string mes = new Drug_insert_BLL().Update(Dupdate);
break;
case "药品入库":
Drug_Insert();
break;
}
}
