public static string GetMaPhanLoaiChiNameByPhieuChiId(PhieuChiTableAdapter adapter, Int32 phieuChiId)
{
if (phieuChiId < 0)
{
return(CommonConstant.EMPTY);
}
QLMamNon.Dao.QLMamNonDs.PhieuChiDataTable phieChiTable = adapter.GetPhieuChiById(phieuChiId);
if (ListUtil.IsEmpty(phieChiTable.Rows))
{
return(CommonConstant.EMPTY);
}
QLMamNon.Dao.QLMamNonDs.PhieuChiRow phieChiRow = phieChiTable.Rows[0] as QLMamNon.Dao.QLMamNonDs.PhieuChiRow;
if (phieChiRow != null)
{
QLMamNon.Dao.QLMamNonDs.PhanLoaiChiDataTable table = StaticDataFacade.Get(StaticDataKeys.PhanLoaiChi) as QLMamNon.Dao.QLMamNonDs.PhanLoaiChiDataTable;
QLMamNon.Dao.QLMamNonDs.PhanLoaiChiRow[] rows = (QLMamNon.Dao.QLMamNonDs.PhanLoaiChiRow[])table.Select(String.Format("PhanLoaiChiId={0}", phieChiRow.PhanLoaiChiId));
if (!ArrayUtil.IsEmpty(rows))
{
return(rows[0].MaPhanLoai);
}
}
return(CommonConstant.EMPTY);
}
public QLMamNon.Dao.QLMamNonDs.PhieuChiDataTable LoadPhieuChi(PhieuChiTableAdapter phieuChiTableAdapter)
{
QLMamNon.Dao.QLMamNonDs.PhieuChiDataTable table = phieuChiTableAdapter.GetData();
fillPhanLoaiChiForPhieuChiRows(phieuChiTableAdapter, table);
return(table);
}
public QLMamNon.Dao.QLMamNonDs.PhieuChiDataTable LoadPhieuChiByDateRangeWithGroupPhanLoaiChi(DateTime?fromDate, DateTime?toDate, List <int> phanLoaiChiIds)
{
PhieuChiTableAdapter phieuChiTableAdapter = (PhieuChiTableAdapter)StaticDataFacade.Get(StaticDataKeys.AdapterPhieuChi);
QLMamNon.Dao.QLMamNonDs.PhieuChiDataTable table = phieuChiTableAdapter.GetDataByByDateRangeWithGroupPhanLoaiChi(fromDate, toDate, StringUtil.JoinWithCommas(phanLoaiChiIds));
return(table);
}
private void addPhieuChiToReport(SortedList soQuyTienMatMap, DateTime fromDate, DateTime toDate, List <int> phanLoaiChiIds)
{
PhieuChiService phieuChiService = new PhieuChiService();
QLMamNon.Dao.QLMamNonDs.PhieuChiDataTable phieuChiDataTable = phieuChiService.LoadPhieuChiByDateRange(fromDate, toDate, phanLoaiChiIds);
foreach (QLMamNon.Dao.QLMamNonDs.PhieuChiRow phieuChiRow in phieuChiDataTable)
{
SoQuyTienMatItem soQuyTienMatItemChi = new SoQuyTienMatItem()
{
DienGiai = phieuChiRow.NoiDung,
GhiChu = phieuChiRow.GhiChu,
NgayChungTu = phieuChiRow.Ngay.AddMilliseconds(soQuyTienMatMap.Count),
SoChungTuChi = phieuChiRow.MaPhieu,
SoTienChi = phieuChiRow.SoTien
};
soQuyTienMatMap.Add(soQuyTienMatItemChi.NgayChungTu, soQuyTienMatItemChi);
}
}
private static void fillPhanLoaiChiForPhieuChiRows(PhieuChiTableAdapter phieuChiTableAdapter, QLMamNon.Dao.QLMamNonDs.PhieuChiDataTable table)
{
foreach (QLMamNon.Dao.QLMamNonDs.PhieuChiRow row in table)
{
row.PhanLoaiChi = StaticDataUtil.GetMaPhanLoaiChiNameByPhieuChiId(phieuChiTableAdapter, row.PhieuChiId);
}
}
