/// <summary> /// 获取推荐商品类型集合 /// </summary> /// <returns></returns> private string GetGoodsRecommendType() { DAL.GoodsInfoDal goodsInfoDal = new DAL.GoodsInfoDal(); DataTable dataTable = goodsInfoDal.GetGoodsRecommendType(); string result = JsonConvert.SerializeObject(new { data = dataTable }); return(result); }
/// <summary> /// 删除推荐商品 /// </summary> /// <param name="json"></param> /// <returns></returns> private string DeleteGoodsRecommend(string json) { dynamic obj = JsonConvert.DeserializeObject <dynamic>(json); int type = Convert.ToInt32(obj.code); int articleid = Convert.ToInt32(obj.articleid); DAL.GoodsInfoDal goodsInfoDal = new DAL.GoodsInfoDal(); bool result = goodsInfoDal.DeleteGoodsRecommend(articleid, type); return(result ? JsonMethod.GetError(1, "删除成功") : JsonMethod.GetError(0, "删除失败,请稍后重试")); }
/// <summary> /// 获取单个推荐商品 /// </summary> /// <param name="json"></param> /// <returns></returns> private string SingleGoodsRecommend(string json) { dynamic obj = JsonConvert.DeserializeObject <dynamic>(json); int type = Convert.ToInt32(obj.code); int articleid = Convert.ToInt32(obj.articleid); DAL.GoodsInfoDal goodsInfoDal = new DAL.GoodsInfoDal(); DataTable dt = goodsInfoDal.SingleGoodsRecommend(articleid, type); string result = JsonConvert.SerializeObject(dt); return(result); }
/// <summary> /// 获取购物车推荐的商品列表 /// </summary> /// <param name="json"></param> /// <returns></returns> private string GetGoodRecommendList(string json) { dynamic souObj = JsonConvert.DeserializeObject <dynamic>(json); int type = Convert.ToInt32(souObj.code); int status = Convert.ToInt32(souObj.status); string soustr = souObj.soustr; int pageindex = Convert.ToInt32(souObj.pageindex); int pagesize = Convert.ToInt32(souObj.pagesize); int recordcount = 0; int pagecount = 0; DAL.GoodsInfoDal goodsInfoDal = new DAL.GoodsInfoDal(); DataTable dataTable = goodsInfoDal.GetGoodsRecommendList(pageindex, pagesize, soustr.Trim().ToUpper(), type, status, ref recordcount, ref pagecount).Tables[1]; string result = JsonConvert.SerializeObject(new { data = dataTable, recordcount = recordcount, pagecount = pagecount }); return(result); }
/// <summary> /// 添加推荐商品 /// </summary> /// <param name="json"></param> /// <returns></returns> private string AddGoodsRecommend(string json) { dynamic obj = JsonConvert.DeserializeObject <dynamic>(json); int type = Convert.ToInt32(obj.code); int status = Convert.ToInt32(obj.status); int articleid = Convert.ToInt32(obj.articleid); int sort = Convert.ToInt32(obj.sort); DAL.GoodsInfoDal goodsInfoDal = new DAL.GoodsInfoDal(); bool isExist = goodsInfoDal.ExistGoodsRecommend(articleid, type); if (isExist) { return(JsonMethod.GetError(3, "此推荐商品已存在"));// "{\"d\":false,\"msg\":\"此推荐商品已存在\"}"; } bool result = goodsInfoDal.AddGoodsRecommend(articleid, type, status, sort); return(result ? JsonMethod.GetError(1, "添加成功") : JsonMethod.GetError(0, "添加失败,请稍后重试"));// "{\"d\":true,\"msg\":\"添加成功\"}" : "{\"d\":false,\"msg\":\"系统错误,请稍后重试\"}"; }
/// <summary> /// 修改推荐商品 /// </summary> /// <param name="json"></param> /// <returns></returns> private string UpdateGoodsRecommend(string json) { dynamic obj = JsonConvert.DeserializeObject <dynamic>(json); int articleid = Convert.ToInt32(obj.articleid); int old_articleid = Convert.ToInt32(obj.old_articleid); int type = Convert.ToInt32(obj.code); int old_type = Convert.ToInt32(obj.old_type); int status = Convert.ToInt32(obj.status); int sort = Convert.ToInt32(obj.sort); DAL.GoodsInfoDal goodsInfoDal = new DAL.GoodsInfoDal(); if (articleid != old_articleid) { bool isExist = goodsInfoDal.ExistGoodsRecommend(articleid, type); if (isExist) { return(JsonMethod.GetError(3, "此推荐商品已存在")); } } bool result = goodsInfoDal.UpdateGoodsRecommend(articleid, old_articleid, type, old_type, status, sort); return(result ? JsonMethod.GetError(1, "修改成功") : JsonMethod.GetError(0, "修改失败,请稍后重试")); }