public bool Load(string conjuction) { bool loaded = false; DataTable dt = null; try { if ((_aggregateParameters == null || _aggregateParameters.Count <= 0) && _resultColumns.Length <= 0 && _countAll == false) { this._entity._canSave = true; } this._entity.OnQueryLoad(conjuction); IDbCommand cmd = _Load(conjuction); _lastQuery = cmd.CommandText; IDbDataAdapter da = this._entity.CreateIDbDataAdapter(); da.SelectCommand = cmd; TransactionMgr txMgr = TransactionMgr.ThreadTransactionMgr(); dt = new DataTable(_entity.MappingName); txMgr.Enlist(cmd, _entity); DbDataAdapter dbDataAdapter = this._entity.ConvertIDbDataAdapter(da); dbDataAdapter.Fill(dt); txMgr.DeEnlist(cmd, _entity); } catch (Exception ex) { throw ex; } finally { this._entity.DataTable = dt; loaded = (dt.Rows.Count > 0); } return(loaded); }
protected void OnRowUpdated(object sender, OleDbRowUpdatedEventArgs e) { try { if (e.Status == UpdateStatus.Continue && e.StatementType == StatementType.Insert) { TransactionMgr txMgr = TransactionMgr.ThreadTransactionMgr(); OleDbCommand cmd = new OleDbCommand("SELECT @@IDENTITY"); txMgr.Enlist(cmd, this); object o = cmd.ExecuteScalar(); txMgr.DeEnlist(cmd, this); if (o != null) { e.Row[this.GetAutoKeyColumn()] = o; e.Row.AcceptChanges(); } } } catch {} }
protected void OnRowUpdated(object sender, MySqlRowUpdatedEventArgs e) { try { if (e.Status == UpdateStatus.Continue && e.StatementType == StatementType.Insert) { TransactionMgr txMgr = TransactionMgr.ThreadTransactionMgr(); string identityCol = this.GetAutoKeyColumns(); MySqlCommand cmd = new MySqlCommand(); cmd.CommandText = "SELECT LAST_INSERT_ID();"; txMgr.Enlist(cmd, this); object o = cmd.ExecuteScalar(); txMgr.DeEnlist(cmd, this); if (o != null) { e.Row[identityCol] = o; } e.Row.AcceptChanges(); } } catch {} }
virtual public void Save() { if (_dataTable == null) { return; } if (!_canSave) { throw new Exception("Cannot call Save() after Query.AddResultColumn()"); } TransactionMgr txMgr = TransactionMgr.ThreadTransactionMgr(); try { bool needToInsert = false; bool needToUpdate = false; bool needToDelete = false; DataRow row; DataRowCollection rows = _dataTable.Rows; for (int i = 0; i < rows.Count; i++) { row = rows[i]; switch (row.RowState) { case DataRowState.Added: needToInsert = true; break; case DataRowState.Modified: needToUpdate = true; break; case DataRowState.Deleted: needToDelete = true; break; } } if (needToInsert || needToUpdate || needToDelete) { IDbDataAdapter da = this.CreateIDbDataAdapter(); if (needToInsert) { da.InsertCommand = GetInsertCommand(); } if (needToUpdate) { da.UpdateCommand = GetUpdateCommand(); } if (needToDelete) { da.DeleteCommand = GetDeleteCommand(); } txMgr.BeginTransaction(); int txCount = txMgr.NestingCount; if (txCount > 1) { txMgr.AddBusinessEntity(this); } if (needToInsert) { txMgr.Enlist(da.InsertCommand, this); } if (needToUpdate) { txMgr.Enlist(da.UpdateCommand, this); } if (needToDelete) { txMgr.Enlist(da.DeleteCommand, this); } DbDataAdapter dbDataAdapter = ConvertIDbDataAdapter(da); this.HookupRowUpdateEvents(dbDataAdapter); dbDataAdapter.Update(_dataTable); txMgr.CommitTransaction(); if (txCount == 1) { this.AcceptChanges(); } if (needToInsert) { txMgr.DeEnlist(da.InsertCommand, this); } if (needToUpdate) { txMgr.DeEnlist(da.UpdateCommand, this); } if (needToDelete) { txMgr.DeEnlist(da.DeleteCommand, this); } } } catch (Exception ex) { if (txMgr != null) { txMgr.RollbackTransaction(); } throw ex; } }
protected object LoadFromSqlScalar(string sp, ListDictionary Parameters, CommandType commandType, int commandTimeout) { object retValue = 0; try { IDbCommand cmd = this.CreateIDbCommand(); cmd.CommandText = sp; cmd.CommandType = commandType; if (commandTimeout > 0) { cmd.CommandTimeout = commandTimeout; } IDataParameter p; if (Parameters != null) { foreach (DictionaryEntry param in Parameters) { p = param.Key as IDataParameter; if (null == p) { p = this.CreateIDataParameter((string)param.Key, param.Value); } else { p.Value = param.Value; } cmd.Parameters.Add(p); } } TransactionMgr txMgr = TransactionMgr.ThreadTransactionMgr(); txMgr.Enlist(cmd, this); retValue = cmd.ExecuteScalar(); txMgr.DeEnlist(cmd, this); } catch (Exception ex) { throw ex; } return(retValue); }
protected bool LoadFromRawSql(string rawSql, params object[] parameters) { bool loaded = false; DataTable dt = null; try { IDbCommand cmd = _LoadFromRawSql(rawSql, parameters); IDbDataAdapter da = this.CreateIDbDataAdapter(); da.SelectCommand = cmd; TransactionMgr txMgr = TransactionMgr.ThreadTransactionMgr(); dt = new DataTable(this.MappingName); txMgr.Enlist(cmd, this); DbDataAdapter dbDataAdapter = this.ConvertIDbDataAdapter(da); dbDataAdapter.Fill(dt); txMgr.DeEnlist(cmd, this); } catch (Exception ex) { throw ex; } finally { this.DataTable = dt; loaded = (dt.Rows.Count > 0); } return(loaded); }
protected bool LoadFromSql(string sp, ListDictionary Parameters, CommandType commandType) { DataTable dataTable = null; bool loaded = false; try { dataTable = new DataTable(this.MappingName); IDbCommand cmd = this.CreateIDbCommand(); cmd.CommandText = sp; cmd.CommandType = commandType; IDataParameter p; if (Parameters != null) { foreach (DictionaryEntry param in Parameters) { p = param.Key as IDataParameter; if (null == p) { p = this.CreateIDataParameter((string)param.Key, param.Value); } else { p.Value = param.Value; } cmd.Parameters.Add(p); } } IDbDataAdapter da = this.CreateIDbDataAdapter(); da.SelectCommand = cmd; TransactionMgr txMgr = TransactionMgr.ThreadTransactionMgr(); txMgr.Enlist(cmd, this); DbDataAdapter dba = ConvertIDbDataAdapter(da); dba.Fill(dataTable); txMgr.DeEnlist(cmd, this); } catch (Exception ex) { throw ex; } finally { this.DataTable = dataTable; loaded = (this.RowCount > 0); } return(loaded); }