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