public static Dictionary <int, QLMamNon.Dao.QLMamNonDs.HocSinhLopRow> GetHocSinhLopsByHocSinhIds(List <int> hocSinhIds, DateTime ngay) { if (ListUtil.IsEmpty(hocSinhIds)) { return(null); } HocSinhLopTableAdapter hocSinhLopTableAdapter = (HocSinhLopTableAdapter)StaticDataFacade.Get(StaticDataKeys.AdapterHocSinhLop); Dictionary <int, QLMamNon.Dao.QLMamNonDs.HocSinhLopRow> hocSinhIdsToHocSinhLops = new Dictionary <int, QLMamNon.Dao.QLMamNonDs.HocSinhLopRow>(); QLMamNon.Dao.QLMamNonDs.HocSinhLopDataTable table = hocSinhLopTableAdapter.GetHocSinhLopByHocSinhIdsAndNgay(StringUtil.Join(hocSinhIds, ","), ngay); if (!ListUtil.IsEmpty(table.Rows)) { foreach (QLMamNon.Dao.QLMamNonDs.HocSinhLopRow row in table) { if (!hocSinhIdsToHocSinhLops.ContainsKey(row.HocSinhId)) { hocSinhIdsToHocSinhLops.Add(row.HocSinhId, row); } } } return(hocSinhIdsToHocSinhLops); }
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(); }
public List <ViewBangThuTienRow> EvaluateViewBangThuTienRowsForReport(List <ViewBangThuTienRow> viewBangThuTienRows, DateTime toDate) { HashSet <int> hocSinhIds = new HashSet <int>(); foreach (ViewBangThuTienRow viewBangThuTienRow in viewBangThuTienRows) { if (!hocSinhIds.Contains(viewBangThuTienRow.HocSinhId)) { hocSinhIds.Add(viewBangThuTienRow.HocSinhId); } } LoggerFacade.Info(string.Format("EvaluateViewBangThuTienRowsForReport for list HocSinhIds=[{0}]", StringUtil.JoinWithCommas(hocSinhIds.ToList()))); HocSinhLopTableAdapter hocSinhLopTableAdapter = (HocSinhLopTableAdapter)StaticDataFacade.Get(StaticDataKeys.AdapterHocSinhLop); Dictionary <int, QLMamNon.Dao.QLMamNonDs.LopRow> hocSinhIdsToLopNames = StaticDataUtil.GetLopsByHocSinhIds(hocSinhIds.ToList(), toDate); HocSinhDataTable hocSinhDataTable = this.getHocSinhData(); foreach (ViewBangThuTienRow viewBangThuTienRow in viewBangThuTienRows) { viewBangThuTienRow.HoTen = StaticDataUtil.GetHocSinhFullNameByHocSinhId(hocSinhDataTable, viewBangThuTienRow.HocSinhId); if (hocSinhIdsToLopNames.ContainsKey(viewBangThuTienRow.HocSinhId)) { viewBangThuTienRow.Lop = hocSinhIdsToLopNames[viewBangThuTienRow.HocSinhId].Name; } } return(viewBangThuTienRows); }
private void FrmTaoPhieuThu_Load(object sender, EventArgs e) { HocSinhTableAdapter hocSinhTableAdapter = (HocSinhTableAdapter)StaticDataFacade.Get(StaticDataKeys.AdapterHocSinh); HocSinhLopTableAdapter hocSinhLopTableAdapter = (HocSinhLopTableAdapter)StaticDataFacade.Get(StaticDataKeys.AdapterHocSinhLop); QLMamNon.Dao.QLMamNonDs.HocSinhDataTable hocSinhTable = hocSinhTableAdapter.GetData(); ThongTinHocSinhUtil.EvaluateLopInfoForHocSinhTable(hocSinhLopTableAdapter, hocSinhTable); this.hocSinhRowBindingSource.DataSource = hocSinhTable; this.phanLoaiThuRowBindingSource.DataSource = StaticDataFacade.Get(StaticDataKeys.PhanLoaiThu); if (this.IsEditing) { this.loadPhieuThu(); } else { this.resetForm(); } }