/// <summary> /// 执行一般sql语句,返回受影响的记录行数 /// </summary> /// <param name="sql">sql语句</param> /// <param name="prePms">变量的键值对集合</param> /// <returns>受影响的记录行数</returns> public int QueryInt(string sql, Dictionary <string, object> prePms = null) { SqlServerHelper _sqlServer = SqlServerHelper.CreateInstance(SqlConStr); int i = 0; while (i <= 2) { try { return(_sqlServer.QueryInt(sql, prePms)); } catch (Exception ex) { i++; Thread.Sleep(500); continue; throw ex; } } AccessDbHelper _accessSever = AccessDbHelper.CreateInstance(AccessConStr); return(_accessSever.QueryInt(sql, prePms)); }
/// <summary> /// 泛型方法,根据对应操作和泛型列表执行对应数据库操作,返回对应操作影响的行数 /// </summary> /// <typeparam name="T">泛型,Model中数据表的对应类</typeparam> /// <param name="opration">数据操作:Insert、Update、Delete忽略大小写</param> /// <param name="modelList">泛型列表</param> /// <returns>影响的行数</returns> public int QueryInt <T>(string opration, List <T> modelList) { SqlServerHelper _sqlServer = SqlServerHelper.CreateInstance(SqlConStr); int i = 0; while (i <= 2) { try { return(_sqlServer.QueryInt <T>(opration, modelList)); } catch (Exception exc) { i++; Thread.Sleep(500); continue; throw exc; } } AccessDbHelper _accessSever = AccessDbHelper.CreateInstance(AccessConStr); return(_accessSever.QueryInt <T>(opration, modelList)); }