/// <summary>
/// 执行查询语句，返回DataSet
/// </summary>
/// <param name="sqlString">查询语句</param>
/// <returns>DataSet</returns>
public static DataSet Query(string sqlString, string connectString)
{
lock (Lock)
{
//实例化数据库连接
sara.gisserver.console.doconsole.AccessSQLiteData accessdata = new sara.gisserver.console.doconsole.AccessSQLiteData(connectString);
DataSet ds = new DataSet();
try
{
ds = accessdata.Query(sqlString);
}
catch (Exception e)
{
errcount++;
if (errcount <= trytimes && e.Message.IndexOf("SQL logic error or missing database") != -1)
{
ds = Query(sqlString, connectString);
}
else
{
errcount = 0;
throw e;
}
}
return(ds);
}
}
/// <summary>
/// 执行SQL语句，返回影响的记录数
/// </summary>
/// <param name="sqlString">SQL语句</param>
/// <returns>影响的记录数</returns>
public static int ExecuteSql(string sqlString, string connectString)
{
lock (Lock)
{
//实例化数据库连接
sara.gisserver.console.doconsole.AccessSQLiteData accessdata = new sara.gisserver.console.doconsole.AccessSQLiteData(connectString);
int rows = 0;
try
{
rows = accessdata.ExecuteSql(sqlString);
}
catch (Exception e)
{
errcount++;
if (errcount <= trytimes && e.Message.IndexOf("SQL logic error or missing database") != -1)
{
rows = ExecuteSql(sqlString, connectString);
}
else
{
errcount = 0;
throw e;
}
}
return(rows);
}
}
/// <summary>
///
/// </summary>
/// <param name="sqlString"></param>
/// <returns></returns>
public static object GetSingle(string sqlString, string connectString)
{
lock (Lock)
{
//实例化数据库连接
sara.gisserver.console.doconsole.AccessSQLiteData accessdata = new sara.gisserver.console.doconsole.AccessSQLiteData(connectString);
object obj;
try
{
obj = accessdata.GetSingle(sqlString);
}
catch (Exception e)
{
errcount++;
if (errcount <= trytimes && e.Message.IndexOf("SQL logic error or missing database") != -1)
{
obj = GetSingle(sqlString, connectString);
}
else
{
errcount = 0;
throw e;
}
}
return(obj);
}
}
