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));
}
}
