コード例 #1
0
ファイル: SQLCommunicator.cs プロジェクト: OTL90104/OrderBOT
        internal static string CommunicateShopNameUpdate(string UserID, int QID, int OID, string channelAccessToken)
        {
            // 先拿到存在ShopTemp裡面的ShopName
            ShopTemp shopTemp = new ShopTemp(UserID);

            shopTemp.SelectByUserID();

            // 拿到存在UserStatus裡的TempData,目前裡面是前一步輸入的ShopID
            UserStatus userStatus = new UserStatus(UserID);

            userStatus.SelectByUserID();

            ShopInfo shopInfo = new ShopInfo();
            int      result   = 0;

            // 分成MyShop跟ClubShop兩種update方法
            switch (QID)
            {
            case 191:
                shopInfo.ShopName = shopTemp.ShopName;
                result            = shopInfo.UpdateMyShopNameByShopID(shopTemp.ShopID);
                break;

            case 291:
                shopInfo.ShopName = shopTemp.ShopName;
                result            = shopInfo.UpdateClubShopNameByShopID(userStatus.TempData);
                break;

            default:
                break;
            }

            if (result > 0)
            {
                userStatus.InitializeUserStatusByUserID();
                shopTemp.InitializeShopTempByUserID();
                return("商店名稱修改成功");
            }
            else
            {
                return("商店名稱修改失敗");
            }
        }