// GET: api/OrderDetailsExtended public async Task <IHttpActionResult> GetOrderDetailsExtended(int page = 0, int pageSize = 5) { int totalCount = 0; IList <OrderDetailsExtendedVm> listVm = new List <OrderDetailsExtendedVm>(); var result = Task.Factory.StartNew(() => { ICriteria criteria = new Criteria <BOOrderDetailsExtended>(OrderDetailsExtendedRepository); totalCount = criteria.Count(); IList <BOOrderDetailsExtended> listBOs = criteria .Add(new OrderBy("OrderID", OrderBy.OrderDirection.Ascending)) .Skip(page * pageSize) .Take(pageSize) .List <BOOrderDetailsExtended>(); foreach (var bo in listBOs) { listVm.Add(new OrderDetailsExtendedVm(bo)); } return(listVm); }); await result; return(Ok(new { Data = result.Result, Paging = new { Total = totalCount, Limit = pageSize, CurrentPage = page, PageCount = (int)Math.Ceiling((double)totalCount / pageSize) } })); }
static void Main(string[] args) { ICriteria criteria = new Criteria <BOProducts>(ProductsRepository); var totalCount = criteria.Count(); var page = 0; var pageSize = 100; IList <BOProducts> listBOs = criteria .Add(new OrderBy("supplier_ids", OrderBy.OrderDirection.Ascending)) .Skip(page * pageSize) .Take(pageSize) .List <BOProducts>(); }
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 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 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 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; } return JsonMessage(200, "验证成功,请稍候...", url); } }
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); } }
//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); }
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 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); } }
private string LoginUser() { AuthenticationResponse _AuthenticationResponse = new AuthenticationResponse { Result = false }; try { string m_LoginName = string.Empty; string m_Password = string.Empty; bool m_IsRemember = false; if (Request.Form["EmailAddress"] != null && Request.Form["IsFB"] != null) { string _UserEmail = Request.Form["EmailAddress"].ToString(); User _ThisUser = new User().GetUserDetails(_UserEmail, true); m_LoginName = _ThisUser.LoginName; m_Password = _ThisUser.Password; m_IsRemember = false; } else { m_LoginName = Request.Form["LoginName"].ToString(); m_Password = Request.Form["Password"].ToString(); m_IsRemember = Convert.ToBoolean(Request.Form["IsRemember"].ToString()); } bool IsEmailLogin = IsValidEmail(m_LoginName); User m_UserDetails; if (IsEmailLogin) { m_UserDetails = new User().AuthenticateUserWithEmail(m_LoginName, m_Password); } else { m_UserDetails = new User().AuthenticateUser(m_LoginName, m_Password); } if (m_UserDetails != null) { string ACCOUNT_STATUS = new UserAccountSettings().GetUserAccountSettings(m_UserDetails.UserID).AccoutStatus; if (ACCOUNT_STATUS.ToUpper() == "A") { if (!m_IsRemember) { FormsAuthentication.RedirectFromLoginPage(m_UserDetails.UserID.ToString(), false); if (m_UserDetails.Status == "A") { // Check if any unanswered Criteria questions Criteria[] _UnAnsweredCriteriaQuestions = new Criteria().GetUnAnsweredQuestions(m_UserDetails.UserID); _AuthenticationResponse.Result = true; if (_UnAnsweredCriteriaQuestions.Count() == 0) { _AuthenticationResponse.RedirectPath = "Web/Home"; } else { _AuthenticationResponse.RedirectPath = "Web/Criteria"; } } if (m_UserDetails.Status == "P") { _AuthenticationResponse.RedirectPath = "Web/Criteria"; } if (m_UserDetails.Status == "I") { _AuthenticationResponse.RedirectPath = "Delete"; } } else { FormsAuthentication.SetAuthCookie(m_UserDetails.UserID.ToString(), true); FormsAuthenticationTicket intellidateTicket = new FormsAuthenticationTicket(1, m_UserDetails.UserID.ToString(), DateTime.Now, DateTime.Now.AddDays(30), true, ""); HttpCookie intellidateCookie = new HttpCookie(FormsAuthentication.FormsCookieName, FormsAuthentication.Encrypt(intellidateTicket)); Response.Cookies.Add(intellidateCookie); _AuthenticationResponse.Result = true; if (m_UserDetails.Status == "A") { // Check if any unanswered Criteria questions Criteria[] _UnAnsweredCriteriaQuestions = new Criteria().GetUnAnsweredQuestions(m_UserDetails.UserID); if (_UnAnsweredCriteriaQuestions.Count() == 0) { _AuthenticationResponse.RedirectPath = "Web/Home"; } else { _AuthenticationResponse.RedirectPath = "Web/Criteria"; } } if (m_UserDetails.Status == "P") { _AuthenticationResponse.RedirectPath = "Web/Criteria"; } if (m_UserDetails.Status == "I") { _AuthenticationResponse.RedirectPath = "Delete"; } } } else if (ACCOUNT_STATUS.ToUpper() == "I") { FormsAuthentication.SetAuthCookie(m_UserDetails.UserID.ToString(), true); FormsAuthenticationTicket intellidateTicket = new FormsAuthenticationTicket(1, m_UserDetails.UserID.ToString(), DateTime.Now, DateTime.Now.AddDays(30), true, ""); HttpCookie intellidateCookie = new HttpCookie(FormsAuthentication.FormsCookieName, FormsAuthentication.Encrypt(intellidateTicket)); Response.Cookies.Add(intellidateCookie); _AuthenticationResponse.Result = true; _AuthenticationResponse.RedirectPath = "Web/ActivateAccount"; } else if (ACCOUNT_STATUS.ToUpper() == "D") { _AuthenticationResponse.Result = false; _AuthenticationResponse.RedirectPath = null; } } } catch (Exception ex) { IntellidateR1.Error.LogError(ex, "Login LoginUser"); _AuthenticationResponse.Result = false; } return(JsonConvert.SerializeObject(_AuthenticationResponse)); }
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); } }