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();
}
protected override void onSaving()
{
if (this.DataTable != null)
{
List <DataRow> deletedRow = new List <DataRow>();
List <DataRow> addedRow = new List <DataRow>();
List <DataRow> modifiedRow = new List <DataRow>();
foreach (DataRow row in this.DataTable.Rows)
{
if (row.RowState == DataRowState.Deleted)
{
deletedRow.Add(row);
}
else if (row.RowState == DataRowState.Added)
{
addedRow.Add(row);
}
if (row.RowState == DataRowState.Modified)
{
modifiedRow.Add(row);
}
}
base.onSaving();
foreach (DataRow row in deletedRow)
{
QLMamNon.Dao.QLMamNonDs.LopRow lopRow = row as QLMamNon.Dao.QLMamNonDs.LopRow;
this.lopKhoiTableAdapter.DeleteLopKhoiByLopId(lopRow.LopId);
}
foreach (DataRow row in modifiedRow)
{
QLMamNon.Dao.QLMamNonDs.LopRow lopRow = row as QLMamNon.Dao.QLMamNonDs.LopRow;
int?khoiId = StaticDataUtil.GetKhoiIdByLopId(this.lopKhoiTableAdapter, lopRow.LopId);
if (khoiId != null)
{
this.lopKhoiTableAdapter.DeleteLopKhoiByLopId(lopRow.LopId);
}
if (!lopRow.IsKhoiIdNull())
{
this.lopKhoiTableAdapter.Insert(lopRow.LopId, lopRow.KhoiId);
}
}
foreach (DataRow row in addedRow)
{
QLMamNon.Dao.QLMamNonDs.LopRow lopRow = row as QLMamNon.Dao.QLMamNonDs.LopRow;
if (!lopRow.IsKhoiIdNull())
{
this.lopKhoiTableAdapter.Insert(lopRow.LopId, lopRow.KhoiId);
}
}
}
}
private void UCEditFormLopHoc_Enter(object sender, EventArgs e)
{
QLMamNon.Dao.QLMamNonDs.LopRow row = this.GridView.GetFocusedDataRow() as QLMamNon.Dao.QLMamNonDs.LopRow;
if (row != null)
{
this.cmbKhoi.EditValue = StaticDataUtil.GetKhoiIdByLopId(this.lopKhoiTableAdapter, row.LopId);
}
}
public static string GetLopNameByLopId(Int32 lopId)
{
if (lopId < 0)
{
return(CommonConstant.EMPTY);
}
QLMamNon.Dao.QLMamNonDs.LopDataTable lopTable = StaticDataFacade.Get(StaticDataKeys.LopHoc) as QLMamNon.Dao.QLMamNonDs.LopDataTable;
QLMamNon.Dao.QLMamNonDs.LopRow lopRow = lopTable.FindByLopId(lopId);
if (lopRow != null)
{
return(lopRow.Name);
}
return(CommonConstant.EMPTY);
}
