public int ThemPhieuBanHang(PhieuBanHangDTO pbh)
{
string sql = string.Format("insert into PhieuBanHang(MaPBH, MaNV, MaKH, DiaChi, GhiChu, MaKho, SoVAT, SoPhieuVT, DK_ThanhToan, HT_ThanhToan, HanThanhToan, NgayGiao, NgayLap, VAT, CK, TongThanhTien, IsDaThuTien)" +
"values('{0}', '{1}', '{2}', N'{3}', N'{4}', '{5}', '{6}', '{7}', '{8}', '{9}', '{10}', '{11}', '{12}', '{13}', '{14}', '{15}', {16})",
pbh.MaPBH, pbh.MaNV, pbh.MaKH, pbh.DiaChi, pbh.GhiChu, pbh.MaKho, pbh.SoVAT, pbh.SoPhieuVT, pbh.DK_ThanhToan, pbh.HT_ThanhToan, pbh.HanThanhToan, pbh.NgayGiao, pbh.NgayLap, pbh.VAT, pbh.CK, pbh.TongThanhTien, 0);
return(db.ExcuteSql(sql));
}
public int CapNhatPhieuBanHang(PhieuBanHangDTO pbh)
{
string sql = string.Format("update PhieuBanHang set MaNV = '{0}', MaKH = '{1}', DiaChi = N'{2}', GhiChu = N'{3}', MaKho = '{4}', SoVAT = '{5}', SoPhieuVT = '{6}', DK_ThanhToan = '{7}', " +
" HT_ThanhToan = '{8}', HanThanhToan = '{9}', NgayGiao = '{10}', NgayLap = '{11}', VAT = '{12}', CK = '{13}', TongThanhTien = {14} where MaPBH like '{15}'",
pbh.MaNV, pbh.MaKH, pbh.DiaChi, pbh.GhiChu, pbh.MaKho, pbh.SoVAT, pbh.SoPhieuVT, pbh.DK_ThanhToan, pbh.HT_ThanhToan, pbh.HanThanhToan, pbh.NgayGiao, pbh.NgayLap, pbh.VAT, pbh.CK, pbh.TongThanhTien, pbh.MaPBH);
return(db.ExcuteSql(sql));
}
public List <PhieuBanHangDTO> GetDsLoaiSanPham()
{
List <PhieuBanHangDTO> list = new List <PhieuBanHangDTO>();
string query = "select * from PHIEUBANHANG";
DataTable data = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow item in data.Rows)
{
PhieuBanHangDTO LoaiSP = new PhieuBanHangDTO(item);
list.Add(LoaiSP);
;
}
return(list);
}
public int ThemPhieuBanHang(PhieuBanHangDTO pbh)
{
return(phieuBanHangDAO.ThemPhieuBanHang(pbh));
}
public int CapNhatPhieuBanHang(PhieuBanHangDTO pbh)
{
return(phieuBanHangDAO.CapNhatPhieuBanHang(pbh));
}
