private void LoadDanhSachHoaDon()
{
try
{
HoaDonThuChiFilter _filter = new HoaDonThuChiFilter();
_filter.LoaiChungTuId = O2S_Common.TypeConvert.Parse.ToInt32(cboLoaiChungTu_TK.SelectedValue.ToString());
_filter.ThoiGianLap_Tu = date_TuNgay.DateTime;
_filter.ThoiGianLap_Den = date_DenNgay.DateTime;
this.lstHoaDonThuChi = HoaDonThuChiLogic.Select(_filter);
if (this.lstHoaDonThuChi != null && this.lstHoaDonThuChi.Count > 0)
{
decimal _tongthu = 0;
decimal _tongchi = 0;
for (int i = 0; i < this.lstHoaDonThuChi.Count; i++)
{
this.lstHoaDonThuChi[i].Stt = i + 1;
if (this.lstHoaDonThuChi[i].LoaiChungTuId == KeySetting.LOAICHUNGTU_PhieuThu)
{
_tongthu += this.lstHoaDonThuChi[i].SoTien ?? 0;
}
else
{
_tongchi += this.lstHoaDonThuChi[i].SoTien ?? 0;
this.lstHoaDonThuChi[i].SoTien = 0 - this.lstHoaDonThuChi[i].SoTien;
}
}
gridControlDSHoaDonThuChi.DataSource = this.lstHoaDonThuChi;
lblTongThu.Text = O2S_Common.Number.Convert.NumberToString(_tongthu, 0) + " đ";
lblTongChi.Text = O2S_Common.Number.Convert.NumberToString(_tongchi, 0) + " đ";
lblTonQuy.Text = O2S_Common.Number.Convert.NumberToString(_tongthu - _tongchi, 0) + " đ";
}
else
{
gridControlDSHoaDonThuChi.DataSource = null;
lblTongThu.Text = "0 đ";
lblTongChi.Text = "0 đ";
lblTonQuy.Text = "0 đ";
}
}
catch (Exception ex)
{
O2S_Common.Logging.LogSystem.Warn(ex);
}
}
public static List <HoaDonThuChi_PlusDTO> Select(HoaDonThuChiFilter _filter)
{
try
{
var query = (from obj in GlobalSettings.Database.HOADONTHUCHIs
select new HoaDonThuChi_PlusDTO
{
HoaDonThuChiId = obj.HoaDonThuChiId,
SoHoaDon = obj.SoHoaDon,
LoaiChungTuId = obj.LoaiChungTuId,
TenLoaiChungTu = obj.LOAICHUNGTU.TenLoaiChungTu,
ThoiGianLap = obj.ThoiGianLap,
TenNguoiLap = obj.TenNguoiLap,
SoTien = obj.SoTien,
NoiDung = obj.NoiDung,
GhiChu = obj.GhiChu,
IsRemove = obj.IsRemove,
CreatedDate = obj.CreatedDate,
CreatedBy = obj.CreatedBy,
CreatedLog = obj.CreatedLog,
ModifiedDate = obj.ModifiedDate,
ModifiedBy = obj.ModifiedBy,
ModifiedLog = obj.ModifiedLog,
}).ToList();
if (_filter.LoaiChungTuId != null && _filter.LoaiChungTuId != 0)
{
query = query.Where(o => o.LoaiChungTuId == _filter.LoaiChungTuId).ToList();
}
if (_filter.ThoiGianLap_Tu != null && _filter.ThoiGianLap_Den != null)
{
query = query.Where(o => o.ThoiGianLap >= _filter.ThoiGianLap_Tu && o.ThoiGianLap <= _filter.ThoiGianLap_Den).ToList();
}
return(query.ToList());
}
catch (System.Exception ex)
{
return(null);
O2S_Common.Logging.LogSystem.Error(ex);
}
}
