internal static string CommunicateClubShop(string UserID, int QID, int OID, string channelAccessToken) { // 取得ShopTemp裡的資料:ShopName, ShopPhone, ShopAddress, ClubID ShopTemp shopTemp = new ShopTemp(UserID); shopTemp.GetClubShopTempInfoFromSQL(); // 先用時間和UserID製作ShopID,因為是ClubShop所以前面加上CS shopTemp.ShopID = $"CS{DateTime.Now.ToString("yyyyMMddHHmmssfff")}{shopTemp.ClubID}"; // 取得ShopItemTemp裡的資料:ShopItem, ShopItemPrice List <ShopTemp> shopItemList = shopTemp.GetShopItemTempFromSQL(); // 把資料存進各個資料表 int result = 0; result = shopTemp.InsertAllClubShopData(shopItemList); if (result > 0) { shopTemp.InitializeShopTempByUserID(); shopTemp.DeleteShopItemTempByUserID(); UserStatus userStatus = new UserStatus(UserID); userStatus.InitializeUserStatusByUserID(); return("商店建立成功"); } else { return("商店建立失敗"); } }
private static string GetConfirmText(int QID, int OID, string UserIDorClubIDorOrderID) { OrderInfo orderInfo; switch (QID) { case 52: orderInfo = new OrderInfo(); orderInfo.OrderID = UserIDorClubIDorOrderID; orderInfo.SelectMyOrderNameByOrderID(); return($"確定要刪除:{orderInfo.OrderName} 嗎???"); case 61: switch (OID) { case 2: OrderTemp orderTemp = new OrderTemp(UserIDorClubIDorOrderID); orderTemp.SelectByUserID(); return($"請確認將開單時間修改為:{orderTemp.StartTime.ToString("yyyy-MM-dd HH:mm")},結單時間修改為:{orderTemp.EndTime.ToString("yyyy-MM-dd HH:mm")} 嗎???"); default: break; } break; case 102: switch (OID) { case 1: ClubInfo clubInfo = new ClubInfo(); clubInfo.ClubID = UserIDorClubIDorOrderID; // 這裡用ClubID return($"確定離開 {clubInfo.SelectByClubid()[0].ClubName} 嗎???"); default: break; } break; case 152: orderInfo = new OrderInfo(); orderInfo.OrderID = UserIDorClubIDorOrderID; orderInfo.SelectClubOrderNameByOrderID(); return($"確定要刪除:{orderInfo.OrderName} 嗎???"); case 161: switch (OID) { case 2: OrderTemp orderTemp = new OrderTemp(UserIDorClubIDorOrderID); orderTemp.SelectByUserID(); return($"請確認將開單時間修改為:{orderTemp.StartTime.ToString("yyyy-MM-dd HH:mm")},結單時間修改為:{orderTemp.EndTime.ToString("yyyy-MM-dd HH:mm")} 嗎???"); default: break; } break; case 171: switch (OID) { case 7: ShopTemp shopTemp = new ShopTemp(UserIDorClubIDorOrderID); // 這裡用UserID shopTemp.GetMyShopTempInfoFromSQL(); List <ShopTemp> shopItems = shopTemp.GetShopItemTempFromSQL(); string confirmText1 = $"請確認建立商店資訊:" + $"商店名稱:{shopTemp.ShopName}," + $"商店電話:{shopTemp.ShopPhone}," + $"商店地址:{shopTemp.ShopAddress},商店品項:"; string confirmText2 = ""; for (int i = 0; i < shopItems.Count; i++) { confirmText2 += $"{shopItems[i].ShopItem}({shopItems[i].ShopItemPrice} TWD) "; } return(confirmText1 + confirmText2); default: break; } break; case 201: switch (OID) { case 3: return($"確定建立嗎???"); default: break; } break; case 211: switch (OID) { case 3: return($"要繼續選擇商店嗎???"); default: break; } break; case 231: switch (OID) { case 3: ShopInfo shopInfo = new ShopInfo(); shopInfo.ShopID = UserIDorClubIDorOrderID; shopInfo.SelectMyShopNameByShopID(); if (shopInfo.ShopName != null) { return($"確定將此訂單商店換成 {shopInfo.ShopName} 嗎???"); } else { List <ShopInfo> shopInfos = shopInfo.BossShopSelectShopNameByShopid(); return($"確定將此訂單商店換成 {shopInfos[0].ShopName} 嗎???"); } default: break; } return(""); case 241: switch (OID) { case 3: return($"確定建立嗎???"); default: break; } break; case 251: switch (OID) { case 3: return($"要繼續選擇商店嗎???"); default: break; } break; case 261: switch (OID) { case 3: ShopInfo shopInfo = new ShopInfo(); shopInfo.ShopID = UserIDorClubIDorOrderID; shopInfo.SelectMyShopNameByShopID(); if (shopInfo.ShopName != null) { return($"確定將此訂單商店換成 {shopInfo.ShopName} 嗎???"); } else { List <ShopInfo> shopInfos = shopInfo.BossShopSelectShopNameByShopid(); return($"確定將此訂單商店換成 {shopInfos[0].ShopName} 嗎???"); } default: break; } return(""); case 121: switch (OID) { case 5: return("需要繼續修改其他品項嗎?"); default: break; } break; case 271: switch (OID) { case 7: ShopTemp shopTemp = new ShopTemp(UserIDorClubIDorOrderID); // 這裡用UserID shopTemp.GetClubShopTempInfoFromSQL(); List <ShopTemp> shopItems = shopTemp.GetShopItemTempFromSQL(); string confirmText1 = $"請確認建立社團商店資訊:" + $"商店名稱:{shopTemp.ShopName}," + $"商店電話:{shopTemp.ShopPhone}," + $"商店地址:{shopTemp.ShopAddress},商店品項:"; string confirmText2 = ""; for (int i = 0; i < shopItems.Count; i++) { confirmText2 += $"{shopItems[i].ShopItem}({shopItems[i].ShopItemPrice} TWD) "; } return(confirmText1 + confirmText2); default: break; } break; default: break; } return(""); }