void CongNoHienTai()
{
eCongNoNhaCungCap congNo = clsFunction.GetItem <eCongNoNhaCungCap>("NhapHangNhaCungCap/CongNoHienTai", _aEntry.KeyID, slokNhaCungCap.ToInt32(), dteNgayNhap.DateTime.ToJson());
spnNoCu.Value = congNo.ConLai;
CapNhatSoTien();
}
public eCongNoNhaCungCap CongNoHienTai(int IDMaster, int IDNhaCungCap, DateTime NgayHienTai)
{
try
{
Instance.Context = new Model.aModel();
IEnumerable <eCongNoNhaCungCap> lstCongNo = Instance.Context.eCongNoNhaCungCap.Where(x => x.IDNhaCungCap == IDNhaCungCap);
lstCongNo = lstCongNo.Where(x => x.Ngay.Date <= NgayHienTai.Date);
eCongNoNhaCungCap congNo = lstCongNo.FirstOrDefault(x => x.IDMaster == IDMaster) ?? new eCongNoNhaCungCap();
congNo.ConLai = lstCongNo.Where(x => x.IDMaster != IDMaster).ToList().Sum(x => x.ConLai);
return(congNo);
}
catch { return(new eCongNoNhaCungCap()); }
}
async Task CapNhatCongNo(eNhapHangNhaCungCap[] Items)
{
foreach (eNhapHangNhaCungCap item in Items)
{
eCongNoNhaCungCap congNo = await Instance.Context.eCongNoNhaCungCap.FirstOrDefaultAsync(x => x.IsNhapHang && x.IDMaster == item.KeyID);
if (congNo == null)
{
congNo = new eCongNoNhaCungCap();
congNo.IDNhaCungCap = item.IDNhaCungCap;
congNo.IDMaster = item.KeyID;
congNo.NguoiTao = item.NguoiTao;
congNo.MaNguoiTao = item.MaNguoiTao;
congNo.TenNguoiTao = item.TenNguoiTao;
congNo.NgayTao = item.NgayTao;
congNo.IsNhapHang = true;
Instance.Context.eCongNoNhaCungCap.AddOrUpdate(congNo);
}
else
{
congNo.NguoiCapNhat = item.NguoiCapNhat;
congNo.MaNguoiCapNhat = item.MaNguoiCapNhat;
congNo.TenNguoiCapNhat = item.TenNguoiCapNhat;
congNo.NgayCapNhat = item.NgayCapNhat;
}
congNo.MaNhaCungCap = item.MaNhaCungCap;
congNo.TenNhaCungCap = item.TenNhaCungCap;
congNo.TrangThai = item.TrangThai;
congNo.Ngay = item.NgayNhap;
congNo.ThanhTien = item.ThanhTien;
congNo.VAT = item.VAT;
congNo.TienVAT = item.TienVAT;
congNo.CK = item.ChietKhau;
congNo.TienCK = item.TienChietKhau;
congNo.TongTien = item.TongTien;
congNo.NoCu = item.NoCu;
congNo.ThanhToan = item.ThanhToan;
congNo.ConLai = item.ConLai;
congNo.GhiChu = item.GhiChu;
}
}
