public int Cadastrar(CandidatoVaga entity) { try { const string query = @"INSERT INTO CandidatoVaga (IdCandidato, IdVaga) VALUES (:IdCandidato, :IdVaga)"; var parametros = new { entity.IdCandidato, entity.IdVaga }; string sequenceName = null; if (DataBaseType == DataBaseType.Oracle) { sequenceName = SequenceHelper.GetSequenceName <CandidatoVaga>(entity); } return(Convert.ToInt32(IDbConn.CommandInsert(query, DataBaseType, parametros, sequenceName: sequenceName))); } catch (Exception ex) { throw ex; } }
public int Cadastrar(StatusPedido entity) { try { const string query = @"INSERT INTO StatusPedido (Nome, Ordem) VALUES (:Nome, :Ordem)"; var parametros = new { entity.Nome, entity.Ordem }; string sequenceName = null; if (DataBaseType == DataBaseType.Oracle) { sequenceName = SequenceHelper.GetSequenceName <StatusPedido>(entity); } return(Convert.ToInt32(IDbConn.CommandInsert(query, DataBaseType, parametros, sequenceName: sequenceName))); } catch (Exception ex) { throw ex; } }
/// <summary> /// 执行SQL语句,并返加影响的行数 /// </summary> /// <param name="sql">SQL语句</param> /// <returns></returns> public static DataResult ExecuteNonQuery(string sql) { DataResult result = new DataResult(); result.Sql = sql + ";"; using (IDbConn = DataBaseFactory.GetIDbConnection()) { IDbConn.Open(); using (IDbComm = DataBaseFactory.GetIDbCommand(sql)) { try { int rows = IDbComm.ExecuteNonQuery(); IDbConn.Close(); result.RecordCount = rows; } catch (Exception E) { result.Error = E.Message; IDbConn.Close(); result.RecordCount = 0; return(result); } finally { IDbConn.Close(); } } } return(result); }
public bool Atualizar(Pedido entity) { try { const string query = @"UPDATE Pedido SET IdStatus = :IdStatus, ValorPedido = :ValorPedido, DataPrevisaoEntrega = :DataPrevisaoEntrega WHERE IdPedido = :IdPedido"; var parametros = new { entity.IdPedido, entity.IdStatus, entity.ValorPedido, entity.DataPrevisaoEntrega }; var resultado = IDbConn.CommandExecute(query, DataBaseType, parametros); return(resultado > 0); } catch (Exception ex) { throw ex; } }
/// <summary> /// IF文を判定し、条件がTrueになる入れ子SQL文を返す /// </summary> /// <param name="aDbConn">Db接続</param> /// <param name="ifSql">IF文</param> /// <param name="placeHolders">IF文の条件式に適用するPlaceHolder</param> /// <param name="aCacheStrategy"></param> /// <returns></returns> /// <remarks>条件がTrueになる入れ子SQL文がない場合、最大の表記順番+1を返す</remarks> public static SqlAndSeq Evaluate(IDbConn aDbConn , SqlBuilder ifSql , PlaceHolders placeHolders , Tran.CacheStrategy aCacheStrategy) { //IF文でない場合は渡されたSQLをそのまま返す if (ifSql.GetStatementType() != SqlBuilder.StatementType.If) { return(new SqlAndSeq(0, new SqlBuilders(new SqlBuilder[] { ifSql }))); } int i = 0; foreach (Tuple <SqlPredicate, SqlBuilders> branch in ifSql.GetIfBranches()) { //IF文の条件式にPlaceHolderを適用する branch.Item1.Place(placeHolders.ToDictionary()); string ifCondition = branch.Item1.ToString(); if (IfStatement.EvaluateCondition(aDbConn, ifCondition, aCacheStrategy)) { return(new SqlAndSeq(i, branch.Item2)); } i += 1; } return(new SqlAndSeq(i, new SqlBuilders())); }
public bool Atualizar(Vaga entity) { try { const string query = @"UPDATE Vaga SET Nome = :Nome, IdEmpresa = :IdEmpresa, Descricao = :Descricao, Quantidade = :Quantidade WHERE Id = :Id"; var parametros = new { entity.Id, entity.IdEmpresa, entity.Nome, entity.Descricao, entity.Quantidade }; var resultado = IDbConn.CommandExecute(query, DataBaseType, parametros); return(resultado > 0); } catch (Exception ex) { throw ex; } }
public int Cadastrar(VagaTecnologia entity) { try { const string query = @"INSERT INTO VagaTecnologia (IdVaga, IdTecnologia, IdEmpresa, Peso) VALUES (:IdVaga, :IdTecnologia, :IdEmpresa, :Peso)"; var parametros = new { entity.IdVaga, entity.IdTecnologia, entity.IdEmpresa, entity.Peso }; string sequenceName = null; if (DataBaseType == DataBaseType.Oracle) { sequenceName = SequenceHelper.GetSequenceName <VagaTecnologia>(entity); } return(Convert.ToInt32(IDbConn.CommandInsert(query, DataBaseType, parametros, sequenceName: sequenceName))); } catch (Exception ex) { throw ex; } }
/// <summary> /// 执行SQL语句,并返加影响的行数 /// </summary> /// <param name="sql">SQL语句</param> /// <returns></returns> public int ExecuteNonQuery(string sql) { using (IDbConn = DataBaseFactory.GetIDbConnection()) { IDbConn.Open(); using (IDbComm = DataBaseFactory.GetIDbCommand(sql)) { try { int rows = IDbComm.ExecuteNonQuery(); IDbConn.Close(); return(rows); } catch (Exception E) { IDbConn.Close(); return(0); throw new Exception(E.Message); } finally { IDbConn.Close(); } } } }
/// <summary> /// 执行SQL语句返回结果集IDataReader /// </summary> /// <param name="sql">SQL语句</param> /// <param name="cmdParms">参数</param> /// <returns></returns> public IDataReader GetDataReader(string sql, params IDbDataParameter[] cmdParms) { IDataReader ireader = null; try { if (IDbConn == null || IDbConn.State == ConnectionState.Closed) { IDbConn = DataBaseFactory.GetIDbConnection(); IDbConn.Open(); IDbComm = DataBaseFactory.GetIDbCommand(); PrepareCommand(IDbComm, IDbConn, null, CommandType.Text, sql, cmdParms); // = IDbcmd.ExecuteReader(); ireader = IDbComm.ExecuteReader((CommandBehavior)((int)CommandBehavior.CloseConnection)); // IDbComm.Parameters.Clear(); } return(ireader); } catch (Exception e) { this.Close(); return(null); throw new Exception(e.Message); } }
public bool Atualizar(Candidato entity) { try { const string query = @"UPDATE Candidato SET Nome = :Nome, Curriculo = :Curriculo, Status = :Status WHERE Id = :id"; var parametros = new { entity.Id, entity.Nome, entity.Curriculo, entity.Status }; var resultado = IDbConn.CommandExecute(query, DataBaseType, parametros); return(resultado > 0); } catch (Exception ex) { throw ex; } }
public int Cadastrar(Candidato entity) { try { const string query = @"INSERT INTO Candidato (Nome, Curriculo, Status) VALUES (:Nome, :Curriculo, :Status)"; var parametros = new { entity.Nome, entity.Curriculo, entity.Status }; string sequenceName = null; if (DataBaseType == DataBaseType.Oracle) { sequenceName = SequenceHelper.GetSequenceName <Candidato>(entity); } return(Convert.ToInt32(IDbConn.CommandInsert(query, DataBaseType, parametros, sequenceName: sequenceName))); } catch (Exception ex) { throw ex; } }
public bool Atualizar(Tecnologia entity) { try { const string query = @"UPDATE Tecnologia SET Nome = :Nome, Peso = :Peso WHERE Id = :Id"; var parametros = new { entity.Id, entity.Nome, entity.Peso }; var resultado = IDbConn.CommandExecute(query, DataBaseType, parametros); return(resultado > 0); } catch (Exception ex) { throw ex; } }
public bool Atualizar(StatusPedido entity) { try { const string query = @"UPDATE StatusPedido SET Nome = :Nome, Ordem = :Ordem WHERE Id = :IdStatus"; var parametros = new { entity.IdStatus, entity.Nome, entity.Ordem }; var resultado = IDbConn.CommandExecute(query, DataBaseType, parametros); return(resultado > 0); } catch (Exception ex) { throw ex; } }
/// <summary> /// 执行SQL语句,并返加影响的行数 /// </summary> /// <param name="sql">SQL语句</param> /// <param name="cmdParms">参数</param> /// <returns></returns> public static DataResult ExecuteNonQuery(string sql, params IDbDataParameter[] cmdParms) { sql = DataBaseFactory.GetSQL(sql); DataResult result = new DataResult(); result.Sql = sql + ";"; result.IDbDataParameter = cmdParms; using (IDbConn = DataBaseFactory.GetIDbConnection()) { IDbConn.Open(); using (IDbComm = DataBaseFactory.GetIDbCommand()) { try { PrepareCommand(IDbComm, IDbConn, null, CommandType.Text, sql, cmdParms); int rows = IDbComm.ExecuteNonQuery(); IDbConn.Close(); IDbComm.Parameters.Clear(); result.RecordCount = rows; return(result); } catch (Exception E) { IDbConn.Close(); result.RecordCount = 0; result.Error = E.Message; return(result); } finally { IDbConn.Close(); } } } }
/// <summary> /// 执行SQL语句返回结果集object /// </summary> /// <param name="sql">SQL语句</param> /// <param name="cmdParms">参数</param> /// <returns></returns> public static object ExecuteScalar(string sql, params IDbDataParameter[] cmdParms) { sql = DataBaseFactory.GetSQL(sql); DataResult result = new DataResult(); result.Sql = sql + ";"; using (IDbConn = DataBaseFactory.GetIDbConnection()) { IDbConn.Open(); using (IDbComm = DataBaseFactory.GetIDbCommand()) { try { PrepareCommand(IDbComm, IDbConn, null, CommandType.Text, sql, cmdParms); object rows = IDbComm.ExecuteScalar(); IDbConn.Close(); IDbComm.Parameters.Clear(); return(rows); } catch (Exception E) { IDbConn.Close(); return(null); throw new Exception(E.Message); } finally { IDbConn.Close(); } } } }
/// <summary> /// 执行SQL语句返回结果集IDataReader /// </summary> /// <param name="sql">SQL语句</param> /// <param name="cmdParms">参数</param> /// <returns></returns> public static DataResult GetDataReader(string sql, params IDbDataParameter[] cmdParms) { sql = DataBaseFactory.GetSQL(sql); DataResult result = new DataResult(); result.Sql = sql + ";"; result.IDbDataParameter = cmdParms; try { if (IDbConn == null || IDbConn.State == ConnectionState.Closed) { IDbConn = DataBaseFactory.GetIDbConnection(); IDbConn.Open(); IDbComm = DataBaseFactory.GetIDbCommand(); PrepareCommand(IDbComm, IDbConn, null, CommandType.Text, sql, cmdParms); // = IDbcmd.ExecuteReader(); result.IDataReader = IDbComm.ExecuteReader((CommandBehavior)((int)CommandBehavior.CloseConnection)); return(result); // IDbComm.Parameters.Clear(); } else { return(result); } } catch (Exception e) { IDbConn.Close(); result.Error = e.Message; return(result); } }
/// <summary> /// 执行SQL语句返回结果集IDataReader /// </summary> /// <param name="sql">SQL语句</param> /// <returns></returns> public IDataReader GetDataReader(string sql) { IDataReader ireader = null; try { if (IDbConn == null || IDbConn.State == ConnectionState.Closed) { IDbConn = DataBaseFactory.GetIDbConnection(); IDbConn.Open(); IDbComm = DataBaseFactory.GetIDbCommand(sql); //IDbComm.CommandText = sql; //IDbComm.CommandType = CommandType.Text; // = IDbcmd.ExecuteReader(); ireader = IDbComm.ExecuteReader((CommandBehavior)((int)CommandBehavior.CloseConnection)); } return(ireader); } catch (Exception e) { this.Close(); return(null); throw new Exception(e.Message); } }
public int Cadastrar(Produto entity) { try { const string query = @"INSERT INTO Produtos (Nome, PrecoVenda) VALUES (:Nome, :PrecoVenda)"; var parametros = new { entity.Nome, entity.PrecoVenda }; string sequenceName = null; if (DataBaseType == DataBaseType.Oracle) { sequenceName = SequenceHelper.GetSequenceName <Produto>(entity); } return(Convert.ToInt32(IDbConn.CommandInsert(query, DataBaseType, parametros, sequenceName: sequenceName))); } catch (Exception ex) { throw ex; } }
/// <summary> /// 执行SQL语句返回结果中上的第一行第一列的值,忽略额外的列和行 /// </summary> /// <param name="sql">SQL语句</param> /// <returns></returns> public object ExecuteScalar(string sql) { using (IDbConn = DataBaseFactory.GetIDbConnection()) { IDbConn.Open(); using (IDbComm = DataBaseFactory.GetIDbCommand(sql)) { try { //IDbComm.CommandText = sql; //IDbComm.CommandType = CommandType.Text; object rows = IDbComm.ExecuteScalar(); IDbConn.Close(); return(rows); } catch (Exception E) { IDbConn.Close(); return(null); throw new Exception(E.Message); } finally { IDbConn.Close(); } } } }
public bool Atualizar(Usuario entity) { try { const string query = @"UPDATE Usuarios SET Nome = :Nome, CPF = :CPF, Email = :Email, Telefone = :Telefone, Sexo = :Sexo, DataNascimento = :DataNascimento WHERE Id = :Id"; var parametros = new { entity.Id, entity.Nome, entity.CPF, entity.Email, entity.Telefone, entity.Sexo, entity.DataNascimento, entity.DataAlteracao }; var resultado = IDbConn.CommandExecute(query, DataBaseType, parametros); return(resultado > 0); } catch (Exception ex) { throw ex; } }
/// <summary> /// 执行SQL语句返回结果集DataSet /// </summary> /// <param name="sql">SQL语句</param> /// <param name="cmdParms">参数</param> /// <returns></returns> public DataSet GetDataSet(string sql, params IDbDataParameter[] cmdParms) { using (IDbConn = DataBaseFactory.GetIDbConnection()) { IDbConn.Open(); using (IDbComm = DataBaseFactory.GetIDbCommand()) { try { PrepareCommand(IDbComm, IDbConn, null, CommandType.Text, sql, cmdParms); IDbDataAdapter dataAdapter = DataBaseFactory.GetIDbDataAdapter(); dataAdapter.SelectCommand = IDbComm; DataSet dataSet = new DataSet(); dataAdapter.Fill(dataSet); IDbComm.Parameters.Clear(); return(dataSet); } catch (Exception E) { IDbConn.Close(); return(null); throw new Exception(E.Message); } finally { IDbConn.Close(); } } } }
public int Cadastrar(Usuario entity) { try { const string query = @"INSERT INTO Usuarios (Nome, CPF, Email, Telefone, Sexo, DataNascimento) VALUES (:Nome, :CPF, :Email, :Telefone, :Sexo, :DataNascimento)"; var parametros = new { entity.Nome, entity.CPF, entity.Email, entity.Telefone, entity.Sexo, entity.DataNascimento }; string sequenceName = null; if (DataBaseType == DataBaseType.Oracle) { sequenceName = SequenceHelper.GetSequenceName <Usuario>(entity); } return(Convert.ToInt32(IDbConn.CommandInsert(query, DataBaseType, parametros, sequenceName: sequenceName))); } catch (Exception ex) { throw ex; } }
/// <summary> /// 执行SQL语句,并返加影响的行数 /// </summary> /// <param name="sql">SQL语句</param> /// <param name="cmdParms">参数</param> /// <returns></returns> public int ExecuteNonQuery(string sql, params IDbDataParameter[] cmdParms) { using (IDbConn = DataBaseFactory.GetIDbConnection()) { IDbConn.Open(); using (IDbComm = DataBaseFactory.GetIDbCommand()) { try { PrepareCommand(IDbComm, IDbConn, null, CommandType.Text, sql, cmdParms); int rows = IDbComm.ExecuteNonQuery(); IDbConn.Close(); IDbComm.Parameters.Clear(); return(rows); } catch (Exception E) { IDbConn.Close(); return(0); throw new Exception(E.Message); } finally { IDbConn.Close(); } } } }
public bool Atualizar(HistoricoStatus entity) { try { const string query = @"UPDATE HistoricoStatus SET IdStatus = :IdStatus, DataStatus = :DataStatus WHERE IdPedido = :IdPedido"; var parametros = new { entity.IdPedido, entity.IdStatus, entity.DataStatus }; var resultado = IDbConn.CommandExecute(query, DataBaseType, parametros); return(resultado > 0); } catch (Exception ex) { throw ex; } }
public bool Atualizar(ItemPedido entity) { try { const string query = @"UPDATE ItemPedido SET IdStatus = :IdStatus, PrecoVenda = :PrecoVenda WHERE IdPedido = :IdPedido"; var parametros = new { entity.IdPedido, entity.IdProduto, entity.PrecoVenda }; var resultado = IDbConn.CommandExecute(query, DataBaseType, parametros); return(resultado > 0); } catch (Exception ex) { throw ex; } }
public int Cadastrar(HistoricoStatus entity) { try { const string query = @"INSERT INTO HistoricoStatus (IdPedido, IdStatus, DataStatus) VALUES (:IdPedido, :IdStatus, :DataStatus)"; var parametros = new { entity.IdPedido, entity.IdStatus, entity.DataStatus }; string sequenceName = null; if (DataBaseType == DataBaseType.Oracle) { sequenceName = SequenceHelper.GetSequenceName <HistoricoStatus>(entity); } return(Convert.ToInt32(IDbConn.CommandInsert(query, DataBaseType, parametros, sequenceName: sequenceName))); } catch (Exception ex) { throw ex; } }
public int Cadastrar(Pedido entity) { try { const string query = @"INSERT INTO Pedido (IdStatus, ValorPedido, ValorPedido) VALUES (:PrecoVenda, :ValorPedido, :ValorPedido)"; var parametros = new { entity.IdStatus, entity.ValorPedido, entity.DataPrevisaoEntrega }; string sequenceName = null; if (DataBaseType == DataBaseType.Oracle) { sequenceName = SequenceHelper.GetSequenceName <Pedido>(entity); } return(Convert.ToInt32(IDbConn.CommandInsert(query, DataBaseType, parametros, sequenceName: sequenceName))); } catch (Exception ex) { throw ex; } }
/// <summary> /// 执行SQL语句返回结果集DataSet /// </summary> /// <param name="sql">SQL语句</param> /// <returns></returns> public DataSet GetDataSet(string sql) { using (IDbConn = DataBaseFactory.GetIDbConnection()) { IDbConn.Open(); DataSet dataset = new DataSet(); try { IDbComm = DataBaseFactory.GetIDbCommand(sql); //IDbComm.CommandText = sql; //IDbComm.CommandType = CommandType.Text; IDbAdpter = DataBaseFactory.GetIDbDataAdapter(IDbComm); //IDbAdpter.SelectCommand = IDbComm; IDbAdpter.Fill(dataset); } catch (Exception e) { IDbConn.Close(); throw new Exception(e.Message); } finally { IDbConn.Close(); } return(dataset); } }
/// <summary> /// 执行SQL语句返回结果集DataSet /// </summary> /// <param name="sql">SQL语句</param> /// <returns></returns> public static DataResult GetDataSet(string sql) { sql = DataBaseFactory.GetSQL(sql); DataResult result = new DataResult(); result.Sql = sql + ";"; using (IDbConn = DataBaseFactory.GetIDbConnection()) { IDbConn.Open(); using (IDbComm = DataBaseFactory.GetIDbCommand()) { try { PrepareCommand(IDbComm, IDbConn, null, CommandType.Text, sql, IDbParams); IDbDataAdapter dataAdapter = DataBaseFactory.GetIDbDataAdapter(); dataAdapter.SelectCommand = IDbComm; DataSet dataSet = new DataSet(); dataAdapter.Fill(dataSet); IDbComm.Parameters.Clear(); result.DataSet = dataSet; } catch (Exception E) { IDbConn.Close(); result.Error = E.Message; return(result); } finally { IDbConn.Close(); } } } return(result); //using (IDbConn = DataBaseFactory.GetIDbConnection()) //{ // IDbConn.Open(); // DataSet dataset = new DataSet(); // try // { // IDbComm = DataBaseFactory.GetIDbCommand(sql); // //IDbComm.CommandText = sql; // //IDbComm.CommandType = CommandType.Text; // IDbAdpter = DataBaseFactory.GetIDbDataAdapter(IDbComm); // //IDbAdpter.SelectCommand = IDbComm; // IDbAdpter.Fill(dataset); // } // catch (Exception e) // { // IDbConn.Close(); // throw new Exception(e.Message); // } // finally // { // IDbConn.Close(); // } // return dataset; //} }
public bool Delete(int id) { const string query = @"UPDATE Sample SET Ativo = 0, DataAtualizacao = GetDate() WHERE IdSample = @idSample"; IDbConn.CommandExecute(query, DataBaseType, new { idSample = id }); return(true); }
private void LoadKernel( INinjectModule bindings ) { _kernel = new StandardKernel(); _kernel.Load( bindings ); _dbConn = _kernel.Get<IDbConn>(); }
public SessionLogic( IDbConn dbConn ) { _dbConn = dbConn; }
private void OnDbConnHasDummyRanChanged( IDbConn obj ) { _coldStartSwitch.IsChecked = _dbConn.HasDummyRan; }