// PUT: api/Role/5
public void Put(int id, [FromBody] T_Roles value)
{
T_Roles r = dalobj.T_Roles.Find(id);
r.RoleName = value.RoleName;
dalobj.SaveChanges();
}
// DELETE: api/Role/5
public void Delete(int id)
{
T_Roles r = dalobj.T_Roles.Find(id);
dalobj.T_Roles.Remove(r);
dalobj.SaveChanges();
}
//修改选中已选择的角色
private void SelectRight(long rolesId)
{
T_Roles roles = rolesBLL.SelectForID(rolesId);
if (roles != null)
{
//显示待修改的角色
txtRolesId.Value = roles.RoleId.ToString();
txtRoles.Text = roles.RoleName;
txtRoles.ReadOnly = true;
//选中当前角色所属的权限
List <T_RolesRight> rolesRightList = rolesRightBLL.SelectAll().Where(p => p.RolesId == rolesId).ToList <T_RolesRight>();
if (rolesRightList != null && rolesRightList.Count() > 0)
{
foreach (ListItem item in listRights.Items)
{
if (rolesRightList.Exists(p => p.RightId.ToString() == item.Value))
{
item.Selected = true;
}
}
}
}
}
/// <summary>
/// 根据主键删除 T_Roles 表数据
/// </summary>
/// <param name=id>主键</param>
public bool Delete(System.Int64 id)
{
T_Roles info = new T_Roles();
info.RoleId = id;
return(dal.Delete(info));
}
/// <summary>
/// 根据主键查询一个实体
/// </summary>
/// <param name=id>主键</param>
public T_Roles SelectForID(System.Int64 id)
{
T_Roles info = new T_Roles();
info.RoleId = id;
dal.SelectForID(info);
return(info);
}
public ActionResult Save(T_Roles model)
{
li = trolesbl.Save(model);
this.KeyID = Tools.getGuidString(model.uRoles_ID);
if (!db.Commit(li))
{
throw new MessageBox(db.ErrorMessge);
}
return(Json(new { status = 1, ID = KeyID }, JsonRequestBehavior.DenyGet));
}
// GET: api/Roles/5
public Response Get(int id)
{
T_Roles roleToFind = dalobj.T_Roles.Find(id);
response.Data = roleToFind;
response.Status = "success";
response.Err = null;
logger.Log(" Displayed Specify Role using roleid");
return(response);
}
/// <summary>
/// 获取实体
/// </summary>
/// <param name="ID"></param>
/// <returns></returns>
public Dictionary <string, object> Find(Guid ID)
{
troles = db.Find <T_Roles>(f => f.uRoles_ID == Tools.getGuid(ID));
var di = new ToJson().GetDictionary(new Dictionary <string, object>()
{
{ "troles", troles },
{ "status", 1 }
});
return(di);
}
// POST: api/Roles
public Response Post([FromBody] T_Roles role)
{
//dalObj.T_Roles.Add(role);
//dalObj.SaveChanges();
dalObj.Proc_AddRole(role.RoleName);
response.Data = null;
response.Status = "Success";
response.Error = null;
logger.Log("Added new roles");
return(response);
}
// PUT: api/Roles/5
public Response Put(int id, [FromBody] T_Roles roles)
{
//T_Roles roleobj = dalObj.T_Roles.Find(id);
//roleobj.RoleName = roles.RoleName;
//dalObj.SaveChanges();
dalObj.Proc_ModifyRole(id, roles.RoleName);
response.Data = null;
response.Status = "Success";
response.Error = null;
logger.Log("Roles Edited");
return(response);
}
public bool AddRole(T_Roles role)
{
try
{
dalobj.T_Roles.Add(role);
dalobj.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
public bool UpadteRole(T_Roles role)
{
try
{
T_Roles URole = dalobj.T_Roles.Find(role.RoleId);
URole.RoleName = role.RoleName;
dalobj.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
public bool DeleteRole(int id)
{
try
{
T_Roles DRole = dalobj.T_Roles.Find(id);
dalobj.T_Roles.Remove(DRole);
dalobj.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
/// <summary>
/// 角色权限分配
/// </summary>
/// <param name="roles">当前操作的角色</param>
/// <param name="RightsIds">权限id集合</param>
/// <returns></returns>
public T_Roles AddRolesForRights(T_Roles roles, List <long> RightsIds)
{
//using (TransactionScope scope = new TransactionScope())
//{
if (roles.RoleId > 0)//修改已有角色权限
{
//修改角色表
dal.Update(roles);
//根据角色id删除角色权限管理表数据
rolesRightDal.DeleteForRolesId(roles.RoleId);
//根据角色id重新生成角色权限关联
//分配角色关联
if (RightsIds != null && RightsIds.Count > 0)
{
foreach (var item in RightsIds)
{
rolesRightDal.Insert(new T_RolesRight
{
RightId = item,
RolesId = roles.RoleId
});
}
}
}
else//新增角色直接分配权限关联
{
//新增角色数据
int newRolesId = dal.InsertToID(roles);
roles.RoleId = newRolesId;
//分配角色关联
if (RightsIds != null && RightsIds.Count > 0)
{
foreach (var item in RightsIds)
{
rolesRightDal.Insert(new T_RolesRight
{
RightId = item,
RolesId = newRolesId
});
}
}
}
//scope.Complete();
//}
return(roles);
}
public void Delete(int id)
{
using (TimeTrackerEntities db = new TimeTrackerEntities())
{
try
{
T_Roles t_role = new T_Roles();
t_role = db.T_Roles.FirstOrDefault(p => p.Id == id);
db.T_Roles.Remove(t_role);
db.SaveChanges();
}
catch (Exception ex)
{
string msg = ex.Message;
}
}
}
/// <summary>
/// 获取实体
/// </summary>
/// <param name="ID"></param>
/// <returns></returns>
public Dictionary <string, object> Find(Guid ID)
{
tuser = db.Find <T_Users>(w => w.uUsers_ID == ID);
tuserrole = db.Find <T_UsersRoles>(w => w.uUsersRoles_UsersID == tuser.uUsers_ID);
troles = db.Find <T_Roles>(w => w.uRoles_ID == tuserrole.uUsersRoles_RoleID);
tuser.cUsers_LoginPwd = "";
var di = new ToJson().GetDictionary(new Dictionary <string, object>()
{
{ "tuser", tuser },
{ "troles", troles },
{ "status", 1 }
});
di["dUsers_CreateTime"] = di["dUsers_CreateTime"].To_DateTimeString();
return(di);
}
public ActionResult Checked(string username, string userpwd, string loginCode)
{
if (string.IsNullOrEmpty(username))
{
throw new MessageBox("请输入用户名", 500);
}
if (string.IsNullOrEmpty(userpwd))
{
throw new MessageBox("请输入密码", 500);
}
//if (string.IsNullOrEmpty(loginCode))
// throw new MessageBox("请输入验证码", 500);
user = db.Find <T_Users>(w => w.cUsers_LoginName == "admin");
if (Tools.getGuid(user.uUsers_ID).Equals(Guid.Empty))
{
throw new MessageBox("用户不存在", 500);
}
if (!Tools.getString(user.cUsers_LoginPwd).Trim().Equals(userpwd))//Tools.MD5Encrypt(userpwd)))//
{
throw new MessageBox("密码错误", 500);
}
//string code = Tools.GetCookie("loginCode");
//if (string.IsNullOrEmpty(code))
// throw new MessageBox("验证码失效", 500);
//if (!code.ToLower().Equals(loginCode))
// throw new MessageBox("验证码不正确", 500);
tuserroles = db.Find <T_UsersRoles>(w => w.uUsersRoles_UsersID == user.uUsers_ID);
troles = db.Find <T_Roles>(w => w.uRoles_ID == tuserroles.uUsersRoles_RoleID);
Session["UserID"] = user.uUsers_ID;
if (user.cUsers_LoginName.Equals("admin"))
{
Session["RoleID"] = "admin";
}
else
{
Session["RoleID"] = tuserroles.uUsersRoles_RoleID;
}
return(Json(new { status = 1, jumpurl = "/Admin/Home/" }, JsonRequestBehavior.DenyGet));
}
/// <summary>
/// 保存
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public List <SQL> Save(T_Roles model)
{
troles = model;
if (Tools.getGuid(model.uRoles_ID).Equals(Guid.Empty))
{
model.uRoles_ID = Tools.getGuid(db.Add(troles, li));
if (model.uRoles_ID.Equals(Guid.Empty))
{
throw new MessageBox(db.ErrorMessge);
}
}
else
{
if (!db.Edit(troles, item => item.uRoles_ID == troles.uRoles_ID, li))
{
throw new MessageBox(db.ErrorMessge);
}
}
return(li);
}
// PUT: api/Roles/5
public Response Put(int id, [FromBody] T_Roles role)
{
//T_Roles roleToBeUpdated = dalobj.T_Roles.Find(id);
// roleToBeUpdated.RoleName = role.RoleName;
// dalobj.SaveChanges();
try
{
dalobj.proc_ModifyRole(id, role.RoleName);
logger.Log("Role updated.");
response.Status = "success";
return(response);
}
catch (Exception cause)
{
response.Err = cause;
response.Status = "Failed. cause : " + cause.Message;
response.Data = null;
logger.Log("Exception occured while updating Role db");
return(response);
}
}
// POST: api/Roles
public Response Post([FromBody] T_Roles role)
{
//dalobj.T_Roles.Add(role);
//dalobj.SaveChanges();
try
{
dalobj.proc_AddRole(role.RoleName);
response.Err = null;
response.Status = "success";
response.Data = null;
logger.Log("Role Added in db");
return(response);
}
catch (Exception cause)
{
response.Err = cause;
response.Status = "Failed. cause : " + cause.Message;
response.Data = null;
logger.Log("Exception occured while inserting Role db");
return(response);
}
}
// POST: api/Role
public void Post([FromBody] T_Roles rol)
{
dalobj.proc_AddRole(rol.RoleName);
}
// PUT: api/Role/5
public void Put(int id, [FromBody] T_Roles role)
{
// obj.proc_ModifyRole(role.RoleName,id);
}
// POST: api/Role
public void Post([FromBody] T_Roles value)
{
dalobj.T_Roles.Add(value);
dalobj.SaveChanges();
}
// PUT: api/Role/5
public void Put(int id, [FromBody] T_Roles rol)
{
dalobj.proc_ModifyRole(id, rol.RoleName);
}
// PUT: api/Role/5
public void Put(int id, [FromBody] T_Roles t)
{
dalobject.proc_ModifyRole(id, t.RoleName);
}
public void Post([FromBody] T_Roles t)
{
dalobject.proc_AddRole(t.RoleName);
}
// GET: api/Role/5
public T_Roles Get(int id)
{
T_Roles u = dalobj.T_Roles.Find(id);
return(u);
}
private T_Roles InsertParse(Roles role)
{
T_Roles t_role = new T_Roles();
t_role.Description = role.Description;
t_role.Rank = role.Rank;
t_role.CreateDate = role.CreateDate;
t_role.LastUpdateDate = role.LastUpdateDate;
t_role.CreatedBy = role.CreatedBy;
t_role.LastUpdatedBy = role.LastUpdatedBy;
t_role.IsSupervisor = role.IsSupervisor;
return t_role;
}
// POST: api/Role
public void Post([FromBody] T_Roles role)
{
obj.T_Roles.Add(role);
obj.SaveChanges();
}
private void UpdateParse(T_Roles t_role, Roles role)
{
t_role.Description = role.Description;
t_role.Rank = role.Rank;
t_role.LastUpdateDate = role.LastUpdateDate;
t_role.LastUpdatedBy = role.LastUpdatedBy;
t_role.IsSupervisor = role.IsSupervisor;
}
//添加角色,分配权限
protected void btnAddRoles_Click(object sender, EventArgs e)
{
T_Logs log = LogHelper.GetLog();
string rolesName = txtRoles.Text;
if (!string.IsNullOrEmpty(rolesName))
{
try
{
long rid = 0;
long.TryParse(txtRolesId.Value, out rid);
//新增判断角色名是否存在
if (rid == 0)
{
var roles = rolesBLL.SelectAll().FirstOrDefault(p => p.RoleName == rolesName);
if (roles != null)
{
JsAlertClose("角色名已经存在，请勿重复添加！");
}
}
//当前角色
var newRoles = new T_Roles
{
CreateDate = DateTime.Now,
RoleName = rolesName
};
//修改需要指定主键id
if (rid > 0)
{
newRoles.RoleId = rid;
}
List <long> rightIds = null;
//选中的权限id
if (listRights != null && listRights.Items.Count > 0)
{
rightIds = new List <long>();
foreach (ListItem item in listRights.Items)
{
if (item.Selected && !string.IsNullOrEmpty(item.Value))
{
rightIds.Add(Convert.ToInt64(item.Value));
}
}
}
T_Roles resultRoles = rolesBLL.AddRolesForRights(newRoles, rightIds);
if (resultRoles.RoleId > 0)
{
JsAlert(string.Format("编辑【{0}】,保存成功！", rolesName), successUrl);
log.LogContext = string.Format("编辑角色名【{0}】保存成功！", rolesName);
}
else
{
JsAlert(string.Format("编辑【{0}】保存失败！", rolesName), failUrl);
log.LogContext = string.Format("编辑角色名 【{0}】保存失败！", rolesName);
}
LogHelper.WriteOperationLog(log);
}
catch (Exception ex)
{
log.LogContext = string.Format("编辑角色名【{0}】，服务器异常", rolesName);
LogHelper.WriteOperationLog(log);
JsAlert(ex.Message, failUrl);
}
}
else
{
JsAlert("请填写角色名", failUrl);
}
}
/// <summary>
/// 根据主键修改 T_Roles 表数据
/// </summary>
/// <param name=info>T_Roles 实体对象</param>
public bool Update(T_Roles info)
{
return(dal.Update(info));
}
/// <summary>
/// 新增 T_Roles 表数据
/// </summary>
/// <param name=info>T_Roles 实体对象</param>
public bool Insert(T_Roles info)
{
return(dal.Insert(info));
}
