public ActionResult ToInsert(string datas) { var scores = JsonSerializer.Deserialize <Score[]>(datas); foreach (var i in scores) { CProductRank rank = new CProductRank(); rank.fRank = i.score; rank.fComment = i.message; rank.fSubmitDataTime = DateTime.UtcNow.AddHours(08); rank.fDetailOrderIId = i.id; CProductRankFactory.fn評價新增(rank); var a = CDetailOrderFactory.fn訂單明細查詢().Where(n => n.fDetailOrderIId == i.id).ToList(); CNotice c = new CNotice(); c.fCategoryType = "評價留言"; c.fLink = "超連結"; c.fNoticeDatetime = DateTime.UtcNow.AddHours(08); c.fMemberId = a.Single().fMemberSellerId; c.fNoticeContent = "您的" + a.Single().fName + "以新增評價"; CNoticeFactory.fn通知訂單訊息新增(c); } return(new ApiResult()); }
//將選取的對象加入黑名單 public string intoblacklist(int memberid, string blackreason) { var goblacklist = CMemberFactory.fn會員查詢().FirstOrDefault(g => g.fMemberId == memberid); if (goblacklist.fIsBanned == true)//判斷是否已經是黑名單 避免重複加入黑名單 { ViewBag.blacklist = "此會員已是黑名單會員"; return("已是黑名單成員"); } else { goblacklist.fIsBanned = true; CMemberFactory.fn會員更新(goblacklist); CBlackListFactory.fn黑名單新增(new CBlackList() { fLockDateTime = DateTime.UtcNow.AddHours(08), fMemberId = memberid, fReason = blackreason }); CNotice c = new CNotice(); c.fNoticeDatetime = DateTime.Now; c.fNoticeContent = "此帳號因發言屢次違規已被設為黑名單,期間內無法針對商品進行留言"; c.fCategoryType = "管理員"; c.fLink = "超連結"; c.fMemberId = goblacklist.fMemberId; CNoticeFactory.fn通知訂單訊息新增(c); return("黑名單更新成功!"); } }
//會員訊息查詢-----------------------------------------------------\\ public ActionResult MemberNotice() { CMember member = Session[CMemberSession.Session_Login_User] as CMember; if (member != null) { var SelectNotices = CNoticeFactory.fn通知訊息查詢(member).ToList().OrderByDescending(n => n.fNoticeDatetime); var Count銷售 = CNoticeFactory.fn通知訊息查詢(member).Where(n => n.fCategoryType == "銷售").Count(); var Count留言 = CNoticeFactory.fn通知訊息查詢(member).Where(n => n.fCategoryType == "評價留言").Count(); ViewBag.Count銷售 = Count銷售; ViewBag.Count留言 = Count留言; return(View("../Member/MemberNotice", SelectNotices)); } return(RedirectToAction("../Home/Index")); }
public string SignIn(CMember m, CNotice c) { List <CMember> SELECTMember = CMemberFactory.fn會員查詢(); CMember member = SELECTMember.FirstOrDefault(n => n.fAccount == m.fAccount); var data = ""; if (member == null) { string str = m.fPassword + "QAQ"; var md5 = CMemberFactory.MD5驗證碼新增(str); m.fMoneyPoint = 100; m.fPhoto = "../Image/MemberImage/Member.jpg"; m.fRegisterDateTime = DateTime.UtcNow.AddHours(08); m.fLastLoginDateTime = DateTime.UtcNow.AddHours(08); m.fIsVIP = false; m.fIsBanned = false; m.fThePasswordURL = md5; m.fTheAddress = m.fCity + m.fTown + m.fTheAddress; CMemberFactory.fn會員新增(m); //會員註冊訊息新增---------------------------------------------------------------\\ List <CMember> SELECTMember2 = CMemberFactory.fn會員查詢(); CMember member2 = SELECTMember2.FirstOrDefault(n => n.fAccount == m.fAccount); c.fNoticeDatetime = DateTime.UtcNow.AddHours(08); c.fNoticeContent = m.fFirstName + m.fLastName + "歡迎加入Notedge!"; c.fCategoryType = "系統"; c.fLink = "我是超連結"; c.fMemberId = member2.fMemberId; CNoticeFactory.fn通知訊息新增(member2, c); //會員註冊新增未分類筆記----------------------------------------------------------\\ CNoteFolderFactory.fn建立預設筆記資料夾(member2); data = "新增成功"; return(data); } else { data = "新增失敗"; ViewBag.Message = "信箱與人重複,請重新輸入"; return(data); } }
//將選取的對象加入黑名單 public string commentboard(int commentid, string content, int memberid) { CAdmin admin = Session[CAdminSession.Session_Login_User] as CAdmin; var comment = CCommentFactory.fn留言查詢().FirstOrDefault(m => m.fCommentId == commentid); comment.fContent = content; comment.fIsBanned = true; CCommentFactory.fn留言更新(comment); var member = CMemberFactory.fn會員查詢().FirstOrDefault(n => n.fMemberId == memberid); CNotice c = new CNotice(); c.fNoticeDatetime = DateTime.UtcNow.AddHours(08); c.fNoticeContent = "此留言因涉及違規發言已被遮蔽"; c.fCategoryType = "管理員"; c.fLink = "超連結"; c.fMemberId = member.fMemberId; CNoticeFactory.fn通知訂單訊息新增(c); return("遮蔽原因更新成功!"); }
//將選取的對象解除黑名單 public string unlockBlacklist(int bannid, int memberid) { CAdmin admin = Session[CAdminSession.Session_Login_User] as CAdmin; List <CBlackList> blacklist = new List <CBlackList>(); var unlock = CBlackListFactory.fn黑名單查詢().FirstOrDefault(m => m.fBannedId == bannid); var member = CMemberFactory.fn會員查詢().FirstOrDefault(n => n.fMemberId == memberid); member.fIsBanned = false; CMemberFactory.fn會員更新(member); CBlackListFactory.fn黑名單刪除(unlock); CNotice c = new CNotice(); c.fNoticeDatetime = DateTime.UtcNow.AddHours(08); c.fNoticeContent = "此帳號已從黑名單解鎖"; c.fCategoryType = "管理員"; c.fLink = "超連結"; c.fMemberId = member.fMemberId; CNoticeFactory.fn通知訂單訊息新增(c); return("解鎖成功!"); }
public void ToOrder(int totalprice, int remain, int cartId) { CMember member = (CMember)Session[CMemberSession.Session_Login_User];//會員 COrder o = new COrder(); o.fPurchaseDate = DateTime.UtcNow.AddHours(08); o.fTotalPrice = totalprice; o.fMemberId = member.fMemberId; COrderFactory.fn訂單新增(o); CMemberFactory.fn會員更新點數(member, remain); CNotice c = new CNotice(); c.fCategoryType = "系統"; c.fLink = "超連結"; c.fNoticeDatetime = DateTime.UtcNow.AddHours(08); c.fMemberId = member.fMemberId; c.fNoticeContent = "您的訂單已完成了"; CNoticeFactory.fn通知訂單訊息新增(c); List <CCartProduct> CP = CCartProductFactory.fn購物車商品個人查詢(cartId).ToList(); var f = CNoteFolderFactory.fn筆記資料夾查詢(member).Where(q => q.fFolderName == "未分類筆記").ToList(); int orderid = COrderFactory.fn訂單查詢(member).LastOrDefault().fOrderId; foreach (var a in CP) { CDetailOrderFactory.fn訂單明細新增(orderid, a.fProductId); CNotice c1 = new CNotice(); c1.fCategoryType = "銷售"; c1.fLink = "超連結"; c1.fNoticeDatetime = DateTime.UtcNow.AddHours(08); c1.fMemberId = a.fMemberSellerId; c1.fNoticeContent = "您的" + a.fName + "已被購買"; CNoticeFactory.fn通知訂單訊息新增(c1); CIncome i1 = new CIncome(); i1.fIncome = a.fPrice; i1.fPaymentDateTime = DateTime.UtcNow.AddHours(08); i1.fIncomeCategory = "獲利"; i1.fMemberId = a.fMemberSellerId; CIncomeFactory.fn公司獲利新增(i1); var point = CMemberFactory.fn會員查詢().Where(z => z.fMemberId == a.fMemberSellerId); int point1 = (point.Single().fMoneyPoint) + a.fPrice; CMember cm1 = new CMember(); cm1.fMemberId = point.Single().fMemberId; CMemberFactory.fn會員更新點數(cm1, point1); var t = CNoteFactory.fn私人筆記全部查詢().Where(q => q.fFolderId == f.Single().fFolderId).ToList(); int t1 = t.Count(); CNote n = new CNote(); n.fNoteListName = a.fName; n.fCreateDateTime = DateTime.UtcNow.AddHours(08); n.fEditDateTime = DateTime.UtcNow.AddHours(08); n.fNoteListLevel = t1; n.fIsMyFavourite = false; n.fIsTrash = false; n.fFolderId = f.Single().fFolderId; n.fJsonContent = a.fContent; n.fTheShareLink = null; n.fTheContactPerson = null; n.fHTMLContent = ""; CNoteFactory.fn訂單私人筆記新增(n); } CCartFactory.fn購物車個人更新(cartId); }
//登入後主畫面-------------------------------------------------------------------------------\\ public ActionResult MyHome(string name, string id, CNotice c) { CMember member = Session[CMemberSession.Session_Login_User] as CMember; //創造一組亂數字串不重複的訂單編號 var str = "123456789ABCDEFGHIJKLMNPQRSTUVWXYZabcdefhijklmnorstuvwxz"; var next = new Random(); var builder = new StringBuilder(); for (var i = 0; i < 10; i++) { builder.Append(str[next.Next(0, str.Length)]); } //MerchantID(不可變動),MerchantTradeNo(亂數訂單編號),MerchantTradeDate(抓取當前日期時間) int MerchantID = 2000132; var MerchantTradeNo = builder; string MerchantTradeDate = DateTime.UtcNow.AddHours(08).ToString("yyyy/MM/dd hh:mm:ss"); /*tring ReturnUrl = "https://localhost:44300/Home/MyHome?id=" + MerchantTradeNo;*/ string ReturnUrl = "https://noteledge.azurewebsites.net/Home/MyHome?id=" + MerchantTradeNo; string ProductName = "Notedge尊爵鑽石豪華VIP頂級會員"; int Amount = 99; //把需要的資料作串接 string Url = "HashKey=5294y06JbISpM5x9&ChoosePayment=ALL&ChooseSubPayment=&ClientBackURL=" + ReturnUrl + "&EncryptType=1&ItemName=" + ProductName + "&MerchantID=" + MerchantID + "&MerchantTradeDate=" + MerchantTradeDate + "&MerchantTradeNo=" + MerchantTradeNo + "&PaymentType=aio&ReturnURL=" + ReturnUrl + "&StoreID=&TotalAmount=" + Amount + "&TradeDesc=建立全金流測試訂單&HashIV=v77hoKGq4kWxNNIS"; //串接好的資料轉成Encoded var Encoded = System.Web.HttpUtility.UrlEncode(Url); //Encoded 轉成 小寫 encoded var encoded = Encoded.ToLower(); //呼叫sha256_hash(encoded)轉換成SHA256 在轉換大寫 string SHA256 = sha256_hash(encoded).ToUpper(); //把資料傳到前端 ViewBag.MerchantID = MerchantID; ViewBag.MerchantTradeNo = MerchantTradeNo; ViewBag.MerchantTradeDate = MerchantTradeDate; ViewBag.SHA256 = SHA256; ViewBag.Url = ReturnUrl; ViewBag.ProductName = ProductName; ViewBag.Amount = Amount; if (id != null) { List <CMember> SelecteMember = CMemberFactory.fn會員查詢(); CMember cMember = SelecteMember.FirstOrDefault(n => n.fMemberId == member.fMemberId); cMember.fIsVIP = true; cMember.fMoneyPoint = cMember.fMoneyPoint + 500; CMemberFactory.fn會員更新(cMember); //成為VIP新增通知----------------------------------------------------------------------\\ c.fNoticeDatetime = DateTime.UtcNow.AddHours(08); c.fNoticeContent = cMember.fFirstName + cMember.fLastName + "您已成為Notedge尊爵鑽石豪華VIP頂級會員"; c.fCategoryType = "系統"; c.fLink = "連結"; c.fMemberId = member.fMemberId; CNoticeFactory.fn通知訊息新增(member, c); Session[CMemberSession.Session_Login_User] = cMember; if (Session[CMemberSession.Session_Login_User] == null && name == null) { Session[CMemberSession.Session_Login_User] = null; return(RedirectToAction("../Home/Index")); } else { ViewBag.name = name; return(View("../Home/MyHome", "_Layout")); } } if (Session[CMemberSession.Session_Login_User] == null && name == null) { Session[CMemberSession.Session_Login_User] = null; return(RedirectToAction("../Home/Index")); } else { if (name == null) { var SelectNoticess = CNoticeFactory.fn通知訊息查詢(member).Where(n => n.fCategoryType == "銷售" || n.fCategoryType == "評價留言").OrderByDescending(n => n.fNoticeDatetime); var SelectChats = CChatFactory.fn聊聊查詢(member).Where(n => n.fMemberTo == member.fMemberId).OrderByDescending(n => n.fSubmitDateTime); int MCounts = SelectChats.Count(); int SCounts = SelectNoticess.Count(); CMemberMessage memberMessage = new CMemberMessage(); if (Session[CMemberSession.Session_Message_Count] == null) { memberMessage.MessageBell = MCounts; Session[CMemberSession.Session_Message_Count] = memberMessage; } if (Session[CMemberSession.Session_sale_Count] == null) { memberMessage.SaleBell = SCounts; Session[CMemberSession.Session_sale_Count] = memberMessage; } return(View("../Home/MyHome", "_Layout")); } else { ViewBag.name = name; return(View("../Home/MyHome", "_Layout")); } } }