public static QLMamNon.Dao.QLMamNonDs.KhoiTruongRow GetKhoiTruongByKhoiId(KhoiTruongTableAdapter khoiTruongTableAdapter, Int32 khoiId) { if (khoiId < 0) { return(null); } QLMamNon.Dao.QLMamNonDs.KhoiTruongDataTable table = khoiTruongTableAdapter.GetDataByKhoiId(khoiId); if (table != null && table.Rows.Count > 0) { QLMamNon.Dao.QLMamNonDs.KhoiTruongRow row = table[0]; return(row); } return(null); }
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); } } } }