public static SelectList AllOrganizationList()
{
var q = new Criteria<Organization>();
var d = q.Find();
d.Insert(0, new Organization { Id = 0, Name = "全部" });
return new SelectList(d, "Id", "Name");
}
public static SelectList AllSchoolSectionList()
{
var q = new Criteria<Department>();
q.And(m => m.Type.Equals(DeparmentTypeList.Section));
var d = q.Find();
d.Insert(0, new Department { Id = 0, Name = "全部" });
return new SelectList(d, "Id", "Name");
}
/// <summary>
/// 读取滚动公告
/// </summary>
/// <returns></returns>
public static IList<Notice> GetScrollNotices()
{
using (var session = new SessionFactory().OpenSession())
{
var today = DateTime.Today;
var q = new Criteria<Notice>(session).Where(m => m.StopAt >= today);
return q.Find();
}
}
public static SelectList ClassStudentList(long id)
{
var q = new Criteria<SchoolStudent>().Where(m => m.ClassId.Equals(id)).Asc(m => m.StudentNo);
var d = q.Find();
foreach (var x in d)
{
x.StudentName = "[" + x.StudentNo + "]" + x.StudentName;
}
return new SelectList(d, "StudentNo", "StudentName");
}
public static SelectList DepartmentList()
{
var q = new Criteria<SchoolDepartment>();
var d = q.Find();
foreach (var item in d)
{
item.Name = string.Format("{0} [{1}]", item.Name, item.ShortName);
}
d.Insert(0, new SchoolDepartment { Id = 0, Name = "无" });
return new SelectList(d, "Id", "Name");
}
public ActionResult QuickSearch(FormCollection collection, uint pagesize = DefaultPageSize, uint pageno = 1)
{
var keyword = GetDbQueryPara();
using (var session = new SessionFactory().OpenSession())
{
var q = new Criteria<TrainManagement>(session)
.Page(pagesize, pageno)
.Asc(m => m.Id)
.AddOrder(collection, ViewData)
//.AndUnless(string.IsNullOrEmpty(keyword), m => m.Name.Include(keyword))
;
var models = q.Find().PartPage(pageno, pagesize, q.Count());
return View(models);
}
}
public ActionResult QuickSearch(FormCollection collection, uint pagesize = DefaultPageSize, uint pageno = 1)
{
using (var session = new SessionFactory().OpenSession())
{
var q = new Criteria<ActionLog>(session).Page(pagesize, pageno)
.Asc(m => m.CreatedAt).AddOrder(collection, ViewData);
if (collection != null)
{
if (collection.AllKeys.Contains("starttime"))
{
var dtStr = (collection["starttime"] + string.Empty).Trim();
if (!string.IsNullOrEmpty(dtStr))
{
DateTime startAt;
if (DateTime.TryParse(dtStr, out startAt))
{
q.And(m => m.CreatedAt >= startAt);
}
}
}
if (collection.AllKeys.Contains("endtime"))
{
var dtStr = (collection["endtime"] + string.Empty).Trim();
if (!string.IsNullOrEmpty(dtStr))
{
DateTime endAt;
if (DateTime.TryParse(dtStr, out endAt))
{
q.And(m => m.CreatedAt <= endAt);
}
}
}
if (collection.AllKeys.Contains("keywords"))
{
var keywords = (collection["keywords"] + string.Empty).Trim();
if (!string.IsNullOrEmpty(keywords))
{
q.And(m => m.Actor.Include(keywords), m => m.Category.Include(keywords),
m => m.Title.Include(keywords), m => m.Description.Include(keywords),
m => m.Result.Include(keywords));
}
}
}
var models = q.Find().PartPage(pageno, pagesize, q.Count());
return View(models);
}
}
public ActionResult QuickSearch(FormCollection collection, long id = 0, uint pagesize = DefaultPageSize, uint pageno = 1)
{
var keyword = GetDbQueryPara();
using (var session = new SessionFactory().OpenSession())
{
var q = new Criteria<TrainExperienceView>(session)
.Page(pagesize, pageno)
.Asc(m => m.Id)
.AddOrder(collection, ViewData)
.And(m => m.Status.Equals(TrainExperienceConst.已提交培训管理部门), m => m.Status.Equals(TrainExperienceConst.已提交领导))
.And(m => m.TrainManId.Equals(id))
.AndUnless(string.IsNullOrEmpty(keyword), m => m.Year.Equals(keyword), m => m.Dept.Include(keyword), m => m.StaffName.Include(keyword))
;
var models = q.Find().PartPage(pageno, pagesize, q.Count());
return View(models);
}
}
public ActionResult QuickSearch(FormCollection collection, uint pagesize = DefaultPageSize, uint pageno = 1)
{
var keywords = GetDbQueryPara();
using (var session = new SessionFactory().OpenSession())
{
var q = new Criteria<StandardFile>(session).Page(pagesize, pageno).Asc(m => m.Id).AddOrder(collection, ViewData)
.And(m => m.State.Equals(StandardFileStateConst.已发布))
.AndUnless(string.IsNullOrEmpty(keywords),
m => m.OriginName.Include(keywords),
m => m.FileType.Include(keywords),
m => m.Creator.Include(keywords),
m => m.Description.Include(keywords),
m => m.Memo.Include(keywords),
m => m.State.Include(keywords),
m => m.ApproveState.Include(keywords));
var models = q.Find().PartPage(pageno, pagesize, q.Count());
return View(models);
}
}
public ActionResult GetManItem(FormCollection collection)
{
var q = new Criteria<TrainManagementItem>()
.And(m => m.StaffCode.Equals(CurrentAccountNo))
.Desc(m => m.Year);
var model = q.Find();
return JsonData(new SelectList(model, "TrainManName", "Id"));
}
public static SelectList UserList()
{
var q = new Criteria<User>();
var d = q.Find();
return new SelectList(d, "Name", "Realname");
}
public static SelectList TeacherList()
{
var q = new Criteria<User>();
var d = q.Find();
foreach (User x in d)
{
x.Name = x.Code + "|" + x.Realname;
}
d.Insert(0, new User { Id = 0, Name = "无" });
return new SelectList(d, "Name", "Name");
}
public ActionResult Pintask(long[] ids)
{
if (ids.Length == 0)
{
FlashInfo("请选择要查看用户的角色。");
return Close();
}
using (var session = new SessionFactory().OpenSession())
{
var roles = session.Find<Role>(m => m.Id.In(ids));
if (roles == null || roles.Count == 0)
{
FlashInfo("请选择要查看用户的角色。");
return Close();
}
ViewData["roleName"] = string.Join(",", roles.Select(m => m.Name));
var q = new Criteria<Navigation>().Select(m => m.Id).AndIn<AccountNavigationRef>(x => x.Id, y => y.NavigationId,
p => p.Type.Equals(AccountNavigationRef.RoleType) && p.OwnerId.In(ids));
ViewData["selectedIds"] = q.PropertieValues<long>();
var q2 = new Criteria<Navigation>().AndIn<NavigationPriviledge>(m => m.Id, n => n.NavigationId,
n => n.Flag.Equals(NavigationPriviledge.RoleType) && n.OwnerId.In(ids))
.And(p => p.Type.Equals(NavigationType.Module));
var model = q2.Find().ToOrderList();
return View(model);
}
}
public String RoleName()
{
if (IsSystem) return "系统管理员";
var q = new Criteria<AccountRoleRef>().Where(m => m.AccountId.Equals(Id));
var refs = q.Find();
if (refs.Count == 0) return "无角色";
var db = new SessionFactory().OpenSession();
var ids = refs.Select(m => m.RoleId).ToArray();
var roles = db.Find<Role>(m => m.Id.In(ids));
return roles.Count == 0 ? "无角色" : string.Join(", ", roles.Select(m => m.Name));
}
public ActionResult QuickSearch(FormCollection collection, uint pagesize = DefaultPageSize, uint pageno = 1)
{
var keywords = GetDbQueryPara();
using (var session = new SessionFactory().OpenSession())
{
var q = new Criteria<Dossier>(session)
.Page(pagesize, pageno)
.Asc(m => m.Id)
.AddOrder(collection, ViewData)
.AndUnless(string.IsNullOrEmpty(keywords), m => m.Name.Include(keywords),
m => m.ContractNo.Include(keywords),
m => m.Undertaker.Include(keywords),
m => m.Type.Include(keywords),
m => m.State.Include(keywords),
m => m.ApproveState.Include(keywords))
;
var models = q.Find().PartPage(pageno, pagesize, q.Count());
return View(models);
}
}
public static SelectList UserIdList()
{
var q = new Criteria<User>();
var d = q.Find();
d.Insert(0, new User { Id = 0, Name = "无" });
return new SelectList(d, "Id", "Realname");
}
public ActionResult QuickSearch(FormCollection collection, uint pagesize = DefaultPageSize, uint pageno = 1)
{
var keywords = GetDbQueryPara();
using (var session = new SessionFactory().OpenSession())
{
var q = new Criteria<Contract>(session)
.And(m => m.State.Equals(ContractStateConst.审计部门审核))
.Page(pagesize, pageno)
.Asc(m => m.Id)
.AddOrder(collection, ViewData)
.AndUnless(string.IsNullOrEmpty(keywords),
m => m.Name.Contains(keywords));
var models = q.Find().PartPage(pageno, pagesize, q.Count());
return View(models);
}
}
public ActionResult QuickSearch(FormCollection collection, uint pagesize = DefaultPageSize, uint pageno = 1)
{
var keyword = GetDbQueryPara();
using (var session = new SessionFactory().OpenSession())
{
var q = new Criteria<TrainNeed>(session)
.Page(pagesize, pageno)
.Asc(m => m.Id)
.AddOrder(collection, ViewData)
//加过滤，只显示自己的需求
.And(m => m.StaffCode.Equals(CurrentAccountNo))
.And(m => m.Type.Equals(TrainNeedType.员工))
//.AndUnless(string.IsNullOrEmpty(keyword), m => m.Name.Include(keyword))
;
var models = q.Find().PartPage(pageno, pagesize, q.Count());
return View(models);
}
}
public ActionResult GetTrainManName(FormCollection collection)
{
var q = new Criteria<TrainManagement>().Desc(m => m.Name);
var model = q.Find();
return JsonData(new SelectList(model, "Name", "Id"));
}
public ActionResult GetUserName(FormCollection collection)
{
var q = new Criteria<User>().Desc(m => m.Name);
var model = q.Find();
return JsonData(new SelectList(model, "RealName", "Code"));
}
public ActionResult QuickSearch(FormCollection collection, uint pagesize = DefaultPageSize, uint pageno = 1)
{
var keyword = GetDbQueryPara();
using (var session = new SessionFactory().OpenSession())
{
var dept = new Criteria<Department>(session)
.AndIn<User>(m => m.Id, n => n.DepartmentId, m => m.Code.Equals(CurrentAccountNo)).Load();
var q = new Criteria<TrainNeed>(session)
.Page(pagesize, pageno)
.Asc(m => m.Id)
.AddOrder(collection, ViewData)
.AndIf(dept != null && dept.Id != 0, m => m.DeptId.Equals(dept.Id))
.And(m => (m.Type.Equals(TrainNeedType.员工) && m.Status.Equals(TrainNeedStatus.已提交部门负责人)) || m.Type.Equals(TrainNeedType.部门))
//.AndUnless(string.IsNullOrEmpty(keyword), m => m.Name.Include(keyword))
;
var models = q.Find().PartPage(pageno, pagesize, q.Count());
return View(models);
}
}
/// <summary>
/// 组织机构列表
/// </summary>
/// <param name="mode"></param>
/// <returns></returns>
public static SelectList OrganizationList(SelectMode mode = SelectMode.Default)
{
var q = new Criteria<Organization>();
var d = q.Find();
return SelectList(d, "Id", "Name", mode);
}
public IList<Role> GetRoles()
{
var q = new Criteria<AccountRoleRef>().Where(m => m.AccountId.Equals(Id));
var refs = q.Find();
if (refs.Count == 0) return new List<Role>();
var db = new SessionFactory().OpenSession();
var ids = refs.Select(m => m.RoleId).ToArray();
var roles = db.Find<Role>(m => m.Id.In(ids));
return roles;
}
/// <summary>
/// 角色列表
/// </summary>
/// <param name="mode"></param>
/// <returns></returns>
public static SelectList RoleList(SelectMode mode = SelectMode.Default)
{
var q = new Criteria<Role>();
var d = q.Find();
return SelectList(d, "Id", "Name", mode);
}
public ActionResult QuickSearch(FormCollection collection, uint pagesize = DefaultPageSize, uint pageno = 1)
{
using (var session = new SessionFactory().OpenSession())
{
var q = new Criteria<School>(session).Page(pagesize, pageno).Asc(m => m.Id).AddOrder(collection, ViewData);
if (collection != null && collection.AllKeys.Contains("keywords"))
{
var keywords = (collection["keywords"] + string.Empty).Trim();
if (!string.IsNullOrEmpty(keywords))
{
q.And(m => m.Name.Include(keywords), m => m.Address.Include(keywords), m => m.LeaderName.Include(keywords));
}
}
var models = q.Find().PartPage(pageno, pagesize, q.Count());
return View(models);
}
}
/// <summary>
/// 选择校区
/// </summary>
/// <returns></returns>
public static SelectList SchoolSectionList(SelectMode mode = SelectMode.Default)
{
var q = new Criteria<Department>();
q.And(m => m.Type.Equals(DeparmentTypeList.Section));
var d = q.Find();
return SelectList(d, "Id", "Name", mode);
}
public ActionResult QuickSearch(FormCollection collection, long id = 0, uint pagesize = DefaultPageSize, uint pageno = 1)
{
using (var session = new SessionFactory().OpenSession())
{
var q = new Criteria<PunishmentDossierFiles>(session).Page(pagesize, pageno).Asc(m => m.Id).AddOrder(collection, ViewData);
q.And(m => m.ParentId == id);
if (collection != null && collection.AllKeys.Contains("keywords"))
{
var keywords = (collection["keywords"] + string.Empty).Trim();
if (!string.IsNullOrEmpty(keywords))
{
}
}
var models = q.Find().PartPage(pageno, pagesize, q.Count());
return View(models);
}
}
public static SelectList UserIdList()
{
var q = new Criteria<User>();
var d = q.Find();
d.Insert(0, new User { Id = 0, Name = "无" });
return new SelectList(d.Select(m => new { ID = m.Id, Realname = "[" + m.Code + "]" + m.Realname }), "Id", "Realname");
}
public new ActionResult User(long[] ids)
{
if (ids.Length == 0)
{
FlashInfo("请选择要查看用户的角色。");
return Close();
}
using (var session = new SessionFactory().OpenSession())
{
var role = session.Load<Role>(m => m.Id.In(ids));
if (role == null)
{
FlashInfo("请选择要查看用户的角色。");
return Close();
}
ViewData["roleName"] = role.Name;
ViewData["roleDeptName"] = role.Department == null ? string.Empty : role.Department.Name;
var q = new Criteria<FullUser>().Select(m => m.Id)
.AndIn<Account>(x => x.Code, y => y.Name, new Criteria<Account>().AndIn<AccountRoleRef>(m => m.Id, n => n.AccountId, n => n.RoleId.In(ids)));
if (q.Count() == 0)
{
FlashInfo("该角色没有分配给任何用户。");
}
ViewData["selectedIds"] = q.PropertieValues<long>();
q.Reset();
//q.Reset().AndIn<Role>(m => m.DepartmentId, n => n.DepartmentId, n => n.Id.In(ids));
var model = q.Find();
return View(model);
}
}
public static SelectList RoleList()
{
var q = new Criteria<Role>();
var d = q.Find();
d.Insert(0, new Role { Id = 0, Name = "无" });
return new SelectList(d, "Id", "Name");
}
