/// <summary>
/// 根据查询语句返回DataTable
/// </summary>
/// <param name="sql"></param>
/// <param name="as_where1">如：@name=sa</param>
/// <param name="as_where2"></param>
/// <param name="as_where3"></param>
/// <param name="as_where4"></param>
/// <param name="as_where5"></param>
/// <param name="as_where6"></param>
/// <returns></returns>
public static DataTable ExecuteDataTable(string sql, string as_where1 = "", string as_where2 = "", string as_where3 = "", string as_where4 = "", string as_where5 = "", string as_where6 = "")
{
SqlErr = "";
sql = of_AllSql(sql, as_where1, as_where2, as_where3, as_where4, as_where5, as_where6);
DataTable dt = new DataTable();
AccessDB db = new AccessDB(connStr);
try
{
dt = db.ExecuteQueryDataTable(sql);
return dt;
}
catch (Exception e)
{
SqlErr = e.Message;
return dt;
}
finally
{
db.CloseSqlConnection();
}
}
/// <summary>
/// 分页方法
/// </summary>
/// <param name="sql"></param>
/// <param name="ai_PageSize">每页行数</param>
/// <param name="ai_PageIndex">当前页数</param>
/// <param name="ai_totalrow">总行数</param>
/// <returns></returns>
public static DataTable ExecuteDataTable(string sql, int ai_PageSize, int ai_PageIndex, ref int ai_totalrow)
{
SqlErr = "";
if (ai_PageSize > 20000)
{
ai_PageSize = 20000;
}
DataTable dt = new DataTable();
AccessDB db = new AccessDB(connStr);
if (sql.IndexOf("limit") > 0)
{
sql = sql.Substring(0, sql.IndexOf("limit"));
}
try
{
ai_totalrow = db.ExecuteQueryNum(sql);
if (ai_PageIndex == 1)
{
sql += " limit 0," + ai_PageSize;
}
else
{
sql += " limit " + (ai_PageIndex * ai_PageSize - 1) + "," + ai_PageSize;
}
dt = db.ExecuteQueryDataTable(sql);
return dt;
}
catch (Exception e)
{
SqlErr = e.Message;
return dt;
}
finally
{
db.CloseSqlConnection();
}
}
/// <summary>
/// 根据查询语句返回DataTable
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public static DataTable ExecuteDataTable(string sql)
{
SqlErr = "";
DataTable dt = new DataTable();
AccessDB db = new AccessDB(connStr);
try
{
dt = db.ExecuteQueryDataTable(sql);
return dt;
}
catch (Exception e)
{
SqlErr = e.Message;
return dt;
}
finally
{
db.CloseSqlConnection();
}
}