public bool isMatHangDongChai(string mamh)
{
MatHang_DongChai mhdc = data.MatHang_DongChais.Where(c => c.MaMH_DC.Equals(mamh)).FirstOrDefault();
if (mhdc != null)
{
return(true);
}
else
{
return(false);
}
}
private void Btnmon_Click(object sender, EventArgs e)
{
if (banDangChon == null)
{
return;
}
string mahd = cthdbll.getHoaDonBy_Ban(banDangChon.MaBan);
//TH co hoa don roi
if (mahd != "")
{
if (danhmucchon.Equals("Pha Chế"))
{
MatHang_PC mathang = (MatHang_PC)((ButtonX)sender).Tag;
bool kqktr = false;
if (mahd != "")
{
kqktr = cthdbll.kiemTraTonTaiTrongCTHD(mahd, mathang.MaMH_PC);
}
if (kqktr)
{
//Có rồi cập nhật
string soluong = frm.soluong;
if (soluong.Equals(""))
{
soluong = "1";
}
cthdbll.updateCTHD_PC(mahd, mathang.MaMH_PC, soluong);
frm.loadCTHD();
pHienThiChinh.Refresh();
}
else
{
//chưa có thêm mới
string soluong = frm.soluong;
string ma_CTHDMax = mathangbll.getMaxIDCTHD_PC();
int hauso_ct = 0;
if (ma_CTHDMax != null)
{
hauso_ct = Convert.ToInt32(ma_CTHDMax.Split('_')[1]);
}
if (soluong.Equals(""))
{
soluong = "1";
}
if (Convert.ToInt32(soluong.Trim()) > 0)
{
ChiTietHoaDon_PhaChe cthd_pc = new ChiTietHoaDon_PhaChe();
cthd_pc.MaCTHD_PC = "CTHD_" + (hauso_ct + 1);
cthd_pc.MaHD = mahd;
cthd_pc.MaMH_PC = mathang.MaMH_PC;
cthd_pc.SoLuong = Convert.ToInt32(soluong.Trim());
double dongia = mathangbll.getDonGia_byMaMH_PC(mathang.MaMH_PC);
cthd_pc.DonGia = dongia;
cthd_pc.ThanhTien = Convert.ToInt32(soluong.Trim()) * dongia;
cthd_pc.DonViTinh = mathangbll.getDonViTinh_byMaMH_PC(mathang.MaMH_PC);
cthdbll.insertCTHD_PC(cthd_pc);
frm.loadCTHD();
pHienThiChinh.Refresh();
}
}
}
if (danhmucchon.Equals("Đóng Chai"))
{
MatHang_DongChai mathang = (MatHang_DongChai)((ButtonX)sender).Tag;
bool kqktr = false;
if (mahd != "")
{
kqktr = cthdbll.kiemTraTonTaiTrongCTHD(mahd, mathang.MaMH_DC);
}
if (kqktr)
{
//Có rồi cập nhật
string soluong = frm.soluong;
if (soluong.Equals(""))
{
soluong = "1";
}
cthdbll.updateCTHD_DC(mahd, mathang.MaMH_DC, soluong);
frm.loadCTHD();
pHienThiChinh.Refresh();
}
else
{
//chưa có thêm mới
string soluong = frm.soluong;
string ma_CTHDMax = mathangbll.getMaxIDCTHD_DC();
int hauso_ct = 0;
if (ma_CTHDMax != null)
{
hauso_ct = Convert.ToInt32(ma_CTHDMax.Split('_')[1]);
}
if (soluong.Equals(""))
{
soluong = "1";
}
if (Convert.ToInt32(soluong.Trim()) > 0)
{
ChiTietHoaDon_DongChai cthd_dc = new ChiTietHoaDon_DongChai();
cthd_dc.MaCTHD_DC = "CTHD_" + (hauso_ct + 1);
cthd_dc.MaHD = mahd;
cthd_dc.MaMH_DC = mathang.MaMH_DC;
cthd_dc.SoLuong = Convert.ToInt32(soluong.Trim());
double dongia = mathangbll.getDonGia_byMaMH_DC(mathang.MaMH_DC);
cthd_dc.DonGia = dongia;
cthd_dc.ThanhTien = Convert.ToInt32(soluong.Trim()) * dongia;
cthd_dc.DonViTinh = mathangbll.getDonViTinh_byMaMH_DC(mathang.MaMH_DC);
cthdbll.insertCTHD_DC(cthd_dc);
frm.loadCTHD();
pHienThiChinh.Refresh();
}
}
}
}
//TH chua co hoa don
else
{
int hauso = cthdbll.getHauSoHoaDonMax();
string mahd_them = "HD_" + (hauso + 1);
HoaDon hd = new HoaDon();
hd.MaHD = mahd_them;
hd.MaBan = banDangChon.MaBan;
hd.NgayLap = DateTime.Now;
hd.MaNV = "NV01";
hd.TongTien = 0;
hd.TinhTrang = false;
cthdbll.insertHoaDon(hd);
if (danhmucchon.Equals("Pha Chế"))
{
MatHang_PC mathang = (MatHang_PC)((ButtonX)sender).Tag;
string soluong = frm.soluong;
string ma_CTHDMax = mathangbll.getMaxIDCTHD_PC();
int hauso_ct = 0;
if (ma_CTHDMax != null)
{
hauso_ct = Convert.ToInt32(ma_CTHDMax.Split('_')[1]);
}
if (soluong.Equals(""))
{
soluong = "1";
}
if (Convert.ToInt32(soluong.Trim()) > 0)
{
ChiTietHoaDon_PhaChe cthd_pc = new ChiTietHoaDon_PhaChe();
cthd_pc.MaCTHD_PC = "CTHD_" + (Convert.ToInt32(hauso_ct) + 1);
cthd_pc.MaHD = mahd_them;
cthd_pc.MaMH_PC = mathang.MaMH_PC;
cthd_pc.SoLuong = Convert.ToInt32(soluong.Trim());
double dongia = mathangbll.getDonGia_byMaMH_PC(mathang.MaMH_PC);
cthd_pc.DonGia = dongia;
cthd_pc.ThanhTien = Convert.ToInt32(soluong.Trim()) * dongia;
cthd_pc.DonViTinh = mathangbll.getDonViTinh_byMaMH_PC(mathang.MaMH_PC);
cthdbll.insertCTHD_PC(cthd_pc);
frm.loadCTHD();
pHienThiChinh.Refresh();
}
}
if (danhmucchon.Equals("Đóng Chai"))
{
MatHang_DongChai mathang = (MatHang_DongChai)((ButtonX)sender).Tag;
string soluong = frm.soluong;
string ma_CTHDMax = mathangbll.getMaxIDCTHD_DC();
int hauso_ct = 0;
if (ma_CTHDMax != null)
{
hauso_ct = Convert.ToInt32(ma_CTHDMax.Split('_')[1]);
}
if (soluong.Equals(""))
{
soluong = "1";
}
if (Convert.ToInt32(soluong.Trim()) > 0)
{
ChiTietHoaDon_DongChai cthd_dc = new ChiTietHoaDon_DongChai();
cthd_dc.MaCTHD_DC = "CTHD_" + (Convert.ToInt32(hauso_ct) + 1);
cthd_dc.MaHD = mahd_them;
cthd_dc.MaMH_DC = mathang.MaMH_DC;
cthd_dc.SoLuong = Convert.ToInt32(soluong.Trim());
double dongia = mathangbll.getDonGia_byMaMH_DC(mathang.MaMH_DC);
cthd_dc.DonGia = dongia;
cthd_dc.ThanhTien = Convert.ToInt32(soluong.Trim()) * dongia;
cthd_dc.DonViTinh = mathangbll.getDonViTinh_byMaMH_DC(mathang.MaMH_DC);
cthdbll.insertCTHD_DC(cthd_dc);
frm.loadCTHD();
pHienThiChinh.Refresh();
}
}
}
}
public string getDonViTinh_byMaMH_DC(string mamh)
{
MatHang_DongChai dongia = data.MatHang_DongChais.Where(m => m.MaMH_DC.Equals(mamh)).FirstOrDefault();
return(dongia.DonViTinh);
}
public double getDonGia_byMaMH_DC(string mamh)
{
MatHang_DongChai dongia = data.MatHang_DongChais.Where(m => m.MaMH_DC.Equals(mamh)).FirstOrDefault();
return(Convert.ToDouble(dongia.DonGia));
}
