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