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 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 ResetUser(T_User user, DrisionDbContext context)
{
user.User_Password = this.Md5("1");
context.SaveChanges();
UserShow();
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;
}
}
/// <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 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 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 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 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 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("编辑角色成功！");
}
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");
}