public ActionResult GetUserInfo() { using (var db = new EFWorkContext()) { var d = db.User.Include(a => a.UserRole.Role); UserListModelView ul = new UserListModelView(); foreach (var item in d) { UserModelView u = new UserModelView(); u.Id = item.Id; u.Name = item.Name; if (item.UserRole != null) { u.RoleId = item.UserRole.RoleId; u.RoleName = item.UserRole.Role.Name; u.IsAdmin = item.UserRole.Role.IsAdmin; } else { } ul.Users.Add(u); } return(Json(ul, JsonRequestBehavior.AllowGet)); } }
public async Task <ActionResult> GetAllMenu(int role, int pageNo = 1, int pageSize = 5) { using (var db = new EFWorkContext()) { //var d = from m in db.Project where m.ParentId == null && m.RoleProject.Any(a => a.RoleId == role) select m; var d = db.Menu.Where(a => a.Parent == null && a.Roles.Any(b => b.Id == role)); int dataCount = d.Count(); //var p = await d.OrderBy(a => a.Id).Skip((pageNo - 1) * pageSize).Take(pageSize).ToListAsync(); //var orderExpression = string.Format("{0} {1}", sortName, sortType); //sortName排序的名称 sortType排序类型 (desc asc) var orderExpression = string.Format("{0} {1}", "id", "desc"); //sortName排序的名称 sortType排序类型 (desc asc) var p = await d.OrderBy(orderExpression).Skip((pageNo - 1) * pageSize).Take(pageSize).ToListAsync(); ProjectResponse pr = new ProjectResponse(); pr.PageNo = pageNo; pr.PageSize = pageSize; pr.DataCount = dataCount; pr.PageCount = (int)Math.Ceiling((decimal)dataCount / pageSize); foreach (var item in p) { pr.Projects.Add(new Project() { Id = item.Id, Name = item.Name, ParentId = item.ParentId }); } return(Json(pr, JsonRequestBehavior.AllowGet)); } }
public IEnumerable <DeviceTypeTemplateModel> GetDeviceTypeTemplate(int typeId, string token) { using (var db = new EFWorkContext()) { var deviceTemp = db.DeviceTypeTemplate.Where(a => a.TypeId == typeId && a.Token == token).ToList(); return(deviceTemp); } }
public IEnumerable <DeviceTypeModel> GetDeviceType() { using (var db = new EFWorkContext()) { var DeviceType = db.DeviceType.ToList(); return(DeviceType); } }
public void AddGroup(GroupModel entity) { using (var db = new EFWorkContext()) { db.Group.Add(entity); db.SaveChanges(); } }
public IEnumerable <GroupModel> GetGroup(int pageNo, int pageSize, out int pageCount) { using (var db = new EFWorkContext()) { var group = db.Group; pageCount = group.Count(); pageCount = (int)Math.Ceiling((decimal)pageCount / pageSize); var d = group.OrderBy(a => a.Name).Skip((pageNo - 1) * pageSize).Take(pageSize).ToList(); return(d); } }
public async Task <IEnumerable <Controllers.Dev> > GetDevice(string order, int pageSize = 5, int currentPage = 1) { using (var db = new EFWorkContext()) { var data = db.Device.Include(a => a.DeviceType).Include(a => a.DeviceData).Select(a => new Controllers.Dev { DeviceId = a.DeviceId, DeviceName = a.DeviceName, DeviceTypeName = a.DeviceType.Name, Dt = a.DeviceData == null ? default(DateTime): a.DeviceData.Dt, Message = a.DeviceData == null ? "" : a.DeviceData.Message }); int count = data.Count(); Console.WriteLine(data.ToString()); var d = await data.OrderBy(order).Skip((currentPage - 1) * pageSize).Take(pageSize).ToListAsync(); return(d); } }
public async Task <ActionResult> AddOrUpdate(DeviceDataModel d) { using (var db = new EFWorkContext()) { var dd = await db.DeviceData.AsNoTracking().Where(a => a.Name == d.Name).FirstOrDefaultAsync();//.FirstOrDefault(); if (dd == null) { dd = db.DeviceData.Add(d); } else { dd.Message = d.Message; dd.Dt = DateTime.Now; db.Entry <DeviceDataModel>(dd).State = EntityState.Modified; } db.SaveChanges(); return(Json(new { dd.DeviceId })); } }
public ActionResult GetAllTopProject(int pageNo = 1, int pageSize = 5) { using (var db = new EFWorkContext()) { var d = db.Project.Where(a => a.ParentId == null); int dataCount = d.Count(); var m = d.OrderBy(a => a.Id).Skip((pageNo - 1) * pageSize).Take(pageSize); ProjectResponse pr = new ProjectResponse(); pr.PageNo = pageNo; pr.PageSize = pageSize; pr.DataCount = dataCount; pr.PageCount = (int)Math.Ceiling((decimal)dataCount / pageSize); foreach (var item in m) { pr.Projects.Add(new Project() { Id = item.Id, Name = item.Name, ParentId = item.ParentId }); } return(Json(pr, JsonRequestBehavior.AllowGet)); } }
public EFRepositoryBase(string connectionString) { if (connectionString == "appdb") { this.ConnectionString = EFWorkContext.appdb; } else if (connectionString == "default") { this.ConnectionString = EFWorkContext.inetsnell; } else if (connectionString == "inetapp") { this.ConnectionString = EFWorkContext.inetapp; } else if (connectionString == "ep_snell") { this.ConnectionString = EFWorkContext.ep_snell; } else if (connectionString == "gpsps") { this.ConnectionString = EFWorkContext.gpsps; } }
public async Task <ActionResult> GetAllProject(int role, int pageNo = 1, int pageSize = 5) { using (var db = new EFWorkContext()) { //var d = from m in db.Project where m.ParentId == null && m.RoleProject.Any(a => a.RoleId == role) select m; var d = db.Project.Where(a => a.Parent == null && a.RoleProject.Any(b => b.RoleId == role)); int dataCount = d.Count(); var p = await d.OrderBy(a => a.Id).Skip((pageNo - 1) * pageSize).Take(pageSize).ToListAsync(); ProjectResponse pr = new ProjectResponse(); pr.PageNo = pageNo; pr.PageSize = pageSize; pr.DataCount = dataCount; pr.PageCount = (int)Math.Ceiling((decimal)dataCount / pageSize); foreach (var item in p) { pr.Projects.Add(new Project() { Id = item.Id, Name = item.Name, ParentId = item.ParentId }); } return(Json(pr, JsonRequestBehavior.AllowGet)); } }