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;
}
