コード例 #1
0
ファイル: SQLCommunicator.cs プロジェクト: OTL90104/OrderBOT
        internal static string CommunicateShopPhoneUpdate(string UserID, int QID, int OID, string channelAccessToken)
        {
            // 先拿到存在ShopTemp裡面的ShopPhone
            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 192:
                shopInfo.ShopPhone = shopTemp.ShopPhone;
                result             = shopInfo.UpdateMyShopPhoneByShopID(shopTemp.ShopID);
                break;

            case 292:
                shopInfo.ShopPhone = shopTemp.ShopPhone;
                result             = shopInfo.UpdateClubShopPhoneByShopID(userStatus.TempData);
                break;

            default:
                break;
            }

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