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