public static void RecalculateBangThuTienKhoanThuList(LopKhoiTableAdapter lopKhoiTableAdapter,
KhoanThuHangNamTableAdapter khoanThuHangNamTableAdapter,
QLMamNon.Dao.QLMamNonDs.ViewBangThuTienRow viewBangThuTienRow)
{
int khoiId = StaticDataUtil.GetKhoiIdByLopId(lopKhoiTableAdapter, viewBangThuTienRow.LopId).Value;
int[] khoanThuIds = new int[] { BangThuTienConstant.KhoanThuIdBanTru, BangThuTienConstant.KhoanThuIdHocPhi, BangThuTienConstant.KhoanThuIdPhuPhi, BangThuTienConstant.KhoanThuIdTienAnSua, BangThuTienConstant.KhoanThuIdAnSang, BangThuTienConstant.KhoanThuIdAnToi };
QLMamNon.Dao.QLMamNonDs.KhoanThuHangNamDataTable khoanThuHangNamTable = khoanThuHangNamTableAdapter.GetKhoanThuHangNamByParams(String.Join(",", khoanThuIds), khoiId, viewBangThuTienRow.NgayTinh);
foreach (QLMamNon.Dao.QLMamNonDs.KhoanThuHangNamRow row in khoanThuHangNamTable)
{
long soTien = BangThuTienUtil.CalculateSoTienPhi(khoiId, viewBangThuTienRow.SXThangTruoc, row.SoTien, row.KhoanThuId);
switch (row.KhoanThuId)
{
case BangThuTienConstant.KhoanThuIdTienAnSua:
viewBangThuTienRow.TienAnSua = soTien;
break;
case BangThuTienConstant.KhoanThuIdPhuPhi:
viewBangThuTienRow.PhuPhi = soTien;
break;
case BangThuTienConstant.KhoanThuIdBanTru:
viewBangThuTienRow.BanTru = soTien;
break;
case BangThuTienConstant.KhoanThuIdHocPhi:
viewBangThuTienRow.HocPhi = soTien;
break;
default:
break;
}
}
viewBangThuTienRow.KhoanThuChinh = viewBangThuTienRow.TienAnSua + viewBangThuTienRow.PhuPhi + viewBangThuTienRow.BanTru + viewBangThuTienRow.HocPhi;
viewBangThuTienRow.ThanhTien = BangThuTienUtil.CalculateThanhTien(viewBangThuTienRow);
}
public static void EvaluateLopInfoForHocSinhTable(HocSinhLopTableAdapter hocSinhLopTableAdapter, QLMamNon.Dao.QLMamNonDs.HocSinhDataTable hocSinhTable)
{
List <int> hocSinhIds = new List <int>(hocSinhTable.Rows.Count);
foreach (QLMamNon.Dao.QLMamNonDs.HocSinhRow row in hocSinhTable)
{
hocSinhIds.Add(row.HocSinhId);
}
Dictionary <int, QLMamNon.Dao.QLMamNonDs.HocSinhLopRow> hocSinhIdsToHocSinhLops = StaticDataUtil.GetHocSinhLopsByHocSinhIds(hocSinhIds, DateTime.Now);
Dictionary <int, QLMamNon.Dao.QLMamNonDs.LopRow> hocSinhIdsToLops = StaticDataUtil.GetLopsByHocSinhIds(hocSinhIds, DateTime.Now);
foreach (QLMamNon.Dao.QLMamNonDs.HocSinhRow row in hocSinhTable)
{
if (hocSinhIdsToLops.ContainsKey(row.HocSinhId))
{
QLMamNon.Dao.QLMamNonDs.LopRow lop = hocSinhIdsToLops[row.HocSinhId];
row.LopDangHoc = lop.Name;
}
if (hocSinhIdsToHocSinhLops.ContainsKey(row.HocSinhId))
{
QLMamNon.Dao.QLMamNonDs.HocSinhLopRow hocSinhLop = hocSinhIdsToHocSinhLops[row.HocSinhId];
row.NgayVaoLop = hocSinhLop.DateJoin;
}
}
hocSinhTable.AcceptChanges();
}
