public IActionResult CreateUser(UserDto model) { var user = _context.User.Where(x => x.OpenId == model.OpenId).FirstOrDefault(); if (user == null) { string ip = HttpContext.Connection.RemoteIpAddress.ToString(); var UserInfo = new User() { Ip = ip, Name = WebUtility.UrlEncode(model.Name), Avatar = model.Avatar, OpenId = model.OpenId, CreatDate = model.CreatDate, UpDate = model.UpDate }; _context.User.Add(UserInfo); _context.SaveChanges(); return(Ok("新增成功")); } else { string ip = HttpContext.Connection.RemoteIpAddress.ToString(); User info = _context.User.Where(d => d.OpenId == model.OpenId).FirstOrDefault(); info.Name = WebUtility.UrlEncode(model.Name); info.Avatar = model.Avatar; info.UpDate = model.UpDate; info.Ip = ip; _context.SaveChanges(); return(Ok("修改成功!")); } }
public IActionResult Login([FromBody] SysUserDto sysUserDto) { try { var sysuserinfo = _context.SysUsers.Where(x => x.Account == sysUserDto.Account).FirstOrDefault(); if (sysuserinfo == null) { return(BadRequest("不存在此账号!")); } PwdTransition pwdTransition = new PwdTransition(); var Hashpwd = pwdTransition.ToHash(sysUserDto.Pwd, sysuserinfo.Salt); if (sysuserinfo.Pwd != Hashpwd) { return(BadRequest("密码不正确!请重新输入")); } string validateNum = HttpContext.Session.GetString("Code_ValidateNum"); HttpContext.Session.Remove("Code_ValidateNum"); if (validateNum != sysUserDto.Code.ToUpper()) { return(BadRequest("输入验证码有误!")); } var token = Guid.NewGuid().ToString(); sysuserinfo.Token = token; sysuserinfo.Ip = HttpContext.Connection.RemoteIpAddress.ToString(); _context.SaveChanges(); var loginInfo = sysuserinfo.SysUserId + "&" + token; return(Ok(loginInfo)); } catch (Exception ex) { return(StatusCode(500, ex.Message)); } }
public IActionResult PostGoods([FromBody] GoodsDto model) { try { var Goods = new Goods() { SysUserId = model.SysUserId, GoodsKindId = model.GoodsKindId, NewPrice = model.NewPrice, OldPrice = model.OldPrice, Notice = model.Notice, Name = model.Name, Img = model.Img, CreatDate = DateTime.Now, Comment1 = "上架", Comment2 = model.Comment2 }; _context.Goodss.Add(Goods); _context.SaveChanges(); return(Ok("添加成功")); } catch (Exception ex) { return(StatusCode(500, ex.Message)); } }
public IActionResult PostKind([FromBody] GoodsKindDto model) { try { var Kind = new GoodsKind() { GoodsBigKindId = model.GoodsBigKindId, SysUserId = model.SysUserId, Name = model.Name, Index = model.Index, Img = model.Img, CreatDate = DateTime.Now, UpDate = DateTime.Now, }; _context.GoodsKinds.Add(Kind); _context.SaveChanges(); return(Ok("添加成功")); } catch (Exception ex) { return(StatusCode(500, ex.Message)); } }
public IActionResult AddCart(AppCartDto appCartDto) { try { var UserId = _context.User.Where(i => i.OpenId == appCartDto.OpenId).FirstOrDefault().UserId; var checkObj = _context.AppCarts.Where(x => x.GoodsId == appCartDto.GoodsId && x.UserId == UserId).FirstOrDefault(); //判断该人是否购物车里添加过该商品 if (checkObj == null) { var AppCartObj = new AppCart(); AppCartObj.Num = appCartDto.Num; AppCartObj.Seclect = true; AppCartObj.GoodsId = appCartDto.GoodsId; AppCartObj.UserId = UserId; AppCartObj.CreatDate = DateTime.Now; AppCartObj.UpDate = DateTime.Now; _context.AppCarts.Add(AppCartObj); } else { checkObj.Num = appCartDto.Num + checkObj.Num; checkObj.UpDate = DateTime.Now; } _context.SaveChanges(); return(Ok("添加成功")); } catch (Exception ex) { return(StatusCode(500, ex.Message)); } }
public static void SeedRoles(SupermarketDbContext context, RoleManager <ApplicationRole> roleManager) { var roles = new List <ApplicationRole>() { new ApplicationRole() { Name = ApplicationUser.Roles.admin, NormalizedName = ApplicationUser.Roles.Admin }, new ApplicationRole() { Name = ApplicationUser.Roles.storeKeeper, NormalizedName = ApplicationUser.Roles.StoreKeeper }, new ApplicationRole() { Name = ApplicationUser.Roles.manager, NormalizedName = ApplicationUser.Roles.Manager }, }; roles.ForEach(role => { var dbRole = context.Roles.FirstOrDefault(r => r.Name == role.Name); if (dbRole == null) { context.Roles.Add(role); } }); context.SaveChanges(); }
/// <summary> /// 用户信息导入 /// </summary> /// <returns></returns> public IActionResult ImportMemInfJob() { using var context = new SupermarketDbContext(); StreamReader sr = new StreamReader("test.txt"); string name, phone, password; for (int i = 0; i < 3; i++) { var member = new Member() { Credit = 0 }; name = sr.ReadLine(); member.Name = name; phone = sr.ReadLine(); member.Phone = phone; password = sr.ReadLine(); member.Password = password; context.Member.Add(member); context.SaveChanges(); } return(View()); }
public static void SeedProducts(SupermarketDbContext context) { var faker = new Faker(); string product1 = faker.Commerce.ProductName(); string product2 = faker.Commerce.ProductName(); string product3 = faker.Commerce.ProductName(); string product4 = faker.Commerce.ProductName(); var category = context.Categories.FirstOrDefault(p => p.Name == "Electronics"); var category2 = context.Categories.FirstOrDefault(p => p.Name == "Toiletries"); var category3 = context.Categories.FirstOrDefault(p => p.Name == "Miscellaneous"); var category4 = context.Categories.FirstOrDefault(p => p.Name == "Fashion"); var products = new List <Product>() { new Product() { Name = product1, QuantityInStock = faker.Random.Number(1, 9), UnitOfMeasurement = EUnitOfMeasurement.Kilogram, CategoryId = category.Id }, new Product() { Name = product2, QuantityInStock = faker.Random.Number(2, 12), UnitOfMeasurement = EUnitOfMeasurement.Kilogram, CategoryId = category2.Id }, new Product() { Name = product3, QuantityInStock = faker.Random.Number(3, 13), UnitOfMeasurement = EUnitOfMeasurement.Gram, CategoryId = category3.Id }, new Product() { Name = product4, QuantityInStock = faker.Random.Number(5, 15), UnitOfMeasurement = EUnitOfMeasurement.Kilogram, CategoryId = category4.Id } }; products.ForEach(product => { var dbProduct = context.Products.FirstOrDefault(p => p.Name == product.Name); if (dbProduct == null) { context.Products.Add(product); } }); context.SaveChanges(); }
public IActionResult CreateLottery([FromBody] LotteryDto lotteryDto) { try { var LotteryInfo = new Lottery() { Name = lotteryDto.Name, Probability = lotteryDto.Probability, CreatDate = DateTime.Now, SysUserId = lotteryDto.SysUserId }; _context.Lotterys.Add(LotteryInfo); _context.SaveChanges(); return(Ok("新增成功")); } catch (Exception ex) { return(StatusCode(500, ex.Message)); } }
/// <summary> /// 会员等级修改 /// </summary> /// <param name="memberid"></param> /// <param name="levelafter"></param> /// <returns></returns> public IActionResult MemberLevelChange(int memberid, int levelafter) { using var context = new SupermarketDbContext(); var levelitems = context.MemberLevelMapping.FirstOrDefault(x => x.MemberId.Equals(memberid)); levelitems.LevelId = levelafter; context.SaveChanges(); return(View()); }
/// <summary> /// 会员制度管理 /// </summary> /// <param name="viplevelid"></param> /// <param name="levelrateafter"></param> /// <returns></returns> public IActionResult VipManageJob(int viplevelid, double levelrateafter) { using var context = new SupermarketDbContext(); var levelitems = context.Level.FirstOrDefault(x => x.Id.Equals(viplevelid)); levelitems.DiscountRate = levelrateafter; context.SaveChanges(); return(View()); }
public IActionResult CreateAddr(AddressDto model) { var UserId = _context.User.Where(i => i.OpenId == model.OpenId).FirstOrDefault().UserId; var exits = _context.Addresss.Where(i => i.UserId == UserId).Count(); if (exits == 0) { var Address = new Address() { Addr = model.Addr, ContactName = model.ContactName, ContactPhone = model.ContactPhone, CreatDate = DateTime.Now, UpDate = DateTime.Now, UserId = UserId, IsDefault = true, Longitude = model.Longitude, Latitude = model.Latitude }; _context.Addresss.Add(Address); } else { var Address = new Address() { Addr = model.Addr, ContactName = model.ContactName, ContactPhone = model.ContactPhone, CreatDate = DateTime.Now, UpDate = DateTime.Now, UserId = UserId, IsDefault = false, Longitude = model.Longitude, Latitude = model.Latitude }; _context.Addresss.Add(Address); } _context.SaveChanges(); return(Ok("新增成功")); }
public IActionResult AddSysUser([FromBody] SysUserDto sysUserDto) { try { PwdTransition pwdTransition = new PwdTransition(); var Salt = Guid.NewGuid().ToString(); var Hashpwd = pwdTransition.ToHash("123aaa", Salt); string ip = HttpContext.Connection.RemoteIpAddress.ToString(); var SysUserInfo = new SysUser() { Account = sysUserDto.Account, Pwd = Hashpwd, Salt = Salt, Addr = sysUserDto.Addr, Comments = sysUserDto.Comments, CreatDate = DateTime.Now, Ip = ip, Name = sysUserDto.Name, Phone = sysUserDto.Phone, Latitude = sysUserDto.Latitude, Longitude = sysUserDto.Longitude, Popenid = sysUserDto.Popenid, Comment1 = sysUserDto.Comment1, Price = sysUserDto.Price, TemIdAccept = sysUserDto.TemIdAccept, TemIdRefuse = sysUserDto.TemIdRefuse, TemIdOrder = sysUserDto.TemIdOrder, TemIdSend = sysUserDto.TemIdSend, IsOpen = sysUserDto.IsOpen }; _context.SysUsers.Add(SysUserInfo); _context.SaveChanges(); return(Ok("添加成功")); } catch (Exception ex) { return(StatusCode(500, ex.Message)); } }
/// <summary> /// 修改会员消费记录 /// </summary> /// <param name="memberid"></param> /// <param name="goodid"></param> /// <param name="quantity"></param> /// <returns></returns> public IActionResult AmendShopJob(int memberid, int goodid, int quantity) { using var context = new SupermarketDbContext(); var gooditems = context.MemberGoodMapping.FirstOrDefault(x => x.MemberId.Equals(memberid)); gooditems.GoodId = goodid; gooditems.Quantity = quantity; context.SaveChanges(); return(View()); }
public IActionResult MemAmendJob(string name, string phone, string password, string nameafter, string phoneafter, string passwordafter) { using var context = new SupermarketDbContext(); var members = context.Member.FirstOrDefault(x => x.Phone.Contains(phone)); members.Name = nameafter; members.Phone = phoneafter; members.Password = passwordafter; context.SaveChanges(); return(View()); }
/// <summary> /// 异步建立数据值 /// </summary> /// <returns></returns> private async Task SeedDate() { if (!_context.SysUsers.Any()) { PwdTransition pwdTransition = new PwdTransition(); var Salt = Guid.NewGuid().ToString(); var Hashpwd = pwdTransition.ToHash("123aaa", Salt); var sysuser = new SysUser { Account = "admin", Pwd = Hashpwd, Salt = Salt, Name = "超管", CreatDate = DateTime.Now }; await _context.SysUsers.AddAsync(sysuser); _context.SaveChanges(); } }
/// <summary> /// 注销会员 /// </summary> /// <param name="phonetail"></param> /// <returns></returns> public IActionResult DeleteByOneString(string phonetail) { using var context = new SupermarketDbContext(); var members = context.Member.FirstOrDefault(x => x.Phone.Contains(phonetail)); var id = members.Id; var mem2 = context.MemberLevelMapping.FirstOrDefault(x => x.MemberId.Equals(id)); var mem3 = context.Statistics.FirstOrDefault(x => x.MemberId.Equals(id)); context.Remove(mem2); context.Remove(mem3); context.Remove(members); context.SaveChanges(); return(View()); }
public IActionResult MemberJob(string name, string phone, string password) { using var context = new SupermarketDbContext(); var member = new Member() { Credit = 0 }; member.Name = name; member.Phone = phone; member.Password = password; context.Member.Add(member); context.SaveChanges(); return(View()); }
public IActionResult CreateWinner([FromBody] WinnerDto winnerDto) { try { var WinnerInfo = new Winner() { OpenId = winnerDto.OpenId, WinDate = DateTime.Now, SysUserId = winnerDto.SysUserId, Phone = winnerDto.Phone, LotteryId = winnerDto.LotteryId }; _context.Winners.Add(WinnerInfo); _context.SaveChanges(); return(Ok("新增成功")); } catch (Exception ex) { return(StatusCode(500, ex.Message)); } }
/// <summary> /// 增加会员消费记录 /// </summary> /// <param name="memberid"></param> /// <param name="goodid"></param> /// <param name="quantity"></param> /// <returns></returns> public IActionResult RecordShopJob(int memberid, int goodid, int quantity) { using var context = new SupermarketDbContext(); var shopitems = new MemberGoodMapping() { Id = Guid.NewGuid().ToString(), CreateTime = DateTime.Now.ToString() }; shopitems.MemberId = memberid; shopitems.GoodId = goodid; shopitems.Quantity = quantity; //var find1 = context.Good.FirstOrDefault(x => x.Id.Equals(goodid)); //find1.Price context.MemberGoodMapping.Add(shopitems); context.SaveChanges(); return(View()); }
public static void SeedCategories(SupermarketDbContext context) { var categories = new List <Category>() { new Category() { Id = Guid.NewGuid(), Name = "Electronics" }, new Category() { Id = Guid.NewGuid(), Name = "Toiletries" }, new Category() { Id = Guid.NewGuid(), Name = "Miscellaneous" }, new Category() { Id = Guid.NewGuid(), Name = "Fashion" } }; categories.ForEach(category => { var dbCategory = context.Categories.FirstOrDefault(r => r.Name == category.Name); if (dbCategory == null) { context.Categories.Add(category); } }); context.SaveChanges(); }
/// <summary> /// 订单发货提醒 /// </summary> /// <param name="model"></param> /// <returns></returns> public string SendMail(TemDto model) { try { using (HttpClient client = new HttpClient()) { var Toke = _context.Parass.Where(x => x.Name == "AppSendToken").FirstOrDefault(); if (Toke == null) { MediaTypeWithQualityHeaderValue contentType = new MediaTypeWithQualityHeaderValue("application/json"); client.DefaultRequestHeaders.Accept.Add(contentType); HttpResponseMessage response = client.GetAsync("https://api.weixin.qq.com/cgi-bin/token?grant_type=client_credential&appid=wx003c752c0c4e829e&secret=e73afb2381e6335aa947a5ae354d0fe2").Result; string stringData = response.Content.ReadAsStringAsync().Result; if (stringData == null) { return(null); } else { var jObject = JObject.Parse(stringData); var Token = jObject["access_token"].ToString(); var Paras = new Paras() { Name = "AppSendToken", Describe = Token, CreatDate = DateTime.Now }; _context.Parass.Add(Paras); _context.SaveChanges(); var Tok = Token; MediaTypeWithQualityHeaderValue contentType2 = new MediaTypeWithQualityHeaderValue("application/json"); client.DefaultRequestHeaders.Accept.Add(contentType2); HttpContent content = new StringContent(JsonConvert.SerializeObject(model)); HttpResponseMessage response2 = client.PostAsync("https://api.weixin.qq.com/cgi-bin/message/wxopen/template/send?access_token=" + Tok, content).Result; string stringData2 = response2.Content.ReadAsStringAsync().Result; return(stringData2); } } else { var Time2 = Toke.CreatDate; var Time1 = DateTime.Now; TimeSpan ts1 = new TimeSpan(Time1.Ticks); TimeSpan ts2 = new TimeSpan(Time2.Ticks); TimeSpan ts = ts1.Subtract(ts2).Duration(); if (ts.Hours >= 2) { MediaTypeWithQualityHeaderValue contentType = new MediaTypeWithQualityHeaderValue("application/json"); client.DefaultRequestHeaders.Accept.Add(contentType); HttpResponseMessage response = client.GetAsync("https://api.weixin.qq.com/cgi-bin/token?grant_type=client_credential&appid=wx003c752c0c4e829e&secret=e73afb2381e6335aa947a5ae354d0fe2").Result; string stringData = response.Content.ReadAsStringAsync().Result; var jObject = JObject.Parse(stringData); var Token1 = jObject["access_token"].ToString(); var Kind = _context.Parass.Where(x => x.Name == "AppSendToken").FirstOrDefault(); Kind.CreatDate = DateTime.Now; Kind.Describe = Token1; _context.SaveChanges(); var Tok = Kind.Describe; MediaTypeWithQualityHeaderValue contentType1 = new MediaTypeWithQualityHeaderValue("application/json"); client.DefaultRequestHeaders.Accept.Add(contentType1); HttpContent content = new StringContent(JsonConvert.SerializeObject(model)); HttpResponseMessage response1 = client.PostAsync("https://api.weixin.qq.com/cgi-bin/message/wxopen/template/send?access_token=" + Tok, content).Result; string stringData1 = response1.Content.ReadAsStringAsync().Result; return(stringData1); } else { var Token3 = _context.Parass.Where(x => x.Name == "AppSendToken").FirstOrDefault(); var Tok = Token3.Describe; MediaTypeWithQualityHeaderValue contentType = new MediaTypeWithQualityHeaderValue("application/json"); client.DefaultRequestHeaders.Accept.Add(contentType); HttpContent content = new StringContent(JsonConvert.SerializeObject(model)); HttpResponseMessage response = client.PostAsync("https://api.weixin.qq.com/cgi-bin/message/wxopen/template/send?access_token=" + Tok, content).Result; string stringData = response.Content.ReadAsStringAsync().Result; return(stringData); } } } } catch (Exception ex) { throw ex; } }
public IActionResult CreateOrder(OrderDto model) { try { Token Fun = new Token(_context); var Addrs = _context.Addresss.Where(x => x.AddressId == model.AddressId).FirstOrDefault(); var UserId = _context.User.Where(i => i.OpenId == model.OpenId).FirstOrDefault().UserId; if (model.PayType == PayType.货到付款) { var Order = new Order() { OrderNo = DateTime.Now.ToString("yyyyMMddhhmmssfff") + "" + UserId, Price = model.Price, PayType = model.PayType, PayState = PayState.未付款, CreatDate = DateTime.Now, UserId = UserId, SysUserId = model.SysUserId, AddressId = model.AddressId, Comments = model.Comments }; var goodsID = model.GoodsId.Replace("[", "").Replace("]", "").Split(','); _context.Orders.Add(Order); foreach (var p in goodsID) { var num = 1; if (model.ordertype == "wu") { num = _context.AppCarts.Where(i => i.GoodsId == Convert.ToInt64(p) && i.UserId == UserId).FirstOrDefault().Num; } //if(_context.AppCarts.Where(i => i.UserId == UserId).ToList().Contains(Convert.ToInt64(p))) var ordergoods = new OrderGoods() { OrderId = Order.OrderId, GoodsId = Convert.ToInt64(p), Num = num }; _context.OrderGoods.Add(ordergoods); } var CartInfo = _context.AppCarts.Where(x => x.UserId == UserId).ToList(); if (CartInfo.Count != 0) { _context.AppCarts.RemoveRange(CartInfo); _context.SaveChanges(); } else { _context.SaveChanges(); } var Tem = new TemDto(); var sysUserinfo = _context.SysUsers.Where(x => x.SysUserId == model.SysUserId).FirstOrDefault(); var Good = _context.OrderGoods.Where(x => x.OrderId == Order.OrderId).ToList(); var NT = ""; foreach (var s in Good) { var Goodss = _context.Goodss.Where(x => x.GoodsId == s.GoodsId).FirstOrDefault(); NT = NT + Goodss.Name + "*" + s.Num + "; "; } Tem.touser = sysUserinfo.Popenid; Tem.template_id = "xEh7eyNbqUA4REhnVT-aCCH0-NOwqrHFh4IyqFnkM-g"; var data1 = new Data1(); var keyword1 = new Keyword(); var keyword2 = new Keyword(); var keyword3 = new Keyword(); var keyword4 = new Keyword(); var keyword5 = new Keyword(); var first = new Keyword(); var remark = new Keyword(); Tem.data = data1; Tem.data.keyword1 = keyword1; Tem.data.keyword2 = keyword2; Tem.data.keyword3 = keyword3; Tem.data.keyword4 = keyword4; Tem.data.keyword5 = keyword5; Tem.data.first = first; Tem.data.remark = remark; Tem.data.first.value = Order.OrderNo; Tem.data.keyword1.value = NT; Tem.data.keyword2.value = model.Price.ToString(); Tem.data.keyword3.value = Addrs.ContactName + " " + Addrs.ContactPhone; Tem.data.keyword4.value = Addrs.Addr; Tem.data.keyword5.value = model.Comments; Tem.data.remark.value = ""; var Tnc = new TemDto(); var data2 = new Data1(); var first1 = new Keyword(); var keyword11 = new Keyword(); var keyword21 = new Keyword(); var keyword31 = new Keyword(); var keyword41 = new Keyword(); var keyword51 = new Keyword(); var keyword61 = new Keyword(); Tnc.data = data2; Tnc.data.keyword1 = keyword11; Tnc.data.keyword2 = keyword21; Tnc.data.keyword3 = keyword31; Tnc.data.keyword4 = keyword41; Tnc.data.keyword5 = keyword51; Tnc.data.keyword6 = keyword61; Tnc.touser = model.OpenId; Tnc.template_id = "IOxfg-a_xjT3GSY8RHgF6qybqmV-4MlSM1IOpgwpWWg"; Tnc.form_id = model.FormId; Tnc.data.keyword1.value = Order.OrderNo; Tnc.data.keyword2.value = model.Price.ToString(); Tnc.data.keyword3.value = NT; Tnc.data.keyword4.value = DateTime.Now.ToString(); Tnc.data.keyword5.value = Addrs.Addr; Tnc.data.keyword6.value = Addrs.ContactPhone; Fun.GetToken(Tem); AppToken Text = new AppToken(_context); Text.GetAppToken(Tnc); Jpush jpush = new Jpush(); jpush.SendOrder(model.SysUserId, sysUserinfo.Name); } return(Ok("2222!!")); } catch (Exception ex) { return(StatusCode(500, ex.Message)); } }