得到当前数据库中不存在的用户表名

  /// <summary>
    /// 得到当前数据库中不存在的用户表名
    /// </summary>
    /// <returns></returns>
    private string GetUserTblName()
    {
        string userTblName = "Tbl_User_" + IT_Utility.CreateRandom(1, 12);//生成随机用户表名

        //检查数据库中是否存在此用户表名
        string sqlStr = "Select Name from sysobjects where Type='U'";
        DataTable table = IT_SqlHelper.Select(sqlStr);
        bool isExist = false;
        do
        {
            foreach (DataRow row in table.Rows)
            {
                if (row["Name"].ToString().Trim() == userTblName)
                {
                    isExist = true;
                    break;
                }
            }
            if (isExist)
            {
                userTblName = "Tbl_User" + IT_Utility.CreateRandom(1, 12);//生成随机用户表名
            }
        } while (isExist);
        return userTblName;
    }