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 string Show(string type, string actor, string bookname) { CommercedataContext context = new CommercedataContext(); var list = (from f in context.SupplierBookInfo join s in context.BookInfo on f.Isbn equals s.Isbn join t in context.NextClassType on s.NclassId equals t.NclassId join fs in context.AuthorInfo on s.AuthorId equals fs.AuthorId select new { bookName = s.Title, actoreName = fs.Aname, chuBan = s.Publish, time = Convert.ToDateTime(s.PublishTime), price = s.Price, zhe = f.Discount, shangJia = f.SupplierId, bookBian = f.Isbn, bookType = t.NclassName }).ToList(); if (type != null) { list = list.Where(s => s.bookType.Equals(type)).ToList(); } if (actor != null) { list = list.Where(s => s.actoreName.Equals(actor)).ToList(); } if (bookname != null) { list = list.Where(s => s.bookName.Equals(bookname)).ToList(); } string str = ""; Dictionary <string, object> obje = new Dictionary <string, object>(); obje.Add("data", list); obje.Add("count", list.Count); str = JsonConvert.SerializeObject(obje); return(str); }
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 AddOrder(OrderItems addOrder) { int count = 0; CommercedataContext context = new CommercedataContext(); OrderItems item = new OrderItems(); item.BookName = addOrder.BookName; item.BookPrice = addOrder.BookPrice; item.Isbn = addOrder.Isbn; item.OrderId = addOrder.OrderId; item.OrderitemId = addOrder.OrderitemId; item.Quantity = 1; item.Statue = "未支付"; item.SupplierId = addOrder.SupplierId; List <OrderItems> list = context.OrderItems.ToList(); list = list.Where(s => s.OrderitemId.Equals(addOrder.OrderitemId) && s.OrderId.Equals(addOrder.OrderId)).ToList(); if (list.Count != 0) { return(0); } context.OrderItems.Add(item); count = context.SaveChanges(); return(count); }
public string GetBookInfo(string typeId, string authorName = "", string title = "", string pubish = "", int pageName = 1, int limitName = 10) { using (CommercedataContext context = new CommercedataContext()) { var list = (from da in context.BookInfo join du in context.AuthorInfo on da.AuthorId equals du.AuthorId join dd in context.NextClassType on da.NclassId equals dd.NclassId where dd.NclassId == typeId select new { da.Isbn, da.Title, da.Publish, da.PublishTime, da.Price, du.AuthorId, du.Aname, dd.NclassId, dd.NclassName }).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 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 List <NextClassType> GetTypeData() { using (CommercedataContext context = new CommercedataContext()) { List <NextClassType> list = context.NextClassType.ToList(); return(list); } }
public int DelBookData(string Isbn) { using (CommercedataContext context = new CommercedataContext()) { var list = (from s in context.SupplierBookInfo where s.Isbn == Isbn select s).FirstOrDefault(); context.SupplierBookInfo.Remove(list); return(context.SaveChanges()); } }
public int UpdaBookSate(string Isbn) { using (CommercedataContext context = new CommercedataContext()) { var list = (from s in context.SupplierBookInfo where s.Isbn == Isbn select s).FirstOrDefault(); list.BookStues = "出售中"; context.SupplierBookInfo.Update(list); return(context.SaveChanges()); } }
public string GetBookData(string Isbn) { using (CommercedataContext context = new CommercedataContext()) { var list = (from da in context.BookInfo join du in context.AuthorInfo on da.AuthorId equals du.AuthorId join dd in context.NextClassType on da.NclassId equals dd.NclassId where da.Isbn == Isbn select new { da.Isbn, da.Title, da.Publish, da.PublishTime, da.Price, da.Revision, da.Page, du.AuthorId, du.Aname, dd.NclassId, dd.NclassName }).FirstOrDefault(); return(JsonConvert.SerializeObject(list)); } }
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 GetCkBookData(string Isbn) { using (CommercedataContext context = new CommercedataContext()) { var list = (from da in context.BookInfo join du in context.AuthorInfo on da.AuthorId equals du.AuthorId join dc in context.NextClassType on da.NclassId equals dc.NclassId join dd in context.SupplierBookInfo on da.Isbn equals dd.Isbn 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, dc.NclassName }).FirstOrDefault(); 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 AddGuan(ManageInfo manageInfo) { int count = 0; CommercedataContext context = new CommercedataContext(); List <ManageInfo> list = context.ManageInfo.ToList(); list = list.Where(s => s.ManageId.Equals(manageInfo.ManageId)).ToList(); if (list.Count != 0) { return(0); } context.ManageInfo.Add(manageInfo); count = context.SaveChanges(); return(count); }
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 int AddGu(Customer customer) { int count = 0; CommercedataContext context = new CommercedataContext(); customer.UserReddate = DateTime.Now; List <Customer> list = context.Customer.ToList(); list = list.Where(s => s.AccountId.Equals(customer.AccountId)).ToList(); if (list.Count != 0) { return(0); } context.Customer.Add(customer); 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()); } }
public LoginClass Login(LoginClass login) { CommercedataContext context = new CommercedataContext(); LoginClass ret = new LoginClass(); JWTHelper jwtHeader = new JWTHelper(); string jiami = ""; List <Customer> client = new List <Customer>(); List <UserRoderInfo> supplier = new List <UserRoderInfo>(); List <ManageInfo> Administrator = new List <ManageInfo>(); if (login.Table == "Customer") { client = context.Customer.ToList(); if (!string.IsNullOrEmpty(login.AccountName)) { client = client.Where(s => s.AccountName.Equals(login.AccountName.Trim())).ToList(); } if (!string.IsNullOrEmpty(login.AccountPwd)) { client = client.Where(s => s.AccountPwd.Equals(login.AccountPwd.Trim())).ToList(); } if (client.Count == 1) { Dictionary <string, object> keys = new Dictionary <string, object>(); keys.Add("AccountName", client[0].AccountName); keys.Add("TouMoney", client[0].AccountPwd); keys.Add("AccountId", client[0].AccountId); jiami = jwtHeader.GetToken(keys, 600000); ret.AccountName = login.AccountName; ret.AccountPwd = login.AccountPwd; ret.Quan = "顾客"; ret.Encipherment = jiami; ret.Name = client[0].UserName; } return(ret); } if (login.Table == "UserRoderInfo") { supplier = context.UserRoderInfo.ToList(); if (!string.IsNullOrEmpty(login.AccountName)) { supplier = supplier.Where(s => s.ContactName.Equals(login.AccountName.Trim())).ToList(); } if (!string.IsNullOrEmpty(login.AccountPwd)) { supplier = supplier.Where(s => s.SupplierPwd.Equals(login.AccountPwd.Trim())).ToList(); } if (supplier.Count == 1) { Dictionary <string, object> keys = new Dictionary <string, object>(); keys.Add("ContactName", supplier[0].ContactName); keys.Add("SupplierPwd", supplier[0].SupplierPwd); keys.Add("SuppLierID", supplier[0].SuppLierId); jiami = jwtHeader.GetToken(keys, 600000); ret.AccountName = login.AccountName; ret.AccountPwd = login.AccountPwd; ret.Quan = "供应商"; ret.Encipherment = jiami; ret.Name = supplier[0].TrueName; } return(ret); } if (login.Table == "ManageInfo") { Administrator = context.ManageInfo.ToList(); if (!string.IsNullOrEmpty(login.AccountName)) { Administrator = Administrator.Where(s => s.ManagerUserName.Equals(login.AccountName.Trim())).ToList(); } if (!string.IsNullOrEmpty(login.AccountPwd)) { Administrator = Administrator.Where(s => s.ManagerPwd.Equals(login.AccountPwd.Trim())).ToList(); } if (Administrator.Count == 1) { Dictionary <string, object> keys = new Dictionary <string, object>(); keys.Add("ManagerUserName", Administrator[0].ManagerUserName); keys.Add("ManagerPwd", Administrator[0].ManagerPwd); keys.Add("ManageId", Administrator[0].ManageId); jiami = jwtHeader.GetToken(keys, 600000); ret.AccountName = login.AccountName; ret.AccountPwd = login.AccountPwd; ret.Quan = "管理员"; ret.Encipherment = jiami; ret.Name = Administrator[0].ManagerUserName; } return(ret); } else { return(ret); } }