public bool AddSize(string sizeName, int width, int height, int thumb_width, int thumb_height, int cover_width, int cover_height, out IList<string> errors) { using (var context = new WSI.DataAccess.WSICmsContext()) { var entity = new ImageSize() { SizeName = sizeName, Width = width, Height = height, ThumbWidth = thumb_width, ThumbHeight = thumb_height, CoverWidth = cover_width, CoverHeight = cover_height, State = (int)EnumHelper.State.Enable, CreateTime = DateTime.Now }; var validate = context.Entry(entity).GetValidationResult(); if (!validate.IsValid) { errors = validate.ValidationErrors.Select(e => e.ErrorMessage).ToList(); return false; } context.ImageSizes.Add(entity); context.LogChangesDuringSave = true; context.SaveChanges(); errors = null; return true; } }
public int AddTag(string parentId, string tagName, string code, string description) { using (var context = new WSI.DataAccess.WSICmsContext()) { Tag tag = new Tag(); tag.TagName = tagName; tag.TagCode = code; tag.Description = description; //父标签 Guid pid; if (Guid.TryParse(parentId, out pid)) { tag.Parent = context.Tags.Find(pid); } tag.CreateTime = DateTime.Now; tag.State = (int)EnumHelper.State.Enable;//默认启用 context.Tags.Add(tag); context.LogChangesDuringSave = true; return context.SaveChanges(); } }
//添加导航时不对排序字段进行设置,默认为0,显示在最前的位置,当第一次执行排序操作时,将会对SortIndex进行更新 public void AddNavigation(string navName, string url, string description, string parentId, bool asMenu) { using (var context = new WSI.DataAccess.WSICmsContext()) { Navigation nav = new Navigation(); nav.NavigationName = navName; nav.Url = url; nav.Description = description; nav.AsMenu = asMenu; //父导航 Guid id; if (Guid.TryParse(parentId, out id)) { nav.Parent = context.Navigations.Find(id); } nav.State = (int)EnumHelper.State.Enable; nav.CreateTime = DateTime.Now; context.Navigations.Add(nav); context.LogChangesDuringSave = true; context.SaveChanges(); } }
public int AddNavigation(string parentId, string navName, string url, int type, string description) { using (var context = new WSI.DataAccess.WSICmsContext()) { FrontendNavigation nav = new FrontendNavigation(); nav.NavName = navName; nav.Url = url; nav.Type = type; //添加父导航 Guid pid; if (Guid.TryParse(parentId, out pid)) { nav.Parent = context.FrontendNavigations.Find(pid); } nav.Description = description; nav.State = (int)EnumHelper.State.Enable; nav.CreateTime = DateTime.Now; context.FrontendNavigations.Add(nav); context.LogChangesDuringSave = true; return context.SaveChanges(); } }
public void AddAttachImage(string infoid, string path, string description) { using (var context = new WSI.DataAccess.WSICmsContext()) { var info = GetDetailIncludeAll(infoid); context.Informations.Attach(info); //var info = GetDetailIncludeAll(infoid, context); if (info.Attachments == null) { info.Attachments = new List<Attachment>(); } long sortindex = info.Attachments.Count == 0 ? 0 : (info.Attachments.Select(a => a.SortIndex).Max() + 10); info.Attachments.Add(new Attachment() { SourceUrl = path, Description = description, CreateTime = DateTime.Now, State = (int)EnumHelper.State.Disable, SortIndex = sortindex }); context.LogChangesDuringSave = true; context.SaveChanges(); } }
public void Add(string rolename, string description, IList<string> navlist) { using (var context = new WSI.DataAccess.WSICmsContext()) { RoleInfo role = new RoleInfo(); role.RoleInfoId = Guid.NewGuid(); role.RoleName = rolename; role.Description = description; role.CreateTime = DateTime.Now; //设置权限 setNavigation(context, role, navlist); //角色类型 if (SiteManager == null) { //如果没有站点管理角色 role.RoleType = (int)RoleType.SiteManager; } else { role.RoleType = (int)RoleType.Common; } context.RoleInfoes.Add(role); context.LogChangesDuringSave = true; context.SaveChanges(); } }
public void Add(JoinApply apply) { using (var context = new WSI.DataAccess.WSICmsContext()) { context.Entry(apply).State = EntityState.Added; context.SaveChanges(); } }
public IList<Navigation> GetActiveList() { using (var context = new WSI.DataAccess.WSICmsContext()) { return context.Navigations .Where(n => n.State == (int)EnumHelper.State.Enable) .OrderByDescending(n => n.CreateTime) .ToList(); } }
public int ChangeState(Attachment attach, int state) { using (var context = new WSI.DataAccess.WSICmsContext()) { context.Attachments.Attach(attach); attach.State = state; context.LogChangesDuringSave = true; return context.SaveChanges(); } }
public int ChangeState(UserInfo user, int state) { using (var context = new WSI.DataAccess.WSICmsContext()) { context.UserInfoes.Attach(user); user.State = state; context.LogChangesDuringSave = true; return context.SaveChanges(); } }
public IList<JoinApply> GetPagedList(int pageindex, int pagesize, out int count) { using (var context = new WSI.DataAccess.WSICmsContext()) { var query = context.JoinApplys .OrderByDescending(j => j.ApplyTime); count = query.Count(); return query.Skip(pagesize * (pageindex - 1)).Take(pagesize).ToList(); } }
public int Delete(string id) { using (var context = new WSI.DataAccess.WSICmsContext()) { var item = GetDetail(id); context.Entry(item).State = EntityState.Deleted; context.LogChangesDuringSave = true; return context.SaveChanges(); } }
public int ChangeState(FrontendNavigation nav, int state) { using (var context = new WSI.DataAccess.WSICmsContext()) { context.FrontendNavigations.Attach(nav); nav.State = state; context.LogChangesDuringSave = true; return context.SaveChanges(); } }
public IList<Log> GetPagedList(int pageindex, int pagesize, out int count) { using (var context = new WSI.DataAccess.WSICmsContext()) { var query = context.Logs .OrderByDescending(l => l.CreateTime); count = query.Count(); return query.Skip(pagesize * (pageindex - 1)).Take(pagesize).ToList(); } }
public int ChangeState(Recruitment item, int state) { using (var context = new WSI.DataAccess.WSICmsContext()) { context.Recruitments.Attach(item); item.State = state; context.LogChangesDuringSave = true; return context.SaveChanges(); } }
public int ChangeState(RoleInfo role, int state) { using (var context = new WSI.DataAccess.WSICmsContext()) { context.RoleInfoes.Attach(role); role.State = state; context.LogChangesDuringSave = true; return context.SaveChanges(); } }
public UserInfo GetDetail(string userid) { using (var context = new WSI.DataAccess.WSICmsContext()) { Guid id; if (Guid.TryParse(userid, out id)) { return context.UserInfoes.Find(id); } return null; } }
public JoinApply GetDetail(string applyid) { using (var context = new WSI.DataAccess.WSICmsContext()) { Guid id; if (Guid.TryParse(applyid, out id)) { return context.JoinApplys.Find(id); } return null; } }
public IList<Recruitment> GetActivePagedList(int pageindex, int pagesize, out int count) { using (var context = new WSI.DataAccess.WSICmsContext()) { var query = context.Recruitments .Where(r => r.State == (int)EnumHelper.State.Enable) .OrderByDescending(r => r.PublishTime); count = query.Count(); return query.Skip(pagesize * (pageindex - 1)).Take(pagesize).ToList(); } }
public Log GetDetail(string logid) { using (var context = new WSI.DataAccess.WSICmsContext()) { Guid id; if (Guid.TryParse(logid, out id)) { return context.Logs.Find(id); } return null; } }
public Attachment GetDetail(string attachId) { using (var context = new WSI.DataAccess.WSICmsContext()) { Guid id; if (Guid.TryParse(attachId, out id)) { return context.Attachments.Find(id); } return null; } }
public int Delete(string id) { using (var context = new WSI.DataAccess.WSICmsContext()) { var nav = GetDetailIncludeAll(id); context.Navigations.Attach(nav); context.Navigations.Remove(nav); context.LogChangesDuringSave = true; return context.SaveChanges(); } }
public int AddInformation( string title, string subtitle, string source, string author, string adder, string summary, string content, string referenceUrl, bool isTop, IList<string> keywords, IList<string> navidlist, DateTime publishTime, string resourcePath ) { using (var context = new WSI.DataAccess.WSICmsContext()) { Information info = new Information(); info.Title = title; info.SubTitle = subtitle; info.Source = source; info.Author = author; info.Adder = adder; info.Summary = summary; info.Content = content; info.ReferenceUrl = referenceUrl; info.IsTop = isTop; info.PublishTime = publishTime; info.ResourcePath = resourcePath; //默认字段 info.CreateTime = DateTime.Now; info.UpdateTime = DateTime.Now; info.State = (int)EnumHelper.State.Disable;//默认禁用,因为还要在列表页添加附件和预览 //关键字 setKeyWords(context, info, keywords); //所属栏目 setNavigation(context, info, navidlist); context.Informations.Add(info); context.LogChangesDuringSave = true; return context.SaveChanges(); } }
public void UpdateAttach(string attachId, string description, int sortIndex) { using (var context = new WSI.DataAccess.WSICmsContext()) { var attach = GetDetail(attachId); if (attach != null) { context.Attachments.Attach(attach); attach.Description = description; attach.SortIndex = sortIndex; context.LogChangesDuringSave = true; context.SaveChanges(); } } }
public int Delete(string userid) { using (var context = new WSI.DataAccess.WSICmsContext()) { var user = GetDetail(userid); context.UserInfoes.Attach(user); //加载个人信息和角色信息到内存中 context.Entry(user).Reference(u => u.Profile).Load(); context.Entry(user).Collection(u => u.RoleList).Load(); context.UserInfoes.Remove(user); context.LogChangesDuringSave = true; return context.SaveChanges(); } }
public int Delete(string id) { using (var context = new WSI.DataAccess.WSICmsContext()) { //只能删除没有子项的栏目 if (GetSortedListByParentId(id).Count == 0) { var nav = GetDetail(id); context.FrontendNavigations.Attach(nav); context.FrontendNavigations.Remove(nav); context.LogChangesDuringSave = true; return context.SaveChanges(); } return 0; } }
public int Delete(string id) { using (var context = new WSI.DataAccess.WSICmsContext()) { var item = GetDetail(id); if (item != null) { context.Attachments.Attach(item); var info = context.Informations.Find(item.InformationId); //先将该附件从信息中移除 info.Attachments.Remove(item); context.Attachments.Remove(item); } context.LogChangesDuringSave = true; return context.SaveChanges(); } }
public void Add(string name, string password, IList<string> roleidlist) { using (var context = new WSI.DataAccess.WSICmsContext()) { UserInfo user = new UserInfo(); //user.UserId = Guid.NewGuid(); user.UserName = name; user.UserPassword = password.EncryptMD5(); user.CreateTime = DateTime.Now; user.LastVisitTime = DateTime.Now; user.State = (int)EnumHelper.State.Disable; //添加角色 setRoleInfo(context, user, roleidlist); context.UserInfoes.Add(user); context.LogChangesDuringSave = true; context.SaveChanges(); } }
public void AddRecruitment(string position, string department, string workplace, string duty, string requirement, DateTime publishTime) { using (var context = new WSI.DataAccess.WSICmsContext()) { var recruit = new Recruitment() { Position = position, Department = department, WorkPlace = workplace, Duty = duty, Requirement = requirement, PublishTime = publishTime }; context.Recruitments.Add(recruit); context.LogChangesDuringSave = true; context.SaveChanges(); } }
public void AddCookBook( string name, string summary, string source, string referenceUrl, string materail, string benifits, string practice, string tips, string navid, bool isRecommend) { using (var context = new WSI.DataAccess.WSICmsContext()) { context.CookBooks.Add(new CookBook() { CookBookName = name, Summary = summary, Source = source, ReferenceUrl = referenceUrl, Material = materail, Benifits = benifits, Practice = practice, Tips = tips, NavigationId = Guid.Parse(navid), IsRecommend = isRecommend, ImageUrl = "", LikeCount = 0, State = (int)EnumHelper.State.Disable, CreateTime = DateTime.Now }); context.LogChangesDuringSave = true; context.SaveChanges(); } }