public int ThemCT_PhieuBanHang(CT_PhieuBanHangDTO ctpbh)
{
string sql = string.Format("insert into CT_Phieu_Ban_Hang(MaPhieuBanHang, MaSanPham, TenSanPham, SoLuong, DonVi, LoaiGia, DonGia, ThanhTien, CK, ChietKhau, ThanhToan, ViTri)" +
"values('{0}', '{1}', N'{2}',{3}, N'{4}',{5}, {6}, {7}, {8}, {9}, {10}, {11})", ctpbh.MaPhieuBanHang, ctpbh.MaSanPham, ctpbh.TenSanPham, ctpbh.SoLuong, ctpbh.DonVi, ctpbh.LoaiGia, ctpbh.DonGia, ctpbh.ThanhTien, ctpbh.CK, ctpbh.ChietKhau, ctpbh.ThanhToan, ctpbh.ViTri);
return(db.ExcuteSql(sql));
}
public int KiemTraDanhSachBanCoVuotTonKhoToiThieu()
{
for (int i = 0; i < grvrootbanhang.RowCount - 1; i++)
{
SanPhamPhu sp = new SanPhamPhu();
try
{
int temp = PhieuBanHangBUS.KiemTraHangHoaBanCoVuotTonKhoToiThieu(grvrootbanhang.GetRowCellValue(i, "Mã Hàng").ToString(), int.Parse(grvrootbanhang.GetRowCellValue(i, "Số Lượng").ToString()), cbkhocongty.EditValue.ToString(), grvrootbanhang.GetRowCellValue(i, "Tên Hàng").ToString());
if (temp == 0)
{
masploi = grvrootbanhang.GetRowCellValue(i, "Mã Hàng").ToString();
return(0);
}
CT_PhieuBanHangDTO ctpbh = new CT_PhieuBanHangDTO();
ctpbh.ViTri = i;
ctpbh.MaPhieuBanHang = txtmaphieubh.Text;
ctpbh.MaSanPham = grvrootbanhang.GetRowCellValue(i, "Mã Hàng").ToString();
// sp.ma = grvrootbanhang.GetRowCellValue(i, "Mã Hàng").ToString();
ctpbh.TenSanPham = grvrootbanhang.GetRowCellValue(i, "Tên Hàng").ToString();
ctpbh.SoLuong = int.Parse(grvrootbanhang.GetRowCellValue(i, "Số Lượng").ToString());
//sp.soluong = int.Parse(grvrootbanhang.GetRowCellValue(i, "Số Lượng").ToString());
ctpbh.DonVi = grvrootbanhang.GetRowCellValue(i, "Đơn Vị").ToString();
ctpbh.DonGia = float.Parse(grvrootbanhang.GetRowCellValue(i, "Đơn Giá").ToString());
ctpbh.ChietKhau = float.Parse(grvrootbanhang.GetRowCellValue(i, "Chiết Khấu").ToString());
ctpbh.ThanhToan = float.Parse(grvrootbanhang.GetRowCellValue(i, "Thanh Toán").ToString());
ctpbh.LoaiGia = int.Parse(grvrootbanhang.GetRowCellValue(i, "Loại Giá").ToString());
ctpbh.CK = float.Parse(grvrootbanhang.GetRowCellValue(i, "CK").ToString());
ctpbh.ThanhTien = float.Parse(grvrootbanhang.GetRowCellValue(i, "Thành Tiền").ToString());
}
catch { return(-1); }
}
return(1);
}
public int CapNhatCT_PhieuBanHang(CT_PhieuBanHangDTO ctpbh)
{
string sql = string.Format("update CT_Phieu_Ban_Hang set MaSanPham = '{0}', TenSanPham = N'{1}', DonVi = N'{2}', LoaiGia = {3}, SoLuong = {4}, DonGia = {5}, " +
"ThanhTien = {6}, CK = {7}, ChietKhau = {8}, ThanhToan = {9} where MaPhieuBanHang like '{10}' and ViTri = {11}",
ctpbh.MaSanPham, ctpbh.TenSanPham, ctpbh.DonVi, ctpbh.LoaiGia, ctpbh.SoLuong, ctpbh.DonGia, ctpbh.ThanhTien, ctpbh.CK, ctpbh.ChietKhau, ctpbh.ThanhToan, ctpbh.MaPhieuBanHang, ctpbh.ViTri);
return(db.ExcuteSql(sql));
}
public int ThemCT_PhieuBanHang(CT_PhieuBanHangDTO ctpbh)
{
return(phieuBanHangDAO.ThemCT_PhieuBanHang(ctpbh));
}
public int CapNhatCT_PhieuBanHang(CT_PhieuBanHangDTO ctpbh)
{
return(phieuBanHangDAO.CapNhatCT_PhieuBanHang(ctpbh));
}
