private void Consumertopic_Listener(IMessage message)
{
ActiveMQTextMessage text = message as ActiveMQTextMessage;
e = new ConvertXML <eBenhNhan>().XML2O(text.Text.ToString());
AddToTreeTopic(e.MSBN);
}
private eBenhNhan ConvertTextToEntity()
{
eBenhNhan e = new eBenhNhan {
DIACHI = textBox4.Text.ToString(), HOTEN = textBox3.Text.ToString(), MSBN = textBox1.Text.ToString(), SOCMND = textBox2.Text.ToString()
};
return(e);
}
public void ThemThongTinBenhNhan(eBenhNhan newBN)
{
BenhNhans temp = new BenhNhans();
temp.MaBenhNhan = newBN.MaBenhNhan;
temp.TenBenhNhan = newBN.TenBenhNhan;
temp.NamSinh = newBN.NamSinh;
temp.GioiTinh = newBN.GioiTinh;
temp.SDT = newBN.SDT;
temp.DiaChi = newBN.DiaChi;
qt.BenhNhans.InsertOnSubmit(temp);
qt.SubmitChanges();
}
private void SendThongTinQueue(eBenhNhan bn)
{
IConnectionFactory factory = new ConnectionFactory("tcp://localhost:61616");
IConnection connection = factory.CreateConnection("admin", "admin");
connection.Start();
ISession session = connection.CreateSession(AcknowledgementMode.AutoAcknowledge);
ActiveMQQueue queue = new ActiveMQQueue("DuongChiHieu_17044781_Queue");
IMessageProducer producer = session.CreateProducer(queue);
string x = new ConvertXML <eBenhNhan>().O2XML(bn);
ActiveMQTextMessage mes = new ActiveMQTextMessage(x);
producer.Send(mes);
producer.Close();
session.Close();
connection.Close();
}
public int InsertBenhNhan(eBenhNhan bnmoi)
{
if (CheckExisted(bnmoi.MaBenhNhan))
{
return(0);
}
BenhNhans bntemp = new BenhNhans();
bntemp.MaBenhNhan = bnmoi.MaBenhNhan;
bntemp.TenBenhNhan = bnmoi.TenBenhNhan;
bntemp.NamSinh = bnmoi.NamSinh;
bntemp.GioiTinh = bnmoi.GioiTinh;
bntemp.DiaChi = bnmoi.DiaChi;
bntemp.SDT = bnmoi.SDT;
qt.BenhNhans.InsertOnSubmit(bntemp);
qt.SubmitChanges();
return(1);
}
public List <eBenhNhan> LayThongTinBenhNhan()
{
var dsBenhNhan = qt.BenhNhans.ToList();
List <eBenhNhan> dsbn = new List <eBenhNhan>();
foreach (BenhNhans item in dsBenhNhan)
{
eBenhNhan bn = new eBenhNhan();
bn.MaBenhNhan = item.MaBenhNhan;
bn.TenBenhNhan = item.TenBenhNhan;
bn.NamSinh = item.NamSinh;
bn.GioiTinh = item.GioiTinh;
bn.SDT = item.SDT;
bn.DiaChi = item.DiaChi;
dsbn.Add(bn);
}
return(dsbn);
}
private void btnLapDonThuoc_Click(object sender, EventArgs e)
{
System.Windows.Forms.Form f = System.Windows.Forms.Application.OpenForms["FormKeDonThuoc"];
dsDT = dtBLL.LayThongTinDonThuoc();
string maDT = (dsDT.Count + 1).ToString();
DialogResult DR = MessageBox.Show("Bạn có muốn lập đơn thuốc hay không ?", "Lập đơn thuốc", MessageBoxButtons.OKCancel);
if (DialogResult.OK == DR)
{
if (ThongBaoLoi() == false)
{
}
else
{
eDonThuoc dtmoi1 = new eDonThuoc();
eBenhNhan bnmoi1 = new eBenhNhan();
eCTDonThuoc ctdtmoi1 = new eCTDonThuoc();
//Lưu vào csdl Bệnh Nhân
bnmoi1.MaBenhNhan = tbMaBN.Text;
bnmoi1.TenBenhNhan = txtTenKhachHangKD.Text;
bnmoi1.SDT = tbSDT.Text;
bnmoi1.DiaChi = cbbTP.Text;
if (rdNam.Checked)
{
bnmoi1.GioiTinh = "Nam";
}
if (rdNu.Checked)
{
bnmoi1.GioiTinh = "Nu";
}
bnmoi1.NamSinh = Convert.ToInt32(txtNamSinhKD.Text);
if (bnBLL.InsertBenhNhan(bnmoi1) == 0)
{
}
else
{
bnBLL.InsertBenhNhan(bnmoi1);
}
//-----------------------------------//
//Lưu vào csdl đơn thuốc
dtmoi1.MaDonThuoc = maDT;
dtmoi1.MaBenhNhan = bnmoi1.MaBenhNhan;
dtmoi1.MaBacSi = ((FormKeDonThuoc)f).lblMa.Text;
dtmoi1.MoTaBenh = txtLoaiBenhKD.Text;
//-----------------------------------//
int kq = dtBLL.InsertDonThuoc(dtmoi1);
if (kq == 1)
{
//Lưu vào csdl CTHoaDon
int countCTDT = dgvThuocDaChonKD.Rows.Count;
for (int i = 0; i <= countCTDT - 1; i++)
{
ctdtmoi1.MaThuoc = Convert.ToString(dgvThuocDaChonKD.Rows[i].Cells[3].Value);
ctdtmoi1.MaDonThuoc = dtmoi1.MaDonThuoc;
ctdtmoi1.SoLuong = Convert.ToInt32(dgvThuocDaChonKD.Rows[i].Cells[1].Value);
ctdtmoi1.DVT = Convert.ToString(dgvThuocDaChonKD.Rows[i].Cells[0].Value);
ctdtmoi1.GhiChu = Convert.ToString(dgvThuocDaChonKD.Rows[i].Cells[2].Value);
ctdtBLL.InsertCTDonThuoc(ctdtmoi1);
}
//-----------------------------------
MessageBox.Show("Lập đơn thuốc thành công !");
dgvThuocDaChonKD.Rows.Clear();
txtTenKhachHangKD.Clear();
txtNamSinhKD.Clear();
txtLoaiBenhKD.Clear();
txtLoaiBenhKD.Clear();
tbSDT.Clear();
cbbTP.Text = "";
HienThiThongTinThuoc();
rdNam.Checked = false;
rdNu.Checked = false;
btnHuy.Enabled = false;
UCKeDonThuoc_Load(sender, e);
}
else
{
MessageBox.Show("Sai hoặc thiếu thông tin, vui lòng kiểm tra lại!");
}
}
}
if (DialogResult.Cancel == DR)
{
}
}
private void btnLapHoaDon_Click(object sender, EventArgs e)
{
dsHoaDon = hoadonBLL.LayThongTinHoaDon();
dsLoThuoc = loThuocBLL.LayThongTinLoThuoc();
dsBenhNhan = benhnhanBLL.LayThongTinBenhNhan();
var timkiemBN = dsBenhNhan.Where(w => w.TenBenhNhan.Equals(txtBenhNhan.Text)).ToList();
eHoaDon newHD = new eHoaDon();
eBenhNhan newBN = new eBenhNhan();
if (dsHoaDon.Count == 0)
{
newHD.MaHoaDon = "1";
}
else
{
newHD.MaHoaDon = (Convert.ToInt32(dsHoaDon.Last().MaHoaDon) + 1).ToString();
}
newHD.MaNhanVien = "1";
if (timkiemBN.Count == 0)
{
newHD.MaBenhNhan = newBN.MaBenhNhan = (dsBenhNhan.Count + 1).ToString();
newBN.TenBenhNhan = txtBenhNhan.Text;
newBN.NamSinh = Convert.ToInt32(txtNamSinh.Text);
newBN.SDT = txtSDT.Text;
newBN.DiaChi = cbbTP.Text;
if (rdNam.Checked == true)
{
newBN.GioiTinh = "nam";
}
else
{
newBN.GioiTinh = "nu";
}
benhnhanBLL.ThemThongTinBenhNhan(newBN);
}
else
{
newHD.MaBenhNhan = timkiemBN.First().MaBenhNhan;
}
newHD.NgayLapHD = DateTime.Now;
newHD.TongTien = Convert.ToDecimal(lblTongTien.Text);
newHD.MaDonThuoc = null;
hoadonBLL.ThemThongTinHoaDon(newHD);
for (int i = 0; i < dgvThuocDaChon.Rows.Count; i++)
{
var loThuocTimKiem = dsLoThuoc.Where(w => w.MaLoThuoc.Equals(dgvThuocDaChon.Rows[i].Cells["MaLoThuoc"].Value.ToString()));
eCTHoaDon newCTHD = new eCTHoaDon();
if (dsHoaDon.Count == 0)
{
newCTHD.MaHoaDon = "1";
}
else
{
newCTHD.MaHoaDon = (Convert.ToInt32(dsHoaDon.Last().MaHoaDon) + 1).ToString();
}
newCTHD.MaLoThuoc = dgvThuocDaChon.Rows[i].Cells["MaLoThuoc"].Value.ToString();
newCTHD.DVT = dgvThuocDaChon.Rows[i].Cells["DVT"].Value.ToString();
newCTHD.SoLuong = Convert.ToInt32((dgvThuocDaChon.Rows[i].Cells["soluongcol"].Value));
newCTHD.GiaBan = Convert.ToDecimal((dgvThuocDaChon.Rows[i].Cells["dongiacol"].Value));
loThuocBLL.CapNhatSoLuongLoThuoc(dgvThuocDaChon.Rows[i].Cells["MaLoThuoc"].Value.ToString(), loThuocTimKiem.First().SoLuong - Convert.ToInt32((dgvThuocDaChon.Rows[i].Cells["soluongcol"].Value)));
cthdBLL.ThemThongTinCTHoaDon(newCTHD);
}
MessageBox.Show("Tao Hoa Don Thanh Cong");
LoadSauKhiLapHD();
HienThiLoThuoc();
}
