//public JsonResult UpdateSorts(long? bannerId, int sx, int Sorts, int IdentityStatus, int BannerPlaceCode) public JsonResult UpdateSorts(SortsModel modelst) { bannerModel model = new bannerModel(); bannerModel modelsx = new bannerModel(); var resultModel = new ResultModel(); resultModel.Messages = new List <string> { "Parameter ID error" }; resultModel.IsValid = false; if (modelst.bannerId > 0) { //UserInfoModel asuser = UserInfo.GetLoginUserInfo(); List <bannerModel> ds = null; //查询 ResultModel result1 = this._bannerService.GetBannerById(modelst.bannerId); if (result1.Data != null) { bannerModel models = new bannerModel(); models = result1.Data; modelst.bannerId = models.bannerId; modelst.BannerPlaceCode = models.PlaceCode; modelst.Sorts = models.Sorts; modelst.IdentityStatus = models.IdentityStatus; } if (modelst.sx == 1) { //获取触发行的下一行数据 var resultlist = this._bannerService.GetBanner(modelst.Sorts, 1, modelst.IdentityStatus, modelst.bannerId, modelst.BannerPlaceCode); ds = resultlist.Data; if (ds != null && ds.Count > 0) { modelsx = ds[0]; modelsx.UpdateBy = UserInfo.CurrentUserName; modelsx.UpdateDT = DateTime.Now; var models = modelsx.Sorts; modelsx.Sorts = modelst.Sorts; // //this._bannerService.UpdateBanner(smodel); model.Sorts = models; //触发行修改的排序 } else { resultModel.Messages = new List <string> { "This is last line!!" }; return(Json(resultModel, JsonRequestBehavior.AllowGet)); } } else { //获取触发行的上一行数据 var resultlist = this._bannerService.GetBanner(modelst.Sorts, 2, modelst.IdentityStatus, modelst.bannerId, modelst.BannerPlaceCode); ds = resultlist.Data; if (ds != null && ds.Count > 0) { modelsx = ds[ds.Count - 1];//获取最后一行 modelsx.UpdateBy = UserInfo.CurrentUserName; modelsx.UpdateDT = DateTime.Now; var models = modelsx.Sorts; modelsx.Sorts = modelst.Sorts; // //this._bannerService.UpdateBanner(smodel1); model.Sorts = models; //触发行修改的排序 } else { resultModel.Messages = new List <string> { "This is top line!" }; return(Json(resultModel, JsonRequestBehavior.AllowGet)); } } model.bannerId = modelst.bannerId; model.UpdateBy = UserInfo.CurrentUserName; model.UpdateDT = DateTime.Now; var result = this._bannerService.UpdateSorts(model, modelsx).IsValid; if (result) { resultModel.Messages = new List <string> { "Move success!" }; } else { resultModel.Messages = new List <string> { "Move failed!" }; } return(Json(resultModel, JsonRequestBehavior.AllowGet)); } return(Json(resultModel, JsonRequestBehavior.AllowGet)); }
/// <summary> /// Banner上下移动Sorts(用于列表排序显示) /// </summary> /// <param name="bannerId"></param> /// <param name="sx">1上移动,2下移动</param> /// <returns></returns> public string UpdateSorts(SortsModel modelst) { bannerProductModel model = new bannerProductModel(); bannerProductModel modelsx = new bannerProductModel(); if (modelst.bannerId > 0) { //UserInfoModel asuser = UserInfo.GetLoginUserInfo(); List <bannerProductModel> ds = null; //查询 SearchbannerProductModel spmodel = new SearchbannerProductModel(); spmodel.bannerProductId = modelst.bannerId; spmodel.IdentityStatus = modelst.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]; modelst.bannerId = models.bannerProductId; modelst.BannerPlaceCode = models.PlaceCode; modelst.Sorts = models.Sorts; modelst.IdentityStatus = models.IdentityStatus; } if (modelst.sx == 1) { //获取触发行的下一行数据 var resultlist = this._bannerProductService.GetBannerProduct(modelst.Sorts, 1, modelst.IdentityStatus, modelst.bannerId, 1, modelst.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 = modelst.Sorts; //触发行的上一行,把它的排序减一 //this._bannerService.UpdateBanner(smodel); model.Sorts = msorts; //触发行修改的排序 } else { return("This is last line!"); } } else { //获取触发行的上一行数据 var resultlist = this._bannerProductService.GetBannerProduct(modelst.Sorts, 2, modelst.IdentityStatus, modelst.bannerId, 1, modelst.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 = modelst.Sorts; //触发行的下一行,把它排序加一 //this._bannerService.UpdateBanner(smodel1); model.Sorts = msorts; //触发行修改的排序 } else { return("This is top line"); } } model.bannerProductId = modelst.bannerId; 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!"); }