public OpResult SaveData(Entity.ProductPublishSql obj) { if (obj.Id == 0) { obj.CreateDT = DateTime.Now; obj.CreateUID = CurrentUser.UID; obj.RunSort = ProductPublishSqlRepository.GetMaxInt(o => (int?)o.RunSort, whereLambda: o => o.PublishId == obj.PublishId); ProductPublishSqlRepository.Add(obj, false); } else { var menu = ProductPublishSqlRepository.Get(obj.Id); if (ProductPublishSqlRepository.IsExists(o => o.MenuId == obj.MenuId && o.PublishId == menu.PublishId && o.Id != obj.Id)) { return(OpResult.Fail("该菜单模块已存在")); } menu.RunSql = obj.RunSql; } var menuModelId = System.Web.HttpContext.Current.Request["menuModelId"]; if (obj.PublishId > 0 && !menuModelId.IsNullOrEmpty()) { var ver = Get(obj.PublishId); if (ver != null) { ver.MenuModuleId = menuModelId; ver.RunSqlWay = System.Web.HttpContext.Current.Request["runSqlWay"].ToType <short>(); ver.UpdateDT = DateTime.Now; ver.UpdateUID = CurrentUser.UID; } } ProductPublishSqlRepository.SaveChanges(); return(OpResult.Success()); }
public void MoveItem(short mode, int sn, int verId) { var list = ProductPublishSqlRepository.GetQuery(o => o.PublishId == verId).OrderBy(o => o.RunSort).ToList(); var obj = list.FirstOrDefault(o => o.MenuId == sn); switch (mode) { case 2: //下移 var obj1 = list.LastOrDefault(); if (obj.Id != obj1.Id) { Entity.ProductPublishSql next = null; for (var i = 0; i < list.Count; i++) { if (obj.Id == list[i].Id) { next = list[i + 1]; break; } } if (next != null) { var sort = obj.RunSort; obj.RunSort = next.RunSort; next.RunSort = sort; ProductPublishSqlRepository.SaveChanges(); } } break; default: //上移 var obj2 = list.FirstOrDefault(); if (obj.Id != obj2.Id) { Entity.ProductPublishSql prev = null; for (var i = 0; i < list.Count; i++) { if (obj.Id == list[i].Id) { prev = list[i - 1]; break; } } if (prev != null) { var sort = obj.RunSort; obj.RunSort = prev.RunSort; prev.RunSort = sort; ProductPublishSqlRepository.SaveChanges(); } } break; } }