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