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