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