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