public bool ThemChiTietPhieuKham(DTOChiTietPhieuKham ctpk)
{
// Kiểm tra trạng thái
if (_connect.connected == false)
{
_connect.lastError = "Connection not established.";
return(false);
}
// Tạo lệnh SQL
SQLiteCommand cmd = new SQLiteCommand(
"INSERT INTO CHITIETPHIEUKHAM VALUES (@MaChiTietPhieuKham, @MaChiTietDanhSach, @MaLoaiThuoc, @MaLoaiDonVi, @MaLoaiCachDung, @SoLuong, @TienThuoc);",
_connect.cnn);
// Ấn định tham số
cmd.Parameters.Add(new SQLiteParameter("@MaChiTietPhieuKham", ctpk.MaChiTietPhieuKham));
cmd.Parameters.Add(new SQLiteParameter("@MaChiTietDanhSach", ctpk.MaChiTietDanhSach));
cmd.Parameters.Add(new SQLiteParameter("@MaLoaiThuoc", ctpk.MaLoaiThuoc));
cmd.Parameters.Add(new SQLiteParameter("@MaLoaiDonVi", ctpk.MaLoaiDonVi));
cmd.Parameters.Add(new SQLiteParameter("@MaLoaiCachDung", ctpk.MaLoaiCachDung));
cmd.Parameters.Add(new SQLiteParameter("@SoLuong", ctpk.SoLuong));
cmd.Parameters.Add(new SQLiteParameter("@TienThuoc", ctpk.TienThuoc));
// Thi hành
cmd.ExecuteNonQuery();
_connect.lastError = string.Empty;
return(true);
}
private void buttonThemThuoc_Click(object sender, EventArgs e)
{
//MessageBox.Show(BLL.LayMaBenh ( comboBoxDuDoanBenh.Text.ToString ( ) ));
//MessageBox.Show(BLL.LayMaLoaiThuoc(comboBoxTenThuoc.Text.ToString()));
//MessageBox.Show(BLL.LayMaLoaiDonVi(comboBoxDonVi.Text.ToString()));
//MessageBox.Show(BLL.LayMaLoaiCachDung(comboBoxCachDung.Text.ToString()));
//MessageBox.Show ( BLL.LayDonGiaThuoc ( comboBoxTenThuoc.Text.ToString ( ) ).ToString ( ) );
DTO.DTOChiTietPhieuKham ctkp = new DTOChiTietPhieuKham( );
ctkp.MaChiTietDanhSach = MaChiTietDanhSach;
ctkp.MaLoaiCachDung = BLL.LayMaLoaiCachDung(comboBoxCachDung.Text.ToString( ));
ctkp.MaLoaiDonVi = BLL.LayMaLoaiDonVi(comboBoxDonVi.Text.ToString( ));
ctkp.MaLoaiThuoc = BLL.LayMaLoaiThuoc(comboBoxTenThuoc.Text.ToString());
ctkp.SoLuong = int.Parse(comboBoxSoLuong.Text.ToString( ));
ctkp.TienThuoc = int.Parse(BLL.LayDonGiaThuoc(comboBoxTenThuoc.Text.ToString( )).ToString( )) *
int.Parse(comboBoxSoLuong.Text.ToString( ));
BLL.ThemChiTietPhieuKham(ctkp);
BLL.TimDanhSachThuoc(MaChiTietDanhSach, dataGridViewDanhSachThuoc);
// cap nhat lại
ctds.MaChiTietDanhSach = MaChiTietDanhSach;
ctds.MaBenhNhan = "BN000";
ctds.MaDanhSach = "DS000";
ctds.TrieuChung = richTextBoxTrieuChung.Text.ToString();
ctds.MaBenh = BLL.LayMaBenh(comboBoxDuDoanBenh.Text.ToString());
ctds.TienKham = BLL.LayTienKhamQuyDinh();
ctds.TongTienThuoc = BLL.LayTongTienThuoc(MaChiTietDanhSach);
ctds.TongTienHoaDon = BLL.LayTienKhamQuyDinh() + BLL.LayTongTienThuoc(MaChiTietDanhSach);
BLL.CapNhatChiTietDanhSach(ctds);
}
public void ThemChiTietPhieuKham(DTOChiTietPhieuKham ctpk)
{
int count1 = 0;
try
{
lpkb.GetCount(ref count1, "CHITIETPHIEUKHAM", "MaChiTietPhieuKham", "CP");
count1++;
}
catch
{ }
string ID = "CP" + count1.ToString("000");
ctpk.MaChiTietPhieuKham = ID;
lpkb.ThemChiTietPhieuKham(ctpk);
}
