/// <summary> /// 反填商家信息 /// </summary> /// <returns></returns> public UserRoderInfo ModifySupplier(string suppliserid) { var listsupplier = dal.AllRoderInfo().ToList(); UserRoderInfo mode = listsupplier.Where(m => m.SuppLierId.Contains(suppliserid)).FirstOrDefault(); //if (mode.AllSaledAccount >= 1000 && mode.AllSaledAccount <= 2000) //{ // mode.QuanTity = 40; // mode.SuoolierType = "会员商家"; //} //else if (mode.AllSaledAccount < 1000) //{ // mode.QuanTity = 20; // mode.SuoolierType = "普通商家"; //} //else //{ // mode.QuanTity = 60; // mode.SuoolierType = "超级商家"; //} return(mode); }
public int UpdUserRoder(Dictionary <string, object> dic) { using (CommercedataContext context = new CommercedataContext()) { UserRoderInfo info = JsonConvert.DeserializeObject <UserRoderInfo>(dic["obj"].ToString()); string token = dic["token"].ToString(); if (token == "undefined") { return(0); } JWTHelper jWT = new JWTHelper(); UserRoderInfo user = JsonConvert.DeserializeObject <UserRoderInfo>(jWT.GetPayload(token)); var ue = context.UserRoderInfo.Where(n => n.ContactName.Equals(user.ContactName) && n.SupplierPwd.Equals(user.SupplierPwd)).FirstOrDefault(); if (ue == null) { return(0); } string SupplierId = ue.SuppLierId; var list = (from s in context.UserRoderInfo where s.SuppLierId == SupplierId select s).FirstOrDefault(); list.ShopName = info.ShopName; list.ShopAddress = info.ShopAddress; list.ContactName = info.ContactName; list.CortactPhone = info.CortactPhone; list.Mail = info.Mail; list.TrueName = info.TrueName; context.UserRoderInfo.Update(list); //context.Set<UserRoderInfo>().Where(n=>n.SuppLierId.Equals(SupplierId)).Update(info); //context.Entry<UserRoderInfo>(info).State = EntityState.Modified; return(context.SaveChanges()); } }
public int InsertBook(Dictionary <string, object> dic) { using (CommercedataContext context = new CommercedataContext()) { SupplierBookInfo info = JsonConvert.DeserializeObject <SupplierBookInfo>(dic["obj"].ToString()); string token = dic["token"].ToString(); if (token == "undefined") { return(0); } JWTHelper jWT = new JWTHelper(); UserRoderInfo user = JsonConvert.DeserializeObject <UserRoderInfo>(jWT.GetPayload(token)); var ue = context.UserRoderInfo.Where(n => n.ContactName.Equals(user.ContactName) && n.SupplierPwd.Equals(user.SupplierPwd)).FirstOrDefault(); if (ue == null) { return(0); } string SupplierId = ue.SuppLierId; var list = (from s in context.SupplierBookInfo where s.Isbn == info.Isbn select s).FirstOrDefault(); if (list == null) { info.Score = 0; info.SaledQuantity = 0; info.BookStues = "未出售"; info.SupplierId = SupplierId; context.SupplierBookInfo.Add(info); return(context.SaveChanges()); } else { return(0); } } }
public string GetGoodSH(string token = "", int pageName = 1, int limitName = 10) { using (CommercedataContext context = new CommercedataContext()) { if (token == "undefined") { return(""); } JWTHelper jWT = new JWTHelper(); UserRoderInfo user = JsonConvert.DeserializeObject <UserRoderInfo>(jWT.GetPayload(token)); var ue = context.UserRoderInfo.Where(n => n.ContactName.Equals(user.ContactName) && n.SupplierPwd.Equals(user.SupplierPwd)).FirstOrDefault(); if (ue == null) { return(""); } string SupplierId = ue.SuppLierId; var list = (from da in context.OrderItems join du in context.UserorderRecound on da.OrderId equals du.OrderId join dd in context.SupplierBookInfo on da.SupplierId equals dd.SupplierId where da.SupplierId == SupplierId && du.DelivaeryStatue == "待确认收货" select new { da.Isbn, da.SupplierId, da.BookName, da.BookPrice, da.Quantity, da.Statue, du.OrderId, du.BuyNum, du.ConsigName, du.ClinchTime, du.PayStatues, du.OrderStatue, du.DelivaeryStatue }).Distinct().ToList(); Dictionary <string, object> dic = new Dictionary <string, object>(); dic.Add("data", list); dic.Add("count", list.Count); return(JsonConvert.SerializeObject(dic)); } }
public int UpdBook(Dictionary <string, object> dic) { using (CommercedataContext context = new CommercedataContext()) { SupplierBookInfo info = JsonConvert.DeserializeObject <SupplierBookInfo>(dic["obj"].ToString()); string token = dic["token"].ToString(); if (token == "undefined") { return(0); } JWTHelper jWT = new JWTHelper(); UserRoderInfo user = JsonConvert.DeserializeObject <UserRoderInfo>(jWT.GetPayload(token)); var ue = context.UserRoderInfo.Where(n => n.ContactName.Equals(user.ContactName) && n.SupplierPwd.Equals(user.SupplierPwd)).FirstOrDefault(); if (ue == null) { return(0); } string SupplierId = ue.SuppLierId; var list = (from s in context.SupplierBookInfo where s.Isbn == info.Isbn select s).FirstOrDefault(); list.Price = info.Price; list.Discount = info.Discount; list.TotalQuantity = info.TotalQuantity; list.BookType = info.BookType; context.SupplierBookInfo.Update(list); return(context.SaveChanges()); } }
public int ModifyInfo(string mode) { UserRoderInfo mods = JsonConvert.DeserializeObject <UserRoderInfo>(mode); return(dal.ModifyRoderInfo(mods)); }
public string GetGoodPJ(string token = "", int pageName = 1, int limitName = 10) { using (CommercedataContext context = new CommercedataContext()) { if (token == "undefined") { return(""); } JWTHelper jWT = new JWTHelper(); UserRoderInfo user = JsonConvert.DeserializeObject <UserRoderInfo>(jWT.GetPayload(token)); var ue = context.UserRoderInfo.Where(n => n.ContactName.Equals(user.ContactName) && n.SupplierPwd.Equals(user.SupplierPwd)).FirstOrDefault(); if (ue == null) { return(""); } string SupplierId = ue.SuppLierId; var list = (from da in context.ReplyInfo join dd in context.SupplierBookInfo on da.SupplierId equals dd.SupplierId where da.SupplierId == SupplierId select new { da.Isbn, da.Replay }).ToList().GroupBy(a => a.Isbn).Select(a => new ReplyModel { Isbn = a.Key, ReplyA = (from s in a select s.Replay).ToList() } ); //var listResult = from s in list // select new ReplyModel // { // Isbn = s.Key, // ReplyA = (from a in s select a.Replay).ToList() // }; // select new ReplyModel { ReplyA = new List<ReplyInfo> { new ReplyInfo { Replay = g.v } }, Isbn = g.Key.Isbn }).ToList(); //var query = list.GroupBy(s => s.Isbn).Select(x => x.First()).ToList(); //var linq=from s in context.ReplyInfo where //string ss= JsonConvert.SerializeObject(list); //ReplyInfo reply = JsonConvert.DeserializeObject<ReplyInfo>(ss); //var query = reply.DistinctBy(p=>p.Isbn); //Dictionary<string, object> dic = new Dictionary<string, object>(); //dic.Add("data", list); //dic.Add("count", list.Count); return(JsonConvert.SerializeObject(list)); } }
public string GetCkZBookInfo(string token = "", string authorName = "", string title = "", string pubish = "", int pageName = 1, int limitName = 10) { using (CommercedataContext context = new CommercedataContext()) { if (token == "undefined") { return(""); } JWTHelper jWT = new JWTHelper(); UserRoderInfo user = JsonConvert.DeserializeObject <UserRoderInfo>(jWT.GetPayload(token)); var ue = context.UserRoderInfo.Where(n => n.ContactName.Equals(user.ContactName) && n.SupplierPwd.Equals(user.SupplierPwd)).FirstOrDefault(); if (ue == null) { return(""); } string SupplierId = ue.SuppLierId; var list = (from da in context.BookInfo join du in context.AuthorInfo on da.AuthorId equals du.AuthorId join dd in context.SupplierBookInfo on da.Isbn equals dd.Isbn where dd.BookStues == "出售中" && dd.SupplierId == SupplierId select new { da.Isbn, da.Title, da.Publish, da.PublishTime, dd.Price, dd.TotalQuantity, dd.Discount, dd.BookType, dd.SaledQuantity, dd.BookStues, du.AuthorId, du.Aname }).ToList(); if (!string.IsNullOrEmpty(authorName)) { list = list.Where(n => n.Aname.Contains(authorName)).ToList(); } if (!string.IsNullOrEmpty(title)) { list = list.Where(n => n.Title.Contains(title)).ToList(); } if (!string.IsNullOrEmpty(pubish)) { list = list.Where(n => n.Publish.Contains(pubish)).ToList(); } var slist = list.Skip((pageName - 1) * limitName).Take(limitName).ToList(); Dictionary <string, object> obj = new Dictionary <string, object>(); //前台通过key值获得对应的value值 obj.Add("code", 0); obj.Add("msg", ""); obj.Add("count", list.Count); obj.Add("data", slist); return(JsonConvert.SerializeObject(obj)); } }
public int AddGong(UserRoderInfo userRoder) { int count = 0; CommercedataContext context = new CommercedataContext(); userRoder.RegDate = DateTime.Now; List <UserRoderInfo> list = context.UserRoderInfo.ToList(); list = list.Where(s => s.SuppLierId.Equals(userRoder.SuppLierId)).ToList(); if (list.Count != 0) { return(0); } context.UserRoderInfo.Add(userRoder); count = context.SaveChanges(); return(count); }
public string GetUserRoder(string token = "") { using (CommercedataContext context = new CommercedataContext()) { if (token == "undefined") { return(""); } JWTHelper jWT = new JWTHelper(); UserRoderInfo user = JsonConvert.DeserializeObject <UserRoderInfo>(jWT.GetPayload(token)); var ue = context.UserRoderInfo.Where(n => n.ContactName.Equals(user.ContactName) && n.SupplierPwd.Equals(user.SupplierPwd)).FirstOrDefault(); if (ue == null) { return(""); } string SupplierId = ue.SuppLierId; var list = (from s in context.UserRoderInfo where s.SuppLierId == SupplierId select s).FirstOrDefault(); return(JsonConvert.SerializeObject(list)); } }
public int UpdGoodFH(string token = "", string orderId = "") { using (CommercedataContext context = new CommercedataContext()) { if (token == "undefined") { return(0); } JWTHelper jWT = new JWTHelper(); UserRoderInfo user = JsonConvert.DeserializeObject <UserRoderInfo>(jWT.GetPayload(token)); var ue = context.UserRoderInfo.Where(n => n.ContactName.Equals(user.ContactName) && n.SupplierPwd.Equals(user.SupplierPwd)).FirstOrDefault(); if (ue == null) { return(0); } var list = context.UserorderRecound.Where(n => n.OrderId.Equals(orderId)).FirstOrDefault(); list.OrderStatue = "已发货"; context.UserorderRecound.Update(list); return(context.SaveChanges()); } }
public int UpdxBookSate(string token, string Isbn) { using (CommercedataContext context = new CommercedataContext()) { if (token == "undefined") { return(0); } JWTHelper jWT = new JWTHelper(); UserRoderInfo user = JsonConvert.DeserializeObject <UserRoderInfo>(jWT.GetPayload(token)); var ue = context.UserRoderInfo.Where(n => n.ContactName.Equals(user.ContactName) && n.SupplierPwd.Equals(user.SupplierPwd)).FirstOrDefault(); if (ue == null) { return(0); } string SupplierId = ue.SuppLierId; var list = (from s in context.SupplierBookInfo where s.Isbn == Isbn select s).FirstOrDefault(); list.BookStues = "未出售"; context.SupplierBookInfo.Update(list); return(context.SaveChanges()); } }
/// <summary> /// 修改商家信息 /// </summary> /// <param name="mode"></param> /// <returns></returns> public int ModifyRoderInfo(UserRoderInfo mode) { return(Roder.Modify(mode)); }
/// <summary> /// 注册商家信息 /// </summary> /// <param name="mode"></param> /// <returns></returns> public int AddRoderInfo(UserRoderInfo mode) { return(Roder.Add(mode)); }