internal static string UpdateOrder(int QID, int OID, string userId) { int result = 0; OrderTemp orderTemp; OrderInfo orderInfo; switch (QID) { case 61: orderTemp = new OrderTemp(userId); orderTemp.SelectByUserID(); orderInfo = new OrderInfo(userId); orderInfo.OrderPartitionID = orderTemp.OrderPartitionID; orderInfo.SelectMyOrderTableByOrderPartitionID(); orderInfo.StartTime = orderTemp.StartTime; orderInfo.EndTime = orderTemp.EndTime; switch (orderInfo.OrderStatus) { case "wait": orderInfo.OrderStatus = "wait"; result = orderInfo.UpdateTimeByOrderPartitionIDToMyOrder(); break; case "available": orderInfo.OrderStatus = "wait"; result = orderInfo.UpdateTimeByOrderPartitionIDToMyOrder(); break; case "done": return("此訂單已經結單,無法再改時間囉~"); break; default: break; } // result = orderInfo.UpdateTimeByOrderPartitionIDToMyOrder(); break; case 161: orderTemp = new OrderTemp(userId); orderTemp.ClubIDSelectByUserID(); orderTemp.SelectByUserID(); orderInfo = new OrderInfo(orderTemp.ClubID); orderInfo.OrderPartitionID = orderTemp.OrderPartitionID; orderInfo.SelectClubOrderTableByOrderPartitionID(); orderInfo.StartTime = orderTemp.StartTime; orderInfo.EndTime = orderTemp.EndTime; switch (orderInfo.OrderStatus) { case "wait": orderInfo.OrderStatus = "wait"; result = orderInfo.UpdateTimeByOrderPartitionIDTOClubOrder(); break; case "available": orderInfo.OrderStatus = "wait"; result = orderInfo.UpdateTimeByOrderPartitionIDTOClubOrder(); break; case "done": return("此訂單已經結單,無法再改時間囉~"); break; default: break; } // result = orderInfo.UpdateTimeByOrderPartitionIDTOClubOrder(); break; default: break; } if (result > 0) { orderTemp = new OrderTemp(userId); orderTemp.UpdateInitialOrderTemp(); return("修改成功"); } else { return("修改失敗"); } }
internal static string CommunicateOrder(string userId, int QID, int OID, string OrderName, string channelAccessToken) { OrderTemp orderTmp = new OrderTemp(userId); orderTmp.SelectByUserID(); //這裡主要從OrderTmp抓取起始時間跟結束時間,ShopID OrderInfo orderinfo = new OrderInfo(); //準備輸入SQL的資料 switch (QID) //根據QID不同初始化clubOrderAndMyOrder { case 201: orderinfo = new OrderInfo(userId, OrderName); break; case 231: //231只修改shopID orderinfo = new OrderInfo(userId); orderTmp.SelectByUserID(); orderTmp.ShopID = OrderName; //在此處傳進來OrderName是ShopID break; case 241: orderTmp.ClubIDSelectByUserID(); //撈取ClubID orderinfo = new OrderInfo(orderTmp.ClubID, OrderName); break; case 261: orderTmp.ClubIDSelectByUserID(); //撈取ClubID orderinfo = new OrderInfo(orderTmp.ClubID); orderTmp.SelectByUserID(); orderTmp.ShopID = OrderName; //在此處傳進來OrderName是ShopID break; default: break; } orderinfo.StartTime = orderTmp.StartTime; orderinfo.EndTime = orderTmp.EndTime; orderinfo.ShopID = orderTmp.ShopID; if (QID == 201 | QID == 241) { orderinfo.OrderType = "Once"; } else { orderinfo.OrderType = "Period"; } orderinfo.OrderStatus = "wait"; int result = 0; switch (QID) { case 201: orderinfo.OrderPartitionID = "MOO" + orderinfo.OrderID; result = orderinfo.InserMyOrderTableToSQL(); break; case 231: //修改MyOrder訂單店家 orderinfo.OrderPartitionID = orderTmp.OrderPartitionID; result = orderinfo.UpdateShopIDByOrderPartitionIDToMyOrder(); if (result > 0) { return("修改完成"); } else { return("修改失敗"); } break; case 241: orderinfo.OrderPartitionID = "COO" + orderinfo.OrderID; result = orderinfo.InserClubOrderTableToSQL(); if (result > 0) { UserStatus userStatus = new UserStatus(userId); userStatus.InitializeUserStatusByUserID(); orderTmp.UpdateInitialOrderTemp(); orderTmp = new OrderTemp(userId); return("社團訂單建立成功,所有社團成員皆能收到此訂單通知,無須再讓成員加入訂單喔~"); } break; case 261: orderinfo.OrderPartitionID = orderTmp.OrderPartitionID; result = orderinfo.UpdateShopIDByOrderPartitionIDToClubOrder(); if (result > 0) { return("修改完成"); } else { return("修改失敗"); } break; default: break; } if (result > 0) { UserStatus userStatus = new UserStatus(userId); userStatus.InitializeUserStatusByUserID(); orderTmp = new OrderTemp(userId); orderinfo.InsertOrdeUserTable(); orderTmp.UpdateInitialOrderTemp(); isRock.LineBot.Utility.PushMessage(userId, orderinfo.OrderID, channelAccessToken); // string orderCreateMessage = "上面是你的訂單參加碼,可以將此參加碼分享給其他人,讓其他人加入你的訂單喔~"; // isRock.LineBot.Utility.PushMessage(userId, orderCreateMessage, channelAccessToken); return("訂單建立成功喔~~\n上面是你的訂單參加碼,可以將此參加碼分享給其他人,讓其他人加入你的訂單喔~"); } else { return("訂單建立失敗"); } }
internal static ImagemapMessage MakeMenu(Event item) { // 先做初始化 UserStatus userStatus = new UserStatus(item.source.userId); userStatus.InitializeUserStatusByUserID(); ShopTemp shopTemp = new ShopTemp(item.source.userId); shopTemp.InitializeShopTempByUserID(); shopTemp.DeleteShopItemTempByUserID(); OrderTemp orderTemp = new OrderTemp(item.source.userId); orderTemp.UpdateInitialOrderTemp(); PeriodOrderTmp periodOrderTmp = new PeriodOrderTmp(item.source.userId); periodOrderTmp.UpdateInitialPeriodOrderTmp(); ShopListTemp shopListTemp = new ShopListTemp(item.source.userId); shopListTemp.DeleteByUserID(); BuyerTemp buyerTemp = new BuyerTemp(item.source.userId); buyerTemp.DeleteByBuyerID(); // 先做初始化 ImagemapMessage imagemapMessage = new ImagemapMessage(); Uri uri = new Uri("https://i220.photobucket.com/albums/dd130/jung_04/Menu2.png#"); imagemapMessage.baseUrl = uri; imagemapMessage.altText = "這是imagemap"; Size size = new Size(1040, 1040); imagemapMessage.baseSize = size; #region LeftUp isRock.LineBot.ImagemapArea imagemapAreaLeftUp = new isRock.LineBot.ImagemapArea() { x = 0, y = 0, width = 520, height = 520 }; isRock.LineBot.ImagemapMessageAction imagemapMessageActionLeftUp = new ImagemapMessageAction(); imagemapMessageActionLeftUp.area = imagemapAreaLeftUp; imagemapMessageActionLeftUp.text = "我要進入訂單模式!!!"; imagemapMessage.actions.Add(imagemapMessageActionLeftUp); #endregion #region RightUp isRock.LineBot.ImagemapArea imagemapAreaRightUp = new isRock.LineBot.ImagemapArea() { x = 520, y = 0, width = 520, height = 520 }; isRock.LineBot.ImagemapMessageAction imagemapMessageActionRightUp = new ImagemapMessageAction(); imagemapMessageActionRightUp.area = imagemapAreaRightUp; imagemapMessageActionRightUp.text = "我要進入個人模式!!!"; imagemapMessage.actions.Add(imagemapMessageActionRightUp); #endregion #region LeftDown isRock.LineBot.ImagemapArea imagemapAreaLeftDown = new isRock.LineBot.ImagemapArea() { x = 0, y = 520, width = 520, height = 520 }; isRock.LineBot.ImagemapMessageAction imagemapMessageActionLeftDown = new ImagemapMessageAction(); imagemapMessageActionLeftDown.area = imagemapAreaLeftDown; imagemapMessageActionLeftDown.text = "我要進入社團模式!!!"; imagemapMessage.actions.Add(imagemapMessageActionLeftDown); #endregion #region RightDown var actions1 = new List <isRock.LineBot.ImagemapActionBase>(); isRock.LineBot.ImagemapArea imagemapAreaRightDown = new isRock.LineBot.ImagemapArea() { x = 520, y = 520, width = 520, height = 520 }; isRock.LineBot.ImagemapMessageAction imagemapMessageActionRightDown = new ImagemapMessageAction(); imagemapMessageActionRightDown.area = imagemapAreaRightDown; imagemapMessageActionRightDown.text = "我要進入商店模式!!!"; imagemapMessage.actions.Add(imagemapMessageActionRightDown); #endregion return(imagemapMessage); }