public DataTable GetAllTonKhoByMaKho(TonKhoO tk)
{
SqlParameter param = new SqlParameter();
param.ParameterName = "@MaKho";
param.Value = tk.MaKho;
return(conn.executeSelectQuery("proGetTonKho_Kho_HangHoa_DonVi_NhomHang_IfMaKho", param));
}
public bool TruSoLuongTonKho(ref string err, TonKhoO tk)
{
return(conn.MyExecuteNonQuery("proTruSoLuongTonKho",
CommandType.StoredProcedure, ref err,
new SqlParameter("@MaHangHoa", tk.MaHangHoa),
new SqlParameter("@MaKho", tk.MaKho),
new SqlParameter("@SoLuong", tk.SoLuong)
));
}
public UCTonKho()
{
InitializeComponent();
tk = new TonKhoO();
tonKhoBUS = new TonKhoBUS();
//load du lieu cho lueKho
khoBUS = new KhoBUS();
lueKho.Properties.DataSource = khoBUS.getAllKhoBUS();
lueKho.Properties.DisplayMember = "TenKho";
lueKho.Properties.ValueMember = "MaKho";
}
public UCLichSuChuyenKho()
{
InitializeComponent();
ucck = new UCChuyenKho();
CK = new ChuyenKhoO();
CTCK = new ChiTietChuyenKhoO();
TK = new TonKhoO();
chuyenKhoBUS = new ChuyenKhoBUS();
chiTietChuyenKhoBUS = new ChiTietChuyenKhoBUS();
tonKhoBUS = new TonKhoBUS();
}
public UCLichSuBanHang()
{
InitializeComponent();
BH = new BanHangO();
CTPBH = new ChiTietPhieuBanHangO();
TK = new TonKhoO();
banHangBUS = new BanHangBUS();
khachHangBUS = new KhachHangBUS();
chiTietPhieuBanHangBUS = new ChiTietPhieuBanHangBUS();
tonKhoBUS = new TonKhoBUS();
}
public UCLichSuMuaHang()
{
InitializeComponent();
ucmh = new UCMuaHang();
MH = new MuaHangO();
CTPMH = new ChiTietPhieuMuaHangO();
TK = new TonKhoO();
muaHangBUS = new MuaHangBUS();
nhaCungCapBUS = new NhaCungCapBUS();
chiTietPhieuMuaHangBUS = new ChiTietPhieuMuaHangBUS();
tonKhoBUS = new TonKhoBUS();
}
public UCLichSuTraHang()
{
InitializeComponent();
ucth = new UCTraHang2();
KH = new KhachHangO();
TH = new TraHangO();
CTTH = new ChiTietTraHangO();
TK = new TonKhoO();
traHangBUS = new TraHangBUS();
khachHangBUS = new KhachHangBUS();
chiTietPhieuTraHangBUS = new ChiTietPhieuTraHangBUS();
tonKhoBUS = new TonKhoBUS();
}
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();
}
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 XoaTonKho(ref string err, TonKhoO tk)
{
return(conn.MyExecuteNonQuery("proXoaTonKho",
CommandType.StoredProcedure, ref err,
new SqlParameter("@MaHangHoa", tk.MaHangHoa)));
}
public bool XoaTonKhoBUS(ref string err, TonKhoO tk)
{
return(tonKhoDAO.XoaTonKho(ref err, tk));
}
public bool TruSoLuongTonKho(ref string err, TonKhoO tk)
{
return(tonKhoDAO.TruSoLuongTonKho(ref err, tk));
}
public bool CongSoLuongTonKhoBUS(ref string err, TonKhoO tk)
{
return(tonKhoDAO.CongSoLuongTonKho(ref err, tk));
}
public bool ThemTonKhoBUS(ref string err, TonKhoO tk)
{
return(tonKhoDAO.ThemTonKho(ref err, tk));
}
public DataTable GetAllTonKhoByMaKhoBUS(TonKhoO tk)
{
return(tonKhoDAO.GetAllTonKhoByMaKho(tk));
}
