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 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"); }
public void Process() { // (A = 5 AND ((A > 4 OR A < 5) AND (B <> 7 OR C IS NOT NULL)) AND S LIKE 'qwert' OR S NOT LIKE 'qwerty' AND A <= 9 AND Q >= 8) Criteria criteria = new Criteria("A", Clause.Eq, 5); Criteria criteria1 = new Criteria("A", Clause.Grate, 4).Or("A", Clause.Less, 5); Criteria criteria2 = new Criteria(LogicalOperator.And, "B", Clause.NotEq, 7).Or("C", Clause.IsNotNull); criteria.And(new Criteria(criteria1, criteria2)); criteria.And("S", Clause.Like, "qwert"); criteria.Or("S", Clause.NotLike, "qwerty"); criteria.And("A", Clause.NotGrate, 9).And("Q", Clause.NotLess, 8); criteria.And("E", Clause.NotIn, new[] { 1, 2, 3 }); StringCriteriaHandler criteriaHandler = new StringCriteriaHandler(ToStringConverter.Instance); criteria.Process(criteriaHandler); const string EXPECTED = "(A = 5 AND ((A > 4 OR A < 5) AND (B <> 7 OR C IS NOT NULL)) AND S LIKE 'qwert' OR S NOT LIKE 'qwerty' AND A <= 9 AND Q >= 8 AND E NOT IN (1, 2, 3))"; string actual = criteriaHandler.Expression; Assert.AreEqual(EXPECTED, actual); }
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 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); } }
protected void btnRegister_Click(object sender, EventArgs e) { mvMessage.CheckRequired(txtUserName, "Tên Người Dùng(User Name): Mục Bắt Buộc"); mvMessage.CheckRequired(txtFullName, "Họ Tên: ): Mục Bắt Buộc"); //mvMessage.CheckRequired(txtEmail, "Emailを正しく入力してください。"); if (!mvMessage.IsValid) return; if (btnRegister.CommandName == "Edit") { //if (txtConfirm.Text != String.Empty || txtPassword.Text != String.Empty) //{ // if (txtPassword.Text != txtConfirm.Text) // { // mvMessage.AddError("パスワードが一致していません。"); // return; // } // if (!mvMessage.IsValid) return; //} aspnet_MembershipData data = new aspnet_MembershipData(); Criteria cri = new Criteria(); MembershipUser user = Membership.GetUser(UserName); cri.And("UserId", "=", user.ProviderUserKey.ToString()); ITransaction tran = factory.GetSearchObject(data, cri); Execute(tran); data = (aspnet_MembershipData)(((System.Collections.ArrayList)tran.Result)[0]); user.IsApproved = chkActive.Checked; user.Email = txtEmail.Text.ToString().Trim(); try { string[] roles = Roles.GetRolesForUser(UserName); bool isExist = false; for (int i = 0; i < roles.Length; i++) { if (ddlRolesList.SelectedValue == roles[i]) { isExist = true; break; } } if (!isExist) { if (roles.Length > 0) { Roles.RemoveUserFromRoles(UserName, roles); } Roles.AddUserToRole(UserName, ddlRolesList.SelectedValue); } } catch (Exception ex) { ApplicationLog.WriteError(ex); } //if (txtPassword.Text != String.Empty) //{ // try // { // string pass = user.ResetPassword(); // txtPassReset.Text = pass; // //if (!user.ChangePassword(pass, txtPassword.Text)) // //{ // // mvMessage.AddError("エラーが発生しました。"); // // return; // //} // } // catch // { // mvMessage.AddError("変更パスワード中エラーが発生しました。"); // } //} user.IsApproved = chkActive.Checked; user.Email = txtEmail.Text.ToString().Trim(); Membership.UpdateUser(user); //if( cbManagement.Checked == true) // data.SaleUserFlag = "1"; //else // data.SaleUserFlag = "0"; //if (cbInputer.Checked == true) // data.InChargeUserFlag = "1"; //else // data.InChargeUserFlag = "0"; string plainQuery = String.Format("UPDATE [aspnet_Membership] SET [FullName] = '{0}', BuildingId = '{1}' WHERE [UserID] = '{2}';", txtFullName.Text.Trim(), Func.ParseString(Session["__BUILDINGID__"]), user.ProviderUserKey.ToString()); SqlDatabase db = new SqlDatabase(); int Modifieditem = db.ExecuteNonQuery(plainQuery); if (Modifieditem == 0) { Membership.DeleteUser(txtUserName.Text.Trim()); OperationLogger.WriteError(Constants.LogOperationUserId, Constants.LogActionUpdateId, "Lỗi Phát Sinh", Page.User.Identity.Name); mvMessage.AddError("Lỗi Phát Sinh"); } else { OperationLogger.WriteInfo(Constants.LogOperationUserId, Constants.LogActionUpdateId, "Cập Nhật Thành Công", Page.User.Identity.Name); mvMessage.SetCompleteMessage("Cập Nhật Thành Công"); ScriptManager.RegisterClientScriptBlock(this.btnRegister, this.GetType(), "openedituser", "window.opener.__doPostBack('PopUpEditUser','');", true); //Add quyền int _count = lstSelectedRole.Items.Count; if (_count != 0) { DbHelper.ExecuteNonQuery("Delete From Mst_UserInRoles Where UserName = '******'"); for (int i = 0; i < _count; i++) { ListItem item = new ListItem(); item.Text = lstSelectedRole.Items[i].Text; item.Value = lstSelectedRole.Items[i].Value; //Add the item to selected employee list Mst_UserInRolesData dataRole = new Mst_UserInRolesData(); ITransaction tranA = factory.GetInsertObject(dataRole); dataRole.UserName = txtUserName.Text; dataRole.RoleId = item.Value; dataRole.ModifiedBy = Page.User.Identity.Name; dataRole.CreatedBy = Page.User.Identity.Name; dataRole.Created = DateTime.Now.ToString("yyyyMMddHHmmss"); dataRole.Modified = DateTime.Now.ToString("yyyyMMddHHmmss"); dataRole.DelFlag = "0"; Execute(tranA); if (!HasError) { } else { } } } } } else // Dang ky moi { MembershipCreateStatus status; MembershipUser user = null; mvMessage.CheckRequired(txtPassword, "Nhập Mới Mật Khẩu"); mvMessage.CheckRequired(txtConfirm, "Nhập Xác Nhận Mật Khẩu"); if (!mvMessage.IsValid) return; if (txtConfirm.Text.Trim() != txtPassword.Text.Trim()) { mvMessage.AddError("Mật Khẩu Không Giống Nhau"); return; } user = Membership.GetUser(txtUserName.Text); if (user != null) { mvMessage.AddError("Người dùng: " + txtUserName.Text + " đã tồn tại."); return; } if (txtUserName.Text.Length >= 14) { mvMessage.AddError("Người dùng: Tên đăng nhập phải < 14 ký tự."); return; } status = new MembershipCreateStatus(); user = Membership.CreateUser(txtUserName.Text.Trim(), txtPassword.Text.Trim(), txtEmail.Text.Trim(), "Who is Peter?", "Peter's Father's son", true, out status); if (status == MembershipCreateStatus.Success) { user.IsApproved = chkActive.Checked; Membership.UpdateUser(user); try { Roles.RemoveUserFromRoles(user.UserName, Roles.GetAllRoles()); } catch { } try { Roles.AddUserToRole(user.UserName, ddlRolesList.SelectedItem.Text); } catch { } if (txtFullName.Text.Trim() != string.Empty) { string SaleUserFlag = String.Empty; string InChargeUserFlag = String.Empty; //if (cbManagement.Checked == true) //{ // SaleUserFlag = "1"; //} //else //{ // SaleUserFlag = "0"; //} //if (cbInputer.Checked == true) //{ // InChargeUserFlag = "1"; //} //else //{ // InChargeUserFlag = "0"; //} aspnet_MembershipData data = new aspnet_MembershipData(); string plainQuery = String.Format("UPDATE [aspnet_Membership] SET [FullName] = '{0}', [BuildingId] = '{2}' WHERE [UserId] = '{1}';", txtFullName.Text.Trim(), user.ProviderUserKey.ToString().Trim(), Func.ParseString(Session["__BUILDINGID__"])); SqlDatabase db = new SqlDatabase(); if (db.ExecuteNonQuery(plainQuery) == 0) { Membership.DeleteUser(txtUserName.Text.Trim()); OperationLogger.WriteError(Constants.LogOperationUserId, Constants.LogActionUpdateId, "Lỗi Phát Sinh", Page.User.Identity.Name); mvMessage.AddError("Lỗi Phát Sinh"); return; } } OperationLogger.WriteInfo(Constants.LogOperationUserId, Constants.LogActionInsertId, "Thêm Mới Hoàn Tất", Page.User.Identity.Name); mvMessage.SetCompleteMessage("Thêm Mới Hoàn Tất"); ScriptManager.RegisterClientScriptBlock(this.btnRegister, this.GetType(), "openadduser", "window.opener.__doPostBack('PopUpEditUser','');", true); //Add quyền int _count = lstSelectedRole.Items.Count; if (_count != 0) { DbHelper.ExecuteNonQuery("Delete From Mst_UserInRoles Where UserName = '******'"); for (int i = 0; i < _count; i++) { ListItem item = new ListItem(); item.Text = lstSelectedRole.Items[i].Text; item.Value = lstSelectedRole.Items[i].Value; //Add the item to selected employee list Mst_UserInRolesData dataRole = new Mst_UserInRolesData(); ITransaction tran = factory.GetInsertObject(dataRole); dataRole.UserName = txtUserName.Text; dataRole.RoleId = item.Value; dataRole.ModifiedBy = Page.User.Identity.Name; dataRole.CreatedBy = Page.User.Identity.Name; dataRole.Created = DateTime.Now.ToString("yyyyMMddHHmmss"); dataRole.Modified = DateTime.Now.ToString("yyyyMMddHHmmss"); dataRole.DelFlag = "0"; Execute(tran); if (!HasError) { } else { } } } } else { OperationLogger.WriteError(Constants.LogOperationUserId, Constants.LogActionInsertId, "Lỗi Phát Sinh", Page.User.Identity.Name); mvMessage.AddError("Lỗi Phát Sinh"); } } }
protected void Page_Load(object sender, EventArgs e) { UserName = Request["UserName"]; Action = Request["Action"]; if (!IsPostBack) { if (Action == "Edit") { lblHeader.Text = "Thông Tin Người Dùng"; btnRegister.Text = "Cập Nhật"; btnRegister.CommandName = "Edit"; ltrNotice.Visible = false; trPassReset.Visible = true; trPass.Visible = false; trPassConfirm.Visible = false; btnReset.Attributes.Add("onclick", "return confirm('Phát sinh lại Mật Khẩu');"); lblOldPassword.Text = "Mật Khẩu Mới"; lblPassword.Text = "Xác Nhận Mật Khẩu"; if (!IsPostBack) { txtUserName.Text = UserName; txtUserName.ReadOnly = true; aspnet_MembershipData data = new aspnet_MembershipData(); Criteria cri = new Criteria(); MembershipUser user = Membership.GetUser(UserName); cri.And("UserId", "=", user.ProviderUserKey.ToString()); ITransaction tran = factory.GetSearchObject(data, cri); Execute(tran); if (tran.Result != null) if (((System.Collections.ArrayList)tran.Result).Count > 0) data = (aspnet_MembershipData)(((System.Collections.ArrayList)tran.Result)[0]); txtFullName.Text = data.FullName; txtEmail.Text = user.Email; //ddlRolesList.DataSource = Roles.GetAllRoles(); //ddlRolesList.DataBind(); DbHelper.FillList(ddlRolesList, "Select * from Mst_Roles Where delFlag = '0'", "RoleName", "RoleId"); //DbHelper.FillList(drpBuilding, "Select Name as BD_Name, BuildingId from Mst_Building", "BD_Name", "BuildingId"); //if (data.SaleUserFlag == "1") // cbManagement.Checked = true; //if (data.InChargeUserFlag == "1") // cbInputer.Checked = true; //if(Roles.GetRolesForUser(UserName).Length != 0) DbHelper.FillList(ddlRolesList, "Select * from Mst_Roles Where RoleId not in (Select RoleId from Mst_UserInRoles Where Username = '******')", "RoleName", "RoleId"); DbHelper.FillList(lstSelectedRole, "Select * from Mst_Roles Where RoleId in (Select RoleId from Mst_UserInRoles Where Username = '******')", "RoleName", "RoleId"); chkActive.Checked = user.IsApproved; } } else // Add new case { //DbHelper.FillList(drpBuilding, "Select Name as BD_Name, BuildingId from Mst_Building Where delFlag = '0'and BuildingId in ('" + Func.ParseString(Session["__BUILDINGID__"]) + "')", "BD_Name", "BuildingId"); //DbHelper.FillList(ddlRolesList, "Select * from Mst_Roles Where delFlag = '0'", "RoleName", "RoleId"); DbHelper.FillList(ddlRolesList, "Select * from Mst_Roles Where RoleId not in (Select RoleId from Mst_UserInRoles Where Username = '******')", "RoleName", "RoleId"); lblHeader.Text = "Thông Tin Người Dùng"; trPassReset.Visible = false; trPass.Visible = true; trPassConfirm.Visible = true; btnRegister.Text = "Thêm Mới"; ltrNotice.Visible = true; ltrNotice.Text = ""; //if (!IsPostBack) //{ // ddlRolesList.DataSource = Roles.GetAllRoles(); // ddlRolesList.DataBind(); //} } } }
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); if (!IsAdmin() && IsInchargeLeader()) { q.And(m => m.State.Equals(StandardFileStateConst.分管领导审批)); } else if (!IsAdmin() && IsLeader()) { q.And(m => m.State.Equals(StandardFileStateConst.法规部门负责人审核)); } q.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); } }
/// <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); }