public bool InsertColumnData(string table, Dictionary <string, object> columnDatMap)
{
var sql = SqlHelper.GenInsertSql(table, columnDatMap);
var oracleParams = ParameterHandler.GetConditionParams(columnDatMap);
return(_dataAccessor.Update(sql, oracleParams) > 0);
}
public bool DelData(string table, string condition, params object[] paramList)
{
var sql = SqlHelper.GenDelSql(table, condition);
var oracleParams = ParameterHandler.GetConditionParams(condition, paramList);
return(_dataAccessor.Update(sql, oracleParams) > 0);
}
public List <T> GetColumnList <T>(string table, string column, string condition, params object[] paramList)
{
var sql = SqlHelper.GenSelectSql(table, column, condition);
var oracleParams = ParameterHandler.GetConditionParams(condition, paramList);
return(_dataAccessor.QueryColumnList <T>(sql, oracleParams));
}
public List <Dictionary <string, object> > QueryMapList(string sql, Dictionary <string, object> parms)
{
PrintSql(sql);
OracleConnection conn = null;
var result = new List <Dictionary <string, object> >();
try
{
conn = OracleConnectionFactory.OpenConn();
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = sql;
cmd.CommandType = CommandType.Text;
ParameterHandler.SetParameters(cmd, parms);
var reader = cmd.ExecuteReader();
result = ResultHandler.GenerateResultMapFromTable(reader);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
OracleConnectionFactory.CloseConn(conn);
}
return(result);
}
public int Update(string sql, Dictionary <string, object> parms)
{
PrintSql(sql);
OracleConnection conn = null;
try
{
conn = OracleConnectionFactory.OpenConn();
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = sql;
cmd.CommandType = CommandType.Text;
ParameterHandler.SetParameters(cmd, parms);
return(cmd.ExecuteNonQuery());
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
OracleConnectionFactory.CloseConn(conn);
}
return(-1);
}
public long QueryCount(string sql, Dictionary <string, object> parms)
{
PrintSql(sql);
OracleConnection conn = null;
long result = 0;
try
{
conn = OracleConnectionFactory.OpenConn();
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = sql;
cmd.CommandType = CommandType.Text;
ParameterHandler.SetParameters(cmd, parms);
var count = cmd.ExecuteScalar();
result = Convert.ToInt64(count);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
OracleConnectionFactory.CloseConn(conn);
}
return(result);
}
public long GetCount <T>(string condition, params object[] paramList) where T : class
{
var type = typeof(T);
var sql = SqlHelper.GenCountSql(type, condition);
var oracleParams = ParameterHandler.GetConditionParams(condition, paramList);
return(_dataAccessor.QueryCount(sql, oracleParams));
}
public bool Del <T>(string condition, params object[] paramList) where T : class
{
var type = typeof(T);
var sql = SqlHelper.GenDelSql(type, condition);
var oracleParams = ParameterHandler.GetConditionParams(condition, paramList);
return(_dataAccessor.Update(sql, oracleParams) > 0);
}
public bool Insert <T>(T t) where T : class
{
var type = typeof(T);
var sql = SqlHelper.GenInsertSql(type);
var oracleParams = ParameterHandler.GetConditionParams(t);
return(_dataAccessor.Update(sql, oracleParams) > 0);
}
public bool UpdateColumnData(string table, Dictionary <string, object> columnDatMap, string condition,
params object[] paramList)
{
var sql = SqlHelper.GenUpdateSql(table, columnDatMap, condition);
var oracleParams1 = ParameterHandler.GetConditionParams(columnDatMap);
var oracleParams2 = ParameterHandler.GetConditionParams(condition, paramList);
var oracleParams =
oracleParams1.Concat(oracleParams2).ToDictionary(k => k.Key, v => v.Value);
return(_dataAccessor.Update(sql, oracleParams) > 0);
}
public bool Update <T>(T t, string condition, params object[] paramList) where T : class
{
var type = typeof(T);
var sql = SqlHelper.GenUpdateSql(type, condition);
var oracleParams1 = ParameterHandler.GetConditionParams(t);
var oracleParams2 = ParameterHandler.GetConditionParams(condition, paramList);
var oracleParams =
oracleParams1.Concat(oracleParams2).ToDictionary(k => k.Key, v => v.Value);
return(_dataAccessor.Update(sql, oracleParams) > 0);
}
