public ActionResult EditForAjax(SYS_Role model)
{
return(Json(this.roleService.Update(model,
x => new SYS_Role {
RoleName = model.RoleName, Status = model.Status
})));
}
public JsonResult UpdateRole(SYS_Role Role)
{
JsonResult result = new JsonResult();
string msg = "";
try
{
Role.ModifiedTime = DateTime.Now;
Role.Modifier = (Session["user"] as SYS_User)?.UserName;
bool isSuccess = roleService.UpdateRole(Role);
if (isSuccess)
{
msg = "修改成功";
}
else
{
msg = "修改失败";
}
log.Info(msg);
}
catch (DbEntityValidationException e)
{
log.Error(e.Message);
}
catch (Exception e)
{
log.Error(e.Message);
}
finally
{
result = Json(new { msg = msg }, JsonRequestBehavior.AllowGet);
}
return(result);
}
private dynamic GetState(SYS_Role role, int funcId)
{
if (role.RoleSign.Equals("SYS_ADMIN") && new SYS_FunctionManager().GetByPK(funcId).ParentID != null)
{
return(new
{ //描述节点的初始状态 Object
/*disabled: true,*/ //是否禁用节点
expanded = false, //是否展开节点
selected = true //是否选中节点
});
}
if (role.SYS_Function.Where(s => s.FunctionID == funcId).ToList().Count > 0)
{
return(new
{ //描述节点的初始状态 Object
/*disabled: true,*/ //是否禁用节点
expanded = false, //是否展开节点
selected = true //是否选中节点
});
}
return(new
{ //描述节点的初始状态 Object
/*disabled: true,*/ //是否禁用节点
expanded = false, //是否展开节点
selected = false //是否选中节点
});
}
public void FillDdls()
{
obj_SYS_Role = new SYS_Role();
obj_BAL_SYS_Role = new SYS_Role_BLogic();
DataSet dsSelect = new DataSet();
// dsSelect = obj_BAL_SYS_Role.BAL_Select_Employee_BMS_SelectAll(Convert.ToInt64(Session["EmpolyeeID"]));
dsSelect = obj_BAL_SYS_Role.BAL_Select_Employee_BMS_SelectAll(Convert.ToInt64(ViewState["EmpolyeeID"]));
if (dsSelect.Tables.Count > ((int)EnumFile.AssignValue.Zero))
{
Session["ds_BMS"] = dsSelect;
ddlBoard.DataSource = dsSelect.Tables[0];
ddlBoard.DataTextField = "BMS";
ddlBoard.DataValueField = "BMSID";
ddlBoard.DataBind();
ddlBoard.Items.Insert(((int)EnumFile.AssignValue.Zero), new ListItem("-- Select --"));
}
mp1.Show();
//upSelectBMS.Update();
ddlSubject.SelectedIndex = ((int)EnumFile.AssignValue.Zero);
ddlSubject.Enabled = false;
ddlDivision.SelectedIndex = ((int)EnumFile.AssignValue.Zero);
ddlDivision.Enabled = false;
}
// POST: odata/Roles
public IHttpActionResult Post(SYS_Role model)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var addedEntity = this.db.Add(model);
try
{
this.db.SaveToDb();
}
catch (DbUpdateException)
{
if (Exists(model.ID))
{
return(Conflict());
}
else
{
throw;
}
}
return(Created(model));
}
public ActionResult DeleteRole(int id)
{
SYS_RoleManager rm = new SYS_RoleManager();
SYS_Role role = rm.GetByPK(id);
int result = 0;
if (role.SYS_User.Count > 0)
{
result = -1;//该角色下还有管理员
}
else if (role.SYS_Function.Count > 0)
{
if (!rm.ClearRight(role.RoleId))
{
result = -2; //清除权限时错误
}
}
if (result == 0)
{
if (rm.Delete(role.RoleId))
{
result = 1;
}
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
private dynamic DG(int functionId, dynamic info, SYS_Role role)
{
SYS_FunctionManager bll = new SYS_FunctionManager();
var list = bll.Where(x => x.ParentID == functionId);
if (list.Count > 0)
{
dynamic newInfo = new
{
id = functionId,
info.text,
nodes = new List <object>(),
state = GetState(role, functionId)
};
foreach (var item in list)
{
var sub = new
{
id = item.FunctionID,
text = item.FunctionName,
icon = "glyphicon glyphicon-unchecked", //节点上显示的图标，支持bootstrap的图标 string
selectedIcon = "glyphicon glyphicon-check ", //节点被选中时显示的图标 string
state = GetState(role, item.FunctionID)
//nodes = new List<object>()
};
newInfo.nodes.Add(DG(item.FunctionID, sub, role));
}
return(newInfo);
}
return(info);
}
public ActionResult UpdateRole(SYS_Role role)
{
if (role.AppId.Equals("-1"))
{
role.AppId = null;
}
return(Json(new SYS_RoleManager().Update(role), JsonRequestBehavior.AllowGet));
}
protected void btnChangesubmit_Click(object sender, EventArgs e)
{
if (AppSessions.RoleID == 4)//student
{
//Employee_BLogic BEmployee = new Employee_BLogic();
//Employee PEmployee = new Employee();
//PEmployee.roleid = AppSessions.RoleID;
//PEmployee.userid = "";
//PEmployee.Studentlist = Convert.ToString(AppSessions.StudentID);
//PEmployee.password = txtnp.Text;
//PEmployee.modifiedby = AppSessions.EmpolyeeID;
//BEmployee.BAL_Employee_Password_Update(PEmployee);
//lblmsg.Visible = true;
DataSet dtLogin = new DataSet();
DataTable LoginInfo = new DataTable();
DataTable UserInfo = new DataTable();
SYS_Role obj_SYS_Role = new SYS_Role();
SYS_Role_BLogic obj_BAL_SYS_Role = new SYS_Role_BLogic();
obj_SYS_Role.Username = AppSessions.LoginID;
obj_SYS_Role.Password = txtop.Text;
dtLogin = obj_BAL_SYS_Role.BAL_SYS_Student_Login(obj_SYS_Role);
LoginInfo = dtLogin.Tables[0];
if (LoginInfo.Rows.Count > 0 && LoginInfo != null)
{
Employee_BLogic BEmployee = new Employee_BLogic();
Employee PEmployee = new Employee();
PEmployee.roleid = AppSessions.RoleID;
PEmployee.userid = "";
PEmployee.Studentlist = Convert.ToString(AppSessions.StudentID);
PEmployee.password = txtnp.Text;
PEmployee.modifiedby = AppSessions.EmpolyeeID;
BEmployee.BAL_Employee_Password_Update(PEmployee);
lblmsg.Text = "Password changed successfully";
TrackLog_Utils.Log(Convert.ToInt32(AppSessions.SchoolID), Convert.ToInt32(AppSessions.EmployeeOrStudentID), Convert.ToInt16(AppSessions.DivisionID), StringEnum.stringValueOf(EnumFile.AccessedPages.AccessMyAccount), "Change Password Tab", "Click", Convert.ToDateTime(System.DateTime.Now), HttpContext.Current.Session.SessionID, StringEnum.stringValueOf(EnumFile.Activity.MyAccountChangedPassword), "Changed Password > From : " + txtop.Text + " To : " + txtnp.Text, 0);
}
else
{
lblmsg.Visible = true;
lblmsg.Text = "Please enter valid old password.";
//WebMsg.Show("Please enter valid old password.");
}
}
else if (AppSessions.RoleID == 3 || AppSessions.RoleID == 2 || AppSessions.RoleID == 1) //3-teacher,2-sadmin,1-epath-admin
{
Employee_BLogic BEmployee = new Employee_BLogic();
Employee PEmployee = new Employee();
PEmployee.roleid = AppSessions.RoleID;
PEmployee.userid = Convert.ToString(AppSessions.EmpolyeeID);
PEmployee.Studentlist = "";
PEmployee.password = txtnp.Text;
PEmployee.modifiedby = AppSessions.EmpolyeeID;
BEmployee.BAL_Employee_Password_Update(PEmployee);
}
}
//public bool isValid_BMS_Employee()
//{
// DAL_SYS_Role = new DataAccess();
// //return DAL_SYS_Role.executescalre("PROC_Select_Active_BMS");
//}
public DataSet BAL_SelectRoles_ForUserList(SYS_Role SYS_Role)
{
DAL_SYS_Role = new DataAccess();
arrParameter = new ArrayList();
arrParameter.Add(new parameter("RoleID", SYS_Role.roleid));
return(DAL_SYS_Role.DAL_Select("proc_Select_Role_ForUserList", arrParameter));
}
/// <summary>
/// 删除角色
/// </summary>
/// <param name="id">ID</param>
/// <returns></returns>
public bool DeleteRole(Guid id)
{
using (var db = base.GDDSVSPDb)
{
int isdel = Convert.ToInt32(IsDel.已删除);
SYS_Role role = db.SYS_Role.SingleOrDefault(p => p.RoleID == id);
role.IsDel = isdel;
return(db.SaveChanges() > 0);
}
}
public DataSet BAL_SYS_Check_Login_studentportal(SYS_Role SYS_Role)
{
DAL_SYS_Role = new DataAccess();
arrParameter = new ArrayList();
arrParameter.Add(new parameter("UserName", SYS_Role.Username));
arrParameter.Add(new parameter("Name", SYS_Role.Name));
return(DAL_SYS_Role.DAL_Select("Student_Portal_PROC_Select_Valid_login", arrParameter));
}
public DataSet BAL_SYS_Role_Select(SYS_Role SYS_Role, string mode)
{
DAL_SYS_Role = new DataAccess();
arrParameter = new ArrayList();
arrParameter.Add(new parameter("mode", mode));
arrParameter.Add(new parameter("RoleID", SYS_Role.roleid));
arrParameter.Add(new parameter("RoleIDStr", SYS_Role.roleidStr));
return(DAL_SYS_Role.DAL_Select("Proc_SYS_RoleSelectDelete", arrParameter));
}
public ServiceResult Update(SYS_Role model, Expression <Func <SYS_Role, SYS_Role> > expression)
{
var result = new ServiceResult();
if (this.roleRepository.Exists(r => r.RoleName == model.RoleName && r.SystemRoleId != model.SystemRoleId))
{
return(result.IsFailed("修改角色失败，已存在同名角色"));
}
this.roleRepository.Update(x => x.SystemRoleId == model.SystemRoleId, expression);
return(result.IsSucceed("修改角色成功"));
}
public static bool CheckRight(this SYS_Role role, string FunctionName)
{
foreach (var f in role.SYS_Function)
{
if (f.FunctionName.Equals(FunctionName))
{
return(true);
}
}
return(false);
}
public ServiceResult Update(SYS_Role model)
{
var result = new ServiceResult();
if (this.roleRepository.Exists(r => r.RoleName == model.RoleName && r.SystemRoleId != model.SystemRoleId))
{
return(result.IsFailed("修改角色失败，已存在同名角色"));
}
this.roleRepository.Update(model);
return(result.IsSucceed("修改角色成功"));
}
public DataSet BAL_SYS_Active_Login_Swayam(SYS_Role SYS_Role)
{
DAL_SYS_Role = new DataAccess();
arrParameter = new ArrayList();
arrParameter.Add(new parameter("UserName", SYS_Role.Username));
arrParameter.Add(new parameter("Password", SYS_Role.Password));
//arrParameter.Add(new parameter("RoleID", SYS_Role.roleid));
return(DAL_SYS_Role.DAL_Select("PROC_Select_ValidUser_Swayam", arrParameter));
}
public DataSet BAL_SYS_Check_Login(SYS_Role SYS_Role)
{
DAL_SYS_Role = new DataAccess();
arrParameter = new ArrayList();
arrParameter.Add(new parameter("UserName", SYS_Role.Username));
arrParameter.Add(new parameter("Password", SYS_Role.Password));
//return DAL_SYS_Role.DAL_Select("PROC_Select_Valid_login", arrParameter);
return(DAL_SYS_Role.DAL_Select("PROC_Select_Valid_login", arrParameter));
}
public int BAL_SYS_Role_Delete(SYS_Role SYS_Role, string mode)
{
DAL_SYS_Role = new DataAccess();
arrParameter = new ArrayList();
arrParameter.Add(new parameter("mode", mode));
arrParameter.Add(new parameter("RoleID", SYS_Role.roleid));
arrParameter.Add(new parameter("RoleIDStr", SYS_Role.roleidStr));
arrParameter.Add(new parameter("IsActive", SYS_Role.isactive));
return(DAL_SYS_Role.DAL_Delete_Return("Proc_SYS_RoleSelectDelete", arrParameter));
}
public DataSet BAL_SYS_Parent_Login(SYS_Role SYS_Role)
{
DAL_SYS_Role = new DataAccess();
arrParameter = new ArrayList();
arrParameter.Add(new parameter("UserName", SYS_Role.Username));
arrParameter.Add(new parameter("Password", SYS_Role.Password));
//arrParameter.Add(new parameter("RoleID", SYS_Role.roleid));
return(DAL_SYS_Role.DAL_Select("Proc_Select_ValidParent", arrParameter));
}
public int add(int PrID, string Name, string Remark, string CID)
{
SYS_Role Role_table = new SYS_Role();
Role_table.Name = Name;
Role_table.ProgramId = PrID;
Role_table.Remark = Remark;
Role_table.CreatorID = CID;
Role_table.CreatedTime = DateTime.Now;
Database.SYS_Role.Add(Role_table);
return(Database.SaveChanges());
}
public HttpResponseMessage Post([FromBody] SYS_Role value)
{
try
{
var result = context.Create(value);
return(Request.CreateResponse(HttpStatusCode.OK, result));
}
catch (Exception e)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, e.Message));
}
}
public HttpResponseMessage Put(string id, [FromBody] SYS_Role value)
{
try
{
var result = context.Update(id, value);
return(Request.CreateResponse(HttpStatusCode.OK, result ? value : null));
}
catch (Exception e)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, e.Message));
}
}
/// <summary>
/// 修改角色以及角色对应菜单
/// </summary>
/// <param name="RoleCode">角色编号</param>
/// <param name="RoleName">角色名称</param>
/// <param name="RoleDesc">角色描述</param>
/// <param name="strPrivCode">菜单编号</param>
/// <returns></returns>
public ActionResult ModifyCfg(string RoleCode, string RoleName, string RoleDesc, string strPrivCode)
{
try
{
#region 1.修改角色信息基础表
SYS_Role role = new SYS_Role();
role.RoleCode = RoleCode;
role.RoleName = RoleName;
role.RoleDesc = RoleDesc;
op.UpdateRole(role);
#endregion
#region 2.更新角色对应菜单关系表
//1.先把该角色下的权限全部删除
op.DeleteRoleProgPrivByRoleCode(RoleCode);
//2.新增角色对应菜单关系
string[] privCodeList = strPrivCode.Split(';');
foreach (string privCode in privCodeList)
{
if (string.IsNullOrEmpty(privCode))
{
continue;
}
var progPriv = op.GetProgPrivByProgCode(privCode);
if (progPriv == null)
{
return(Json(new { state = "error", message = string.Format("Modification failed! Reason: the menu number [{0}] is in the SYS_ProgPriv Does not exist in the table", privCode) }));
}
SYS_RoleProgPriv RoleProgPriv = new SYS_RoleProgPriv();
RoleProgPriv.RoleCode = RoleCode;
RoleProgPriv.PrivCode = progPriv.PrivCode;
RoleProgPriv.LatestModifyUserAccount = this.UserID;
RoleProgPriv.LatestModifyTime = DateTime.Now;
RoleProgPriv.LatestModifyMachine = this.MachineName;
RoleProgPriv.CreateUserAccount = this.UserID;
RoleProgPriv.CreateMachine = this.MachineName;
RoleProgPriv.CreateTime = DateTime.Now;
op.InsertRoleProgPriv(RoleProgPriv);
}
#endregion
return(Json(new { state = "success", message = "Submitted successfully！" }));
}
catch (Exception ex)
{
return(Json(new { state = "error", message = ex.Message }));
}
}
public int BAL_SYS_Role_Update(SYS_Role SYS_Role, string mode)
{
DAL_SYS_Role = new DataAccess();
arrParameter = new ArrayList();
arrParameter.Add(new parameter("mode", mode));
arrParameter.Add(new parameter("RoleID", SYS_Role.roleid));
arrParameter.Add(new parameter("Role", SYS_Role.role));
arrParameter.Add(new parameter("Description", SYS_Role.description));
arrParameter.Add(new parameter("CreatedBy", SYS_Role.createdby));
arrParameter.Add(new parameter("ModifiedBy", SYS_Role.modifiedby));
return(DAL_SYS_Role.DAL_InsertUpdate_Return("Proc_SYS_RoleInsertUpdate", arrParameter));
}
/// <summary>
/// Action执行之前调用
/// </summary>
/// <param name="filterContext"></param>
public override void OnActionExecuting(ActionExecutingContext filterContext)
{
base.OnActionExecuting(filterContext);
SYS_Role role = (filterContext.HttpContext.Session["SYSUSER"] as SYS_User).SYS_Role;
if (!role.RoleSign.Equals("SYS_ADMIN"))
{
if (!role.CheckRight(Message))
{
filterContext.HttpContext.Response.Write(ReturnMsg);
}
}
//filterContext.HttpContext.Response.Write("Action执行之前" + Message + "<br />");
}
public ServiceResult Add(SYS_Role model)
{
var result = new ServiceResult();
var eff = this.roleRepository.AddIfNotExists(model, r => r.RoleName == model.RoleName && r.SystemRoleId != model.SystemRoleId);
if (eff > 0)
{
return(result.IsSucceed("添加角色成功"));
}
else
{
return(result.IsFailed("添加角色失败，已存在同名角色"));
}
}
public BaseResponse <RoleModel> SaveRole(RoleModel request)
{
BaseResponse <RoleModel> response = new BaseResponse <RoleModel>()
{
Data = request
};
var role = base.unitOfWork.GetRepository <SYS_Role>();
SYS_Role model;
if (request.RoleID > 0)
{
model = role.dbSet.FirstOrDefault(f => f.RoleID == request.RoleID && f.IsDeleted == false);
if (model != null)
{
model.DefaultPage = request.DefaultPage;
model.Description = request.Description;
model.RoleName = request.RoleName;
role.Update(model);
}
else
{
response.IsSuccess = false;
return(response);
}
}
else
{
model = role.dbSet.FirstOrDefault(f => f.RoleNo == request.RoleNo && f.IsDeleted == false);
if (model != null)
{
response.IsSuccess = false;
response.ResultMessage = string.Format("{0} {1} 已存在", request.RoleNo, request.RoleName);
return(response);
}
model = new SYS_Role
{
RoleNo = GenerateCode(EnumCodeKey.RoleCode, EnumCodeRule.None, "R", 3, 0),
DefaultPage = request.DefaultPage,
Description = request.Description,
IsDeleted = false,
RoleName = request.RoleName
};
role.Insert(model);
base.unitOfWork.Save();
}
SaveMenu(model.RoleID, request);
return(response);
}
public void BindRolesForUserList(DropDownList DDl, SYS_Role Role)
{
DataSet dsRole = new DataSet();
dsRole = this.BAL_SelectRoles_ForUserList(Role);
if (dsRole.Tables[0].Rows.Count > 0)
{
DDl.DataSource = dsRole;
DDl.DataTextField = "Role";
DDl.DataValueField = "RoleID";
DDl.DataBind();
}
DDl.Items.Insert(0, "-- Select --");
DDl.Items[0].Value = "0";
}
/// <summary>
/// 新增角色
/// </summary>
/// <param name="role">角色对象</param>
/// <returns></returns>
public bool InsertRole(SYS_Role role)
{
try
{
using (var db = base.GDDSVSPDb)
{
db.SYS_Role.Add(role);
return(db.SaveChanges() > 0);
}
}
catch (DbEntityValidationException ex)
{
throw ex;
}
}
