public DataTable InPhieuNhap(EC_PhieuNhap etpn)
{
return(SQL.InPhieuNhap(etpn));
}
public DataTable ThongTinPhieuNhap(EC_PhieuNhap etpn)
{
return(SQL.ThongTinPhieuNhap(etpn));
}
public void LuuPhieu(EC_PhieuNhap etpn)
{
SQL.LuuPhieu(etpn);
}
public void HuyPhieu(EC_PhieuNhap etpn)
{
SQL.HuyPhieu(etpn);
}
public void XoaDuLieu(EC_PhieuNhap et)
{
SQL.XoaDuLieu(et);
}
public DataTable TimPhieu(EC_PhieuNhap etpn)
{
return(SQL.TimPhieu(etpn));
}
public void ThemDuLieu(EC_PhieuNhap et)
{
SQL.ThemDuLieu(et);
}
public void SuaDuLieu(EC_PhieuNhap et)
{
SQL.SuaDuLieu(et);
}
public DataTable InPhieuNhap(EC_PhieuNhap etpn)
{
return(cn.LayDuLieu("EXEC SPU_PhieuNhap_Print '" + etpn.SoPhieu + "'"));
}
public DataTable ThongTinPhieuNhap(EC_PhieuNhap etpn)
{
return(cn.LayDuLieu("SELECT * FROM PhieuNhapHang Where SoPhieu='" + etpn.SoPhieu + "'"));
}
public void HuyPhieu(EC_PhieuNhap etpn)
{
cn.ThucThiSQL("UPDATE PhieuNhapHang Set HieuLuc=0 where SoPhieu='" + etpn.SoPhieu + "'");
}
public DataTable TimPhieu(EC_PhieuNhap etpn)
{
return(cn.LayDuLieu("EXEC SPU_TimPhieu_Nhap '" + etpn.NgayNhap + "'," + etpn.IDNhaCC));
}
public void XoaDuLieu(EC_PhieuNhap et)
{
cn.ThucThiSQL("DELETE FROM PhieuNhapHang where SoPhieu='" + et.SoPhieu + "'");
}
public void SuaDuLieu(EC_PhieuNhap et)
{
cn.ThucThiSQL(@"UPDATE PhieuNhapHang SET MaKho =" + et.MaKho + ", IDNhaCC =" + et.IDNhaCC + ", NgayNhap ='" + et.NgayNhap + "', NguoiNhap =N'" + et.NguoiLap + "', NguoiGiao =N'" + et.NguoiGiao + "',TienHang =" + et.TienHang + ", ThanhToan =" + et.ThanhToan + ", ConNo =" + et.ConNo + ", GhiChu =N'" + et.GhiChu + "' where SoPhieu='" + et.SoPhieu + "'");
}
public void ThemDuLieu(EC_PhieuNhap et)
{
cn.ThucThiSQL(@"");
}
