/// <summary> /// Banner加载数据 /// </summary> /// <param name="id"></param> /// <returns></returns> public ActionResult Create(long?id, int identityStatus) { bannerProductModel model = null; ViewBag.ImagePath = ImagePath; if (id.HasValue) { int total = 0; //查询列表 由于是3表连接,关联关键字是商品ID,默认条件是商品语音为中文,如果查不到,请查看bannerProduct,Product_Lang //var result = this._bannerProductService.GetBannerProduct(model); SearchbannerProductModel spmodel = new SearchbannerProductModel(); spmodel.bannerProductId = id.Value; spmodel.IdentityStatus = identityStatus; var result = this._bannerProductService.GetBannerProduct(spmodel, out total).Data as List <bannerProductModel>; //Result result = this._bannerProductService.GetBannerProductById(id.Value); if (result != null && result.Count > 0) { model = result[0]; } } else { model = new bannerProductModel(); model.IdentityStatus = identityStatus;//添加控制位置是否显示出来 } ViewData["BannerPlaceCodeModel1"] = null; if (model.IdentityStatus == 2) { ViewData["BannerPlaceCodeModel1"] = con.GetBannerProducPlaceCodeNameList(ACultureHelper.GetLanguageID, 0, model.IdentityStatus); } //ViewData["IdentityModelBannerCreate"] = con.GetIdentityNameList(new int[] { 1 }); return(PartialView(model)); }
/// <summary> /// 列表Banner /// </summary> /// <param name="model"></param> /// <returns></returns> public JsonResult List(SearchbannerProductModel model) { //SearchAC_OperateLogModel logmodel = new SearchAC_OperateLogModel(); model.PagedIndex = model.PagedIndex == 0 ? 0 : model.PagedIndex; model.PagedSize = model.PagedSize == 0 ? 10 : model.PagedSize; //标识ID 1首页轮播banner,2首页楼层banner,3 分类频道轮播banner,4分类频道楼层banner model.IdentityStatus = model.IdentityStatus == null ? 1 : model.IdentityStatus; model.LanguageID = ACultureHelper.GetLanguageID; int total = 0; //查询列表 由于是3表连接,关联关键字是商品ID,默认条件是商品语音为中文,如果查不到,请查看bannerProduct,Product_Lang //var result = this._bannerProductService.GetBannerProduct(model); var result = this._bannerProductService.GetBannerProduct(model, out total); List <bannerProductModel> ds = result.Data; var data = new { rows = ds, total = ds.Count, }; return(Json(data, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 列表Banner /// </summary> /// <param name="model"></param> /// <returns></returns> public JsonResult List(SearchbannerProductModel model) { //SearchAC_OperateLogModel logmodel = new SearchAC_OperateLogModel(); model.PagedIndex = model.PagedIndex == 0 ? 0 : model.PagedIndex; model.PagedSize = model.PagedSize == 0 ? 10 : model.PagedSize; //标识ID 1 首页右部的推荐商品,2首页楼层商品,3 APP楼层商品 model.IdentityStatus = 3; int total = 0; //查询列表 由于是3表连接,关联关键字是商品ID,默认条件是商品语音为中文,如果查不到,请查看bannerProduct,Product_Lang //var result = this._bannerProductService.GetBannerProduct(model); var result = this._bannerProductService.GetBannerProduct(model, out total); List <bannerProductModel> ds = result.Data; var data = new { rows = ds, total = ds.Count, }; return(Json(data, JsonRequestBehavior.AllowGet)); }
/// <summary> /// Banner上下移动Sorts(用于列表排序显示) /// </summary> /// <param name="bannerId"></param> /// <param name="sx">1上移动,2下移动</param> /// <returns></returns> public string UpdateSorts(long?bannerId, int sx, long Sorts, int IdentityStatus, int BannerPlaceCode) { bannerProductModel model = new bannerProductModel(); bannerProductModel modelsx = new bannerProductModel(); if (bannerId.HasValue) { //UserInfoModel asuser = UserInfo.GetLoginUserInfo(); //查询 SearchbannerProductModel spmodel = new SearchbannerProductModel(); spmodel.bannerProductId = bannerId.Value; spmodel.IdentityStatus = IdentityStatus; int total = 0; var result1 = this._bannerProductService.GetBannerProduct(spmodel, out total).Data as List <bannerProductModel>; if (result1 != null && result1.Count > 0) { bannerProductModel models = new bannerProductModel(); models = result1[0]; bannerId = models.bannerProductId; BannerPlaceCode = models.PlaceCode; Sorts = models.Sorts; IdentityStatus = models.IdentityStatus; } List <bannerProductModel> ds = null; if (sx == 1) { //获取触发行的上一行数据 var resultlist = this._bannerProductService.GetBannerProduct(Sorts, 1, IdentityStatus, bannerId.Value, 1, BannerPlaceCode); ds = resultlist.Data; if (ds != null && ds.Count > 0) { modelsx = ds[ds.Count - 1]; modelsx.UpdateBy = UserInfo.CurrentUserName; modelsx.UpdateDT = DateTime.Now; var msorts = modelsx.Sorts; modelsx.Sorts = Sorts; //触发行的上一行,把它的排序减一 //this._bannerService.UpdateBanner(smodel); model.Sorts = msorts; //触发行修改的排序 } else { return("This is top line"); } } else { //获取触发行的下一行数据 var resultlist = this._bannerProductService.GetBannerProduct(Sorts, 2, IdentityStatus, bannerId.Value, 1, BannerPlaceCode); ds = resultlist.Data; if (ds != null && ds.Count > 0) { modelsx = ds[0]; modelsx.UpdateBy = UserInfo.CurrentUserName; modelsx.UpdateDT = DateTime.Now; var msorts = modelsx.Sorts; modelsx.Sorts = Sorts; //触发行的下一行,把它排序加一 //this._bannerService.UpdateBanner(smodel1); model.Sorts = msorts; //触发行修改的排序 } else { return("This is last line!"); } } model.bannerProductId = bannerId.Value; model.UpdateBy = UserInfo.CurrentUserName; model.UpdateDT = DateTime.Now; var result = this._bannerProductService.UpdateSorts(model, modelsx).IsValid; return(result == true ? "Move success!" : "Move failed!"); } return("Move failed!"); }
/// <summary> /// 获取banner图片列表 /// </summary> /// <returns>banner图片列表</returns> public ResultModel GetBannerProduct(SearchbannerProductModel model) { var tb = base._database.Db.bannerProduct; var where = new SimpleExpression(1, 1, SimpleExpressionType.Equal); //商品状态 where = new SimpleExpression(where, _database.Db.Product.Status == 4, SimpleExpressionType.And); if (model.PlaceCode > 0) { where = new SimpleExpression(where, tb.PlaceCode == model.PlaceCode, SimpleExpressionType.And);//位置(分类)(代表页面里的某个部位) } if (model.IdentityStatus > 0) { //标识ID (代表页面) where = new SimpleExpression(where, tb.IdentityStatus == model.IdentityStatus, SimpleExpressionType.And); } var result = new ResultModel(); dynamic pc; var query = _database.Db.bannerProduct .Query() .LeftJoin(_database.Db.Product, out pc) .On(_database.Db.Product.ProductId == _database.Db.bannerProduct.ProductId) .Select( tb.productId, tb.PicAddress, tb.Sorts, tb.PlaceCode, tb.IdentityStatus, tb.CreateBy, tb.CreateDT, tb.UpdateBy, tb.UpdateDT, tb.bannerProductId, pc.HKPrice, pc.CategoryId ) //.Where(where); //.Where(cl.languageId == null || cl.languageId == model.LanguageID) .Where(where) .OrderBySorts() .ToList <bannerProductModel>() ; result.Data = query; //var result = new ResultModel() //{ // Data = new SimpleDataPagedList<bannerProductModel>(base._database.Db.bannerProduct.FindAll(where).OrderBySorts(), model.PagedIndex, model.PagedSize) //}; return(result); }
/// <summary> /// 获取列表 /// </summary> /// <returns>列表</returns> public ResultModel GetBannerProduct(SearchbannerProductModel model, out int total) { dynamic cl; dynamic pc; var tb = base._database.Db.bannerProduct; var where = new SimpleExpression(1, 1, SimpleExpressionType.Equal); //商品状态 where = new SimpleExpression(where, _database.Db.Product.Status == 4, SimpleExpressionType.And); var result = new ResultModel(); total = 0; if (model.PlaceCode > 0) { where = new SimpleExpression(where, tb.PlaceCode == model.PlaceCode, SimpleExpressionType.And);//位置(分类)(代表页面里的某个部位) } if (model.IdentityStatus > 0) { //标识ID (代表页面) where = new SimpleExpression(where, tb.IdentityStatus == model.IdentityStatus, SimpleExpressionType.And); } if (model.LanguageID > 0) { //选择语言 where = new SimpleExpression(where, _database.Db.Product_Lang.languageId == model.LanguageID, SimpleExpressionType.And); } else { if (model.IdentityStatus > 1) { //1不是楼层 where = new SimpleExpression(where, _database.Db.Product_Lang.languageId == 1, SimpleExpressionType.And); } } if (model.productId > 0) { where = new SimpleExpression(where, _database.Db.Product.productId == model.productId, SimpleExpressionType.And); } if (model.bannerProductId > 0) { where = new SimpleExpression(where, tb.bannerProductId == model.bannerProductId, SimpleExpressionType.And); } var query = _database.Db.bannerProduct //.FindAllBybannerProductId(1215865440) .Query() //.FindAll() .LeftJoin(_database.Db.Product_Lang, out cl) .On(_database.Db.Product_Lang.ProductId == _database.Db.bannerProduct.ProductId) .LeftJoin(_database.Db.Product, out pc) .On(_database.Db.Product.ProductId == _database.Db.bannerProduct.ProductId) .Select( tb.productId, tb.PicAddress, tb.Sorts, tb.PlaceCode, tb.IdentityStatus, tb.CreateBy, tb.CreateDT, tb.UpdateBy, tb.UpdateDT, tb.bannerProductId, cl.ProductName, cl.LanguageID, pc.HKPrice, pc.CategoryId, pc.Status ) //.Where(where); //.Where(cl.languageId == null || cl.languageId == model.LanguageID) .Where(where) .OrderBySorts() .ToList <bannerProductModel>() ; //query = query.Skip(model.PagedIndex * model.PagedSize).Take(model.PagedSize).ToList<bannerProductModel>(); //total = query.Count; result.Data = query; //result.Data = new SimpleDataPagedList<bannerProductModel>(base._database.Db.bannerProduct.FindAll(where).OrderBySortsDescending(), model.PagedIndex, model.PagedSize); return(result); }