private void UCEditFormKhoiHoc_Enter(object sender, EventArgs e) { QLMamNon.Dao.QLMamNonDs.KhoiRow row = this.GridView.GetFocusedDataRow() as QLMamNon.Dao.QLMamNonDs.KhoiRow; if (row != null) { this.cmbTruong.EditValue = StaticDataUtil.GetTruongIdByKhoiId(this.khoiTruongTableAdapter, row.KhoiId); } }
public static string GetKhoiNameByKhoiId(Int32 khoiId) { if (khoiId < 0) { return(CommonConstant.EMPTY); } QLMamNon.Dao.QLMamNonDs.KhoiDataTable khoiTable = StaticDataFacade.Get(StaticDataKeys.KhoiHoc) as QLMamNon.Dao.QLMamNonDs.KhoiDataTable; QLMamNon.Dao.QLMamNonDs.KhoiRow khoiRow = khoiTable.FindByKhoiId(khoiId); if (khoiRow != null) { return(khoiRow.Name); } return(CommonConstant.EMPTY); }
protected override void onSaving() { DataTable table = this.DataTable.GetChanges(); if (table != null) { List <DataRow> deletedRow = new List <DataRow>(); List <DataRow> addedRow = new List <DataRow>(); List <DataRow> modifiedRow = new List <DataRow>(); foreach (DataRow row in table.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.KhoiRow khoiRow = row as QLMamNon.Dao.QLMamNonDs.KhoiRow; this.khoiTruongTableAdapter.DeleteKhoiTruongByKhoiId(khoiRow.KhoiId); } foreach (DataRow row in modifiedRow) { QLMamNon.Dao.QLMamNonDs.KhoiRow khoiRow = row as QLMamNon.Dao.QLMamNonDs.KhoiRow; QLMamNon.Dao.QLMamNonDs.KhoiTruongRow khoiTruongRow = StaticDataUtil.GetKhoiTruongByKhoiId(this.khoiTruongTableAdapter, khoiRow.KhoiId); if (khoiTruongRow != null) { this.khoiTruongTableAdapter.DeleteKhoiTruongByKhoiId(khoiRow.KhoiId); } if (!khoiRow.IsTruongIdNull()) { this.khoiTruongTableAdapter.Insert(khoiRow.KhoiId, khoiRow.TruongId); } } foreach (DataRow row in addedRow) { QLMamNon.Dao.QLMamNonDs.KhoiRow khoiRow = row as QLMamNon.Dao.QLMamNonDs.KhoiRow; if (!khoiRow.IsTruongIdNull()) { this.khoiTruongTableAdapter.Insert(khoiRow.KhoiId, khoiRow.TruongId); } } } }