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