本文整理汇总了C#中Criteria.Count方法的典型用法代码示例。如果您正苦于以下问题:C# Criteria.Count方法的具体用法?C# Criteria.Count怎么用?C# Criteria.Count使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Criteria
的用法示例。
在下文中一共展示了Criteria.Count方法的13个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: QuickSearch
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);
}
}
示例2: QuickSearch
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);
}
}
示例3: QuickSearch
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);
}
}
示例4: QuickSearch
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);
}
}
示例5: User
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);
}
}
示例6: QuickSearch
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);
}
}
示例7: Login
public ActionResult Login(FormCollection collection)
{
Reset();
var key = collection["key"];
if (!string.IsNullOrEmpty(key))
{
return UkeyLogin(key);
}
var name = collection["username"];
var pwd = collection["password"];
ViewData["username"] = name;
Session[Const.CurrentAccountName] = name;
if (string.IsNullOrEmpty(name))
{
return JsonMessage(100, "请输入用户名!");
}
if (string.IsNullOrEmpty(pwd))
{
return JsonMessage(100, "请输入密码!");
}
using (var session = new SessionFactory().OpenSession())
{
var q = new Criteria<Account>(session)
.AndIn<User>(m => m.Name, n => n.Code, n => n.Name.Equals(name) || n.Code.Equals(name))
.Limit(2);
var uc = q.Count(true);
if (uc == 0)
{
FlashFailureAndLog("用户名或者密码不正确", name);
return JsonMessage(100, "用户名或者密码不正确,请重新输入!");
}
if (uc > 1)
{
FlashFailureAndLog("用户身份不唯一", name);
return JsonMessage(100, "用户身份不唯一,请联系管理员解决!");
}
var account = q.Load();
if (account == null)
{
FlashFailureAndLog("读取用户数据失败", name);
return JsonMessage(100, "读取用户数据失败,请联系管理员解决!");
}
// 禁用的用户
if (account.Status == -1)
{
FlashFailureAndLog("你的账户已经被禁用,请联系系统管理员!");
return JsonMessage(100, "你的账户已经被禁用,请联系管理员解决!");
}
// 未初始化的用户,使用验证码登录
if (account.Status == 0)
{
if (!pwd.Equals(account.Flag))
{
FlashFailureAndLog("验证码不正确,请重新输入!");
return JsonMessage(100, "验证码不正确,请重新输入!");
}
Session[Const.CurrentAccountId] = account.Id;
Session[Const.CurrentAccountName] = name;
FormsAuthentication.SetAuthCookie(account.Name, false);
var resetPasswordUrl = "/base/profile/resetpassword?ReturnUrl=" + Request.Params["ReturnUrl"];
WriteSuccessLog("初次登录,账户初始化!");
return JsonMessage(200, "账户初始化,请稍候...", resetPasswordUrl);
}
// 已经初始化的用户,使用密码登录
if (!account.AuthPassword(pwd))
{
FlashFailureAndLog("用户名密码验证不正确,请重新输入!");
return JsonMessage(100, "用户名密码验证不正确,请重新输入!");
}
Session[Const.CurrentAccountId] = account.Id;
Session[Const.CurrentAccountName] = name;
FormsAuthentication.SetAuthCookie(account.Name, true);
account.LastLoginAt = DateTime.Now;
account.LoginCount++;
if (!session.Update(account))
{
FlashFailureAndLog("更新用户登录记录出错!");
return JsonMessage(100, "更新用户登录记录出错,请联系管理员解决!");
}
WriteSuccessLog("登录", account);
var url = Request.Params["ReturnUrl"];
if (string.IsNullOrEmpty(url))
{
url = FormsAuthentication.DefaultUrl;
//.........这里部分代码省略.........
示例8: QuickSearch
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);
}
}
示例9: AddRole
//public bool AddOrganization(Organization organization)
//{
// if (organization == null || organization.Id <= 0) return false;
// if (Id <= 0) return false;
// var q = new Criteria<AccountOrganizationRef>().Where(m => m.AccountId.Equals(Id) && m.OrganizationId.Equals(organization.Id));
// if (q.Count() > 0) return true;
// var r = new AccountOrganizationRef { AccountId = Id, OrganizationId = organization.Id };
// var db = new SessionFactory().OpenSession();
// return db.Create(r);
//}
public bool AddRole(Role role)
{
if (role == null || role.Id <= 0) return false;
if (Id <= 0) return false;
Criteria<AccountRoleRef> q =
new Criteria<AccountRoleRef>().Where(m => m.AccountId.Equals(Id) && m.RoleId.Equals(role.Id));
if (q.Count() > 0) return true;
Session db = new SessionFactory().OpenSession();
var r = new AccountRoleRef { AccountId = Id, RoleId = role.Id };
return db.Create(r);
}
示例10: QuickSearch
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);
}
}
示例11: QuickSearch
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);
}
}
示例12: QuickSearch
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);
}
}
示例13: QuickSearch
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);
}
}