public bool CapNhatChiTietChuyenKhoByMaPhieuChuyenMaHangHoa(ref string err, ChiTietChuyenKhoO ctpck)
{
return(conn.MyExecuteNonQuery("proSuaChiTietPhieuMuaHangByMaPhieu_MaHangHoa",
CommandType.StoredProcedure, ref err,
new SqlParameter("@MaPhieuChuyen", ctpck.MaPhieuChuyen),
new SqlParameter("@MaHangHoa", ctpck.MaHangHoa)
));
}
public DataTable GetAllChiTietChuyenKhoByMaPhieuChuyen(ChiTietChuyenKhoO ctpck)
{
SqlParameter param = new SqlParameter();
param.ParameterName = "@MaPhieuChuyen";
param.Value = ctpck.MaPhieuChuyen;
return(conn.executeSelectQuery("proGetChiTietChuyenKho_HangHoa_DonVi_IfMaPhieuChuyen", param));
}
public bool CapNhatChiTietChuyenKho(ref string err, ChiTietChuyenKhoO ctpck)
{
return(conn.MyExecuteNonQuery("proSuaChiTietChuyenKho",
CommandType.StoredProcedure, ref err,
new SqlParameter("@MaChiTietPhieuChuyen", ctpck.MaChiTietPhieuChuyen),
new SqlParameter("@MaPhieuChuyen", ctpck.MaPhieuChuyen),
new SqlParameter("@MaHangHoa", ctpck.MaHangHoa),
new SqlParameter("@SoLuong", ctpck.SoLuong),
new SqlParameter("@DonGia", ctpck.DonGia),
new SqlParameter("@ThanhTien", ctpck.ThanhTien)
));
}
public UCLichSuChuyenKho()
{
InitializeComponent();
ucck = new UCChuyenKho();
CK = new ChuyenKhoO();
CTCK = new ChiTietChuyenKhoO();
TK = new TonKhoO();
chuyenKhoBUS = new ChuyenKhoBUS();
chiTietChuyenKhoBUS = new ChiTietChuyenKhoBUS();
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();
}
public bool XoaChiTietChuyenKhoByMaChiTietPhieuChuyen(ref string err, ChiTietChuyenKhoO ctpck)
{
return(conn.MyExecuteNonQuery("proXoaChiTietPhieuChuyenIfMaChiTietPhieuChuyen",
CommandType.StoredProcedure, ref err,
new SqlParameter("@MaChiTietPhieuChuyen", ctpck.MaChiTietPhieuChuyen)));
}
public bool XoaChiTietChuyenKhoByMaPhieuChuyenMaHangHoaBUS(ref string err, ChiTietChuyenKhoO ctpck)
{
return(chiTietChuyenKhoDAO.XoaChiTietChuyenKhoByMaPhieuChuyenMaHangHoa(ref err, ctpck));
}
public bool XoaChiTietChuyenKhoByMaChiTietPhieuBUS(ref string err, ChiTietChuyenKhoO ctpck)
{
return(chiTietChuyenKhoDAO.XoaChiTietChuyenKhoByMaChiTietPhieuChuyen(ref err, ctpck));
}
public bool CapNhatChiTietChuyenKhoBUS(ref string err, ChiTietChuyenKhoO ctpck)
{
return(chiTietChuyenKhoDAO.CapNhatChiTietChuyenKho(ref err, ctpck));
}
public DataTable GetAllChiTietChuyenKhoByMaPhieuChuyenBUS(ChiTietChuyenKhoO ctpck)
{
return(chiTietChuyenKhoDAO.GetAllChiTietChuyenKhoByMaPhieuChuyen(ctpck));
}