/// <summary> /// 修改商品信息 /// </summary> /// <param name="good"></param> /// <returns></returns> public static int UpdateGoods(GoodsTable good) { using (LgShopDBEntities db = new LgShopDBEntities()) { return(db.Database.ExecuteSqlCommand($"update GoodsTable set GoodsName='{good.GoodsName}',GoodsPrice={good.GoodsPrice},OldGoodsPrice={good.OldGoodsPrice},GoodsInventory={good.GoodsInventory},TID={good.TID},GoodsDescribe='{good.GoodsDescribe}',IsGet={good.IsGet} where GoodsID={good.GoodsID}")); } }
/// <summary> /// 修改商品信息 /// </summary> /// <param name="goodsfile">商品图片(多选)</param> /// <param name="good">商品对象</param> /// <param name="pageindex">当前页</param> /// <param name="typeid">分类id</param> /// <param name="text">查询内容</param> /// <returns></returns> public ActionResult GoodsUpdate(GoodsTable good, int?pageindex, int typeid, string text = "") { //添加商品图片 if (Request.Files.Count > 0) { string[] fileTypeStr = { "image/gif", "image/png", "image/jpeg", "image/jpg", "image/bmp" }; List <string> strlist = new List <string>(); for (int i = 0; i < Request.Files.Count; i++) { if (fileTypeStr.Contains(Request.Files[i].ContentType)) { string fileName = Path.GetFileName(Request.Files[i].FileName); strlist.Add(fileName); } } if (GoodsPhotoBll.AddGoodsPhoto(good.GoodsID, strlist)) { //保存文件 //应用程序需要有服务器UploadFile文件夹的读写权限 for (int i = 0; i < Request.Files.Count; i++) { Request.Files[i].SaveAs(Server.MapPath("~/Content/GoodImgs/" + Request.Files[i].FileName)); } } } //修改商品信息 GoodsBll.UpdateGoods(good); return(RedirectToAction("GoodsIndexPartial", "BacksTage", new { pageindex = pageindex, text = text, typeid = typeid })); }
/// <summary> /// 新增商品 /// </summary> /// <param name="Arr">图片数组</param> /// <param name="GoodsPrice">现价</param> /// <param name="GoodsName">名称</param> /// <param name="OldGoodsPrice">原价</param> /// <param name="GoodsInventory">库存</param> /// <param name="TID">分类id</param> /// <param name="GoodsDescribe">描述</param> /// <returns></returns> public JsonResult AddGoodsAjax() { GoodsTable good = new GoodsTable() { GoodsName = Request.Form["goodsname"], GoodsPrice = Convert.ToDecimal(Request.Form["goodsprice"]), OldGoodsPrice = Convert.ToDecimal(Request.Form["oldgoodsprice"]), TID = Convert.ToInt32(Request.Form["tid"]), GoodsInventory = Convert.ToInt32(Request.Form["goodsinventory"]), GoodsDescribe = Request.Form["goodsdescribe"] }; List <string> list = new List <string>(); for (int i = 0; i < Request.Files.Count; i++) { list.Add(Path.GetFileName(Request.Files[i].FileName)); } //调用新增方法 if (GoodsBll.AddGoods(good)) { //查询最后一条商品 GoodsTable lastgood = GoodsBll.SelectAllGoods().LastOrDefault(); //调用新增商品图片方法 if (GoodsPhotoBll.AddGoodsPhoto(lastgood.GoodsID, list)) { //保存图片 for (int i = 0; i < Request.Files.Count; i++) { Request.Files[i].SaveAs(Server.MapPath("~/Content/GoodImgs/" + Request.Files[i].FileName)); } return(Json(1, JsonRequestBehavior.AllowGet)); } } return(Json(0, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 新增单个订单 /// </summary> /// <param name="ord">订单对象</param> /// <returns></returns> public static bool AddOrder(OrderTable ord) { using (LgShopDBEntities db = new LgShopDBEntities()) { try { //获取用户对象 UserInfo user = db.UserInfo.Find(ord.UserID); //获取商品对象 GoodsTable good = db.GoodsTable.Find(ord.GoodsID); db.OrderTable.Add(ord); //商品库存减少 db.GoodsTable.SingleOrDefault(p => p.GoodsID == ord.GoodsID).GoodsInventory -= ord.GoodsNum ?? 0; db.SaveChanges(); //扣除用户余额 db.UserInfo.Find(ord.UserID).UserWallet -= ord.OrderAmount; //新增商品发货消息 db.Database.ExecuteSqlCommand($"insert into NoticeTable values({ord.UserID},'商品发货通知','尊敬的{ord.UserInfo.UserName}用户,您于{DateTime.Now.ToLongDateString().ToString()}购买的商品{good.GoodsName}已发货,请注意查收!','{DateTime.Now}',0)"); return(db.SaveChanges() == 1); } catch (Exception) { return(false); } } }
/// <summary> /// 新增多条订单 /// </summary> /// <param name="list"></param> /// <returns></returns> public static int AddOrders(List <OrderTable> list, int userid, decimal price) { using (LgShopDBEntities db = new LgShopDBEntities()) { try { //获取用户对象 UserInfo user = db.UserInfo.Find(userid); //新增订单记录 foreach (var item in list) { //获取商品对象 GoodsTable good = db.GoodsTable.Find(item.GoodsID); db.Database.ExecuteSqlCommand($"insert into OrderTable values({userid},{item.GoodsID},{item.GoodsNum},'{DateTime.Now}',{item.OrderAmount},0,0)"); //删除购物车记录 db.Database.ExecuteSqlCommand($"delete from ShoppingCartTable where userid={userid} and GoodsID={item.GoodsID}"); //商品库存减少 db.GoodsTable.SingleOrDefault(p => p.GoodsID == item.GoodsID).GoodsInventory -= item.GoodsNum ?? 0; //新增商品发货消息 db.Database.ExecuteSqlCommand($"insert into NoticeTable values({userid},'商品发货通知','尊敬的{user.UserName}用户,您于{DateTime.Now.ToLongDateString().ToString()}购买的商品{good.GoodsName}已发货,请注意查收!','{DateTime.Now}',0)"); } //扣除用户余额 db.UserInfo.Find(userid).UserWallet -= price; return(db.SaveChanges()); } catch (Exception) { return(0); } } }
private Transform ReturnOriginTransform(GoodsTable goodsTable) { GoodsRepository goodsRepository = new GoodsRepository(goodsTable); Transform goodsTransform = goodsRepository.FindGoods(MerchandiseInfo.MerchandiseEnum.RoomMaker).transform; return(goodsTransform); }
/// <summary> /// 新增商品 /// </summary> /// <param name="good">商品对象</param> /// <returns></returns> public static int AddGoods(GoodsTable good) { using (LgShopDBEntities db = new LgShopDBEntities()) { try { //新增商品上架公告 db.Database.ExecuteSqlCommand($"insert into NoticeTable values(null,'新商品上架公告','各位乐购商城用户你们好,新商品{good.GoodsName}于{DateTime.Now.ToLongDateString().ToString()}上架,期待您的购买!','{DateTime.Now}',1)"); return(db.Database.ExecuteSqlCommand($"insert into GoodsTable values('{good.GoodsName}',{good.GoodsPrice},{good.OldGoodsPrice},{good.GoodsInventory},{good.TID},'{good.GoodsDescribe}',0,0,0,0)")); } catch (Exception) { return(0); } } }
/// <summary> /// 查询一个商品的详情 /// </summary> /// <param name="GoodsID">商品id</param> /// <returns></returns> public JsonResult GoodsDesc(string GoodsID) { //查询商品的信息 GoodsTable good = GoodsBll.SelectAllGoods().SingleOrDefault(p => p.GoodsID == Convert.ToInt32(GoodsID)); //查询商品对应的所有图片 var goodsphoto = GoodsPhotoBll.SelectAllGoodsPhoto().Where(p => p.GoodsID == Convert.ToInt32(GoodsID)).Select(p => new { RID = p.RID, GoodsID = p.GoodsID, PhotoPath = p.PhotoPath }).ToList(); //查询所有最小的分类 var typelist = TypeTableBll.SelectSmallType().Select(p => new { typeid = p.TypeID, typename = p.TypeName }); JsonSerializerSettings jsonstring = new JsonSerializerSettings(); jsonstring.ReferenceLoopHandling = ReferenceLoopHandling.Ignore; string list_1 = JsonConvert.SerializeObject(good, jsonstring); string list_2 = JsonConvert.SerializeObject(goodsphoto, jsonstring); string list_3 = JsonConvert.SerializeObject(typelist, jsonstring); return(Json(new { Good = list_1, GoodPhoto = list_2, GoodType = list_3 }, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 商品停售或出售 /// </summary> /// <param name="goodsid">商品id</param> /// <returns></returns> public static int GoodsDel(int goodsid) { using (LgShopDBEntities db = new LgShopDBEntities()) { GoodsTable good = db.GoodsTable.Find(goodsid); if (good.IsDelte == 0) { //停售 good.IsDelte = 1; //发布停售公告 db.Database.ExecuteSqlCommand($"insert into NoticeTable values(null,'商品停售公告','各位乐购商城用户你们好,于{DateTime.Now.ToLongDateString().ToString()}起{good.GoodsName}商品将从商城下架,查看详情请联系TEL:13677447830','{DateTime.Now}',1)"); } else { //出售 good.IsDelte = 0; //发布出售公告 db.Database.ExecuteSqlCommand($"insert into NoticeTable values(null,'商品出售公告','各位乐购商城用户你们好,于{DateTime.Now.ToLongDateString().ToString()}起{good.GoodsName}商品将重新出售,查看详情请联系TEL:13677447830','{DateTime.Now}',1)"); } return(db.SaveChanges()); } }
/// <summary> /// 商品详情 /// </summary> /// <param name="goodsid">商品id</param> /// <returns></returns> public ActionResult GoodsDesc(int goodsid) { //商品图片 ViewBag.GoodsPhoto = GoodsPhotoBll.SelectAllGoodsPhoto().Where(p => p.GoodsID == goodsid).ToList(); //商品的所有评价(置顶排序) List <CommentTable> list = CommentBll.SelectGoodsComment(goodsid).OrderByDescending(p => p.IsTop).ToList(); Session["GoodsComment"] = list; //用户是否收藏商品 ViewBag.iscollection = CollectionBll.SelectOneCollection(Convert.ToInt32(Session["userid"]), goodsid); //加载或更新用户购物车数量 if (Session["userid"] != null) { Session["carcount"] = ShopingCarBll.SelectAllShopCar(Convert.ToInt32(Session["userid"])).Count(); } //获取到的该商品的信息 GoodsTable good = GoodsBll.SelectGoodsIdGoods(goodsid); //相关商品的推荐(3条) ViewBag.GetGoods = GoodsBll.SelectGetGoods(good.TID ?? 0).Where(p => p.GoodsID != good.GoodsID).OrderBy(p => Guid.NewGuid()).Take(3).ToList(); Session["GoodsPhoto"] = GoodsPhotoBll.SelectAllGoodsPhoto(); return(View(good)); }
/// <summary> /// 新增商品 /// </summary> /// <param name="good">商品对象</param> /// <returns></returns> public static bool AddGoods(GoodsTable good) { return(GoodsDal.AddGoods(good) == 1); }
/// <summary> /// 修改商品信息 /// </summary> /// <param name="good"></param> /// <returns></returns> public static bool UpdateGoods(GoodsTable good) { return(GoodsDal.UpdateGoods(good) == 1); }