public frmCS_BangGia_ViewKhuyenMai(List <BangGiaChinhSachInfor> lics, BangGiaChiTietInfor bgct) { InitializeComponent(); Common.LoadStyle(this); this.liChinhSach = lics; this.BangGiaChiTiet = bgct; }
public void UpdateBangGiaChiTiet(BangGiaChiTietInfor bgct) { ExecuteCommand(Declare.StoreProcedureNamespace.spBangGiaChiTietUpdate, bgct.IdChiTiet, bgct.IdBangGia, bgct.IdSanPham, bgct.GiaNhapHDCuoi, bgct.GiaTonKhoBQ, bgct.TienChietKhauQK, bgct.TienKhuyenMai, bgct.TyLeLNBQ, bgct.DungSaiMin, bgct.DungSaiMax, bgct.GiaMin, bgct.GiaMax, bgct.GiaBanAnToan, bgct.DonGiaChuaVAT, bgct.SoLuongBanBQ, bgct.DungSaiSLBQ, bgct.TyLeChietKhau, bgct.TienChietKhau, bgct.TyLeVAT, bgct.TienVAT, bgct.DonGiaCoVAT, bgct.TyLeThuong, bgct.ThuongNong, bgct.NguoiCapNhat, bgct.GiaNiemYet, bgct.GiaWebSite, bgct.LoiNhuan, bgct.LoiNhuanTon, bgct.GiaBanBuon, bgct.LoiNhuanBB, bgct.LoiNhuanTonBB, bgct.DaDuyet, bgct.IdNhomDuyet, bgct.NhomDuyet, bgct.GiaNhapDemoCuoi, bgct.GiaBanDemo, bgct.LoiNhuanDemo, bgct.KhuyenMai, bgct.IdDKMua); }
private void gvSanPham_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { if (gvSanPham.FocusedRowHandle < 0) { return; } if (e.Column.FieldName == "DonGiaCoVAT" || e.Column.FieldName == "GiaBanBuon" || e.Column.FieldName == "ThuongNong") { BangGiaChiTietInfor bgct = (BangGiaChiTietInfor)gvSanPham.GetRow(gvSanPham.FocusedRowHandle); UpdateDataValue(bgct); UpdateTongLoiNhuan(); } }
public void UpdateGiaNhap2BGiaCTiet(BangGiaNhapChiTietInfor gn, ref BangGiaChiTietInfor ct) { ct.IdSanPham = gn.IdSanPham; ct.MaSanPham = gn.MaSanPham; ct.TenSanPham = gn.TenSanPham; ct.DonViTinh = gn.DonViTinh; ct.LoaiSanPham = gn.LoaiSanPham; ct.GiaNhapHDCuoi = gn.GiaNhapHDCuoi; ct.GiaTonKhoBQ = gn.GiaTonKhoBQ; ct.TienChietKhauQK = gn.TienChietKhauQK; ct.TyLeLNBQ = gn.TyLeLNBQ; ct.SoLuongBanBQ = gn.SoLuongBanBQ; ct.GiaNhapDemoCuoi = gn.GiaNhapDemoCuoi; }
private void LoadChinhSachGia() { try { BangGiaChiTietInfor bgct = (BangGiaChiTietInfor)gvSanPham.GetRow(gvSanPham.FocusedRowHandle); List <BangGiaChinhSachInfor> liChinhSach = ChinhSachDataProvider.Instance.GetAllChinhSachDaApDung(bangGia.IdTrungTam, bgct.MaSanPham, mstNgayLap.Value); if (liChinhSach != null && liChinhSach.Count > 0) { frmCS_BangGia_ViewKhuyenMai frm = new frmCS_BangGia_ViewKhuyenMai(liChinhSach, bgct); frm.ShowDialog(); } } catch { } }
private void ChinhSachApDung_Click(object sender, EventArgs e) { BangGiaBanChiTietBCInfor bgInfor = (BangGiaBanChiTietBCInfor)gvListSanPham.GetFocusedRow(); if (bgInfor != null) { int idTrungTam = bteTrungTam.Tag != null ? ((DMTrungTamInfor)bteTrungTam.Tag).IdTrungTam : Declare.IdTrungTam; DateTime ngayLap = CommonProvider.Instance.GetSysDate(); List <BangGiaChinhSachInfor> liCSachs = ChinhSachDataProvider.Instance.GetAllChinhSachDaApDung(idTrungTam, bgInfor.MaSanPham, ngayLap); List <BangGiaChinhSachInfor> liChinhSach = new List <BangGiaChinhSachInfor>(); foreach (BangGiaChinhSachInfor cs in liCSachs) { string lstMatHangKhongAD = String.Format(",{0},", cs.MatHangKhongApDung);//khong nam trong danh sach ko duoc ap dung if (!lstMatHangKhongAD.Contains(String.Format(",{0},", bgInfor.IdSanPham))) { liChinhSach.Add(cs); } } //List<BangGiaChinhSachInfor> liChinhSach = // ChinhSachDataProvider.Instance.GetAllChinhSachDaApDung(bgInfor.IdTrungTam, bgInfor.MaSanPham, // CommonProvider.Instance.GetSysDate()); if (liChinhSach != null && liChinhSach.Count > 0) { BangGiaChiTietInfor bgct = new BangGiaChiTietInfor() { MaSanPham = bgInfor.MaSanPham, TenSanPham = bgInfor.TenSanPham, DonViTinh = bgInfor.TenDonViTinh, DonGiaCoVAT = bgInfor.DonGiaCoVAT }; frmCS_BangGia_ViewKhuyenMai frm = new frmCS_BangGia_ViewKhuyenMai(liChinhSach, bgct); frm.ShowDialog(); } else { MessageBox.Show("Không có chính sách giá cho sản phẩm này!"); } } }
//private void UpdateAllDataValue() //{ // double tongLoiNhuan = 0; // if (gSanPham.DataSource == null) return; // foreach (BangGiaChiTietInfor bgct in (BindingList<BangGiaChiTietInfor>)gSanPham.DataSource) // { // bgct.TienKhuyenMai = CommonFuns.Instance.GetTienKhuyenMai(bangGia.IdTrungTam, bgct.MaSanPham, Common.MaxValues(bgct.DonGiaCoVAT, bgct.GiaBanBuon, bgct.GiaBanDemo)); // bgct.GiaMin = (bgct.GiaNhapHDCuoi - bgct.TienChietKhauQK + bgct.TienKhuyenMai) * // (1 + bgct.TyLeLNBQ * (1 - bgct.DungSaiMin / 100) / 100); // bgct.GiaMax = (bgct.GiaNhapHDCuoi - bgct.TienChietKhauQK + bgct.TienKhuyenMai) * // (1 + bgct.TyLeLNBQ * (1 + bgct.DungSaiMax / 100) / 100); // bgct.GiaBanAnToan = (bgct.GiaNhapHDCuoi - bgct.TienChietKhauQK + bgct.TienKhuyenMai) * // (1 + bgct.TyLeLNBQ / 100); // bgct.DonGiaChuaVAT = bgct.DonGiaCoVAT / (1 + bgct.TyLeVAT / 100) / (1 - bgct.TyLeChietKhau / 100); // bgct.TienChietKhau = bgct.DonGiaChuaVAT * bgct.TyLeChietKhau / 100; // bgct.TienVAT = bgct.DonGiaCoVAT - bgct.DonGiaChuaVAT + bgct.TienChietKhau; // bgct.LoiNhuan = bgct.DonGiaChuaVAT - bgct.GiaNhapHDCuoi + bgct.TienChietKhauQK - bgct.TienKhuyenMai - bgct.ThuongNong;// * bgct.SoLuongBanBQ * (1 + bgct.DungSaiSLBQ / 100); // bgct.LoiNhuanTon = bgct.DonGiaChuaVAT - bgct.GiaTonKhoBQ + bgct.TienChietKhauQK - bgct.TienKhuyenMai - bgct.ThuongNong; // //bgct.GiaNiemYet = bgct.DonGiaCoVAT; // //bgct.GiaWebSite = bgct.DonGiaCoVAT; // double giaBanBuonChuaVat = bgct.GiaBanBuon / (1 + bgct.TyLeVAT / 100) / (1 - bgct.TyLeChietKhau / 100); // bgct.LoiNhuanBB = giaBanBuonChuaVat - bgct.GiaNhapHDCuoi + bgct.TienChietKhauQK - bgct.TienKhuyenMai - bgct.ThuongNong;// * bgct.SoLuongBanBQ * (1 + bgct.DungSaiSLBQ / 100); // bgct.LoiNhuanTon = giaBanBuonChuaVat - bgct.GiaTonKhoBQ + bgct.TienChietKhauQK - bgct.TienKhuyenMai - bgct.ThuongNong; // //tinh thuong nhan vien // bgct.TyLeThuong = (bgct.DonViDoanhThu != 0 ? bgct.DonGiaCoVAT * bgct.TrongSoDoanhThu / bgct.DonViDoanhThu : 0) + // (bgct.DonViLoiNhuan != 0 // ? (bgct.DonGiaChuaVAT - bgct.TienChietKhau - bgct.TienKhuyenMai - // bgct.GiaTonKhoBQ) * // bgct.TrongSoLoiNhuan / bgct.DonViLoiNhuan // : 0) + // (bgct.DonViKhoanTon != 0 // ? bgct.TonKho * bgct.GiaTonKhoBQ * bgct.TrongSoKhoanTon / bgct.DonViKhoanTon // : 0); // if (bgct.DonGiaChuaVAT > bgct.GiaMax || bgct.DonGiaChuaVAT < bgct.GiaMin) // { // //Common.SetGridViewRowErrorStyle(dgvSanPham.CurrentRow); // bgct.DaDuyet = 0; // } // else // { // //Common.SetGridViewRowStyle(dgvSanPham.CurrentRow); // bgct.DaDuyet = 1; // } // //update loi nhuan // tongLoiNhuan += bgct.LoiNhuan; // } // //((BindingList<BangGiaChiTietInfor>)dgvSanPham.DataSource).ResetBindings(); // txtTongLoiNhuan.Text = Common.Double2Str(tongLoiNhuan); //} private void UpdateDataValue(BangGiaChiTietInfor bgct) { if (bgct == null) { return; } bgct.TienKhuyenMai = CommonFuns.Instance.GetTienKhuyenMai(bangGia.IdTrungTam, bgct.MaSanPham, mstNgayLap.Value, Common.MaxValues(bgct.DonGiaCoVAT, bgct.GiaBanBuon, bgct.GiaBanDemo, bgct.GiaNhapDemoCuoi, bgct.GiaTonKhoBQ, bgct.GiaNhapHDCuoi)); bgct.GiaMin = (bgct.GiaNhapHDCuoi - bgct.TienChietKhauQK + bgct.TienKhuyenMai) * (1 + bgct.TyLeLNBQ * (1 - bgct.DungSaiMin / 100) / 100); bgct.GiaMax = (bgct.GiaNhapHDCuoi - bgct.TienChietKhauQK + bgct.TienKhuyenMai) * (1 + bgct.TyLeLNBQ * (1 + bgct.DungSaiMax / 100) / 100); bgct.GiaBanAnToan = (bgct.GiaNhapHDCuoi - bgct.TienChietKhauQK + bgct.TienKhuyenMai) * (1 + bgct.TyLeLNBQ / 100); bgct.DonGiaChuaVAT = bgct.DonGiaCoVAT / (1 + bgct.TyLeVAT / 100) / (1 - bgct.TyLeChietKhau / 100); bgct.TienChietKhau = bgct.DonGiaChuaVAT * bgct.TyLeChietKhau / 100; bgct.TienVAT = bgct.DonGiaCoVAT - bgct.DonGiaChuaVAT + bgct.TienChietKhau; //bgct.DonGiaCoVAT = bgct.DonGiaChuaVAT - bgct.TienChietKhau + bgct.TienVAT; bgct.LoiNhuan = bgct.DonGiaChuaVAT - bgct.GiaNhapHDCuoi + bgct.TienChietKhauQK - bgct.TienKhuyenMai - bgct.ThuongNong;// * bgct.SoLuongBanBQ * (1 + bgct.DungSaiSLBQ / 100); bgct.LoiNhuanTon = bgct.DonGiaChuaVAT - bgct.GiaTonKhoBQ + bgct.TienChietKhauQK - bgct.TienKhuyenMai - bgct.ThuongNong; bgct.GiaNiemYet = bgct.DonGiaCoVAT; bgct.GiaWebSite = bgct.DonGiaCoVAT; double giaBanBuonChuaVat = bgct.GiaBanBuon / (1 + bgct.TyLeVAT / 100) / (1 - bgct.TyLeChietKhau / 100); bgct.LoiNhuanBB = giaBanBuonChuaVat - bgct.GiaNhapHDCuoi + bgct.TienChietKhauQK - bgct.TienKhuyenMai - bgct.ThuongNong;// * bgct.SoLuongBanBQ * (1 + bgct.DungSaiSLBQ / 100); bgct.LoiNhuanTon = giaBanBuonChuaVat - bgct.GiaTonKhoBQ + bgct.TienChietKhauQK - bgct.TienKhuyenMai - bgct.ThuongNong; BangGiaNhomNguoiDuyetInfor nnd = BangGiaDataProvider.Instance.GetNhomNguoiDuyetBangGiaInfor(bgct.MaSanPham, bgct.DonGiaChuaVAT, bgct.GiaNhapHDCuoi, bgct.TienChietKhauQK, bgct.TienKhuyenMai, bgct.TyLeLNBQ); if (nnd != null) { bgct.IdNhomDuyet = nnd.IdNhomNguoiDung; bgct.NhomDuyet = nnd.TenNhomNguoiDung; } else { bgct.IdNhomDuyet = 0; bgct.NhomDuyet = "Chưa phân nhóm duyệt"; } //tinh thuong nhan vien bgct.TyLeThuong = (bgct.DonViDoanhThu != 0 ? bgct.DonGiaCoVAT * bgct.TrongSoDoanhThu / bgct.DonViDoanhThu : 0) + (bgct.DonViLoiNhuan != 0 ? (bgct.DonGiaChuaVAT - bgct.TienChietKhau - bgct.TienKhuyenMai - bgct.GiaTonKhoBQ) * bgct.TrongSoLoiNhuan / bgct.DonViLoiNhuan : 0) + (bgct.DonViKhoanTon != 0 ? bgct.TonKho * bgct.GiaTonKhoBQ * bgct.TrongSoKhoanTon / bgct.DonViKhoanTon : 0); if (bgct.DonGiaChuaVAT > bgct.GiaMax || bgct.DonGiaChuaVAT < bgct.GiaMin) { //Common.SetGridViewRowErrorStyle(dgvSanPham.CurrentRow); bgct.DaDuyet = 0; } else { //Common.SetGridViewRowStyle(dgvSanPham.CurrentRow); bgct.DaDuyet = 1; } //update lai datagrid //((BindingList<BangGiaChiTietInfor>)dgvSanPham.DataSource).ResetBindings(); //UpdateTongLoiNhuan(); }
public void DuyetBangGiaChiTiet(BangGiaChiTietInfor bgct) { BangGiaDAO.Instance.DuyetBangGiaChiTiet(bgct); }
public void DeleteBangGiaChiTiet(BangGiaChiTietInfor bgct) { BangGiaDAO.Instance.DeleteBangGiaChiTiet(bgct); }
public int InsertBangGiaChiTiet(BangGiaChiTietInfor bgct) { return(BangGiaDAO.Instance.InsertBangGiaChiTiet(bgct)); }
public void UpdateBangGiaChiTiet(BangGiaChiTietInfor bgct) { BangGiaDAO.Instance.UpdateBangGiaChiTiet(bgct); }
public void DuyetBangGiaChiTiet(BangGiaChiTietInfor bgct) { ExecuteCommand(Declare.StoreProcedureNamespace.spBangGiaChiTietDuyet, bgct.IdChiTiet, bgct.NguoiDuyet, bgct.DaDuyet, bgct.IdBangGia); }
public void DeleteBangGiaChiTiet(BangGiaChiTietInfor bgct) { ExecuteCommand(Declare.StoreProcedureNamespace.spBangGiaChiTietDelete, bgct.IdChiTiet); }