void initBUS()
{
hangHoaBUS = new HangHoaBUS();
khoBUS = new KhoBUS();
nhomHangBUS = new NhomHangBUS();
donViBUS = new DonViBUS();
nhaCungCapBUS = new NhaCungCapBUS();
HH = new HangHoaO();
}
private void lueHangHoa_EditValueChanged(object sender, EventArgs e)
{
HH.MaHangHoa = lueHangHoa.EditValue.ToString();
HH = hangHoaBUS.getOneHangHoa(HH);
DV.MaDonVi = HH.MaDonVi;
DV = donViBUS.getOneDonVi(DV);//lay don vi tu ma don vi
txtDonGia.Text = HH.GiaMua.ToString();
txtThanhTien.Text = (HH.GiaMua * (Convert.ToDouble(txtSoLuong.Text))).ToString();
}
void initObjectBUS()
{
CK = new ChuyenKhoO();
CTCK = new ChiTietChuyenKhoO();
HH = new HangHoaO();
DV = new DonViO();
TK = new TonKhoO();
chuyenKhoBUS = new ChuyenKhoBUS();
chiTietChuyenKhoBUS = new ChiTietChuyenKhoBUS();
nhanVienBUS = new NhanVienBUS();
khoBUS = new KhoBUS();
hangHoaBUS = new HangHoaBUS();
donViBUS = new DonViBUS();
tonKhoBUS = new TonKhoBUS();
}
public HangHoaO getOneHangHoa(HangHoaO hh)
{
DataTable dt = new DataTable();
dt = hangHoaDAO.GetAllHangHoa();
DataRow[] result = dt.Select("MaHangHoa= '" + hh.MaHangHoa + "'");
DataRow row = result[0];
HH.MaHangHoa = row["MaHangHoa"].ToString();
HH.TenHangHoa = row["TenHangHoa"].ToString();
HH.MaDonVi = row["MaDonVi"].ToString();
HH.GiaMua = Convert.ToDouble(row["GiaMua"].ToString());
HH.GiaBanSi = Convert.ToDouble(row["GiaBanSi"].ToString());
HH.GiaBanLe = Convert.ToDouble(row["GiaBanLe"].ToString());
return(HH);
}
void initObjectBUS()
{
MH = new MuaHangO();
NCC = new NhaCungCapO();
HH = new HangHoaO();
DV = new DonViO();
CTPMH = new ChiTietPhieuMuaHangO();
TK = new TonKhoO();
muaHangBUS = new MuaHangBUS();
nhaCungCapBUS = new NhaCungCapBUS();
nhanVienBUS = new NhanVienBUS();
khoBUS = new KhoBUS();
hangHoaBUS = new HangHoaBUS();
donViBUS = new DonViBUS();
tonKhoBUS = new TonKhoBUS();
chiTietPhieuMuaHangBUS = new ChiTietPhieuMuaHangBUS();
kieuThanhToanBUS = new KieuThanhToanBUS();
hinhThucThanhToanBUS = new HinhThucThanhToanBUS();
}
void initObjectBUS()
{
TH = new TraHangO();
KH = new KhachHangO();
HH = new HangHoaO();
DV = new DonViO();
CTTH = new ChiTietTraHangO();
TK = new TonKhoO();
traHangBUS = new TraHangBUS();
khachHangBUS = new KhachHangBUS();
nhanVienBUS = new NhanVienBUS();
khoBUS = new KhoBUS();
hangHoaBUS = new HangHoaBUS();
donViBUS = new DonViBUS();
tonKhoBUS = new TonKhoBUS();
chiTietPhieuTraHangBUS = new ChiTietPhieuTraHangBUS();
kieuThanhToanBUS = new KieuThanhToanBUS();
hinhThucThanhToanBUS = new HinhThucThanhToanBUS();
}
public bool CapNhatHangHoa(ref string err, HangHoaO hh)
{
return(conn.MyExecuteNonQuery("proSuaHangHoa",
CommandType.StoredProcedure, ref err,
new SqlParameter("@MaHangHoa", hh.MaHangHoa),
new SqlParameter("@TenHangHoa", hh.TenHangHoa),
new SqlParameter("@MaKho", hh.MaKho),
new SqlParameter("@MaNhomHang", hh.MaNhomHang),
new SqlParameter("@MaVachNSX", hh.MaVachNSX),
new SqlParameter("@MaDonVi", hh.MaDonVi),
new SqlParameter("@XuatXu", hh.XuatXu),
new SqlParameter("@Thue", hh.Thue),
new SqlParameter("@TonKhoToiThieu", hh.TonKhoToiThieu),
new SqlParameter("@TonHienTai", hh.TonHienTai),
new SqlParameter("@MaNhaCungCap", hh.MaNhaCungCap),
new SqlParameter("@GiaMua", hh.GiaMua),
new SqlParameter("@GiaBanSi", hh.GiaBanSi),
new SqlParameter("@GiaBanLe", hh.GiaBanLe),
new SqlParameter("@HangHoaOrDichVu", hh.HangHoaOrDichVu),
new SqlParameter("@ConQuanLy", hh.ConQuanLy)
));
}
public bool XoaHangHoaBUS(ref string err, HangHoaO hh)
{
return(hangHoaDAO.XoaHangHoa(ref err, hh));
}
public bool CapNhatHangHoaBUS(ref string err, HangHoaO hh)
{
return(hangHoaDAO.CapNhatHangHoa(ref err, hh));
}
public HangHoaBUS()
{
hangHoaDAO = new HangHoaDAO();
HH = new HangHoaO();
}
public UCHangHoa()
{
InitializeComponent();
hangHoaBUS = new HangHoaBUS();
hh = new HangHoaO();
}
public bool XoaHangHoa(ref string err, HangHoaO hh)
{
return(conn.MyExecuteNonQuery("proXoaHangHoa",
CommandType.StoredProcedure, ref err,
new SqlParameter("@MaHangHoa", hh.MaHangHoa)));
}
