public bool Update() { if (this.Valid(true)) { using (WMContext context = new WMContext()) { UserReceipts model = context.UserReceipts.Find(this.Id); if (model != null) { model.ProvinceId = this.ProvinceId; model.CityId = this.CityId; model.AreaId = this.AreaId; model.Address = this.Address; model.Contact = this.Contact; model.Phone = this.Phone; model.ZipCode = this.ZipCode; context.SaveChanges(); return(true); } } } return(false); }
public bool Add() { if (this.Valid()) { this.Id = General.UniqueString(this.Id); this.AddDate = DateTime.Now; using (WMContext context = new WMContext()) { UserIntegrals model = new UserIntegrals { Id = this.Id, SourceId = this.SourceId, UserId = this.UserId, Integral = this.Integral, AddDate = this.AddDate }; context.UserIntegrals.Add(model); context.SaveChanges(); } return(WMUsers.UpdateIntegral(this.UserId, this.Integral)); } return(false); }
public bool Add() { if (this.Valid()) { this.Id = General.UniqueString(this.Id); this.AddDate = DateTime.Now; using (WMContext context = new WMContext()) { UserReceipts model = new UserReceipts { Id = this.Id, UserId = this.UserId, ProvinceId = this.ProvinceId, CityId = this.CityId, AreaId = this.AreaId, Address = this.Address, Contact = this.Contact, Phone = this.Phone, ZipCode = this.ZipCode, AddDate = this.AddDate }; context.UserReceipts.Add(model); context.SaveChanges(); } return(true); } return(false); }
public static bool UpdateStatus(string id, int stateId) { if (!General.IsNullable(id) && stateId > 0) { using (WMContext context = new WMContext()) { Goods model = context.Goods.Find(id); if (model != null) { model.StatusId = stateId; //恢复上架的商品,上架时间从恢复之时算起 if (stateId == 503) { model.AddDate = DateTime.Now; } context.SaveChanges(); return(true); } } } return(false); }
public static bool Clear(string userId) { if (!General.IsNullable(userId)) { using (WMContext context = new WMContext()) { var list = ( from car in context.ShopCars where car.UserId.Equals(userId) select car ); if (list != null) { foreach (var item in list) context.ShopCars.Remove(item); context.SaveChanges(); return true; } } } return false; }
public static bool Delete(string id) { if (!General.IsNullable(id)) { string fileName = null; using (WMContext context = new WMContext()) { GoodBrands model = context.GoodBrands.Find(id); if (model != null) { if (!General.IsNullable(model.Logo)) fileName = "~" + model.Logo; context.GoodBrands.Remove(model); context.SaveChanges(); } } if (!General.IsNullable(fileName)) return Jumpcity.IO.FileHelper.DeleteFile(fileName); return true; } return false; }
public bool Add() { if (this.Valid()) { this.Id = General.UniqueString(this.Id); this.AddDate = DateTime.Now; using (WMContext context = new WMContext()) { UserBonus model = new UserBonus { Id = this.Id, UserId = this.UserId, OrderId = this.OrderId, BonusSum = this.BonusSum, AddDate = this.AddDate }; context.UserBonus.Add(model); context.SaveChanges(); } return(true); } return(false); }
public static bool UpdateCover(string id) { if (!General.IsNullable(id)) { using (WMContext context = new WMContext()) { GoodImages model = context.GoodImages.Find(id); if (model != null) { GoodImages old = context.GoodImages.Where(gi => gi.GoodId.Equals(model.GoodId) && gi.IsCover).FirstOrDefault(); if (old != null) { old.IsCover = false; } model.IsCover = true; context.SaveChanges(); return(true); } } } return(false); }
/// <summary> /// 用购物车的数据填充订单商品表 /// </summary> /// <param name="orderId">订单ID</param> /// <param name="shopCars">购物车数据</param> /// <returns>添加成功返回TRUE,否则返回FALSE</returns> public static bool AddList(string orderId, List<WMShopCars> shopCars) { if (!General.IsNullable(orderId) && !General.IsNullable(shopCars)) { WMOrderGoods model = null; using (WMContext context = new WMContext()) { foreach (WMShopCars item in shopCars) { model = new WMOrderGoods { Id = General.UniqueString(), OrderId = orderId, GoodId = item.GoodId, Price = item.Price, Count = item.Count }; context.OrderGoods.Add(model); } context.SaveChanges(); } return true; } return false; }
public bool Add() { if (this.Valid()) { this.Id = General.UniqueString(this.Id); this.AddDate = DateTime.Now; using (WMContext context = new WMContext()) { Users model = new Users { Id = this.Id, RoleId = this.RoleId, OpenId = this.OpenId, UserName = this.UserName, Password = this.Password, NickName = this.NickName, Image = this.Image, Mobile = this.Mobile, BankCard = this.BankCard, StatusId = this.StatusId, AddDate = this.AddDate }; context.Users.Add(model); context.SaveChanges(); } return(true); } return(false); }
public static bool Delete(string id) { if (!General.IsNullable(id)) { string fileName = null; using (WMContext context = new WMContext()) { GoodBrands model = context.GoodBrands.Find(id); if (model != null) { if (!General.IsNullable(model.Logo)) { fileName = "~" + model.Logo; } context.GoodBrands.Remove(model); context.SaveChanges(); } } if (!General.IsNullable(fileName)) { return(Jumpcity.IO.FileHelper.DeleteFile(fileName)); } return(true); } return(false); }
public bool Delete(string id) { if (!General.IsNullable(id)) { using (WMContext context = new WMContext()) { var list = ( from gc in context.GoodCategories where gc.Id.Equals(id) || gc.ParentId.Equals(id) select gc ); if (list != null) { foreach (var model in list) { context.GoodCategories.Remove(model); } context.SaveChanges(); return(true); } } } return(false); }
public bool Update() { if (this.Valid(true)) { using (WMContext context = new WMContext()) { Goods model = context.Goods.Find(this.Id); if (model != null) { model.CategoryId = this.CategoryId; model.BrandId = this.BrandId; model.Name = this.Name; model.OriginalPrice = this.OriginalPrice; model.PresentPrice = this.PresentPrice; model.Unit = this.Unit; model.Desc = this.Desc; model.Spec = this.Spec; model.Service = this.Service; model.Integral = this.Integral; model.Clicks = this.Clicks; model.Saves = this.Saves; model.Bonus = this.Bonus; model.GoldPool = this.GoldPool; model.StatusId = this.StatusId; context.SaveChanges(); return(true); } } } return(false); }
public bool Add() { if (this.Valid()) { this.AddDate = DateTime.Now; using (WMContext context = new WMContext()) { Administartors model = new Administartors { RoleId = this.RoleId, UserName = this.UserName, Password = this.Password, StatusId = this.StatusId, AddDate = this.AddDate }; context.Administartors.Add(model); context.SaveChanges(); } return(true); } return(false); }
public bool Update(bool updatePwd = false) { if (this.Valid(true)) { using (WMContext context = new WMContext()) { Users model = context.Users.Find(this.Id); if (model != null) { model.UserName = this.UserName; model.RoleId = this.RoleId; model.NickName = this.NickName; model.Integral = this.Integral; model.Image = this.Image; model.Mobile = this.Mobile; model.BankCard = this.BankCard; model.StatusId = this.StatusId; if (updatePwd) { model.Password = this.Password; } context.SaveChanges(); return(true); } } } return(false); }
public static bool Clear(string userId) { if (!General.IsNullable(userId)) { using (WMContext context = new WMContext()) { var list = ( from car in context.ShopCars where car.UserId.Equals(userId) select car ); if (list != null) { foreach (var item in list) { context.ShopCars.Remove(item); } context.SaveChanges(); return(true); } } } return(false); }
/// <summary> /// 用购物车的数据填充订单商品表 /// </summary> /// <param name="orderId">订单ID</param> /// <param name="shopCars">购物车数据</param> /// <returns>添加成功返回TRUE,否则返回FALSE</returns> public static bool AddList(string orderId, List <WMShopCars> shopCars) { if (!General.IsNullable(orderId) && !General.IsNullable(shopCars)) { WMOrderGoods model = null; using (WMContext context = new WMContext()) { foreach (WMShopCars item in shopCars) { model = new WMOrderGoods { Id = General.UniqueString(), OrderId = orderId, GoodId = item.GoodId, Price = item.Price, Count = item.Count }; context.OrderGoods.Add(model); } context.SaveChanges(); } return(true); } return(false); }
public bool Add() { if (this.Valid()) { this.Id = General.UniqueString(this.Id); using (WMContext context = new WMContext()) { OrderGoods model = new OrderGoods { Id = this.Id, OrderId = this.OrderId, GoodId = this.GoodId, Price = this.Price, Count = this.Count }; context.OrderGoods.Add(model); context.SaveChanges(); } return(true); } return(false); }
public bool Add() { if (this.Valid()) { this.Id = General.UniqueString(this.Id); this.AddDate = DateTime.Now; using (WMContext context = new WMContext()) { this.IsCover = (context.GoodImages.Where(gi => gi.GoodId.Equals(this.GoodId)).Count() == 0); GoodImages model = new GoodImages { Id = this.Id, GoodId = this.GoodId, URL = this.URL, IsCover = this.IsCover, AddDate = this.AddDate }; context.GoodImages.Add(model); context.SaveChanges(); } return(true); } return(false); }
/// <summary> /// 为指定的订单付款,并将相应的购买积分添加到用户的账户中 /// </summary> /// <param name="orderId">要付款的订单ID</param> /// <returns>付款成功返回TRUE,否则返回FALSE</returns> public static bool Payment(string orderId) { bool flag = false; if (!General.IsNullable(orderId)) { string userId = null; using (WMContext context = new WMContext()) { Orders model = context.Orders.Find(orderId); if (model != null) { userId = model.UserId; model.Paid = true; context.SaveChanges(); flag = true; } } if (flag && !General.IsNullable(userId)) { int inteSum = WMOrderGoods.GetIntegralSum(orderId); return(new WMUserIntegrals { UserId = userId, Integral = inteSum }.Add()); } } return(flag); }
public bool Add() { if (this.Valid()) { this.AddDate = DateTime.Now; using (WMContext context = new WMContext()) { UserSets model = ( from us in context.UserSets where us.TypeId == this.TypeId && us.UserId.Equals(this.UserId) && us.GoodId.Equals(this.GoodId) select us ).FirstOrDefault(); if (model != null) { model.AddDate = this.AddDate; } else { model = new UserSets { Id = General.UniqueString(this.Id), TypeId = this.TypeId, UserId = this.UserId, GoodId = this.GoodId, AddDate = this.AddDate }; context.UserSets.Add(model); if (this.TypeId == 401) { //商品的被收藏数量获得递增 Goods good = context.Goods.Find(this.GoodId); if (good != null) { good.Saves++; } } } context.SaveChanges(); } return(true); } return(false); }
public bool Add() { if (this.Valid()) { this.Id = General.UniqueString(this.Id); using (WMContext context = new WMContext()) { GoodCategories model = new GoodCategories { Id = this.Id, ParentId = this.ParentId, Name = this.Name, Level = 1, Sort = 0 }; GoodCategories level = context.GoodCategories.Find(this.ParentId); if (level == null) { model.Level = 1; } else { model.Level = level.Level + 1; } var sort = context.GoodCategories.Where(gc => gc.ParentId.Equals(this.ParentId)).ToList(); if (General.IsNullable(sort)) { model.Sort = 1; } else { model.Sort = sort.Max(gc => gc.Sort) + 1; } context.GoodCategories.Add(model); context.SaveChanges(); } return(true); } return(false); }
public bool Add() { if (this.Valid()) { this.Id = General.UniqueString(this.Id); this.AddDate = DateTime.Now; using (WMContext context = new WMContext()) { Goods good = context.Goods.Find(this.GoodId); if (good != null) { UserClicks model = ( from uc in context.UserClicks where uc.PromoterId.Equals(this.PromoterId) && uc.CustomerId.Equals(this.CustomerId) && uc.GoodId.Equals(this.GoodId) select uc ).FirstOrDefault(); if (model == null) { model = new UserClicks { Id = this.Id, PromoterId = this.PromoterId, CustomerId = this.CustomerId, GoodId = this.GoodId, AddDate = this.AddDate }; good.Clicks++; context.UserClicks.Add(model); context.SaveChanges(); } } } return(true); } return(false); }
public static bool Delete(string userId) { if (!General.IsNullable(userId)) { using (WMContext context = new WMContext()) { Users model = context.Users.Find(userId); if (model != null) { model.StatusId = 203; context.SaveChanges(); return true; } } } return false; }
public bool Add() { if (this.Valid()) { this.Id = General.UniqueString(this.Id); this.AddDate = DateTime.Now; using (WMContext context = new WMContext()) { ShopCars model = ( from car in context.ShopCars where car.UserId.Equals(this.UserId) && car.GoodId.Equals(this.GoodId) select car ).FirstOrDefault(); if (model != null) { model.Price = this.Price; model.Count += this.Count; } else { model = new ShopCars { Id = this.Id, GoodId = this.GoodId, UserId = this.UserId, Price = this.Price, Count = this.Count, AddDate = this.AddDate }; context.ShopCars.Add(model); } context.SaveChanges(); } return(true); } return(false); }
public static bool Delete(int adminId) { if (adminId > 0) { using (WMContext context = new WMContext()) { Administartors model = context.Administartors.Find(adminId); if (model != null) { model.StatusId = 203; context.SaveChanges(); return(true); } } } return(false); }
public static bool Delete(string userId) { if (!General.IsNullable(userId)) { using (WMContext context = new WMContext()) { Users model = context.Users.Find(userId); if (model != null) { model.StatusId = 203; context.SaveChanges(); return(true); } } } return(false); }
public static bool UpdateIntegral(string userId, int addInte) { if (!General.IsNullable(userId)) { using (WMContext context = new WMContext()) { Users model = context.Users.Find(userId); if (model != null) { model.Integral += addInte; context.SaveChanges(); return(true); } } } return(false); }
public bool Add() { if (this.Valid()) { this.Id = General.UniqueString(this.Id); this.AddDate = DateTime.Now; if (!this.PresentPrice.HasValue) { this.PresentPrice = this.OriginalPrice; } using (WMContext context = new WMContext()) { Goods model = new Goods { Id = this.Id, CategoryId = this.CategoryId, BrandId = this.BrandId, Name = this.Name, OriginalPrice = this.OriginalPrice, PresentPrice = this.PresentPrice, Unit = this.Unit, Desc = this.Desc, Spec = this.Spec, Service = this.Service, Integral = this.Integral, Clicks = this.Clicks, Saves = this.Saves, Bonus = this.Bonus, GoldPool = this.GoldPool, StatusId = this.StatusId, AddDate = this.AddDate }; context.Goods.Add(model); context.SaveChanges(); } return(true); } return(false); }
public static bool Delete(int adminId) { if (adminId > 0) { using (WMContext context = new WMContext()) { Administartors model = context.Administartors.Find(adminId); if (model != null) { model.StatusId = 203; context.SaveChanges(); return true; } } } return false; }
public static bool UpdateStatus(string orderId, int state) { if (!General.IsNullable(orderId) && state > 0) { using (WMContext context = new WMContext()) { Orders model = context.Orders.Find(orderId); if (model != null) { model.StatusId = state; context.SaveChanges(); return(true); } } } return(false); }
public static bool Delete(string id) { if (!General.IsNullable(id)) { using (WMContext context = new WMContext()) { UserSets model = context.UserSets.Find(id); if (model != null) { context.UserSets.Remove(model); context.SaveChanges(); return true; } } } return false; }
public static bool Delete(string id) { if (!General.IsNullable(id)) { using (WMContext context = new WMContext()) { UserIntegrals model = context.UserIntegrals.Find(id); if (model != null) { context.UserIntegrals.Remove(model); context.SaveChanges(); return(true); } } } return(false); }
public static bool Delete(string id) { if (!General.IsNullable(id)) { string fileName = null; using (WMContext context = new WMContext()) { GoodImages model = context.GoodImages.Find(id); if (model != null) { fileName = "~" + model.URL; GoodImages newCover = null; if (model.IsCover) { newCover = ( from gi in context.GoodImages where gi.GoodId.Equals(model.GoodId) && gi.Id != model.Id orderby gi.AddDate descending select gi ).FirstOrDefault(); if (newCover != null) { newCover.IsCover = true; } } context.GoodImages.Remove(model); context.SaveChanges(); } } return(FileHelper.DeleteFile(fileName)); } return(false); }
public bool Update() { if (this.Valid(true)) { using (WMContext context = new WMContext()) { GoodBrands model = context.GoodBrands.Find(this.Id); if (model != null) { model.Name = this.Name; model.Logo = this.Logo; model.URL = this.URL; context.SaveChanges(); return(true); } } } return(false); }
public bool Update() { if (this.Valid(true)) { using (WMContext context = new WMContext()) { Administartors model = context.Administartors.Find(this.Id); if (model != null) { model.UserName = this.UserName; model.Password = this.Password; model.RoleId = this.RoleId; model.StatusId = this.StatusId; context.SaveChanges(); return(true); } } } return(false); }
public static bool Delete(string id) { if (!General.IsNullable(id)) { string fileName = null; using (WMContext context =new WMContext()) { GoodImages model = context.GoodImages.Find(id); if (model != null) { fileName = "~" + model.URL; GoodImages newCover = null; if (model.IsCover) { newCover = ( from gi in context.GoodImages where gi.GoodId.Equals(model.GoodId) && gi.Id != model.Id orderby gi.AddDate descending select gi ).FirstOrDefault(); if (newCover != null) newCover.IsCover = true; } context.GoodImages.Remove(model); context.SaveChanges(); } } return FileHelper.DeleteFile(fileName); } return false; }
public static bool UpdateCover(string id) { if (!General.IsNullable(id)) { using (WMContext context = new WMContext()) { GoodImages model = context.GoodImages.Find(id); if (model != null) { GoodImages old = context.GoodImages.Where(gi => gi.GoodId.Equals(model.GoodId) && gi.IsCover).FirstOrDefault(); if (old != null) old.IsCover = false; model.IsCover = true; context.SaveChanges(); return true; } } } return false; }
/// <summary> /// 为指定的订单付款,并将相应的购买积分添加到用户的账户中 /// </summary> /// <param name="orderId">要付款的订单ID</param> /// <returns>付款成功返回TRUE,否则返回FALSE</returns> public static bool Payment(string orderId) { bool flag = false; if (!General.IsNullable(orderId)) { string userId = null; using (WMContext context = new WMContext()) { Orders model = context.Orders.Find(orderId); if (model != null) { userId = model.UserId; model.Paid = true; context.SaveChanges(); flag = true; } } if (flag && !General.IsNullable(userId)) { int inteSum = WMOrderGoods.GetIntegralSum(orderId); return new WMUserIntegrals { UserId = userId, Integral = inteSum }.Add(); } } return flag; }
public static bool UpdateStatus(string id, int stateId) { if (!General.IsNullable(id) && stateId > 0) { using (WMContext context = new WMContext()) { Goods model = context.Goods.Find(id); if (model != null) { model.StatusId = stateId; //恢复上架的商品,上架时间从恢复之时算起 if (stateId == 503) model.AddDate = DateTime.Now; context.SaveChanges(); return true; } } } return false; }
public bool Update() { if (this.Valid(true)) { using (WMContext context = new WMContext()) { Goods model = context.Goods.Find(this.Id); if (model != null) { model.CategoryId = this.CategoryId; model.BrandId = this.BrandId; model.Name = this.Name; model.OriginalPrice = this.OriginalPrice; model.PresentPrice = this.PresentPrice; model.Unit = this.Unit; model.Desc = this.Desc; model.Spec = this.Spec; model.Service = this.Service; model.Integral = this.Integral; model.Clicks = this.Clicks; model.Saves = this.Saves; model.Bonus = this.Bonus; model.GoldPool = this.GoldPool; model.StatusId = this.StatusId; context.SaveChanges(); return true; } } } return false; }
public bool Update(bool updatePwd = false) { if (this.Valid(true)) { using (WMContext context = new WMContext()) { Users model = context.Users.Find(this.Id); if (model != null) { model.UserName = this.UserName; model.RoleId = this.RoleId; model.NickName = this.NickName; model.Integral = this.Integral; model.Image = this.Image; model.Mobile = this.Mobile; model.BankCard = this.BankCard; model.BankName = this.BankName; model.StatusId = this.StatusId; if (updatePwd) model.Password = this.Password; context.SaveChanges(); return true; } } } return false; }
public static bool UpdatePassword(string userId, string oldPwd, string newPwd) { if (!General.IsNullable(userId) && !General.IsNullable(oldPwd) && !General.IsNullable(newPwd)) { using (WMContext context = new WMContext()) { Users model = context.Users.Where(u => u.Id.Equals(userId) && u.Password.Equals(oldPwd)).FirstOrDefault(); if (model != null && !oldPwd.Equals(newPwd)) { model.Password = newPwd; context.SaveChanges(); return true; } } } return false; }
public static bool UpdateIntegral(string userId, int addInte) { if (!General.IsNullable(userId)) { using (WMContext context = new WMContext()) { Users model = context.Users.Find(userId); if (model != null) { model.Integral += addInte; context.SaveChanges(); return true; } } } return false; }
/// <summary> /// 更新订单的当前状态 /// </summary> /// <param name="orderId">要更新的订单号</param> /// <param name="state">要更新到的订单状态ID</param> /// <returns>更新成功返回True,否则返回False</returns> public static bool UpdateStatus(string orderId, int state) { if (!General.IsNullable(orderId) && state > 0) { using (WMContext context = new WMContext()) { Orders model = context.Orders.Find(orderId); if (model != null) { model.StatusId = state; context.SaveChanges(); return true; } } } return false; }
/// <summary> /// 为指定的订单付款,将相应的购买积分添加到购买者的账户中,并保存相应分红信息记录(如果存在推广者的话) /// </summary> /// <param name="orderId">要付款的订单ID</param> /// <param name="bounsUserId">设置可获得订单分红的推广者ID(如果有的话)</param> /// <returns>付款成功返回TRUE。订单已支付、或者由于各种原因造成的付款失败都返回FALSE</returns> public static bool Payment(string orderId, string bounsUserId = null) { bool flag = false; if (!General.IsNullable(orderId)) { string userId = null; using (WMContext context = new WMContext()) { Orders model = context.Orders.Find(orderId); if (model != null && !model.Paid) { userId = model.UserId; model.Paid = true; context.SaveChanges(); flag = true; } } if (flag && !General.IsNullable(userId)) { new WMUserIntegrals { UserId = userId, Integral = WMOrderGoods.GetTotalIntegral(orderId) }.Add(); if (!General.IsNullable(bounsUserId)) { new WMUserBonus { UserId = bounsUserId, OrderId = orderId, BonusSum = WMOrderGoods.GetTotalBonus(orderId) }.Add(); } } } return flag; }
public bool Add() { if (this.Valid()) { this.Id = General.UniqueString(this.Id); using (WMContext context = new WMContext()) { GoodBrands model = new GoodBrands { Id = this.Id, Name = this.Name, Logo = this.Logo, URL = this.URL }; context.GoodBrands.Add(model); context.SaveChanges(); } return true; } return false; }
public bool Add() { if (this.Valid()) { this.AddDate = DateTime.Now; using (WMContext context = new WMContext()) { UserSets model = ( from us in context.UserSets where us.TypeId == this.TypeId && us.UserId.Equals(this.UserId) && us.GoodId.Equals(this.GoodId) select us ).FirstOrDefault(); if (model != null) model.AddDate = this.AddDate; else { model = new UserSets { Id = General.UniqueString(this.Id), TypeId = this.TypeId, UserId = this.UserId, GoodId = this.GoodId, AddDate = this.AddDate }; context.UserSets.Add(model); if (this.TypeId == 401) { //商品的被收藏数量获得递增 Goods good = context.Goods.Find(this.GoodId); if (good != null) good.Saves++; } } context.SaveChanges(); } return true; } return false; }
/// <summary> /// 添加新的购物车信息,如果购物信息已存在,则追加相应购买数量 /// </summary> /// <returns>操作成功返回True,否则返回False</returns> public bool Add() { if (this.Valid()) { this.Id = General.UniqueString(this.Id); this.AddDate = DateTime.Now; using (WMContext context = new WMContext()) { ShopCars model = ( from car in context.ShopCars where car.UserId.Equals(this.UserId) && car.GoodId.Equals(this.GoodId) select car ).FirstOrDefault(); if (model != null) { model.Price = this.Price; model.Count += this.Count; } else { model = new ShopCars { Id = this.Id, GoodId = this.GoodId, UserId = this.UserId, Price = this.Price, Count = this.Count, AddDate = this.AddDate }; context.ShopCars.Add(model); } context.SaveChanges(); } return true; } return false; }
/// <summary> /// 更新购物车内指定购买信息的商品数量 /// </summary> /// <param name="id">设置要更新的购买信息ID</param> /// <param name="count">设置要更新的数量</param> /// <param name="isAppend">设置是否是追加数量的操作,默认为False</param> /// <returns>更新成功返回True,否则返回False</returns> public static bool UpdateCount(string id, int count, bool isAppend = false) { if (!General.IsNullable(id)) { using (WMContext context = new WMContext()) { ShopCars model = context.ShopCars.Find(id); if (model != null) { if (isAppend && (model.Count + count) > 0) model.Count += count; else if (!isAppend && count > 0) model.Count = count; else return false; context.SaveChanges(); return true; } } } return false; }
public bool Add() { if (this.Valid()) { this.Id = General.UniqueString(this.Id); this.AddDate = DateTime.Now; if (!this.PresentPrice.HasValue) this.PresentPrice = this.OriginalPrice; using (WMContext context = new WMContext()) { Goods model = new Goods { Id = this.Id, CategoryId = this.CategoryId, BrandId = this.BrandId, Name = this.Name, OriginalPrice = this.OriginalPrice, PresentPrice = this.PresentPrice, Unit = this.Unit, Desc = this.Desc, Spec = this.Spec, Service = this.Service, Integral = this.Integral, Clicks = this.Clicks, Saves = this.Saves, Bonus = this.Bonus, GoldPool = this.GoldPool, StatusId = this.StatusId, AddDate = this.AddDate }; context.Goods.Add(model); context.SaveChanges(); } return true; } return false; }
public bool Add() { if (this.Valid()) { this.Id = General.UniqueString(this.Id); this.AddDate = DateTime.Now; using (WMContext context = new WMContext()) { this.IsCover = (context.GoodImages.Where(gi => gi.GoodId.Equals(this.GoodId)).Count() == 0); GoodImages model = new GoodImages { Id = this.Id, GoodId = this.GoodId, URL = this.URL, IsCover = this.IsCover, AddDate = this.AddDate }; context.GoodImages.Add(model); context.SaveChanges(); } return true; } return false; }
public bool Update() { if (this.Valid(true)) { using (WMContext context = new WMContext()) { GoodBrands model = context.GoodBrands.Find(this.Id); if (model != null) { model.Name = this.Name; model.Logo = this.Logo; model.URL = this.URL; context.SaveChanges(); return true; } } } return false; }
/// <summary> /// 更新当前订单的速递单号、负责配送速递公司名称以及当前的订单状态 /// </summary> /// <returns>更新成功返回True,否则返回False</returns> public bool Update() { if (this.Valid(true)) { using (WMContext context = new WMContext()) { Orders model = context.Orders.Find(this.Id); if (model != null) { model.ExpressId = this.ExpressId; model.OddNumber = this.OddNumber; model.StatusId = this.StatusId; context.SaveChanges(); return true; } } } return false; }
public static bool UpdateOpenId(string userId, string openId, string unionId) { if (!General.IsNullable(userId) && !General.IsNullable(openId) && General.IsNullable(unionId)) { using (WMContext context = new WMContext()) { int count = ( from u in context.Users where u.UnionId != null && u.UnionId != "" && u.UnionId.Equals(unionId) && u.Id != userId select u.Id ).Count(); if (count == 0) { Users model = context.Users.Find(userId); if (model != null) { model.OpenId = openId; model.UnionId = unionId; context.SaveChanges(); return true; } } } } return false; }
public bool Add() { if (this.Valid()) { this.Id = General.UniqueString(this.Id); this.AddDate = DateTime.Now; using (WMContext context = new WMContext()) { UserBonus model = new UserBonus { Id = this.Id, UserId = this.UserId, OrderId = this.OrderId, BonusSum = this.BonusSum, AddDate = this.AddDate }; context.UserBonus.Add(model); context.SaveChanges(); } return true; } return false; }
public bool Add() { if (this.Valid()) { this.Id = General.UniqueString(this.Id); this.AddDate = DateTime.Now; using (WMContext context = new WMContext()) { Users model = new Users { Id = this.Id, RoleId = this.RoleId, OpenId = this.OpenId, UnionId = this.UnionId, UserName = this.UserName, Password = this.Password, NickName = this.NickName, Image = this.Image, Mobile = this.Mobile, BankCard = this.BankCard, BankName = this.BankName, StatusId = this.StatusId, AddDate = this.AddDate }; context.Users.Add(model); context.SaveChanges(); } return true; } return false; }
public bool Add() { if (this.Valid()) { this.Id = General.UniqueString(this.Id); this.AddDate = DateTime.Now; using (WMContext context = new WMContext()) { Goods good = context.Goods.Find(this.GoodId); if (good != null) { UserClicks model = ( from uc in context.UserClicks where uc.PromoterId.Equals(this.PromoterId) && uc.CustomerId.Equals(this.CustomerId) && uc.GoodId.Equals(this.GoodId) select uc ).FirstOrDefault(); if (model == null) { model = new UserClicks { Id = this.Id, PromoterId = this.PromoterId, CustomerId = this.CustomerId, GoodId = this.GoodId, AddDate = this.AddDate }; good.Clicks++; context.UserClicks.Add(model); context.SaveChanges(); } } } return true; } return false; }
public bool Add() { if (this.Valid()) { this.Id = Guid.NewGuid().ToUniqueNumber().ToString(); this.AddDate = DateTime.Now; using (WMContext context = new WMContext()) { Orders model = new Orders { Id = this.Id, UserId = this.UserId, ProvinceId = this.ProvinceId, CityId = this.CityId, AreaId = this.AreaId, Contact = this.Contact, Address = this.Address, Phone = this.Phone, ZipCode = this.ZipCode, PayId = this.PayId, Paid = this.Paid, Freight = this.Freight, Message = this.Message, StatusId = this.StatusId, AddDate = this.AddDate }; context.Orders.Add(model); context.SaveChanges(); } return true; } return false; }
public bool Add() { if (this.Valid()) { this.Id = General.UniqueString(this.Id); using (WMContext context = new WMContext()) { OrderGoods model = new OrderGoods { Id = this.Id, OrderId = this.OrderId, GoodId = this.GoodId, Price = this.Price, Count = this.Count }; context.OrderGoods.Add(model); context.SaveChanges(); } return true; } return false; }