public RecordIds(DbBase db, HluDataSet hluDataset, TableAdapterManager hluTableAdapterMgr, ViewModelWindowMain.GeometryTypes gisLayerType) { if (db == null) { throw new ArgumentException("db"); } if (hluDataset == null) { throw new ArgumentException("hluDataset"); } if (hluTableAdapterMgr == null) { throw new ArgumentException("hluTableAdapterMgr"); } _db = db; _hluDataset = hluDataset; _hluTableAdapterMgr = hluTableAdapterMgr; _gisLayerType = gisLayerType; if (_hluDataset.lut_last_incid.IsInitialized && _hluDataset.lut_last_incid.Count == 0) { if (_hluTableAdapterMgr.lut_last_incidTableAdapter == null) { _hluTableAdapterMgr.lut_last_incidTableAdapter = new HluTableAdapter <HluDataSet.lut_last_incidDataTable, HluDataSet.lut_last_incidRow>(_db); } _hluTableAdapterMgr.Fill(_hluDataset, new Type[] { typeof(HluDataSet.lut_last_incidDataTable) }, false); } _incidCurrentNumber = CurrentMaxIncidNumber(false); InitializeIncidChildRecordIds(); }
private void btnTimKiem_Click(object sender, EventArgs e) { TableAdapterManager tt = new TableAdapterManager(); DataTable table = new DataTable(); tt.Fill(table, cbDiemDi.SelectedValue.ToString(), cbDiemDen.SelectedValue.ToString(), dtpNgayDi.Value, cbLoaiVe.Text); dataGridView1.DataSource = table; }
private int CurrentMaxIncidNumber(bool increment) { try { int maxIncidNumber = 0; // check in-memory incid table if (_hluDataset.incid.Count > 0) { _hluDataset.incid.Max(r => IncidNumber(r.incid)); } // check lut_last_incid in DB _hluTableAdapterMgr.Fill(_hluDataset, typeof(HluDataSet.lut_last_incidDataTable), true); HluDataSet.lut_last_incidRow lastIncidRow = null; if (_hluDataset.lut_last_incid.Count > 0) { lastIncidRow = _hluDataset.lut_last_incid.ElementAt(_hluDataset.lut_last_incid.Count - 1); if (lastIncidRow.last_incid > maxIncidNumber) { maxIncidNumber = lastIncidRow.last_incid; } } // check DB incid table string sql = String.Format("SELECT MAX({0}) FROM {1}", _db.QuoteIdentifier(_hluDataset.incid.incidColumn.ColumnName), _db.QualifyTableName(_hluDataset.incid.TableName)); object result = _db.ExecuteScalar(sql, _db.Connection.ConnectionTimeout, CommandType.Text); int dbMax; if ((result != DBNull.Value) && (result != null) && ((dbMax = IncidNumber(result.ToString())) > maxIncidNumber)) { maxIncidNumber = dbMax; } if (increment) { // increment the greatest value found and save to lut_last_incid maxIncidNumber++; if (lastIncidRow != null) { lastIncidRow.last_incid = maxIncidNumber; } else { lastIncidRow = _hluDataset.lut_last_incid.Addlut_last_incidRow(maxIncidNumber); } _hluTableAdapterMgr.lut_last_incidTableAdapter.Update(lastIncidRow); } return(maxIncidNumber); } catch { return(-1); } }