private void ReloadData()
{
ThreadHelper.LoadForm(() =>
{
CRUD.DisposeDb();
if (tabControl.SelectedTabPage == tabNhaCungCap)
{
_khachHangs = CRUD.DbContext.KhachHangs.Where(s => s.IsActived && s.LoaiKhachHang == _loaiKhachHang.ToString()).ToList();
gridControlKhachHang.DataSource = _khachHangs;
}
if (tabControl.SelectedTabPage == tabNhapKho)
{
var startDate = NhapKho_StartDate.Value;
var endDate = NhapKho_EndDate.Value;
_donHangs =
CRUD.DbContext.DonHangs
.Where(s => s.IsActived &&
s.LoaiDonHang == _loaiDonHang.ToString() &&
s.NgayLap >= startDate &&
s.NgayLap <= endDate)
.ToList();
gridControlNhapKho.DataSource = _donHangs;
}
if (tabControl.SelectedTabPage == tabCongNo)
{
ucCongNoList1.SetLoaiDonHang(_loaiDonHang, Define.LoaiTienTeEnum.VND);
}
if (tabControl.SelectedTabPage == tabCongNoUSD)
{
ucCongNoList2.SetLoaiDonHang(_loaiDonHang, Define.LoaiTienTeEnum.USD);
}
if (tabControl.SelectedTabPage == tabThanhToan)
{
var startDate = ThanhToan_StartDate.Value;
var endDate = ThanhToan_EndDate.Value;
_thanhToanCongNoes = CRUD.DbContext.ThanhToanCongNoes
.Where(s => s.IsActived &&
s.CongNo.IsActived &&
s.CongNo.LoaiDonHang == _loaiDonHang.ToString() &&
s.NgayThanhToan >= startDate &&
s.NgayThanhToan <= endDate).ToList();
gridControlThanhToan.DataSource = _thanhToanCongNoes;
}
});
}
public UcCongNoCu(Define.LoaiDonHangEnum loaiDonHang, Define.LoaiTienTeEnum loaiTienTe)
{
InitializeComponent();
CongNo_KhachHangId.DisplayMember = "Ten";
CongNo_KhachHangId.ValueMember = "Id";
var lstKhachHang = new List <KhachHang>();
if (loaiDonHang == Define.LoaiDonHangEnum.XuatKho)
{
lstKhachHang = CRUD.DbContext.KhachHangs.Where(s => s.LoaiKhachHang != Define.LoaiKhachHangEnum.NhaCungCap.ToString()).ToList();
lblKhachHangId.Text = "Khách Hàng";
}
else
{
lstKhachHang = CRUD.DbContext.KhachHangs.Where(s => s.LoaiKhachHang == Define.LoaiKhachHangEnum.NhaCungCap.ToString()).ToList();
}
CongNo_KhachHangId.DataSource = new BindingSource((lstKhachHang), null);
CongNo_LoaiTienTe.DisplayMember = "Value";
CongNo_LoaiTienTe.ValueMember = "Key";
CongNo_LoaiTienTe.DataSource = new BindingSource(Define.LoaiTienTeDict, null);
_domainData = new CongNo();
_domainData.NgayLap = TimeHelper.CurentDateTime();
_domainData.LoaiDonHang = loaiDonHang.ToString();
_domainData.LoaiTienTe = loaiTienTe.ToString();
Init(_domainData);
}
public override bool SaveData()
{
var validateResult = ValidateInput();
if (!string.IsNullOrEmpty(validateResult))
{
MessageBox.Show(validateResult);
return(false);
}
var saveData = CRUD.GetFormObject <CongNo>(FormControls);
CRUD.DecorateSaveData(saveData);
saveData.LoaiDonHang = _loaiDonHang.ToString();
CRUD.DbContext.CongNoes.AddOrUpdate(saveData);
CRUD.DbContext.SaveChanges();
return(true);
}
public UcDonHang(Define.LoaiDonHangEnum loaiDonHang, DonHang data = null)
{
InitializeComponent();
DonHang_KhachHangId.DisplayMember = "Ten";
DonHang_KhachHangId.ValueMember = "Id";
var lstKhachHang = new List <KhachHang>();
if (loaiDonHang == Define.LoaiDonHangEnum.XuatKho)
{
lstKhachHang = CRUD.DbContext.KhachHangs.Where(s => s.LoaiKhachHang != Define.LoaiKhachHangEnum.NhaCungCap.ToString()).ToList();
lblKhachHangId.Text = "Khách Hàng";
}
else
{
lstKhachHang = CRUD.DbContext.KhachHangs.Where(s => s.LoaiKhachHang == Define.LoaiKhachHangEnum.NhaCungCap.ToString()).ToList();
}
DonHang_KhachHangId.DataSource = new BindingSource((lstKhachHang), null);
DonHang_LoaiTienTe.DisplayMember = "Value";
DonHang_LoaiTienTe.ValueMember = "Key";
DonHang_LoaiTienTe.DataSource = new BindingSource(Define.LoaiTienTeDict, null);
_loaiDonHang = loaiDonHang;
_domainData = data;
if (_domainData == null)
{
_domainData = new DonHang();
_domainData.NgayLap = TimeHelper.CurentDateTime();
_domainData.LoaiDonHang = loaiDonHang.ToString();
_domainData.TrangThai = Define.TrangThaiDonHang.Moi.ToString();
_domainData.LoaiTienTe = Define.LoaiTienTeEnum.VND.ToString();
_domainData.TyGia = 1;
btnDelete.Visible = false;
btnIn.Visible = false;
GenerateMaDH();
}
else
{
_chiTietDonhang = new BindingList <ChiTietDonHang>(_domainData.ChiTietDonHangs.ToList());
if (_domainData.KhachHangId == Define.KhachLeId)
{
var khachLe = lstKhachHang.FirstOrDefault(s => s.Id == Define.KhachLeId);
if (khachLe != null)
{
khachLe.Ten = _domainData.Ten;
}
}
btnDelete.Visible = true;
_chiTietDonhang.ForEach(s => s.ListChiTietHangHoa = s.ChiTietHangHoas.ToList());
if (_domainData.TrangThai == Define.TrangThaiDonHang.ThanhToan.ToString())
{
btnSave.Enabled = false;
btnDelete.Visible = false;
_domainData.ThanhToan += _domainData.CongNoes.Where(l => l.IsActived).Sum(l => l.ThanhToan);
}
}
Init(_domainData);
// Get list hang hoa
var dataSource = CRUD.DbContext.KhoHangs
.Where(s => s.IsActived &&
(loaiDonHang == Define.LoaiDonHangEnum.NhapKho || s.SoLuong > 0))
.Select(s => new { s.TenHang, s.Id })
.Union(CRUD.DbContext.ChiTietDonHangs
.Where(s => _domainData.Id == s.DonHangId)
.Join(CRUD.DbContext.KhoHangs, ctdh => ctdh.HangHoaId, kh => kh.Id,
(ctdh, kh) => new { kh.TenHang, kh.Id })).ToList();
FormBehavior.DecoreateLookEdit(listHangHoa, dataSource, "TenHang");
listHangHoa.EditValueChanged += listHangHoa_EditValueChanged;
gridControlChiTiet.DataSource = _chiTietDonhang;
gridViewChiTiet.ActiveFilterString = string.Format("[IsActived] = '{0}'", true);
CheckDonHangUSD();
btnDeleteRow.ButtonClick += btnDeleteRow_ButtonClick;
UpdateTongTien();
UpdateNo();
}
public override bool SaveData()
{
var validateResult = ValidateInput();
if (!string.IsNullOrEmpty(validateResult))
{
MessageBox.Show(validateResult);
return(false);
}
var thanhToan = PrimitiveConvert.StringToInt(ThanhToanCongNo_ThanhToan.Text);
var no = PrimitiveConvert.StringToInt(CongNo_No.Text);
using (var transaction = new TransactionScope())
{
if (thanhToan > no)
{
foreach (var congNo in _congNoes)
{
CRUD.DecorateSaveData(congNo);
var tienThanhToan = thanhToan;
if (congNo.No >= thanhToan)
{
thanhToan = 0;
}
else
{
tienThanhToan = (long)congNo.No;
thanhToan -= (long)congNo.No;
}
congNo.No -= tienThanhToan;
var thanhToanCongNo = CRUD.GetFormObject <ThanhToanCongNo>(FormControls);
thanhToanCongNo.ThanhToan = tienThanhToan;
thanhToanCongNo.CongNoId = congNo.Id;
CRUD.DecorateSaveData(thanhToanCongNo);
CRUD.DbContext.ThanhToanCongNoes.Add(thanhToanCongNo);
if (thanhToan <= 0)
{
break;
}
}
CRUD.DbContext.SaveChanges();
}
else
{
// Update cong no
var congNo = CRUD.GetFormObject <CongNo>(FormControls);
congNo.DonHangId = _domainData.DonHangId;
congNo.KhachHangId = _domainData.KhachHangId;
congNo.NgayLap = _domainData.NgayLap;
congNo.LoaiDonHang = _loaiDonHang.ToString();
CRUD.DecorateSaveData(congNo, _domainData);
UpdateCongNo(congNo);
}
transaction.Complete();
}
return(true);
}