private void btnDefault_Click(object sender, EventArgs e)
{
BangGiaChinhSachInfor chinhSach = (BangGiaChinhSachInfor)gvChinhSach.GetRow(gvChinhSach.FocusedRowHandle);
try
{
if (chinhSach != null && MessageBox.Show("Bạn có chắc chắn muốn thiết lập mặc định cho chính sách này không (Yes/No)?", "Cảnh báo", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
chinhSach.MacDinh = 1;
ChinhSachDataProvider.Instance.ThietLapMacDinhChinhSach(chinhSach);
((BindingList <BangGiaChinhSachInfor>)gChinhSach.DataSource).ResetBindings();
MessageBox.Show("Đã thiết lập chính sách khuyến mại mặc định thành công!");
}
}
catch (Exception ex)
{
EventLogProvider.Instance.WriteLog(ex.ToString()
+ "\nUser: "******"\nMay: " + Declare.TenMay,
this.Name);
#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 cmdGhiKM_Click(object sender, EventArgs e)
{
try
{
if (ValidKhuyenMai())
{
Chose = 1;
this.DialogResult = DialogResult.OK;
}
else if (liChinhSachDefault.Count > 0)
{
if (MessageBox.Show("Chính sách mặc định đang có hiệu lực. Bạn có đồng ý áp dụng không (Yes/No)?", "Cảnh báo", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
this.ChinhSachSelected = null;
this.liSanPhamSelected = new List <ChungTuBanHangChiTietInfor>();
Chose = 1;
this.DialogResult = DialogResult.OK;
}
}
}
catch (Exception e1)
{
MessageBox.Show(e1.Message);
}
}
public frmCS_List_ChinhSachKM_View(BangGiaChinhSachInfor chinhSach, List <BangGiaChinhSachInfor> liChinhSach, bool isView)
{
InitializeComponent();
Common.LoadStyle(this);
this.chinhSach = chinhSach;
this.liChinhSach = liChinhSach;
this.isView = isView;
}
private void ShowInfors(BangGiaChinhSachInfor chinhSach)
{
if (chinhSach != null)
{
tsslTrangThai.Text = chinhSach.DaDuyetTT;
tsslDraft.Text = Common.Int2Bool(chinhSach.Draft) ? "Bản nháp {chưa xác nhận}" : "";
}
}
private void EditOrder(int rowHandle)
{
if (rowHandle < 0)
{
return;
}
ChinhSach = (BangGiaChinhSachInfor)gvChinhSach.GetRow(rowHandle);
}
public void UpdateBangGiaChinhSach(BangGiaChinhSachInfor bgcs)
{
ExecuteCommand(Declare.StoreProcedureNamespace.spBangGiaChinhSachUpdate, bgcs.IdChinhSach, bgcs.SoChinhSach, bgcs.NgayLap,
bgcs.NguoiLap, bgcs.NgayHieuLuc, bgcs.HanHieuLuc, bgcs.GhiChu, bgcs.DuyNhatCMND, bgcs.DuyNhatSDT, bgcs.GioiTinh,
bgcs.DoTuoiTu, bgcs.DoTuoiDen, bgcs.GiaTriHDToiThieu, bgcs.IdNgheNghiep, bgcs.Draft, bgcs.IdTinh, bgcs.IdHuyen,
bgcs.CachGiaoHang, bgcs.GiaTriDHDaMua, bgcs.ThoiHanMua, bgcs.DoUuTien, bgcs.ThanhToanToiThieu, bgcs.SoKhachDauNgay,
bgcs.NguoiCapNhat, bgcs.LoaiDoiTuong, bgcs.MacDinh, bgcs.ChinhSachAD, bgcs.SieuThiAD, bgcs.DoiTuongAD, bgcs.ThoiGianAD,
bgcs.ThanhToanAD, bgcs.MotaKhac, bgcs.SoTienTToanToiThieu, bgcs.MatHangKhongApDung);
}
public int InsertBangGiaChinhSach(BangGiaChinhSachInfor bgcs)
{
ExecuteCommand(Declare.StoreProcedureNamespace.spBangGiaChinhSachInsert, bgcs.IdChinhSach, bgcs.SoChinhSach, bgcs.NgayLap,
bgcs.NguoiLap, bgcs.NgayHieuLuc, bgcs.HanHieuLuc, bgcs.GhiChu, bgcs.DuyNhatCMND, bgcs.DuyNhatSDT, bgcs.GioiTinh,
bgcs.DoTuoiTu, bgcs.DoTuoiDen, bgcs.GiaTriHDToiThieu, bgcs.IdNgheNghiep, bgcs.Draft, bgcs.IdTinh, bgcs.IdHuyen,
bgcs.CachGiaoHang, bgcs.GiaTriDHDaMua, bgcs.ThoiHanMua, bgcs.DoUuTien, bgcs.ThanhToanToiThieu, bgcs.SoKhachDauNgay,
bgcs.NguoiTao, bgcs.LoaiDoiTuong, bgcs.MacDinh, bgcs.ChinhSachAD, bgcs.SieuThiAD, bgcs.DoiTuongAD, bgcs.ThoiGianAD,
bgcs.ThanhToanAD, bgcs.MotaKhac, bgcs.SoTienTToanToiThieu, bgcs.MatHangKhongApDung);
return(Common.IntValue(Parameters["p_IdChinhSach"].Value));
}
private void gvListChungTu_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e)
{
if (gvChinhSach.FocusedRowHandle < 0)
{
return;
}
BangGiaChinhSachInfor chinhSach = (BangGiaChinhSachInfor)gvChinhSach.GetRow(gvChinhSach.FocusedRowHandle);
setEDFunctions(chinhSach);
ShowInfors(chinhSach);
}
protected void setEDFunctions(BangGiaChinhSachInfor chinhSach)
{
btnDefault.Enabled = (chinhSach != null) && (chinhSach.IdChinhSach > 0) && (chinhSach.MacDinh == 0) &&
(nguoiDung.TenDangNhap.Equals(chinhSach.NguoiTao) || nguoiDung.SupperUser == 1) && ConnectionUtil.Instance.IsUAT != 1;
btnStop.Enabled = (chinhSach != null) && (chinhSach.IdChinhSach > 0) && chinhSach.Draft == 0 &&
(chinhSach.DaDuyet == 1 || chinhSach.DaDuyet == -1) && (nguoiDung.TenDangNhap.Equals(chinhSach.NguoiTao) || nguoiDung.SupperUser == 1);
btnStop.Text = (chinhSach != null && chinhSach.DaDuyet == -1) ? "Kích hoạt(F11)" : "Tạm &dừng (F11)";
tsbEdit.Enabled = chinhSach != null && (nguoiDung.TenDangNhap.Equals(chinhSach.NguoiTao) &&
chinhSach.Draft == 1 || nguoiDung.SupperUser == 1);
tsbDelete.Enabled = chinhSach != null && (nguoiDung.TenDangNhap.Equals(chinhSach.NguoiTao) &&
chinhSach.Draft == 1 || nguoiDung.SupperUser == 1);
}
private void EditOrder(int rowHandle)
{
if (rowHandle < 0)
{
return;
}
BangGiaChinhSachInfor ct = (BangGiaChinhSachInfor)gvChinhSach.GetRow(rowHandle);
frmCS_LapChinhSachKM frm = new frmCS_LapChinhSachKM(ct);
frm.ShowDialog();
btnTimkiem_Click(null, null);
}
private void search()
{
frmCS_TimKiem_ChinhSachGia frm = new frmCS_TimKiem_ChinhSachGia(1);
if (frm.ShowDialog() == DialogResult.OK && frm.ChinhSach != null)
{
chinhSach = frm.ChinhSach;
//hien thi thong tin bang gia hien tai
LoadChinhSachInfor();
//Thiet lap trang thai item
Updating = false;
setEDItems();
setEDFunctions();
}
}
private void EditOrder(int rowHandle)
{
if (rowHandle < 0)
{
return;
}
ChinhSach = (BangGiaChinhSachInfor)gvChinhSach.GetRow(rowHandle);
if (KieuTimKiem > 0 && ChinhSach != null)
{
this.DialogResult = DialogResult.OK;
}
else
{
this.DialogResult = DialogResult.None;
frmCS_List_ChinhSachKM_View frm = new frmCS_List_ChinhSachKM_View(ChinhSach, liResult, true, this);
//frm.HideMenu();
frm.Show();
}
}
private void btnStop_Click(object sender, EventArgs e)
{
try
{
if (MessageBox.Show("Bạn có chắc chắn muốn dừng chính sách giá này không (Yes/No)?", "Cảnh báo", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
string msg = "";
if (chinhSach.DaDuyet == 1)
{
chinhSach.DaDuyet = -1;
msg = "Tạm dừng chính sách giá thành công!";
}
else if (chinhSach.DaDuyet == -1)
{
chinhSach.DaDuyet = 1;
msg = "Kích hoạt chính sách giá thành công!";
}
chinhSach.NguoiDuyet = nguoiDung.TenDangNhap;
ChinhSachDataProvider.Instance.DuyetBangGiaChinhSach(chinhSach);
BangGiaChinhSachInfor cs = ChinhSachDataProvider.Instance.GetBangGiaChinhSachInforById(chinhSach.IdChinhSach);
chinhSach.DaDuyetTT = cs.DaDuyetTT;
txtTrangThai.Text = chinhSach.DaDuyetTT;
Updating = false;
setEDItems();
setEDFunctions();
MessageBox.Show(msg);
}
}
catch (Exception ex)
{
EventLogProvider.Instance.WriteLog(ex.ToString()
+ "\nUser: "******"\nMay: " + Declare.TenMay,
this.Name);
#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 btnTruoc_Click(object sender, EventArgs e)
{
try
{
if (IndexBG > 0)
{
if (Updating)
{
if (MessageBox.Show("Dữ liệu đang cập nhật, bạn có muốn hủy bỏ không?", "Thông báo", MessageBoxButtons.YesNo) == DialogResult.No)
{
return;
}
}
IndexBG--;
IsAdded = false;
chinhSach = liChinhSach[IndexBG];
LoadChinhSachInfor();
Updating = false;
setEDItems();
setEDFunctions();
if (frmCS != null)
{
frmCS.setRowFocus(IndexBG);
}
}
}
catch (Exception ex)
{
EventLogProvider.Instance.WriteLog(ex.ToString()
+ "\nUser: "******"\nMay: " + Declare.TenMay,
this.Name);
#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 gvChinhSach_RowCellStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowCellStyleEventArgs e)
{
BangGiaChinhSachInfor cs = (BangGiaChinhSachInfor)gvChinhSach.GetRow(gvChinhSach.FocusedRowHandle);
if (cs != null)
{
if (e.Column.FieldName.Equals("DaDuyetTT"))
{
if (cs.DaDuyet == 0)
{
e.Appearance.BackColor = tsslChuaDuyetClr.BackColor;
e.Appearance.ForeColor = tsslChuaDuyetClr.ForeColor;
}
else if (cs.DaDuyet == -2)
{
e.Appearance.BackColor = tsslTuChoiClr.BackColor;
e.Appearance.ForeColor = tsslTuChoiClr.ForeColor;
}
}
}
}
private void btnStop_Click(object sender, EventArgs e)
{
BangGiaChinhSachInfor chinhSach = (BangGiaChinhSachInfor)gvChinhSach.GetRow(gvChinhSach.FocusedRowHandle);
try
{
if (chinhSach != null && MessageBox.Show("Bạn có chắc chắn muốn dừng chính sách giá này không (Yes/No)?", "Cảnh báo", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
string msg = "";
if (chinhSach.DaDuyet == 1)
{
chinhSach.DaDuyet = -1;
msg = "Tạm dừng chính sách giá thành công!";
}
else if (chinhSach.DaDuyet == -1)
{
chinhSach.DaDuyet = 1;
msg = "Kích hoạt chính sách giá thành công!";
}
chinhSach.NguoiDuyet = nguoiDung.TenDangNhap;
ChinhSachDataProvider.Instance.DuyetBangGiaChinhSach(chinhSach);
((BindingList <BangGiaChinhSachInfor>)gChinhSach.DataSource).ResetBindings();
MessageBox.Show(msg);
}
}
catch (Exception ex)
{
EventLogProvider.Instance.WriteLog(ex.ToString()
+ "\nUser: "******"\nMay: " + Declare.TenMay,
this.Name);
#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 frm_BangGia_Load(object sender, EventArgs e)
{
try
{
LoadAllDanhMuc();
if (liChinhSach == null || liChinhSach.Count == 0)
{
LoadAllBangGia();
}
//gan bang gia hien tai
if (chinhSach != null)
{
LoadIndexBG();
}
else if (liChinhSach.Count > 0)
{
IndexBG = 0;
chinhSach = liChinhSach[IndexBG];
}
//hien thi thong tin bang gia hien tai
LoadChinhSachInfor();
//Thiet lap trang thai item
Updating = false;
setEDItems();
setEDFunctions();
}
catch (Exception ex)
{
EventLogProvider.Instance.WriteLog(ex.ToString()
+ "\nUser: "******"\nMay: " + Declare.TenMay,
this.Name);
#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
}
}
public void UpdateBangGiaChinhSachNoDuyet(BangGiaChinhSachInfor bgcs)
{
ChinhSachGiaDAO.Instance.UpdateBangGiaChinhSachNoDuyet(bgcs);
}
public frmCS_DuyetChinhSachKMai(BangGiaChinhSachInfor chinhSach)
{
InitializeComponent();
Common.LoadStyle(this);
this.chinhSach = chinhSach;
}
private void gvChinhSach_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e)
{
if (gvChinhSach.FocusedRowHandle < 0 || !gChinhSach.Enabled)
{
return;
}
ChinhSachSelected = (BangGiaChinhSachInfor)gvChinhSach.GetRow(gvChinhSach.FocusedRowHandle);
if (ChinhSachSelected == null)
{
return;
}
gSanPhamKem.DataSource = new BindingList <BangGiaADSPKemInfor>();
gKhuyenMai.DataSource = new BindingList <BangGiaADKhuyenMaiInfor>();
gKMChiTiet.DataSource = new BindingList <BangGiaADKhuyenMaiChiTietInfor>();
tsslCSGStatus.Text = "Ghi chú: " + ChinhSachSelected.GhiChu;
//get sanpham mua kem
List <BangGiaADSPKemInfor> lstSPKem = new List <BangGiaADSPKemInfor>();
lstSPKem.AddRange(liSPKemDefault);
List <BangGiaADSPKemInfor> lstSPK = KhuyenMaiDataProvider.Instance.GetAllSanPhamKemADInfors(ChinhSachSelected.IdDKMua, IdKhoSelected);
foreach (BangGiaADSPKemInfor spk in lstSPK)
{
spk.GhiChu = String.Format("{0}", ChinhSachSelected.SoChinhSach);
lstSPKem.Add(spk);
}
gSanPhamKem.DataSource = new BindingList <BangGiaADSPKemInfor>(lstSPKem);
gSanPhamKem.Focus();
//get thanh toan
List <BangGiaADBankInfor> lstThanhToan = new List <BangGiaADBankInfor>();
lstThanhToan.AddRange(liThanhToan);
foreach (BangGiaADBankInfor tt in ChinhSachSelected.ListBangGiaADThanhToan)
{
tt.GhiChu = String.Format("{0}", ChinhSachSelected.SoChinhSach);
lstThanhToan.Add(tt);
}
gThanhToan.DataSource = new BindingList <BangGiaADBankInfor>(lstThanhToan);
if (lstSPKem.Count > 0 || lstThanhToan.Count == 0)
{
xtraTabControl1.SelectedTabPage = xtraTabPage1;
}
else if (lstThanhToan.Count > 0)
{
xtraTabControl1.SelectedTabPage = xtraTabPage2;
}
//get khuyen mai
List <BangGiaADKhuyenMaiInfor> lstKM = KhuyenMaiDataProvider.Instance.GetAllBangGiaKhuyenMaiADInfors(ChinhSachSelected.IdDKMua);
for (int i = 0; i < lstKM.Count; i++)
{
lstKM[i].ListKhuyenMaiChiTiet = KhuyenMaiDataProvider.Instance.GetAllKhuyenMaiChiTietADInfors(lstKM[i].IdKhuyenMai, IdKhoSelected, CTu.DonGiaCoVat);
}
gKhuyenMai.DataSource = new BindingList <BangGiaADKhuyenMaiInfor>(lstKM);
gKhuyenMai.Focus();
if (lstKM.Count > 0)
{
gvKhuyenMai.SelectRow(0);
gvKhuyenMai_FocusedRowChanged(sender, e);
}
else
{
gvKhuyenMai_FocusedRowChanged(sender, e);
}
LoadSanPhamBanKem();
LoadChinhSachInfor();
}
private void gvChinhSach_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e)
{
if (gvChinhSach.FocusedRowHandle < 0)
{
return;
}
ChinhSachSelected = (BangGiaChinhSachInfor)gvChinhSach.GetRow(gvChinhSach.FocusedRowHandle);
if (ChinhSachSelected == null)
{
return;
}
gKhuyenMai.DataSource = new BindingList <BangGiaADKhuyenMaiInfor>();
gKMChiTiet.DataSource = new BindingList <BangGiaADKhuyenMaiChiTietInfor>();
//get khuyen mai
List <BangGiaADKhuyenMaiInfor> lstKM = KhuyenMaiDataProvider.Instance.GetAllBangGiaKhuyenMaiADInfors(ChinhSachSelected.IdDKMua);
for (int i = 0; i < lstKM.Count; i++)
{
lstKM[i].ListKhuyenMaiChiTiet =
KhuyenMaiDataProvider.Instance.GetAllKhuyenMaiChiTietADTTInfors(lstKM[i].IdKhuyenMai, IdKhoSelected,
BangGiaChiTiet.DonGiaCoVAT);
}
gKhuyenMai.DataSource = new BindingList <BangGiaADKhuyenMaiInfor>(lstKM);
gKhuyenMai.Focus();
if (lstKM.Count > 0)
{
gvKhuyenMai.SelectRow(0);
}
List <BangGiaADDKMuaInfor> liDKMua = KhuyenMaiDataProvider.Instance.GetBangGiaADDKMuaInforsById(ChinhSachSelected.IdDKMua);
if (liDKMua != null && liDKMua.Count > 0)
{
double dt = (liDKMua[0].SoDiemThuong > 0)
? liDKMua[0].SoDiemThuong
: (liDKMua[0].TyLeDiemThuong > 0
? liDKMua[0].TyLeDiemThuong * BangGiaChiTiet.DonGiaCoVAT / 100
: 0);
string strDiemThuong = "0";
if (dt != 0)
{
strDiemThuong = Common.Double2Str(dt);
if (liDKMua[0].TyLeDiemThuong > 0)
{
strDiemThuong = String.Format("{0} ({1}%)", strDiemThuong, liDKMua[0].TyLeDiemThuong);
}
else
{
if (BangGiaChiTiet.DonGiaCoVAT > 0)
{
strDiemThuong = String.Format("{0} ({1}%)", strDiemThuong, Common.DoubleValueInt(dt * 100 / liDKMua[0].TyLeDiemThuong * BangGiaChiTiet.DonGiaCoVAT));
}
else
{
strDiemThuong = String.Format("{0}", strDiemThuong);
}
}
}
txtDiemThuong.Text = strDiemThuong;
txtTyleCK.Text = Common.Double2Str(liDKMua[0].TyLeChietKhau);
txtTienCK.Text = Common.Double2Str(liDKMua[0].TienChietKhau);
}
lblSieuThiAD.Text = ChinhSachSelected.LoaiDoiTuong == 1
? "chỉ áp dụng Online"
: (String.IsNullOrEmpty(ChinhSachSelected.SieuThiAD) || ChinhSachSelected.SieuThiAD.Trim().Equals("Tất cả")
? "tại tất cả siêu thị Trần Anh"
: String.Format("tại siêu thị {0}", ChinhSachSelected.SieuThiAD));
}
public void DuyetBangGiaChinhSach(BangGiaChinhSachInfor bgcs)
{
ExecuteCommand(Declare.StoreProcedureNamespace.spBangGiaChinhSachDuyet, bgcs.IdChinhSach, bgcs.DaDuyet, bgcs.NguoiDuyet);
}
public void ThietLapMacDinhChinhSach(BangGiaChinhSachInfor bgcs)
{
ExecuteCommand(Declare.StoreProcedureNamespace.spBangGiaChinhSachMacDinh, bgcs.IdChinhSach, bgcs.MacDinh);
}
public int InsertBangGiaChinhSachNoDuyet(BangGiaChinhSachInfor bgcs)
{
return(ChinhSachGiaDAO.Instance.InsertBangGiaChinhSachNoDuyet(bgcs));
}
public void ThietLapMacDinhChinhSach(BangGiaChinhSachInfor bgcs)
{
ChinhSachGiaDAO.Instance.ThietLapMacDinhChinhSach(bgcs);
}
public void DuyetBangGiaChinhSach(BangGiaChinhSachInfor bgcs)
{
ChinhSachGiaDAO.Instance.DuyetBangGiaChinhSach(bgcs);
}
