// GET: Goods
public ActionResult GoodsIndex(int?tid_1, int?typeid_1, int?typeid_2, string txt = "")
{
//清空session数据
Session.Remove("Goods");
Session.Remove("Goods_tid");
Session.Remove("Goods_typeid");
//获得所有分类数据
ViewBag.Type = TypeTableBll.SelectAllType();
ViewBag.GoodsPhoto = GoodsPhotoBll.SelectAllGoodsPhoto();
if (tid_1 != null)
{
//根据tid查询
Session["Goods_tid"] = GoodsBll.SelectTidGoods(tid_1 ?? 0);
//ViewBag.tid = tid_1 ?? 0;
}
else if (typeid_1 != null)
{
//根据tiyeid查询
Session["Goods_typeid"] = GoodsBll.SelectTypeidGoods(typeid_1 ?? 0);
}
else if (typeid_2 != null)
{
Session["Goods_typeid_2"] = GoodsBll.SelectType1Goods(typeid_2 ?? 0);
}
else
{
Session["Goods"] = GoodsBll.SelectAllGoods().Where(p => p.GoodsName.Contains(txt) && p.IsDelte == 0).OrderBy(p => p.GoodsHot).ToList();
}
return(View());
}
/// <summary>
/// 商品列表分布视图
/// </summary>
/// <returns></returns>
public ActionResult GoodsIndexPartial(int?pageindex, int typeid, string text = "")
{
List <GoodsTable> list = null;
if (typeid == 0)
{
list = GoodsBll.SelectAllGoods().Where(p => p.GoodsName.Contains(text)).ToList();
}
else
{
//查询第一大类的商品
list = GoodsBll.SelectType1GoodsAdmin(typeid).Where(p => p.GoodsName.Contains(text)).ToList();
//查询所有分类
List <TypeTable> typelist = TypeTableBll.SelectAllType();
//防止错误赋值给typetable导航属性
list.ForEach(p => p.TypeTable = typelist.Where(a => a.TypeID == p.TID).ToList()[0]);
}
if (list != null && list.Count() > 0)
{
Session["goodscount"] = list.Count();
}
else
{
Session["goodscount"] = 0;
}
Session["goodpagecount"] = Math.Ceiling(list.Count() / 8.0);
ViewBag.pageindex = pageindex;
ViewBag.text = text;
ViewBag.typeid = typeid;
Session["allgoods"] = list.Skip(((pageindex ?? 1) - 1) * 8).Take(8).ToList();
return(PartialView("GoodsIndexPartial"));
}
/// <summary>
/// 新增分类
/// </summary>
/// <param name="TID">所属分类id</param>
/// <param name="TypeName">类型名称</param>
/// <returns></returns>
public JsonResult AddType(string TID, string TypeName)
{
if (TypeTableBll.AddType(TypeName, Convert.ToInt32(TID)))
{
return(Json(1, JsonRequestBehavior.AllowGet));
}
return(Json(0, JsonRequestBehavior.AllowGet));
}
// GET: BackType
public ActionResult BackTypeIndex()
{
Session["li_1"] = 2;
Session["li_2"] = 0;
List <TypeTable> typetable = TypeTableBll.SelectAllType();
return(View(typetable));
}
public JsonResult TypeDel(string TypeID)
{
if (TypeTableBll.DeleteType(Convert.ToInt32(TypeID)))
{
return(Json(1, JsonRequestBehavior.AllowGet));
}
return(Json(0, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 新增商品界面
/// </summary>
/// <returns></returns>
public ActionResult AddGoods()
{
Session["li_1"] = 1;
Session["li_2"] = 1;
//查询所有最小的分类
List <TypeTable> typelist = TypeTableBll.SelectSmallType().Select(p => new TypeTable {
TypeID = p.TypeID, TypeName = p.TypeName
}).ToList();
Session["smalltype"] = typelist;
return(View());
}
public JsonResult GetTypeAjax(int index)
{
//获取数据
var list = TypeTableBll.SelectAllType().Where(p => p.TID == index).Select(p => new { TypeName = p.TypeName, TID = p.TID, TypeID = p.TypeID });
JsonSerializerSettings jsonstring = new JsonSerializerSettings();
jsonstring.ReferenceLoopHandling = ReferenceLoopHandling.Ignore;
string ret_1 = JsonConvert.SerializeObject(list, jsonstring);
string ret_2 = JsonConvert.SerializeObject(TypeTableBll.SelectIndexType(index).Select(p => new { TypeName = p.TypeName, TID = p.TID, TypeID = p.TypeID }), jsonstring);
return(Json(new { list_1 = ret_1, list_2 = ret_2 }, JsonRequestBehavior.AllowGet));
}
/// <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>
/// <returns></returns>
public ActionResult Index()
{
//获取导航栏的分类数据
Session["Type"] = TypeTableBll.SelectTypeTable();
//获得所有分类数据
ViewBag.Type = TypeTableBll.SelectAllType();
//获取图片
ViewBag.GoodsPhoto = GoodsPhotoBll.SelectAllGoodsPhoto();
ViewBag.goods_1 = GoodsBll.SelectType1Goods(1).OrderBy(p => p.GoodsHot).Take(8);
ViewBag.goods_2 = GoodsBll.SelectType1Goods(2).OrderBy(p => p.GoodsHot).Take(8);
ViewBag.goods_3 = GoodsBll.SelectType1Goods(3).OrderBy(p => p.GoodsHot).Take(8);
ViewBag.goods_4 = GoodsBll.SelectType1Goods(4).OrderBy(p => p.GoodsHot).Take(8);
if (Session["userid"] != null)
{
Session["carcount"] = ShopingCarBll.SelectAllShopCar(Convert.ToInt32(Session["userid"])).Count();
}
return(View(GoodsBll.SelectAllGoods().Where(p => p.IsDelte == 0).ToList()));
}
/// <summary>
/// 查询上一级分类
/// </summary>
/// <param name="TypeID">分类id</param>
/// <returns></returns>
public JsonResult SelectTid(string index)
{
List <TypeTable> list = new List <TypeTable>();
if (index == "2")
{
//查询第一分类
list = TypeTableBll.SelectAllType().Where(p => p.TID == null).Select(p => new TypeTable()
{
TypeID = p.TypeID, TypeName = p.TypeName
}).ToList();
}
else
{
//查询第二分类
list = TypeTableBll.SelectTypeTable().Select(p => new TypeTable()
{
TypeID = p.TypeID, TypeName = p.TypeName
}).ToList();
}
return(Json(list, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 修改分类名称或所属分类
/// </summary>
/// <param name="TypeID">分类id</param>
/// <param name="TypeName">分类名称</param>
/// <returns></returns>
public JsonResult UpdateTypeName(string TypeID, string TypeName, string TID)
{
TypeTable type = new TypeTable();
if (TID == "")
{
type = new TypeTable()
{
TypeID = Convert.ToInt32(TypeID), TypeName = TypeName, TID = null
};
}
else
{
type = new TypeTable()
{
TypeID = Convert.ToInt32(TypeID), TypeName = TypeName, TID = Convert.ToInt32(TID)
};
}
if (TypeTableBll.UpdateType(type))
{
return(Json(1, JsonRequestBehavior.AllowGet));
}
return(Json(0, JsonRequestBehavior.AllowGet));
}
