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));
}
}