/// <summary>
/// 获取表数据
/// </summary>
/// <param name="SQLType">1-获取表数据,0-获取表结构,</param>
/// <returns></returns>
public DataTable GetTable(int SQLType, string where)
{
string sql = SQLGeneration.MySQLGeneration(tablename, where, SQLType);
return(DBHelper.GetTable(sql, DBHelper.connStr));
}
/// <summary>
/// 基本的增删改
/// </summary>
/// <param name="id">主键</param>
/// <param name="table">要更新的表数据</param>
/// <param name="SQLType">0-增加,1-修改,2-删除,</param>
/// <returns></returns>
public int Update(string PrimaryKey, DataTable table, int SQLType, List <string> keys)
{
string sql = SQLGeneration.MySQLGeneration(table, PrimaryKey, SQLType, tablename, keys);
return(DBHelper.Update(sql, DBHelper.connStr));
}
