public void UpdateChiTietChungTu(ChungTuBanHangChiTietInfor chiTietChungTu)
{
ExecuteCommand(Declare.StoreProcedureNamespace.spChungTuBanHangCTietUpdate, chiTietChungTu.IdChungTuChiTiet,
chiTietChungTu.IdChungTu, chiTietChungTu.IdSanPham, chiTietChungTu.SoLuong, chiTietChungTu.DonGia,
chiTietChungTu.TyleChietKhau, chiTietChungTu.TienChietKhau, chiTietChungTu.ThanhTien,
chiTietChungTu.TienSauChietKhau, chiTietChungTu.TyleVAT, chiTietChungTu.TienVAT,
chiTietChungTu.TyleThuong, chiTietChungTu.ThuongNong, chiTietChungTu.GiaTheoBangGia,
chiTietChungTu.IdSanPhamBan, chiTietChungTu.NoKhuyenMai, chiTietChungTu.GiaNiemYet, chiTietChungTu.GiaWebSite,
chiTietChungTu.GhiChu, chiTietChungTu.CungDongDonHangChinh, chiTietChungTu.LoaiHangKem, chiTietChungTu.TyLePhanBo, chiTietChungTu.TyLeThanhToan, chiTietChungTu.ListIdChinhSach);
}
public int InsertChiTietChungTu(ChungTuBanHangChiTietInfor chiTietChungTu)
{
ExecuteCommand(Declare.StoreProcedureNamespace.spChungTuBanHangCTietInsert, chiTietChungTu.IdChungTuChiTiet,
chiTietChungTu.IdChungTu, chiTietChungTu.IdSanPham, chiTietChungTu.SoLuong, chiTietChungTu.DonGia,
chiTietChungTu.TyleChietKhau, chiTietChungTu.TienChietKhau, chiTietChungTu.ThanhTien,
chiTietChungTu.TienSauChietKhau, chiTietChungTu.TyleVAT, chiTietChungTu.TienVAT,
chiTietChungTu.TyleThuong, chiTietChungTu.ThuongNong, chiTietChungTu.GiaTheoBangGia,
chiTietChungTu.IdSanPhamBan, chiTietChungTu.NoKhuyenMai, chiTietChungTu.GiaNiemYet, chiTietChungTu.GiaWebSite,
chiTietChungTu.GhiChu, chiTietChungTu.CungDongDonHangChinh, chiTietChungTu.LoaiHangKem, chiTietChungTu.TyLePhanBo, chiTietChungTu.TyLeThanhToan, chiTietChungTu.ListIdChinhSach);
return(Convert.ToInt32(Parameters["p_IdChiTiet"].Value.ToString()));
}
public BanHangBusiness(ChungTuBanHangInfor ctu, double tienTraLaiThe, int soDiemAm, int idThe)
{
int Vat = 10 / 100;
//chungtu
ChungTu = new ChungTuBanHangInfor(ctu);
ChungTu.IdChungTu = 0;
ChungTu.LoaiChungTu = (int)TransactionType.DON_HANG_DAT_TRUOC;
ChungTu.TrangThai = (int)OrderStatus.TAO_DON_HANG_DAT_TRUOC;
ChungTu.SoChungTu = "DT-" + ChungTu.SoChungTu;
ChungTu.OrderType = Declare.OrderTypeBan;
ChungTu.GhiChu = "Đơn hàng DT hoàn tiền điểm thưởng";
ChungTu.TongTienHang = tienTraLaiThe / (1 + Vat);
ChungTu.TongTienChietKhau = 0;
ChungTu.TongTienSauChietKhau = tienTraLaiThe / (1 + Vat);
ChungTu.TongTienVAT = tienTraLaiThe / (1 + Vat) * Vat;
ChungTu.TongTienThanhToan = tienTraLaiThe;
ChungTu.TienThanhToanThuc = 0;
ChungTu.TienConNo = tienTraLaiThe;
ChungTu.IdLyDoGiaoDich = -1; //danh dau don hang thu tien diem thuong am
ChungTu.SoTienTichLuy = soDiemAm; //so diem truoc khi bu tien
ChungTu.SoDiemBiTru = 0;
ChungTu.SoTienQuyDoi = 0;
ChungTu.IdTheThanhVien = idThe;
ChungTu.SoDiemTichLuy = -soDiemAm;
ChungTu.DaTichDiem = 1;
ChungTu.IdTrungTamHachToan = ChungTu.IdTrungTam;
//chungtu chitiet
HeSoDoiDiemInfo heso = HeSoDoiDiemDataProvider.Instance.LoadHeSoDoiDiem();
ChungTuBanHangChiTietInfor ct = new ChungTuBanHangChiTietInfor()
{
IdSanPham = heso.IdSanPham,
MaSanPham = heso.MaHoanTien,
TenSanPham = heso.TenSanPham,
SoLuong = 1,
DonGiaCoVat = tienTraLaiThe,
DonGia = tienTraLaiThe / (1 + Vat),
TyleChietKhau = 0,
TienChietKhau = 0,
TienSauChietKhau = tienTraLaiThe / (1 + Vat),
TyleVAT = 10,
TienVAT = tienTraLaiThe / (1 + Vat) * Vat,
ThanhTien = tienTraLaiThe
};
ListChiTietChungTu = new List <ChungTuBanHangChiTietInfor>();
ListChiTietChungTu.Add(ct);
ListChungTuThanhToan = new List <ChungTuThanhToanInfor>();
}
private void EditOrder(int rowHandle)
{
if (rowHandle < 0)
{
return;
}
ChungTuChiTiet = (ChungTuBanHangChiTietInfor)gvSanPhamBan.GetRow(rowHandle);
if (ChungTuChiTiet == null)
{
MessageBox.Show("Phải chọn một sản phẩm chính!");
return;
}
this.DialogResult = DialogResult.OK;
}
//public frmBH_ChonChinhSach_BanHang(List<BangGiaChinhSachInfor> lics, ChungTuBanHangChiTietInfor ctu, int idKho, int idTrungTam)
//{
// InitializeComponent();
// Common.LoadStyle(this);
// this.CTu = ctu;
// this.IdKhoSelected = idKho;
// this.IdTTamSelected = idTrungTam;
// this.liChinhSach = lics;
//}
public frmBH_ChonChinhSach_BanHang(List <BangGiaChinhSachInfor> lics, ChungTuBanHangChiTietInfor ctu, int idKho, int idTrungTam, bool datTruoc)
{
InitializeComponent();
Common.LoadStyle(this);
this.CTu = ctu;
this.IdKhoSelected = idKho;
this.IdTTamSelected = idTrungTam;
this.liChinhSach = new List <BangGiaChinhSachInfor>();
this.liChinhSachDefault = new List <BangGiaChinhSachInfor>();
foreach (BangGiaChinhSachInfor cs in lics)
{
if (cs.MacDinh == 1)
{
this.liChinhSachDefault.Add(cs);
string ghichu = String.Format("{0} (mặc định)", cs.SoChinhSach);
//load thanh toan
foreach (BangGiaADBankInfor tt in cs.ListBangGiaADThanhToan)
{
tt.GhiChu = ghichu;
liThanhToan.Add(tt);
}
//load san pham kem default
List <BangGiaADSPKemInfor> lstSPK = KhuyenMaiDataProvider.Instance.GetAllSanPhamKemADInfors(cs.IdDKMua, IdKhoSelected);
foreach (BangGiaADSPKemInfor spk in lstSPK)
{
spk.GhiChu = ghichu;
liSPKemDefault.Add(spk);
}
//load khuyen mai default => load KM dau tien
List <BangGiaADKhuyenMaiInfor> lstKM = KhuyenMaiDataProvider.Instance.GetAllBangGiaKhuyenMaiADInfors(cs.IdDKMua);
if (lstKM.Count > 0)
{
List <BangGiaADKhuyenMaiChiTietInfor> lstKMCTiet = KhuyenMaiDataProvider.Instance.GetAllKhuyenMaiChiTietADInfors(lstKM[0].IdKhuyenMai, IdKhoSelected, CTu.DonGiaCoVat);
foreach (BangGiaADKhuyenMaiChiTietInfor kmct in lstKMCTiet)
{
kmct.ChinhSachKhuyenMai = ghichu;
liKMCTietDefault.Add(kmct);
}
}
}
else
{
this.liChinhSach.Add(cs);
}
}
this.DatTruoc = datTruoc;
}
private void gvSanPham_ShowingEditor(object sender, CancelEventArgs e)
{
try
{
if (gvSanPham.FocusedColumn.FieldName == "GhiChu")// && IsChietKhau(gvSanPham.FocusedRowHandle))
{
ChungTuBanHangChiTietInfor ct = (ChungTuBanHangChiTietInfor)gvSanPham.GetRow(gvSanPham.FocusedRowHandle);
if (ct != null && ct.NoKhuyenMai > 0)
{
e.Cancel = true;
}
}
}
catch
{
}
}
private void gvSanPham_RowCellStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowCellStyleEventArgs e)
{
if (e.RowHandle < 0)
{
return;
}
ChungTuBanHangChiTietInfor ct = (ChungTuBanHangChiTietInfor)gvSanPham.GetRow(e.RowHandle);
if (ct != null && ct.NoKhuyenMai > 0)
{
if (e.Column.FieldName.Equals("TenLoaiHangKem"))
{
e.Appearance.BackColor = tsslNoKhuyenMai.BackColor;
e.Appearance.ForeColor = Color.Red;
e.Appearance.Font = new Font("Tahoma", 9, FontStyle.Bold);
}
}
}
private void SaveChungTuDetails()
{
List <ChungTuBanHangChiTietInfor> listOrigin =
BanHangDataProvider.Instance.GetListChiTietChungTuByIdChungTu(ChungTu.IdChungTu);
//xoa nhung cai cu
foreach (ChungTuBanHangChiTietInfor originInfo in listOrigin)
{
if (!ListChiTietChungTu.Exists(delegate(ChungTuBanHangChiTietInfor match)
{
return(match.IdChungTuChiTiet == originInfo.IdChungTuChiTiet);
}))
{
BanHangDataProvider.Instance.DeleteChiTietChungTu(originInfo);
}
}
//them hoac cap nhat cai moi
foreach (ChungTuBanHangChiTietInfor newInfo in ListChiTietChungTu)
{
ChungTuBanHangChiTietInfor originInfo = listOrigin.Find(
delegate(ChungTuBanHangChiTietInfor match)
{
return(match.IdChungTuChiTiet == newInfo.IdChungTuChiTiet);
});
if (originInfo != null)
{
if (!newInfo.IsOrigin)
{
BanHangDataProvider.Instance.UpdateChiTietChungTu(newInfo);
}
}
else
{
newInfo.IdChungTu = ChungTu.IdChungTu;
newInfo.IdChungTuChiTiet = BanHangDataProvider.Instance.InsertChiTietChungTu(newInfo);
}
}
}
public void DeleteChiTietChungTu(ChungTuBanHangChiTietInfor chiTietChungTu)
{
ExecuteCommand(Declare.StoreProcedureNamespace.spChungTuBanHangCTietDelete, chiTietChungTu.IdChungTuChiTiet);
}
private void InputDataFromCode(string code)
{
try
{
DMSanPhamBriefInfo sp = DmSanPhamProvider.GetSanPhamBriefByNSDMa(code, nguoiDung.IdNhomNguoiDung);
if (sp == null)
{
frmLookUp_HangHoa frm = new frmLookUp_HangHoa(false,
(Common.Int2Bool(nguoiDung.SupperUser)
? -1
: nguoiDung.IdNhomNguoiDung), 1, -1);
if (frm.ShowDialog() == DialogResult.OK)
{
sp = frm.SelectedItem;
}
}
if (sp != null)
{
BangGiaBanChiTietInfor spb;
spb = liBangGiaBan.Find(delegate(BangGiaBanChiTietInfor match)
{
return(match.MaSanPham.Equals(code));
});
if (spb == null)
{
spb = BangGiaDataProvider.Instance.GetGiaBan(IdTTamSelected, IdKhoSelected, sp.MaSanPham);
}
if (spb == null)
{
MessageBox.Show("Giá chưa thiết lập!");
return;
}
else if (!DatTruoc && spb.ChietKhau != 1 && GetTonConLai(spb) <= 0)
{
MessageBox.Show("Hàng đã hết tồn kho!");
return;
}
liBangGiaBan.Add(spb);
int isHangKem = (rdHangBanKem.Checked ? 1 : 0);
string tenHangKem = (rdHangBanKem.Checked ? strMuaKem : strKhuyenMai);
ChungTuBanHangChiTietInfor ctu = liSanPhamSelected.Find(delegate(ChungTuBanHangChiTietInfor match)
{
return(match.MaSanPham.Equals(spb.MaSanPham) && match.LoaiHangKem == isHangKem);
});
if (ctu != null)
{
ctu.SoLuong += 1;
ctu.TienSauChietKhau += spb.DonGiaChuaVAT;
ctu.TienVAT += spb.TienVAT;
ctu.ThanhTien += spb.DonGiaCoVAT;
ctu.ThuongNong += spb.ThuongNong;
ctu.NoKhuyenMai = (spb.TonKho >= ctu.SoLuong || DatTruoc || rdHangBanKem.Checked) ? 0 : ctu.SoLuong - spb.TonKho;
ctu.GhiChu = Common.Int2Bool(spb.ChietKhau) ? "CK" : (ctu.NoKhuyenMai > 0 ? "Nợ khuyến mại" : "");
ctu.SoLuongOld = ctu.SoLuong;
((BindingList <ChungTuBanHangChiTietInfor>)gSanPham.DataSource).ResetBindings();
}
else
{
//add san pham ban
ChungTuBanHangChiTietInfor ct = null;
if (rdHangBanKem.Checked)
{
ct = BanHangDataProvider.Instance.ConvertBG2SanPhamBan(spb);
}
else
{
ct = BanHangDataProvider.Instance.ConvertBG2SanPhamKM(spb);
ct.TyleVAT = Common.Int2Bool(spb.ChietKhau) ? spb.TyLeVAT : 0;
//if (liSanPhamSelected.Exists(delegate (ChungTuBanHangChiTietInfor match)
// {
// return
// match.MaSanPham.Equals(ct.MaSanPham) && match.LoaiHangKem == 0;
// }))
//{
// ct.TyleChietKhau = 0;
//}
}
ct.NoKhuyenMai = (spb.TonKho >= ct.SoLuong || DatTruoc || rdHangBanKem.Checked) ? 0 : ct.SoLuong - spb.TonKho;
ct.LoaiHangKem = isHangKem;
ct.TenLoaiHangKem = tenHangKem;
ct.IdSanPhamBan = CTu.IdSanPham;
ct.TenSanPhamBan = CTu.TenSanPham;
ct.GhiChu = Common.Int2Bool(spb.ChietKhau) ? "CK" : (ct.NoKhuyenMai > 0 ? "Nợ khuyến mại" : "");
ct.SoLuongOld = ct.SoLuong;
((BindingList <ChungTuBanHangChiTietInfor>)gSanPham.DataSource).Add(ct);
}
//spb.TonKho = spb.TonKho - 1;
}
}
catch (System.Exception ex)
{
#if DEBUG
//MessageBox.Show("Lỗi ngoại lệ: " + ex.ToString(), Declare.titleError, MessageBoxButtons.OK, MessageBoxIcon.Error);
#else
//MessageBox.Show("Lỗi ngoại lệ: " + ex.Message, Declare.titleError, MessageBoxButtons.OK, MessageBoxIcon.Error);
#endif
}
}
private void LoadSanPhamBanKem()
{
liSanPhamSelected = new List <ChungTuBanHangChiTietInfor>();
gSanPham.DataSource = new BindingList <ChungTuBanHangChiTietInfor>(liSanPhamSelected);
//foreach (ChungTuBanHangChiTietInfor ct in (BindingList<ChungTuBanHangChiTietInfor>)gSanPham.DataSource)
//{
// if (ct.LoaiHangKem==1)
// {
// ((BindingList<ChungTuBanHangChiTietInfor>) gSanPham.DataSource).Remove(ct);
// }
//}
foreach (BangGiaADSPKemInfor spk in (BindingList <BangGiaADSPKemInfor>)gSanPhamKem.DataSource)
{
if (spk.LoaiHangKem == 6)//neu la san pham va co du ton
{
if (spk.TrangThaiTon == 1)
{
BangGiaBanChiTietInfor spb;
spb = liBangGiaBan.Find(delegate(BangGiaBanChiTietInfor match)
{
return(match.MaSanPham.Equals(spk.MaHangKem));
});
if (spb == null)
{
spb = BangGiaDataProvider.Instance.GetGiaBan(IdTTamSelected, IdKhoSelected, spk.MaHangKem);
}
if (spb != null)
{
liBangGiaBan.Add(spb);
//add san pham ban
ChungTuBanHangChiTietInfor ct = BanHangDataProvider.Instance.ConvertBG2SanPhamBan(spb);
ct.Hang = spk.MaHangSX;
ct.LoaiHangKem = 1;
ct.TenLoaiHangKem = Declare.DescHangKem;
ct.SoLuong = spk.SoLuong;
ct.IdSanPhamBan = CTu.IdSanPham;
ct.TenSanPhamBan = CTu.TenSanPham;
ct.TyleChietKhau = spk.TyLeChietKhau;
double tienKM = spk.TyLeChietKhau == 0
? spk.TienChietKhau
: spk.TyLeChietKhau * ct.DonGiaCoVat * ct.SoLuong / 100;
double tienCK = spk.TienChietKhau == 0
? tienKM
: Common.MinValues(spk.TienChietKhau, tienKM);
ct.TienChietKhau = tienCK /**ct.SoLuong*/ / (1 + ct.TyleVAT / 100);
ct.TienSauChietKhau = ct.DonGia * ct.SoLuong - ct.TienChietKhau;
ct.TienVAT = ct.TienSauChietKhau * ct.TyleVAT / 100;
ct.ThanhTien = ct.DonGiaCoVat * ct.SoLuong - tienCK;
ct.TyLePhanBo = spk.TyLePhanBo / 100;
ct.SoLuongOld = ct.SoLuong;
((BindingList <ChungTuBanHangChiTietInfor>)gSanPham.DataSource).Add(ct);
}
else
{
spk.GhiChu = "Chưa có giá";
}
}
}
}
if (gKMChiTiet.DataSource == null)
{
return;
}
foreach (BangGiaADKhuyenMaiChiTietInfor kmct in (BindingList <BangGiaADKhuyenMaiChiTietInfor>)gKMChiTiet.DataSource)
{
//con ton hoac het ton nhung no khuyen mai
if (kmct.LoaiHangKM == 6)
{
//if (kmct.NoKhuyenMai == 0 || kmct.NoKhuyenMai > 0 && kmct.HetTonDungKM == 0 || DatTruoc) //neu la san pham
//{
BangGiaBanChiTietInfor spb;
spb = liBangGiaBan.Find(delegate(BangGiaBanChiTietInfor match)
{
return(match.MaSanPham.Equals(kmct.MaHangKM));
});
if (spb == null)
{
spb = BangGiaDataProvider.Instance.GetGiaBan(IdTTamSelected, IdKhoSelected, kmct.MaHangKM);
}
if (spb != null)
{
liBangGiaBan.Add(spb);
//add san pham ban
ChungTuBanHangChiTietInfor ct = BanHangDataProvider.Instance.ConvertBG2SanPhamKM(spb);
ct.CungDongDonHangChinh = kmct.InKemHD;
ct.Hang = kmct.MaHangSX;
ct.LoaiHangKem = 0;
ct.TenLoaiHangKem = Declare.DescKhuyenMai;
ct.SoLuong = DatTruoc ? kmct.SoLuong : kmct.SoLuong - kmct.NoKhuyenMai;
ct.NoKhuyenMai = DatTruoc ? 0 : kmct.NoKhuyenMai;
ct.IdSanPhamBan = CTu.IdSanPham;
ct.TenSanPhamBan = CTu.TenSanPham;
ct.TyleChietKhau = kmct.TyLeKM;
ct.TyleVAT = Common.Int2Bool(kmct.ChietKhau) ? CTu.TyleVAT /*spb.TyLeVAT*/ : 0;
double tienKM = kmct.TyLeKM == 0 ? kmct.SoTienKM : kmct.TyLeKM * CTu.DonGiaCoVat / 100;
double tienCK = kmct.SoTienKM == 0 ? tienKM : Common.MinValues(kmct.SoTienKM, tienKM);
ct.TienChietKhau = Common.Int2Bool(kmct.ChietKhau) ? -tienCK / (1 + ct.TyleVAT / 100) : 0;
ct.TienSauChietKhau = ct.TienChietKhau;
ct.ThanhTien = Common.Int2Bool(kmct.ChietKhau) ? -tienCK : tienCK;
ct.TienVAT = ct.TyleVAT * ct.ThanhTien / (100 + ct.TyleVAT);
ct.TyLeThanhToan = kmct.TyLeThanhToan;
ct.ThanhTien = ct.ThanhTien * kmct.TyLeThanhToan / 100;
ct.GhiChu = Common.Int2Bool(kmct.ChietKhau)
? "CK"
: (DatTruoc ? "Đặt trước" : (ct.NoKhuyenMai > 0 ? "Nợ khuyến mại" : ""));
ct.SoLuongOld = ct.SoLuong;
ct.SoLuongKhuyenMai = kmct.SoLuongOld;
((BindingList <ChungTuBanHangChiTietInfor>)gSanPham.DataSource).Add(ct);
}
else
{
kmct.GhiChu = "Chưa có giá";
}
//}
}
}
}
public void UpdateChiTietChungTu(ChungTuBanHangChiTietInfor chiTietChungTu)
{
BanHangDAO.Instance.UpdateChiTietChungTu(chiTietChungTu);
}
public void DeleteChiTietChungTu(ChungTuBanHangChiTietInfor chiTietChungTu)
{
BanHangDAO.Instance.DeleteChiTietChungTu(chiTietChungTu);
}
public int InsertChiTietChungTu(ChungTuBanHangChiTietInfor chiTietChungTu)
{
return(BanHangDAO.Instance.InsertChiTietChungTu(chiTietChungTu));
}
