public Tuple <int, List <WorkFlowDo> > GetWorkFlowItem(WorkFlow model) { using (var dal = BaseInfo._container.Resolve <UnitOfWork>()) { var messageRepository = dal.GetRepository <WorkFlow>(); var conditions = ExpandHelper.True <WorkFlow>(); if (!string.IsNullOrEmpty(model.FlowName)) { conditions = conditions.And(a => a.FlowName.Contains(model.FlowName)); } var templist = messageRepository.Get(filter: conditions, includeProperties: "CuserInfo,forminfo,SortInfo,flowSteps").ProjectToQueryable <WorkFlowDo>(); var count = templist.Count(); if (model.order != null && model.order.Count() > 0) { foreach (var item in model.order) { var column = model.columns.ElementAt(int.Parse(item.column)); templist = templist.OrderSort(column.data, item.dir); } } var result = templist.PageBy(model.pageIndex, model.pageSize).ToList(); return(new Tuple <int, List <WorkFlowDo> >(count, result)); } }
public Tuple <int, List <Button> > GetButtonList(Button model) { using (UnitOfWork dal = BaseInfo._container.Resolve <UnitOfWork>()) { var buttonRepository = dal.GetRepository <Button>(); var conditions = ExpandHelper.True <Button>(); if (!string.IsNullOrEmpty(model.ButtonName)) { conditions = conditions.And(a => a.ButtonName.Contains(model.ButtonName)); } var templist = buttonRepository.Get(filter: conditions); var count = templist.Count(); if (model.order != null && model.order.Count() > 0) { foreach (var item in model.order) { var column = model.columns.ElementAt(int.Parse(item.column)); templist = templist.OrderSort(column.data, item.dir); } } var result = templist.PageBy(model.pageIndex, model.pageSize).ToList(); return(new Tuple <int, List <Button> >(count, result)); } }
public Tuple <int, List <FormInfo> > GetFormInfoItems(FormInfo model) { using (var dal = BaseInfo._container.Resolve <UnitOfWork>()) { var forminfo = dal.GetRepository <FormInfo>(); var conditions = ExpandHelper.True <FormInfo>(); if (!string.IsNullOrEmpty(model.FormName)) { conditions = conditions.And(a => a.FormName.Contains(model.FormName)); } var templist = forminfo.Get(filter: conditions, includeProperties: "elementPropertys"); var count = templist.Count(); if (model.order != null && model.order.Count() > 0) { foreach (var item in model.order) { var column = model.columns.ElementAt(int.Parse(item.column)); templist = templist.OrderSort(column.data, item.dir); } } var result = templist.PageBy(model.pageIndex, model.pageSize).ToList(); result.ForEach(a => { a.isConfiguration = a.elementPropertys.Count > 0 ? true : false; }); return(new Tuple <int, List <FormInfo> >(count, result)); } }
public Tuple <int, List <Role> > GetRoleList(Role model) { using (UnitOfWork dal = new UnitOfWork(new CoreDbContext())) { var conditions = ExpandHelper.True <Role>(); if (!string.IsNullOrEmpty(model.RoleName)) { conditions = conditions.And(a => a.RoleName.Contains(model.RoleName)); } var templist = dal.GetRepository <Role>().Get(filter: conditions, includeProperties: "MenuList.mbList"); var count = templist.Count(); if (model.order != null && model.order.Count() > 0) { foreach (var item in model.order) { var column = model.columns.ElementAt(int.Parse(item.column)); templist = templist.OrderSort(column.data, item.dir); } } var result = templist.PageBy(model.pageIndex, model.pageSize).ToList(); return(new Tuple <int, List <Role> >(count, result)); } }
public Tuple <int, List <News> > GetNewsList(News model) { using (var dal = new UnitOfWork(new CoreDbContext())){ var newsRepository = dal.GetRepository <News>(); var conditions = ExpandHelper.True <News>(); if (!string.IsNullOrEmpty(model.NewTitle)) { conditions = conditions.And(a => a.NewTitle.Contains(model.NewTitle)); } var templist = newsRepository.Get(filter: conditions); var count = templist.Count(); if (model.order != null && model.order.Count() > 0) { foreach (var item in model.order) { var column = model.columns.ElementAt(int.Parse(item.column)); templist = templist.OrderSort(column.data, item.dir); } } var result = templist.PageBy(model.pageIndex, model.pageSize).ToList(); return(new Tuple <int, List <News> >(count, result)); } }
public Tuple <int, List <LoginLog> > GetLoginlog(LoginLog model) { using (UnitOfWork dal = new UnitOfWork(new CoreDbContext())) { var loginRepository = dal.GetRepository <LoginLog>(); var conditions = ExpandHelper.True <LoginLog>(); if (!string.IsNullOrEmpty(model.LoginName)) { conditions = conditions.And(a => a.LoginName.Contains(model.LoginName)); } if (!string.IsNullOrEmpty(model.LoginNicker)) { conditions = conditions.And(a => a.LoginNicker.Contains(model.LoginNicker)); } var logmodel = loginRepository.Get(filter: conditions); var count = logmodel.Count(); if (model.order != null && model.order.Count() > 0) { foreach (var item in model.order) { var column = model.columns.ElementAt(int.Parse(item.column)); logmodel = logmodel.OrderSort(column.data, item.dir); } } var result = logmodel.PageBy(model.pageIndex, model.pageSize).ToList(); return(new Tuple <int, List <LoginLog> >(count, result)); } }
public Tuple <int, List <UserMappingMessage> > GetMessagebyUser(UserMappingMessage model) { using (var dal = BaseInfo._container.Resolve <UnitOfWork>()) { var um = dal.GetRepository <UserMappingMessage>(); var conditions = ExpandHelper.True <UserMappingMessage>().And(a => a.UserID == model.UserID); var templist = um.Get(filter: conditions, includeProperties: "MessageInfo"); var count = templist.Count(); if (model.order != null && model.order.Count() > 0) { foreach (var item in model.order) { var column = model.columns.ElementAt(int.Parse(item.column)); templist = templist.OrderSort(column.data, item.dir); } } var result = templist.PageBy(model.pageIndex, model.pageSize).ToList(); result.ForEach(a => { a.MessageInfo.SendUserInfo = new User() { UserName = dal.GetRepository <User>().Get(b => b.UserID == a.MessageInfo.SendUser).FirstOrDefault().UserReallyname }; }); return(new Tuple <int, List <UserMappingMessage> >(count, result)); } }
public List <dynamic> GetDictionaryByCategory(DictionaryCategory model) { using (UnitOfWork dal = BaseInfo._container.Resolve <UnitOfWork>()) { var conditions = ExpandHelper.True <DictionaryCategory>().And(a => a.Enabled == true); if (model.ID != 0) { conditions = conditions.And(a => a.ID == model.ID); } if (!string.IsNullOrEmpty(model.Category)) { conditions = conditions.And(a => a.Category == model.Category); } var dc = dal.GetRepository <DictionaryCategory>().Get(filter: conditions, includeProperties: "DicValueList").FirstOrDefault(); var diction = dc.DicValueList.Select(a => new { id = a.ID, text = a.DicValue }).ToList <dynamic>(); return(diction); } }
public Org GetSingle(Org model) { using (UnitOfWork dal = BaseInfo._container.Resolve <UnitOfWork>()) { var conditions = ExpandHelper.True <Org>(); if (!string.IsNullOrEmpty(model.OrgCode)) { conditions = conditions.And(a => a.OrgCode == model.OrgCode); } var result = dal.GetRepository <Org>().Get(conditions).FirstOrDefault(); return(result); } }
public Tuple <int, List <FlowApproveInfoDo> > GetFlowApproveInfo(FlowApprove model) { Mapper.Initialize(a => { a.CreateMap <FlowApprove, FlowApproveInfoDo>() .ForMember(de => de.FlowName, op => { op.MapFrom(s => s.FlowTaskInfo.WorkFlowInfo.FlowName); }) .ForMember(de => de.FormId, op => { op.MapFrom(s => s.FlowTaskInfo.FormId); }) .ForMember(de => de.FormInfoId, op => { op.MapFrom(s => s.FlowTaskInfo.FormInfoId); }) .ForMember(de => de.StartTime, op => { op.MapFrom(s => s.FlowTaskInfo.CreateTime); }) .ForMember(de => de.StartUserName, op => { op.MapFrom(s => s.FlowTaskInfo.Userinfo.UserReallyname); }) .ForMember(de => de.FlowStepName, op => { op.MapFrom(s => s.FlowStepInfo.name); }); }); using (var dal = BaseInfo._container.Resolve <UnitOfWork>()) { var messageRepository = dal.GetRepository <FlowApprove>(); var conditions = ExpandHelper.True <FlowApprove>().And(a => a.ApproveResult == 0); if (model.FlowInfoId > 0) { conditions = conditions.And(a => a.FlowInfoId == model.FlowInfoId); } if (!string.IsNullOrEmpty(model.ApproveUser)) { conditions = conditions.And(a => a.ApproveUser.StartsWith(model.ApproveUser + ",") || a.ApproveUser.Contains("," + model.ApproveUser + ",") || a.ApproveUser.EndsWith("," + model.ApproveUser) || a.ApproveUser == model.ApproveUser); } var templist = dal.GetRepository <FlowApprove>().Get(conditions, includeProperties: "FlowStepInfo,FlowTaskInfo,FlowTaskInfo.Userinfo,FlowTaskInfo.WorkFlowInfo").ProjectToQueryable <FlowApproveInfoDo>(); var count = templist.Count(); if (model.order != null && model.order.Count() > 0) { foreach (var item in model.order) { var column = model.columns.ElementAt(int.Parse(item.column)); templist = templist.OrderSort(column.data, item.dir); } } var result = templist.PageBy(model.pageIndex, model.pageSize).ToList(); return(new Tuple <int, List <FlowApproveInfoDo> >(count, result)); } }
public Tuple <int, List <FlowTaskDo> > GetFlowInfoBySelf(FlowInfo model) { Mapper.Initialize(a => { a.CreateMap <FlowInfo, FlowTaskDo>() .ForMember(de => de.FlowCategory, op => { op.MapFrom(s => s.WorkFlowInfo.SortInfo.DicValue); }) .ForMember(de => de.UserName, op => { op.MapFrom(s => s.Userinfo.UserReallyname); }) .ForMember(de => de.FlowName, op => { op.MapFrom(s => s.WorkFlowInfo.FlowName); }) .ForMember(de => de.FlowRemark, op => { op.MapFrom(s => s.WorkFlowInfo.remark); }); }); using (var dal = BaseInfo._container.Resolve <UnitOfWork>()) { var messageRepository = dal.GetRepository <FlowInfo>(); var conditions = ExpandHelper.True <FlowInfo>().And(a => a.UserId == model.UserId); if (model.FlowId > 0) { conditions = conditions.And(a => a.FlowId == model.FlowId); } if (model.UserId > 0) { conditions = conditions.And(a => a.UserId == model.UserId); } if (model.WorkFlowInfo != null) { conditions = conditions.And(a => a.WorkFlowInfo.FlowName.Contains(model.WorkFlowInfo.FlowName)); } var templist = dal.GetRepository <FlowInfo>().Get(conditions, includeProperties: "WorkFlowInfo,Userinfo,WorkFlowInfo.SortInfo").ProjectToQueryable <FlowTaskDo>(); var count = templist.Count(); if (model.order != null && model.order.Count() > 0) { foreach (var item in model.order) { var column = model.columns.ElementAt(int.Parse(item.column)); templist = templist.OrderSort(column.data, item.dir); } } var result = templist.PageBy(model.pageIndex, model.pageSize).ToList(); return(new Tuple <int, List <FlowTaskDo> >(count, result)); } }
public List <UserMappingMessage> GetMesByUser(int UserId, bool isAll) { using (var dal = BaseInfo._container.Resolve <UnitOfWork>()) { var userMesR = dal.GetRepository <UserMappingMessage>(); var conditions = ExpandHelper.True <UserMappingMessage>().And(a => a.UserID == UserId); if (!isAll) { conditions = conditions.And(a => a.IsRead == false); } return(userMesR.Get(conditions, includeProperties: "MessageInfo", orderBy: a => a.OrderByDescending(b => b.IsRead == true)) .ToList()); } }
public void DetectionMessage(int currentUserId) { using (var dal = BaseInfo._container.Resolve <UnitOfWork>()) { var messageR = dal.GetRepository <Message>(); var stringtoid = currentUserId.ToString(); var conditions = ExpandHelper.True <Message>().And(a => a.RecUser.StartsWith(stringtoid + ",") || a.RecUser.Contains("," + stringtoid + ",") || a.RecUser.EndsWith("," + stringtoid) || a.RecUser == stringtoid); var today = DateTime.Now; conditions = conditions.And(a => a.ExpirationTime == null || today <= a.ExpirationTime); var currentUserMessage = messageR.Get(conditions).Select(a => a.MessageID); if (currentUserMessage.Count() > 0) { var userMesR = dal.GetRepository <UserMappingMessage>(); var usermes = userMesR.Get(a => a.UserID == currentUserId).Select(a => a.MessageID); var list = currentUserMessage.ToList().Except(usermes.ToList()); if (list.Count() > 0) { var addUserMessage = new List <UserMappingMessage>(); Parallel.ForEach(list, (a => { var mes = new UserMappingMessage { MessageID = a, UserID = currentUserId, IsRead = false }; addUserMessage.Add(mes); })); userMesR.Insert(addUserMessage); dal.Save(); } } } }
public Tuple <int, List <MenuDo> > GetMenuList(Menu model) { Mapper.Initialize(a => { a.CreateMap <Menu, MenuDo>() .ForMember(de => de.MenuParentName, op => { op.MapFrom(s => s.Father.MenuName); }); }); using (UnitOfWork dal = BaseInfo._container.Resolve <UnitOfWork>()) { var menuRepository = dal.GetRepository <Menu>(); var conditions = ExpandHelper.True <Menu>(); if (!string.IsNullOrEmpty(model.MenuName)) { conditions = conditions.And(a => a.MenuName.Contains(model.MenuName)); } var templist = menuRepository.Get(filter: conditions, includeProperties: "mbList,Father").ProjectToQueryable <MenuDo>(); var count = templist.Count(); if (model.order != null && model.order.Count() > 0) { foreach (var item in model.order) { var column = model.columns.ElementAt(int.Parse(item.column)); templist = templist.OrderSort(column.data, item.dir); } } var result = templist.PageBy(model.pageIndex, model.pageSize).ToList(); //按钮排序 result.ForEach(m => { if (m.mbList.Count > 0) { m.mbList = m.mbList.OrderBy(a => a.OrderBy).ToList(); } }); return(new Tuple <int, List <MenuDo> >(count, result)); } }
public User GetSingle(User model) { using (UnitOfWork dal = BaseInfo._container.Resolve <UnitOfWork>()){ var conditions = ExpandHelper.True <User>(); if (!string.IsNullOrEmpty(model.UserName)) { conditions = conditions.And(a => a.UserName == model.UserName || a.MobilePhone == model.UserName); } if (!string.IsNullOrEmpty(model.MobilePhone)) { conditions = conditions.And(a => a.MobilePhone == model.MobilePhone); } var result = dal.GetRepository <User>().Get(conditions).FirstOrDefault(); return(result); } }
public Tuple <int, List <MessageDo> > GetMessageList(Message model) { Mapper.Initialize(a => { a.CreateMap <Message, MessageDo>() .ForMember(de => de.SendUserName, op => { op.MapFrom(s => s.SendUserInfo.UserReallyname); }); }); using (var dal = BaseInfo._container.Resolve <UnitOfWork>()) { var messageRepository = dal.GetRepository <Message>(); var conditions = ExpandHelper.True <Message>(); if (!string.IsNullOrEmpty(model.MessageTitle)) { conditions = conditions.And(a => a.MessageTitle.Contains(model.MessageTitle)); } if (model.SendTime != null) { // EntityFunctions.TruncateTime(model.SendTime); EF6.0之前的写法, conditions = conditions.And(a => DbFunctions.TruncateTime(a.SendTime) == DbFunctions.TruncateTime(model.SendTime)); } var templist = messageRepository.Get(filter: conditions, includeProperties: "SendUserInfo").ProjectToQueryable <MessageDo>(); var count = templist.Count(); if (model.order != null && model.order.Count() > 0) { foreach (var item in model.order) { var column = model.columns.ElementAt(int.Parse(item.column)); templist = templist.OrderSort(column.data, item.dir); } } var result = templist.PageBy(model.pageIndex, model.pageSize).ToList(); return(new Tuple <int, List <MessageDo> >(count, result)); } }
public Tuple <int, List <FlowTaskDo> > GetFlowInfoBySelf(FlowInfo model) { using (var dal = BaseInfo._container.Resolve <UnitOfWork>()) { var messageRepository = dal.GetRepository <FlowInfo>(); var conditions = ExpandHelper.True <FlowInfo>().And(a => a.UserId == model.UserId); if (model.FlowId > 0) { conditions = conditions.And(a => a.FlowId == model.FlowId); } if (model.UserId > 0) { conditions = conditions.And(a => a.UserId == model.UserId); } if (model.WorkFlowInfo != null) { conditions = conditions.And(a => a.WorkFlowInfo.FlowName.Contains(model.WorkFlowInfo.FlowName)); } var templist = dal.GetRepository <FlowInfo>().Get(conditions, includeProperties: "WorkFlowInfo,Userinfo,WorkFlowInfo.SortInfo").ProjectToQueryable <FlowTaskDo>(); var count = templist.Count(); if (model.order != null && model.order.Count() > 0) { foreach (var item in model.order) { var column = model.columns.ElementAt(int.Parse(item.column)); templist = templist.OrderSort(column.data, item.dir); } } var result = templist.PageBy(model.pageIndex, model.pageSize).ToList(); return(new Tuple <int, List <FlowTaskDo> >(count, result)); } }
public Tuple <int, List <User> > GetList(User model) { using (UnitOfWork dal = new UnitOfWork(ConnectDB.DataBase())) { var SysUserRepository = dal.GetRepository <User>(); var conditions = ExpandHelper.True <User>(); if (!string.IsNullOrEmpty(model.UserName)) { conditions = conditions.And(a => a.UserName.Contains(model.UserName)); } if (!string.IsNullOrEmpty(model.UserReallyname)) { conditions = conditions.And(a => a.UserReallyname.Contains(model.UserReallyname)); } if (model.DepartmentID > 0) { conditions = conditions.And(a => a.DepartmentID == model.DepartmentID); } var templist = SysUserRepository.Get(filter: conditions, includeProperties: "RoleList"); var count = templist.Count(); if (model.order != null && model.order.Count() > 0) { foreach (var item in model.order) { var column = model.columns.ElementAt(int.Parse(item.column)); templist = templist.OrderSort(column.data, item.dir); } } var result = templist.PageBy(model.pageIndex, model.pageSize).ToList(); return(new Tuple <int, List <User> >(count, result)); } }
public Tuple <int, List <WorkFlowDo> > GetWorkFlowItem(WorkFlow model) { Mapper.Initialize(a => { a.CreateMap <WorkFlow, WorkFlowDo>() .ForMember(de => de.CreateUserName, op => { op.MapFrom(s => s.CuserInfo.UserReallyname); }) .ForMember(de => de.FormName, op => { op.MapFrom(s => s.forminfo.FormName); }) .ForMember(de => de.IsPerfect, op => { op.MapFrom(s => s.flowSteps.Count > 0?true:false); }) .ForMember(de => de.FlowSortName, op => { op.MapFrom(s => s.SortInfo.DicValue); }); }); using (var dal = BaseInfo._container.Resolve <UnitOfWork>()) { var messageRepository = dal.GetRepository <WorkFlow>(); var conditions = ExpandHelper.True <WorkFlow>(); if (!string.IsNullOrEmpty(model.FlowName)) { conditions = conditions.And(a => a.FlowName.Contains(model.FlowName)); } var templist = messageRepository.Get(filter: conditions, includeProperties: "CuserInfo,forminfo,SortInfo,flowSteps").ProjectToQueryable <WorkFlowDo>(); var count = templist.Count(); if (model.order != null && model.order.Count() > 0) { foreach (var item in model.order) { var column = model.columns.ElementAt(int.Parse(item.column)); templist = templist.OrderSort(column.data, item.dir); } } var result = templist.PageBy(model.pageIndex, model.pageSize).ToList(); return(new Tuple <int, List <WorkFlowDo> >(count, result)); } }
public Tuple <int, List <FlowApproveDo> > GetFlowApproveSelf(FlowApprove model) { Mapper.Initialize(a => { a.CreateMap <FlowApprove, FlowApproveDo>() .ForMember(de => de.ApproveUserName, op => { op.MapFrom(s => s.ApproveUser); }) .ForMember(de => de.ReallyApproveUserName, op => { op.MapFrom(s => s.ReallyApproveUserInfo.UserReallyname); }) .ForMember(de => de.FlowStepName, op => { op.MapFrom(s => s.FlowStepInfo.name); }); }); using (var dal = BaseInfo._container.Resolve <UnitOfWork>()) { var messageRepository = dal.GetRepository <FlowApprove>(); var conditions = ExpandHelper.True <FlowApprove>(); if (model.FlowInfoId > 0) { conditions = conditions.And(a => a.FlowInfoId == model.FlowInfoId); } if (!string.IsNullOrEmpty(model.ApproveUser)) { conditions = conditions.And(a => a.ApproveUser.StartsWith(model.ApproveUser + ",") || a.ApproveUser.Contains("," + model.ApproveUser + ",") || a.ApproveUser.EndsWith("," + model.ApproveUser) || a.ApproveUser == model.ApproveUser); } var templist = dal.GetRepository <FlowApprove>().Get(conditions, includeProperties: "FlowStepInfo,FlowTaskInfo").ProjectToQueryable <FlowApproveDo>(); var count = templist.Count(); if (model.order != null && model.order.Count() > 0) { foreach (var item in model.order) { var column = model.columns.ElementAt(int.Parse(item.column)); templist = templist.OrderSort(column.data, item.dir); } } var result = templist.OrderBy(a => a.ApproveId).PageBy(model.pageIndex, model.pageSize).ToList(); result.ForEach(a => { var name = ""; if (a.ApproveUserName.Contains(',')) { var cc = a.ApproveUserName.Split(','); foreach (var item in cc) { var approveid = int.Parse(item); var usrmoel = dal.GetRepository <DDit.Core.Data.Entity.SystemEntity.User>().Get(b => b.UserID == approveid).FirstOrDefault(); name += usrmoel.UserReallyname + ","; } a.ApproveUserName = name.Substring(0, name.Length - 1); } else { var approveid = int.Parse(a.ApproveUserName); a.ApproveUserName = dal.GetRepository <DDit.Core.Data.Entity.SystemEntity.User>().Get(b => b.UserID == approveid).FirstOrDefault().UserReallyname; } }); return(new Tuple <int, List <FlowApproveDo> >(count, result)); } }