public int ThemCT_PhieuNhapHang(CT_PhieuNhapHangDTO ctpnh)
{
string sql = string.Format("insert into CT_PhieuNhapHang(MaPhieuNhapHang, MaSanPham, TenSanPham, DonVi, SoLuong, DonGia, ThanhTien, GhiChu)values('{0}', '{1}', N'{2}', N'{3}', {4}, {5}, {6}, N'{7}')",
ctpnh.MaPhieuNhapHang, ctpnh.MaSanPham, ctpnh.TenSanPham, ctpnh.DonVi, ctpnh.SoLuong, ctpnh.DonGia, ctpnh.ThanhTien, ctpnh.GhiChu);
return(db.ExcuteSql(sql));
}
public int CapNhatCT_PNH(CT_PhieuNhapHangDTO ctpnh)
{
string sql = string.Format("update CT_PhieuNhapHang set TenSanPham = N'{0}', SoLuong = {1}, DonVi = N'{2}', DonGia = {3}, ThanhTien = {4}, GhiChu = N'{5}' " +
"where MaPhieuNhapHang like '{6}' and MaSanPham like '{7}'",
ctpnh.TenSanPham, ctpnh.SoLuong, ctpnh.DonVi, ctpnh.DonGia, ctpnh.ThanhTien, ctpnh.GhiChu, ctpnh.MaPhieuNhapHang, ctpnh.MaSanPham);
return(db.ExcuteSql(sql));
}
public int CapNhatCT_PNH(CT_PhieuNhapHangDTO ctpnh)
{
return(muaHangDAO.CapNhatCT_PNH(ctpnh));
}
public int ThemCT_PhieuNhapHang(CT_PhieuNhapHangDTO ctpnh)
{
return(muaHangDAO.ThemCT_PhieuNhapHang(ctpnh));
}
