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(); }