public object SavePlanSet(PlanSet entity) { using (var db = new WeeklyEntities()) { var loginner = FormsAuth.GetUserData<LoginerBase>(); int execCount = 0; if (entity.Id == 0) { entity.CreateBy = loginner.Name; entity.CreateById = loginner.UserID; entity.CreateByDate = DateTime.Now; db.PlanSets.Add(entity); } else { var oldEntity = db.PlanSets.First(p => p.Id == entity.Id); oldEntity.PBegin = entity.PBegin; oldEntity.BeginDay = entity.BeginDay; oldEntity.PEnd = entity.PEnd; oldEntity.EndDay = entity.EndDay; oldEntity.Content = entity.Content; oldEntity.Place = entity.Place; oldEntity.Leads = entity.Leads; oldEntity.UndertakeDept = entity.UndertakeDept; oldEntity.ParticipationDept = entity.ParticipationDept; oldEntity.PState = entity.PState; } execCount = db.SaveChanges(); if (execCount > 0) return new { status = "success", message = "操作成功!" }; else return new { status = "error", message = "操作失败,请检查!" }; } }
public object SaveNotice(Notice entity) { using (var db = new WeeklyEntities()) { var loginner = FormsAuth.GetUserData<LoginerBase>(); int execCount = 0; if (entity.Id == 0) { entity.CreateBy = loginner.Name; entity.CreateById = loginner.UserID; entity.CreateByDate = DateTime.Now; if (entity.State == 1) entity.ReleaseDate = DateTime.Now; db.Notices.Add(entity); } else { var oldEntity = db.Notices.First(p => p.Id == entity.Id); oldEntity.Title = entity.Title; oldEntity.Content = entity.Content; oldEntity.State = entity.State; if (entity.State == 1) oldEntity.ReleaseDate = DateTime.Now; } execCount = db.SaveChanges(); if (execCount > 0) return new { status = "success", message = "操作成功!" }; else return new { status = "error", message = "操作失败,请检查!" }; } }
public object SaveTask(Task entity) { using (var db = new WeeklyEntities()) { var loginner = FormsAuth.GetUserData<LoginerBase>(); int execCount = 0; if (entity.Id == 0) { entity.State = 1; entity.CreateBy = loginner.Name; entity.CreateById = loginner.UserID; entity.CreateByDate = DateTime.Now; db.Tasks.Add(entity); } else { var oldEntity = db.Tasks.First(p => p.Id == entity.Id); oldEntity.WeeklyYear = entity.WeeklyYear; oldEntity.WeeklyWeeks = entity.WeeklyWeeks; oldEntity.WeeklyBegin = entity.WeeklyBegin; oldEntity.WeeklyEnd = entity.WeeklyEnd; oldEntity.PlanBegin = entity.PlanBegin; oldEntity.PlanEnd = entity.PlanEnd; } execCount = db.SaveChanges(); if (execCount > 0) return new { status = "success", message = "操作成功!" }; else return new { status = "error", message = "操作失败,请检查!" }; } }
public object saveRole(Role entity) { using (var db = new WeeklyEntities()) { var loginner = FormsAuth.GetUserData<LoginerBase>(); int execCount = 0; if (entity.Id == 0) { entity.CreateBy = loginner.Name; entity.CreateById = loginner.UserID; entity.CreateByDate = DateTime.Now; db.Roles.Add(entity); } else { var oldEntity = db.Roles.First(p => p.Id == entity.Id); oldEntity.Name = entity.Name; oldEntity.OrgTypeId = entity.OrgTypeId; } execCount = db.SaveChanges(); if (execCount > 0) return new { status = "success", message = "操作成功!" }; else return new { status = "error", message = "操作失败,请检查!" }; } }
public object GetDataByRoleId(int RoleID) { using (var db = new WeeklyEntities()) { db.Configuration.ProxyCreationEnabled = false; return db.RoleMenus.Where(p => p.RoleId == RoleID).ToList(); } }
public object GetAllData() { using (var db = new WeeklyEntities()) { db.Configuration.ProxyCreationEnabled = false; return db.OrgTypes.OrderBy(p => p.Sort).ToList(); } }
public object GetNewDetail() { using (var db = new WeeklyEntities()) { Task tk = db.Tasks.OrderByDescending(t => t.Id).FirstOrDefault(); return tk; } }
public object getAllMenu() { using (var db = new WeeklyEntities()) { string sql = "SELECT Name, PermCode, CASE WHEN len(PermCode) = 2 THEN '00' ELSE LEFT(PermCode, len(PermCode) - 2) END AS Url,IsShow,Sort FROM Menu"; var Menus = db.Database.SqlQuery<Menu>(sql).ToList(); return Menus; } }
public object saveRoleMenu(List<RoleMenu> entitys) { delRoleMenu(entitys[0].RoleId); using (var db = new WeeklyEntities()) { db.RoleMenus.AddRange(entitys); db.SaveChanges(); return new { status = "success", message = "操作成功!" }; } }
public object DelNotice(string ids) { using (var db = new WeeklyEntities()) { var execCount = 0; string sql = string.Format("delete Notice where Id in ({0})", ids); execCount = db.Database.ExecuteSqlCommand(sql); if (execCount == ids.Split(',').Length) return new { status = "success", message = "操作成功!" }; else return new { status = "error", message = "操作失败,请检查!" }; } }
public object delRoleMenu(int? RoleID) { using (var db = new WeeklyEntities()) { var roleMenus = db.RoleMenus.Where(m => m.RoleId == RoleID).ToList(); if (roleMenus.Count > 0) { db.RoleMenus.RemoveRange(roleMenus); db.SaveChanges(); } return new { status = "success", message = "操作成功!" }; } }
public string GetMainList(int pageIndex, int pageSize) { dynamic result = new ExpandoObject(); using (var db = new WeeklyEntities()) { var customs = (from custom in db.Notices where custom.State == 1 select custom ).OrderByDescending(t => t.ReleaseDate).Skip(0 * 10).Take(10); result.data = customs; var json = JsonConvert.SerializeObject(result); return json; } }
public object getMenuTree() { var loginner = FormsAuth.GetUserData<LoginerBase>(); int RoleId = loginner.RoleId; if (RoleId != 0) { using (var db = new WeeklyEntities()) { var Menus = db.VRoleMenus.Where(p => p.RoleId == RoleId).OrderBy(p => p.Sort).ToList(); return Menus; } } return null; }
public string GetDataList(int pageIndex, int pageSize) { dynamic result = new ExpandoObject(); using (var db = new WeeklyEntities()) { var total = db.PlanSets.Count(); if (total <= 0 || pageSize <= 0) { return null; } var customs = (from custom in db.PlanSets select custom ).OrderBy(t => t.Id).Skip(pageIndex * pageSize).Take(pageSize); result.total = total; result.data = customs; var json = JsonConvert.SerializeObject(result); return json; } }
public string GetDataList(int pageIndex, int pageSize, string Title) { dynamic result = new ExpandoObject(); using (var db = new WeeklyEntities()) { var total = db.Notices.Where(t => t.Title.Contains(Title)).Count(); if (total <= 0 || pageSize <= 0) { return null; } var customs = (from custom in db.Notices where custom.Title.Contains(Title) select custom ).OrderByDescending(t => t.Id).Skip(pageIndex * pageSize).Take(pageSize); result.total = total; result.data = customs; var json = JsonConvert.SerializeObject(result); return json; } }
public string getRole(int pageIndex, int pageSize) { dynamic result = new ExpandoObject(); using (var db = new WeeklyEntities()) { var total = db.Roles.Count(); if (total <= 0 || pageSize <= 0) { return null; } var customs = (from custom in db.Roles join o in db.OrgTypes on custom.OrgTypeId equals o.Id orderby custom.Id select new { custom.Id, custom.Name, custom.OrgTypeId, OrgTypeName = o.Name } ).Skip(pageIndex * pageSize).Take(pageSize); result.total = total; result.data = customs; var json = JsonConvert.SerializeObject(result); return json; } }
public object Login(string UserName, string Password) { using (var db = new WeeklyEntities()) { //用户名密码检查 if (String.IsNullOrEmpty(UserName) || String.IsNullOrEmpty(Password)) return new { status = "error", message = "用户名或密码不能为空" }; //用户名密码验证 var q = from u in db.Emps select u; q = q.Where(p => p.LoginName == UserName); q = q.Where(p => p.Pwd == Password); var list = q.ToList(); if (list.Count == 0) return new { status = "error", message = "用户名或密码不正确!" }; //调用框架中的登陆机制 var loginer = new LoginerBase { UserID = list[0].Id, RoleId = list[0].RoleId == null ? 0 : (int)list[0].RoleId, LoginName = list[0].LoginName, Name = list[0].Name, OrganizationId = list[0].OrganizationId == null ? 0 : (int)list[0].OrganizationId, OrganizationName = list[0].Organization.Name }; var effectiveHours = ZConfig.GetConfigInt("LoginEffectiveHours"); FormsAuth.SignIn(loginer.LoginName, loginer, 60 * effectiveHours); LF.Utils.ZCookies.WriteCookies("UserID", 0, list[0].Id.ToString()); return new { status = "success", message = "登陆成功!", url = "/Home" }; } }