protected void gvShow_RowCommand(object sender, GridViewCommandEventArgs e)
{
using (DrisionDbContext context = new DrisionDbContext(GlobalObject.ConnString))
{
int id = Convert.ToInt32(e.CommandArgument);
T_User user = context.T_User.Where(x => x.User_ID == id).FirstOrDefault();
if (user == null)
{
return;
}
if (e.CommandName == "re")
{
ResetUser(user, context);
}
else if (e.CommandName == "state")
{
ResetState(user, context);
}
else if (e.CommandName == "up")
{
UpdateUser(user, context);
}
else if (e.CommandName == "del")
{
DeleteUser(user, context);
}
else if (e.CommandName == "set")
{
SetRole(user, context);
}
}
}
private void BingRoleToDataGridview()
{
Expression <Func <T_Role, bool> > whereExp = null;
if (!string.IsNullOrEmpty(txtSearchName.Text.Trim()))
{
whereExp = n => n.Role_Name.Contains(txtSearchName.Text.Trim());
}
using (DrisionDbContext context = new DrisionDbContext(GlobalObject.ConnString))
{
if (whereExp == null)
{
int totalCount = context.T_Role.Count();
Pager.Data_AspNetPager(AspNetPager1, totalCount, AspNetPager1.PageSize);
this.gvShow.DataSource = context.T_Role.OrderBy(x => x.Role_ID).Skip(AspNetPager1.PageSize * (AspNetPager1.CurrentPageIndex - 1))
.Take(AspNetPager1.PageSize).ToList();
this.gvShow.DataBind();
}
else
{
int totalCount = context.T_Role.Where(whereExp).Count();
Pager.Data_AspNetPager(AspNetPager1, totalCount, AspNetPager1.PageSize);
this.gvShow.DataSource = context.T_Role.Where(whereExp).OrderBy(x => x.Role_ID).Skip(AspNetPager1.PageSize * (AspNetPager1.CurrentPageIndex - 1))
.Take(AspNetPager1.PageSize).ToList();
this.gvShow.DataBind();
}
}
}
private void ResetState(T_Role role, DrisionDbContext context)
{
if (role.Role_Status == 1)
{
if (role.T_Users.Count > 0 ||
RoleFunctionManager.GetInstance().GetFunctions(role.Role_ID).Count > 0)
{
this.AjaxAlert("此角色已使用，不能停用！");
return;
}
role.Role_Status = 0;
context.SaveChanges();
BingRoleToDataGridview();
this.AjaxAlert("停用角色成功！");
return;
}
else if (role.Role_Status == 0)
{
role.Role_Status = 1;
context.SaveChanges();
BingRoleToDataGridview();
this.AjaxAlert("启用角色成功！");
return;
}
}
private void AddUser(string name)
{
using (DrisionDbContext context = new DrisionDbContext(GlobalObject.ConnString))
{
if (context.T_Role.Where(x => x.Role_Name == name).Count() != 0)
{
this.AjaxAlert("角色名称不能重复！");
return;
}
int roleId;
var query = context.T_Role.OrderByDescending(x => x.Role_ID).FirstOrDefault();
if (query == null)
{
roleId = 1;
}
else
{
roleId = query.Role_ID + 1;
}
context.T_Role.Add(new T_Role()
{
Role_ID = roleId,
Role_Name = txtName.Text.Trim(),
Role_Status = Convert.ToInt32(rbtnState.SelectedValue),
Role_Comment = txtRemark.Text.Trim()
});
context.SaveChanges();
}
BingRoleToDataGridview();
ClearControl();
this.AjaxAlert("添加角色成功！");
}
protected void gvShow_RowCommand(object sender, GridViewCommandEventArgs e)
{
T_Role role = null;
using (DrisionDbContext context = new DrisionDbContext(GlobalObject.ConnString))
{
int roleId = Convert.ToInt32(e.CommandArgument);
role = context.T_Role.Where(x => x.Role_ID == roleId).FirstOrDefault();
if (e.CommandName == "state")
{
ResetState(role, context);
}
else if (e.CommandName == "up")
{
UpdateUser(role, context);
}
else if (e.CommandName == "del")
{
DeleteUser(role, context);
}
else if (e.CommandName == "set")
{
SetRight(role, context);
}
}
}
protected void btnOk_Click(object sender, EventArgs e)
{
var UserCode = this.txtUserCode.Text;
var Email = this.txtEMail.Text;
if (string.IsNullOrWhiteSpace(UserCode) || string.IsNullOrWhiteSpace(Email))
{
this.AjaxAlert("请输入用户名和邮箱！");
return;
}
using (DrisionDbContext context = new DrisionDbContext())
{
var User = context.T_User.FirstOrDefault(p => p.User_Code == UserCode && p.User_EMail == Email);
if (User == null)
{
this.AjaxAlert("输入的用户名和邮箱不匹配！");
return;
}
string NewPwd = new Random().Next(100000, 1000000).ToString();
User.User_Password = this.Md5(NewPwd);
context.SaveChanges();
//调用邮件接口
Drision.Framework.Manager.EmailManager.SendEmail(User.User_EMail, string.Empty, "密码帮助", string.Format("新密码为：{0}，请重新登录！", NewPwd));
Response.Redirect("Login.aspx", false);
}
}
private void BindGrid()
{
try
{
using (DrisionDbContext context = new DrisionDbContext(GlobalObject.ConnString))
{
var list = context.T_MobileOperationErrorLog.ToList();
var result = list.OrderBy(p => p.State).ThenByDescending(p => p.CreateTime).ToList();
this.gcProcessInstance.PagerSettings.DataCount = result.Count();
//绑定
if (result.Count() > this.PageIndex * this.PageSize)
{
result = result.Skip(this.PageIndex * this.PageSize).Take(this.PageSize).ToList();
}
else
{
this.PageIndex = 0;
this.gcProcessInstance.PagerSettings.PageIndex = 0;
result = result.Take(this.PageSize).ToList();
}
gcProcessInstance.DataSource = result;
gcProcessInstance.DataBind();
}
}
catch (ApplicationException ex)
{
this.AjaxAlert(ex.Message);
}
}
private void ResetUser(T_User user, DrisionDbContext context)
{
user.User_Password = this.Md5("1");
context.SaveChanges();
UserShow();
this.AjaxAlert("重置密码成功！");
}
protected void gvShow_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
T_User user = e.Row.DataItem as T_User;
Label lblUserRole = e.Row.FindControl("lblUserRole") as Label;
Label lblState = e.Row.FindControl("lblState") as Label;
Label lblDept = e.Row.FindControl("lblDept") as Label;
LinkButton lbtnReset = e.Row.FindControl("lbtnReset") as LinkButton;
LinkButton lbtnState = e.Row.FindControl("lbtnState") as LinkButton;
LinkButton lbtnEdit = e.Row.FindControl("lbtnEdit") as LinkButton;
LinkButton lbtnDel = e.Row.FindControl("lbtnDel") as LinkButton;
LinkButton lbtnSet = e.Row.FindControl("lbtnSet") as LinkButton;
using (DrisionDbContext context = new DrisionDbContext(GlobalObject.ConnString))
{
//var query = from n in context.T_User_Role
// join r in context.T_Role on n.Role_ID equals r.Role_ID
// where n.User_ID == user.User_ID
// select r.Role_Name;
var query = user.T_Roles.Select(p => p.Role_Name);
lblUserRole.Text = string.Join(" ", query.ToList());
}
if (user.User_Status == 1)
{
lblState.Text = "启用";
lbtnState.Text = "停用";
lbtnState.OnClientClick = "if (!confirm('是否停用用户？')) {return false;}";
}
else
{
lblState.Text = "停用";
lbtnState.Text = "启用";
lbtnState.OnClientClick = "if (!confirm('是否启用用户？')) {return false;}";
}
lblDept.Text = "";
lbtnReset.CommandArgument = user.User_ID.ToString();
lbtnState.CommandArgument = user.User_ID.ToString();
lbtnEdit.CommandArgument = user.User_ID.ToString();
lbtnDel.CommandArgument = user.User_ID.ToString();
lbtnSet.CommandArgument = user.User_ID.ToString();
if (user.User_ID == 1)
{
lbtnReset.Enabled = false;
lbtnState.Enabled = false;
lbtnEdit.Enabled = false;
lbtnDel.Enabled = false;
lbtnSet.Enabled = false;
}
}
}
//页面定义的参数
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (!this.IsPostBack)
{
if (Request.QueryString["id"] == null)
{
//转到错误页
Response.Redirect("~/Error.aspx");
}
//赋值定义的参数
//绑定启动流程下拉选择框
//绑定枚举
ctrl_User_Status.DataSource = typeof(Drision.Framework.Enum.EffectiveFlagEnum);
ctrl_User_Status.DataBind();
ctrl_Is_Prohibit_Web.DataSource = typeof(Drision.Framework.Enum.ForbiddenWebFlagEmum);
ctrl_Is_Prohibit_Web.DataBind();
ctrl_Is_Prohibit_Mobile.DataSource = typeof(Drision.Framework.Enum.ForbiddenMobileFlagEmum);
ctrl_Is_Prohibit_Mobile.DataBind();
txt_User_TypeJW.DataSource = typeof(Drision.Framework.Enum.User_User_TypeEnum);
txt_User_TypeJW.DataBind();
//绑定引用字段下拉
using (DrisionDbContext context = new DrisionDbContext(GlobalObject.ConnString))
{
Tension.DataPage <dynamic> dataPage = new Tension.DataPage <dynamic>(1, int.MaxValue);
dynamic result1 = null;
result1 = context.T_Department.ToList();
foreach (var m in result1)
{
var p = new DataWrapper(m);
ctrl_Department_ID.Items.Add(new ComboItem()
{
Text = p["Department_Name"],
Value = p["Department_ID"],
});
}
}
//查询并加载数据
__Id = Convert.ToInt32(Request.QueryString["id"]);
this.hc.Text = this.ClientScript.GetPostBackEventReference(this.hc, "refresh");
SetTabSelectedIndex();
}
}
catch (Exception ex)
{
this.AjaxAlert(ex);
}
}
private void UpdateUser(T_Role role, DrisionDbContext context)
{
txtName.Text = role.Role_Name;
rbtnState.SelectedValue = role.Role_Status.ToString();
txtRemark.Text = role.Role_Comment;
lblEdit.Text = role.Role_ID.ToString();
btnAdd.Visible = false;
btnEdit.Visible = true;
Panel1.Visible = true;
}
/// <summary>
/// 更新日志状态
/// </summary>
/// <param name="id">日志ID</param>
/// <param name="state">日志状态</param>
void UpdateState(int id, OperationErrorLogStateEnum state)
{
using (DrisionDbContext context = new DrisionDbContext(GlobalObject.ConnString))
{
T_MobileOperationErrorLog log = context.T_MobileOperationErrorLog.FirstOrDefault(p => p.Id == id);
if (log != null)
{
log.StateEnum = state;
context.SaveChanges();
}
}
}
private void DeptShow()
{
using (DrisionDbContext context = new DrisionDbContext())
{
var departmentlist = context.T_Department.Select(x => new { x.Department_ID, x.Department_Name }).ToList();
this.ddlDept.Items.Clear();
this.ddlDept.Items.Add(new ListItem("请选择", "-1"));
this.ddlDept.DataSource = departmentlist;
this.ddlDept.DataTextField = "Department_Name";
this.ddlDept.DataValueField = "Department_ID";
this.ddlDept.DataBind();
}
}
private void EditUser(string code, int id)
{
using (DrisionDbContext context = new DrisionDbContext(GlobalObject.ConnString))
{
T_User user = context.T_User.Where(x => x.User_ID == id).FirstOrDefault();
if (user == null)
{
return;
}
if (ddlDept.Items.Count == 0)
{
this.AjaxAlert("部门不存在，请先添加部门！");
return;
}
else
{
user.Department_ID = Convert.ToInt32(ddlDept.SelectedValue);
}
if (context.T_User.Where(x => x.User_ID != id && x.User_Code == code).Count() != 0)
{
this.AjaxAlert("用户工号不能重复！");
return;
}
else
{
user.User_Code = code;
}
user.User_Name = txtName.Text.Trim();
user.EntryDate = Convert.ToDateTime(txtEntryTime.Text.Trim());
user.Card_No = txtCardNum.Text.Trim();
user.User_Mobile = txtPhone.Text.Trim();
user.User_EMail = txtEmail.Text.Trim();
user.User_Status = Convert.ToInt32(rbtnState.SelectedValue);
user.User_Comment = txtRemark.Text.Trim();
context.SaveChanges();
}
UserShow();
ClearControl();
this.AjaxAlert("编辑用户成功！");
}
private void DeleteUser(T_Role role, DrisionDbContext context)
{
if (role.T_Users.Count > 0 ||
RoleFunctionManager.GetInstance().GetFunctions(role.Role_ID).Count > 0)
{
this.AjaxAlert("此角色已使用，不能删除！");
return;
}
context.T_Role.Remove(role);
context.SaveChanges();
BingRoleToDataGridview();
if (lblEdit.Text.Trim() == role.Role_ID.ToString())
{
ClearControl();
}
this.AjaxAlert("删除角色成功！");
}
private void AddUser(string code)
{
using (DrisionDbContext context = new DrisionDbContext(GlobalObject.ConnString))
{
T_User user = new T_User();
if (ddlDept.Items.Count == 0)
{
this.AjaxAlert("部门不存在，请先添加部门！");
return;
}
else
{
user.Department_ID = Convert.ToInt32(ddlDept.SelectedValue);
}
if (context.T_User.Where(x => x.User_Code == code).Count() != 0)
{
this.AjaxAlert("用户工号不能重复！");
return;
}
else
{
user.User_Code = code;
}
var query = context.T_User.OrderByDescending(x => x.User_ID).FirstOrDefault();
user.User_ID = query == null ? 1 : query.User_ID + 1;
user.User_Password = this.Md5("1");
user.User_Name = txtName.Text.Trim();
user.EntryDate = Convert.ToDateTime(txtEntryTime.Text.Trim());
user.Card_No = txtCardNum.Text.Trim();
user.User_Mobile = txtPhone.Text.Trim();
user.User_EMail = txtEmail.Text.Trim();
user.User_Status = Convert.ToInt32(rbtnState.SelectedValue);
user.User_Comment = txtRemark.Text.Trim();
context.SaveChanges();
}
UserShow();
ClearControl();
this.AjaxAlert("添加用户成功！");
}
private void UserShow()
{
using (DrisionDbContext context = new DrisionDbContext(GlobalObject.ConnString))
{
IEnumerable <T_User> userQuery;
if (string.IsNullOrEmpty(txtSearchName.Text.Trim()))
{
userQuery = context.T_User.OrderBy(x => x.User_ID);
}
else
{
userQuery = context.T_User.Where(x => x.User_Name.Contains(txtSearchName.Text.Trim())).OrderBy(x => x.User_ID);
}
int totalCount = userQuery.Count();
Pager.Data_AspNetPager(AspNetPager1, totalCount, AspNetPager1.PageSize);
this.gvShow.DataSource = userQuery.Skip(AspNetPager1.PageSize * (AspNetPager1.CurrentPageIndex - 1))
.Take(AspNetPager1.PageSize).ToList();
this.gvShow.DataBind();
}
}
/// <summary>
/// 加载数据
/// </summary>
void LoadData()
{
string id = Request.QueryString["id"];
if (!string.IsNullOrEmpty(id))
{
int piid = int.Parse(id);
using (DrisionDbContext context = new DrisionDbContext(GlobalObject.ConnString))
{
T_MobileOperationErrorLog log = context.T_MobileOperationErrorLog.FirstOrDefault(p => p.Id == piid);
if (log != null)
{
lblCreateUserId.Text = log.CreateUserId.HasValue?OrgManager.GetDisplayValue("T_User", log.CreateUserId.Value):string.Empty;
lblCreateTime.Text = log.CreateTime.HasValue ? log.CreateTime.Value.ToString("yyyy-MM-dd HH:mm:ss") : string.Empty;
lblOperationRecord.Text = log.OperationRecord;
lblState.Text = log.State.HasValue? EnumHelper.GetDescription(typeof(OperationErrorLogStateEnum), log.State.Value):string.Empty;
}
}
}
}
private void DeleteUser(T_User user, DrisionDbContext context)
{
context.T_User.Remove(user);
context.SaveChanges();
UserShow();
if (lblEdit.Text.Trim() == user.User_ID.ToString())
{
ClearControl();
}
if (user.User_ID == this.LoginUserID)
{
LoginUser = null;
Session["ModuleId"] = 1;
Session["FunctionId"] = 101;
Response.Redirect("~/Home/Login.aspx");
}
this.AjaxAlert("删除用户成功！");
}
private void ResetState(T_User user, DrisionDbContext context)
{
if (user.User_Status == 1)
{
user.User_Status = 0;
context.SaveChanges();
UserShow();
this.AjaxAlert("停用用户成功！");
return;
}
else if (user.User_Status == 0)
{
user.User_Status = 1;
context.SaveChanges();
UserShow();
this.AjaxAlert("启用用户成功！");
return;
}
}
private void EditUser(string name, int id)
{
using (DrisionDbContext context = new DrisionDbContext(GlobalObject.ConnString))
{
if (context.T_Role.Where(x => x.Role_ID != id && x.Role_Name == name).Count() != 0)
{
this.AjaxAlert("角色名称不能重复！");
return;
}
var query = context.T_Role.Where(x => x.Role_ID == id).FirstOrDefault();
query.Role_Name = txtName.Text.Trim();
query.Role_Status = Convert.ToInt32(rbtnState.SelectedValue);
query.Role_Comment = txtRemark.Text.Trim();
context.SaveChanges();
}
BingRoleToDataGridview();
ClearControl();
this.AjaxAlert("编辑角色成功！");
}
/// <summary>
/// 绑定数据
/// </summary>
protected void ListBind()
{
using (DrisionDbContext context = new DrisionDbContext(GlobalObject.ConnString))
{
var activeRoleQuery = context.T_Role.Where(x => x.Role_Status == 0);
int totalCount = activeRoleQuery.Count();
Pager.Data_AspNetPager(AspNetPager1, totalCount, AspNetPager1.PageSize);
var activeRoleList = activeRoleQuery.OrderBy(x => x.Role_ID).Skip(AspNetPager1.PageSize * (AspNetPager1.CurrentPageIndex - 1))
.Take(AspNetPager1.PageSize).ToList();
//var userRoleList = context.T_User_Role.Where(x => x.User_ID == UserId).ToList();
var userRoleList = context.T_User.FirstOrDefault(p => p.User_ID == UserId).T_Roles.ToList();
this.gvShow.DataSource = activeRoleList.Select(x => new SetRoleEntity()
{
Role_ID = x.Role_ID,
Role_Name = x.Role_Name,
Role_Comment = x.Role_Comment,
CheckedFlag = (userRoleList.Where(y => y.Role_ID == x.Role_ID).Count() != 0)
}).ToList();
this.gvShow.DataBind();
}
}
/// <summary>
/// 绑定用户ID号
/// </summary>
private void BingDataToUserId(string userId)
{
//如果传入ID号有误,则变成下拉菜单来处理
bool nextSetp = true;
if (!string.IsNullOrEmpty(userId))
{
this.UserId = Convert.ToInt32(userId);
using (DrisionDbContext context = new DrisionDbContext(GlobalObject.ConnString))
{
var query = context.T_User.Where(x => x.User_ID == this.UserId).FirstOrDefault();
if (query != null)
{
lblUserName.Text += query.User_Name;
this.ddlRoleList.Visible = false;
nextSetp = false;
}
}
}
if (nextSetp)
{
using (DrisionDbContext Context = new DrisionDbContext(GlobalObject.ConnString))
{
var roleList = Context.T_User.Select(x => new { x.User_ID, x.User_Name }).ToList();
this.ddlRoleList.DataSource = roleList;
this.ddlRoleList.DataValueField = "User_ID";
this.ddlRoleList.DataTextField = "User_Name";
this.ddlRoleList.DataBind();
this.UserId = Convert.ToInt32(this.ddlRoleList.SelectedValue);
this.ddlRoleList.Visible = true;
}
}
}
private void UpdateUser(T_User user, DrisionDbContext context)
{
txtCode.Text = user.User_Code;
txtName.Text = user.User_Name;
if (user.EntryDate == null)
{
txtEntryTime.Text = "";
}
else
{
txtEntryTime.Text = Convert.ToDateTime(user.EntryDate).ToString("yyyy-MM-dd");
}
txtCardNum.Text = user.Card_No;
txtPhone.Text = user.User_Mobile;
txtEmail.Text = user.User_EMail;
if (context.T_Department.Where(x => x.Department_ID == user.Department_ID).Count() != 0)
{
ddlDept.SelectedValue = user.Department_ID.ToString();
}
else
{
ddlDept.SelectedIndex = -1;
}
rbtnState.SelectedValue = user.User_Status.ToString();
txtRemark.Text = user.User_Comment;
lblEdit.Text = user.User_ID.ToString();
btnAdd.Visible = false;
btnEdit.Visible = true;
Panel1.Visible = true;
}
private void SetRole(T_User user, DrisionDbContext context)
{
Response.Redirect("SetRole.aspx?UserId=" + user.User_ID);
}
private void SetRight(T_Role role, DrisionDbContext context)
{
context.Dispose();
Response.Redirect("RightOfMenu.aspx?RoleId=" + role.Role_ID);
return;
}
protected void btnAdd_Click(object sender, EventArgs e)
{
string RoleID = "";
for (int i = 0; i < this.gvShow.Rows.Count; i++)
{
if (((CheckBox)this.gvShow.Rows[i].Cells[1].FindControl("CheckBox1")).Checked)
{
RoleID += this.gvShow.DataKeys[i]["Role_ID"].ToString() + ",";
}
}
if (RoleID == "")
{
this.AjaxAlert("没有选中任何项！");
return;
}
RoleID = RoleID.Trim(',');
string[] RoleArr = RoleID.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
using (DrisionDbContext context = new DrisionDbContext(GlobalObject.ConnString))
{
//var delList = context.T_User_Role.Where(x => x.User_ID == UserId).ToList();
//foreach (var del in delList)
//{
// context.T_User_Role.Remove(del);
//}
T_User user = context.T_User.FirstOrDefault(p => p.User_ID == UserId);
if (user != null)
{
user.T_Roles.Clear();
foreach (var str in RoleArr)
{
int roleId = int.Parse(str);
T_Role role = context.T_Role.FirstOrDefault(p => p.Role_ID == roleId);
if (role != null)
{
user.T_Roles.Add(role);
}
}
//int id;
//var query = context.T_User_Role.OrderByDescending(x => x.Id).FirstOrDefault();
//if (query == null)
// id = 1;
//else
// id = query.Id + 1;
//int roleId;
//foreach (var str in RoleArr)
//{
// roleId = int.Parse(str);
// context.T_User_Role.Add(new WebContext.Model.T_User_Role() {
// Id = id,
// User_ID = UserId,
// Role_ID = roleId
// });
// id++;
//}
context.SaveChanges();
}
}
this.AjaxAlert("设置成功！");
//Response.Redirect("UserInfo.aspx");
Response.Redirect("../HR_Common/UserQuery.aspx");
}
