/// <summary>
/// 筛选
/// </summary>
public static dynamic SqlReader(string sql, List<string> list = null)
{
DBHelper db = new DBHelper();
if (list != null)
{
for (int i = 0; i < list.Count; i++)
{
db.ParameterAdd("@" + i, list[i]);
}
}
dynamic dy = db.ExecuteReader(sql);
db.Dispose();
return dy;
}
/// <summary>
/// 筛选
/// </summary>
public static dynamic Query(string table, int top, string field, string where, string order, List<string> list = null)
{
DBHelper db = new DBHelper();
if (list != null)
{
for (int i = 0; i < list.Count; i++)
{
db.ParameterAdd("@" + i, list[i]);
}
}
dynamic d = db.ExecuteReader(DBSql.Select(table, top, field, where, order));
db.Dispose();
return d;
}