/// <summary> /// 执行SQL语句,返回受影响的行数 /// </summary> /// <param name="sql">SQL语句</param> /// <param name="tableNames">受影响的表的表名</param> /// <returns></returns> public Object ExecuteScalar(String sql, String[] tableNames) { // 移除所有和受影响表有关的缓存 if (EnableCache) { XCache.Remove(tableNames); } return(DB.ExecuteScalar(sql)); }
/// <summary> /// 执行插入语句并返回新增行的自动编号 /// </summary> /// <param name="sql"></param> /// <param name="tableNames">受影响的表的表名</param> /// <returns>新增行的自动编号</returns> public Int32 InsertAndGetIdentity(String sql, String[] tableNames) { // 移除所有和受影响表有关的缓存 if (EnableCache) { XCache.Remove(tableNames); } return(DB.InsertAndGetIdentity(sql)); }
/// <summary> /// 执行SQL语句,返回受影响的行数 /// </summary> /// <param name="sql">SQL语句</param> /// <param name="tableNames">受影响的表的表名</param> /// <returns></returns> public Int32 Execute(String sql, String[] tableNames) { // 移除所有和受影响表有关的缓存 if (EnableCache) { XCache.Remove(tableNames); } return(DB.Execute(sql)); }
/// <summary> /// 执行CMD,返回受影响的行数 /// </summary> /// <param name="cmd"></param> /// <param name="tableNames"></param> /// <returns></returns> public Int32 Execute(DbCommand cmd, String[] tableNames) { // 移除所有和受影响表有关的缓存 if (EnableCache) { XCache.Remove(tableNames); } Int32 ret = DB.Execute(cmd); DB.AutoClose(); return(ret); }