public ActionResult Login()
{
try
{
if (Session["UserLogin"] != null)
{
using (DBEntities db = new DBEntities())
{
UserDTO UserLogin = (UserDTO)Session["UserLogin"];
TB_ROLE Tb_Role = db.TB_ROLE.FirstOrDefault(r => r.ROLE_ID == UserLogin.ROLE_ID);
if (Tb_Role != null)
{
return(Redirect("~/"));
}
else
{
return(Redirect("~/auth/login"));
}
}
}
else
{
ViewBag.DataView = new Dictionary <string, string>()
{
{ "title", "Login" }
};
return(View("Login"));
}
}
catch (Exception)
{
return(Redirect("~/auth/error"));
}
}
public ActionResult Create()
{
if (Session["last_user_id"] == null)
{
return(RedirectToAction("Index", "Login"));
}
string user_id = (string)Session["last_user_id"];
if (!p_helper.hasPermission("0106", user_id))
{
return(RedirectToAction("Index", "Login"));
}
IPERMISSION bll = Bll_Utilitity.GetPermission();
IEnumerable <TB_PERMISSION> list = bll.ListAll();
Dictionary <string, bool> checkState = new Dictionary <string, bool>();
foreach (TB_PERMISSION bean in list)
{
checkState.Add(bean.PERMISSION_ID, false);
}
TB_ROLE role = new TB_ROLE();
role.PERMISSION_LIST = list;
ViewData["role"] = role;
ViewData["check_state"] = checkState;
return(View());
}
public ActionResult Details(TB_ROLE role)
{
IPERMISSION bll = Bll_Utilitity.GetPermission();
IEnumerable <TB_PERMISSION> list = bll.ListAll();
Dictionary <string, bool> checkState = new Dictionary <string, bool>();
IROLEPERMISSION rp_bll = Bll_Utilitity.GetRolePermission();
IEnumerable <string> permission_ids = rp_bll.GetPermissionIds(role.ROLE_ID);
IROLE r_bll = Bll_Utilitity.GetRole();
role = r_bll.Get(role.ROLE_ID);
role.PERMISSION_LIST = list;
ViewData["role"] = role;
IList <string> permission_id_list = permission_ids as IList <string>;
foreach (TB_PERMISSION bean in list)
{
checkState.Add(bean.PERMISSION_ID, false);
}
foreach (string p_id in permission_id_list)
{
if (checkState.ContainsKey(p_id))
{
checkState[p_id] = true;
}
}
ViewData["check_state"] = checkState;
return(View());
}
public ActionResult DeleteConfirmed(decimal id)
{
if (Session["USER"] == null)
{
return(RedirectToAction("../Account/ManagementLogin"));
}
TB_ROLE tb_role = db.TB_ROLE.Single(t => t.ID == id);
db.TB_ROLE.Remove(tb_role);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public override void OnAuthorization(AuthorizationContext filterContext)
{
var Context = filterContext.RequestContext.HttpContext;
try
{
if (Context.Session["UserLogin"] == null)
{
Context.Response.Redirect("~/auth/login");
}
else
{
UserDTO UserLogin = (UserDTO)Context.Session["UserLogin"];
//get session and prosess match betwen menu, sub menu and user role
using (DBEntities db = new DBEntities())
{
//get tb_role base on role id in session user login
TB_ROLE UserRole = db.TB_ROLE.FirstOrDefault(r => r.ROLE_ID == UserLogin.ROLE_ID);
string[] url = filterContext.HttpContext.Request.RawUrl.ToString().Split('/');
string Title_Menu = url[2];
if (Title_Menu.ToLower() == "dashboard")
{
Context.Response.Redirect("~/dashboard");
}
else
{
if (Title_Menu == "" || Title_Menu == null)
{
Context.Response.Redirect("~");
}
TB_MENU Tb_Menu = db.TB_MENU.FirstOrDefault(m => m.TITLE_MENU == Title_Menu);
TB_ACCESS_MENU Access_Menu = db.TB_ACCESS_MENU.FirstOrDefault(am => (am.MENU_ID == Tb_Menu.MENU_ID && am.ROLE_ID == UserRole.ROLE_ID));
//cheking access based role user and tb_access_menu
if (Access_Menu == null)
{
throw new Exception();
}
}
};
Thread.CurrentPrincipal = new GenericPrincipal(new GenericIdentity(UserLogin.USERNAME), null);
}
}
catch (Exception e)
{
string msg = e.Message.Replace('\n', ' ') + e.StackTrace.Replace('\n', ' ');
Context.Response.Redirect("~/auth/error?msg=" + (ConfigurationManager.AppSettings["env"].ToString().Equals("development") ? msg : " "));
}
Thread.CurrentPrincipal = new GenericPrincipal(new GenericIdentity("null"), null);
base.OnAuthorization(filterContext);
}
public void Update(TB_ROLE m_TB_ROLE)
{
string sql = "";
sql = "update [TB_ROLE] set [ROLE_NAME]={@ROLE_NAME} where [ROLE_ID] = {@ROLE_ID} ";
sql = sql.Replace("{@ROLE_ID}", Common.sqlNull(m_TB_ROLE.ROLE_ID));
sql = sql.Replace("{@ROLE_NAME}", Common.sqlNull(m_TB_ROLE.ROLE_NAME));
using (var conn = Common.GetSqlConnection())
{
var n = conn.Execute(sql);
}
}
public TB_ROLE Get(string ROLE_ID)
{
TB_ROLE m_TB_ROLE = null;
using (var conn = Common.GetSqlConnection())
{
String sql = "select [ROLE_ID],[ROLE_NAME] from [TB_ROLE] where [ROLE_ID]={@ROLE_ID}";
sql = sql.Replace("{@ROLE_ID}", Common.sqlNull(ROLE_ID));
var list = conn.Query <TB_ROLE>(sql).ToList();
m_TB_ROLE = list.FirstOrDefault();
}
return(m_TB_ROLE);
}
//
// GET: /Role/Edit/5
public ActionResult Edit(decimal id = 0)
{
if (Session["USER"] == null)
{
return(RedirectToAction("../Account/ManagementLogin"));
}
TB_ROLE tb_role = db.TB_ROLE.Single(t => t.ID == id);
if (tb_role == null)
{
return(HttpNotFound());
}
return(View(tb_role));
}
public void Insert(TB_ROLE m_TB_ROLE)
{
String sql = "insert into TB_ROLE";
sql += "(ROLE_ID,ROLE_NAME)";
sql += " values(";
sql += Common.sqlNull(m_TB_ROLE.ROLE_ID);
sql += ",";
sql += Common.sqlNull(m_TB_ROLE.ROLE_NAME);
sql += ");";
using (var conn = Common.GetSqlConnection())
{
var n = conn.Execute(sql);
}
}
public ActionResult Create(TB_ROLE tb_role)
{
if (Session["USER"] == null)
{
return(RedirectToAction("../Account/ManagementLogin"));
}
if (ModelState.IsValid)
{
db.TB_ROLE.Add(tb_role);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tb_role));
}
public IQueryable <TB_MENU> GetMenusByRole(TB_ROLE oRole)
{
var queryrole = UnitOfWork.context.Set <TB_ROLE>().AsQueryable();
var querymenu = UnitOfWork.context.Set <TB_MENU>().AsQueryable();
var querymenurole = UnitOfWork.context.Set <TB_MENUROLE>().AsQueryable();
var lstres = from menu in querymenu
from menurole in querymenurole
from role in queryrole
where menu.MENU_ID == menurole.MENU_ID &&
menurole.ROLE_ID == role.ROLE_ID &&
role.ROLE_ID == oRole.ROLE_ID
select menu;
return(lstres);
}
public void AssignPower(TB_USERS oUser, TB_ROLE oRole)
{
if (oUser == null || oRole == null)
{
return;
}
var oUserRole = _userroleRepository.Find(x => x.USER_ID == oUser.USER_ID && x.ROLE_ID == oRole.ROLE_ID).FirstOrDefault();
if (oUserRole == null)
{
oUserRole = new TB_USERROLE();
oUserRole.ROLE_ID = oRole.ROLE_ID;
oUserRole.USER_ID = oUser.USER_ID;
oUserRole.ID = 0001;
_userroleRepository.Insert(oUserRole);
}
}
public override void OnAuthorization(AuthorizationContext filterContext)
{
var Context = filterContext.RequestContext.HttpContext;
try
{
if (Context.Session["UserLogin"] == null)
{
Context.Response.Redirect("~/auth/login");
}
else
{
UserDTO UserLogin = (UserDTO)Context.Session["UserLogin"];
//get session and prosess match betwen menu, sub menu and user role
using (DBEntities db = new DBEntities())
{
//get tb_role base on role id in session user login
TB_ROLE UserRole = db.TB_ROLE.FirstOrDefault(r => r.ROLE_ID == UserLogin.ROLE_ID);
string[] url = filterContext.HttpContext.Request.RawUrl.ToString().Split('/');
string Title_Menu = url[1];
if (Title_Menu == "" || Title_Menu == null)
{
Context.Response.Redirect("~");
}
TB_MENU Tb_Menu = db.TB_MENU.FirstOrDefault(m => m.TITLE_MENU == Title_Menu);
TB_ACCESS_MENU Access_Menu = db.TB_ACCESS_MENU.FirstOrDefault(am => (am.MENU_ID == Tb_Menu.MENU_ID && am.ROLE_ID == UserRole.ROLE_ID));
//cheking access based role user and tb_access_menu
if (Access_Menu == null)
{
throw new Exception();
}
};
Thread.CurrentPrincipal = new GenericPrincipal(new GenericIdentity(UserLogin.USERNAME), null);
}
}
catch (Exception)
{
Context.Response.Redirect("~/auth/error");
}
Thread.CurrentPrincipal = new GenericPrincipal(new GenericIdentity("null"), null);
base.OnAuthorization(filterContext);
}
public ActionResult Edit(TB_ROLE tb_role)
{
if (Session["USER"] == null)
{
return(RedirectToAction("../Account/ManagementLogin"));
}
if (ModelState.IsValid)
{
var _update = db.TB_ROLE.FirstOrDefault(f => f.ID == tb_role.ID);
if (_update != null)
{
_update.NAME = tb_role.NAME;
_update.STATUS = tb_role.STATUS;
_update.DESCRIPTON = tb_role.DESCRIPTON;
}
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tb_role));
}
public ActionResult Edit(TB_ROLE role)
{
if (Session["last_user_id"] == null)
{
return(RedirectToAction("Index", "Login"));
}
string user_id = (string)Session["last_user_id"];
if (!p_helper.hasPermission("0107", user_id))
{
return(RedirectToAction("Index", "Login"));
}
IPERMISSION bll = Bll_Utilitity.GetPermission();
IEnumerable <TB_PERMISSION> list = bll.ListAll();
Dictionary <string, bool> checkState = new Dictionary <string, bool>();
IROLEPERMISSION rp_bll = Bll_Utilitity.GetRolePermission();
IEnumerable <string> permission_ids = rp_bll.GetPermissionIds(role.ROLE_ID);
IROLE r_bll = Bll_Utilitity.GetRole();
role = r_bll.Get(role.ROLE_ID);
role.PERMISSION_LIST = list;
ViewData["role"] = role;
IList <string> permission_id_list = permission_ids as IList <string>;
foreach (TB_PERMISSION bean in list)
{
checkState.Add(bean.PERMISSION_ID, false);
}
foreach (string p_id in permission_id_list)
{
if (checkState.ContainsKey(p_id))
{
checkState[p_id] = true;
}
}
ViewData["check_state"] = checkState;
return(View());
}
static void Main(string[] args)
{
var oProgram = new Program();
Regisgter.regisgter().ComposeParts(oProgram);
var oUser = new TB_USERS()
{
USER_ID = "04acd48a819447d388b20dffb15f672e"
};
var oRole = new TB_ROLE()
{
ROLE_ID = "cccc"
};
oProgram.powerDomainService.AssignPower(oUser, oRole);
var oBootstrapper = new Bootstrapper();
oBootstrapper.StartServices();
Console.ReadKey();
}
public IEnumerable <TB_USERS> GetUsersByRole(TB_ROLE oRole)
{
throw new NotImplementedException();
}
public IEnumerable <TB_ROLE> GetList(int pageId, int pageSize, out int total)
{
total = 0;
if (pageId <= 0)
{
pageId = 1;
}
if (pageSize <= 0)
{
pageSize = 10;
}
DataTable dt = new DataTable();
string sql = "";
string sqlWhere = " where 1=1 ";
string sqlOrder = " order by ROLE_ID ";
using (
SqlConnection conn = new SqlConnection(DbConfig.connStr))
{
conn.Open();
sql = "select [ROLE_ID],[ROLE_NAME] from [TB_ROLE]" + sqlWhere + sqlOrder;
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "p_splitpage";
SqlParameter pa_sql = new SqlParameter("@sql", sql);
SqlParameter pa_page = new SqlParameter("@page", pageId);
SqlParameter pa_pageSize = new SqlParameter("@pageSize", pageSize);
SqlParameter pa_pageCount = new SqlParameter();
{
pa_pageCount.ParameterName = "@pageCount";
pa_pageCount.Direction = ParameterDirection.InputOutput;
pa_pageCount.DbType = DbType.Int32;
pa_pageCount.Value = 0;
}
SqlParameter pa_recordCount = new SqlParameter();
{
pa_recordCount.ParameterName = "@recordCount";
pa_recordCount.Direction = ParameterDirection.InputOutput;
pa_recordCount.DbType = DbType.Int32;
pa_recordCount.Value = 0;
}
SqlParameter pa_searchTime = new SqlParameter();
{
pa_searchTime.ParameterName = "@SearchTime";
pa_searchTime.Direction = ParameterDirection.InputOutput;
pa_searchTime.DbType = DbType.Int32;
pa_searchTime.Value = 0;
}
cmd.Parameters.Add(pa_sql);
cmd.Parameters.Add(pa_page);
cmd.Parameters.Add(pa_pageSize);
cmd.Parameters.Add(pa_pageCount);
cmd.Parameters.Add(pa_recordCount);
cmd.Parameters.Add(pa_searchTime);
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adapter.Fill(ds);
dt = ds.Tables[1];
total = Convert.ToInt32(pa_recordCount.Value);
}
conn.Close();
}
IList <TB_ROLE> list = new List <TB_ROLE>();
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow row = dt.Rows[i];
TB_ROLE m = new TB_ROLE();
m.ROLE_ID = dt.Rows[i]["ROLE_ID"] as string;
m.ROLE_NAME = dt.Rows[i]["ROLE_NAME"] as string;
list.Add(m);
}
return(list as IEnumerable <TB_ROLE>);
}
public ActionResult Delete(TB_ROLE role)
{
if (Session["last_user_id"] == null)
{
return(RedirectToAction("Index", "Login"));
}
string user_id = (string)Session["last_user_id"];
if (!p_helper.hasPermission("0108", user_id))
{
return(RedirectToAction("Index", "Login"));
}
if (role == null)
{
return(RedirectToAction("Index", "ROLE"));
}
if (role.ROLE_ID == null)
{
return(RedirectToAction("Index", "ROLE"));
}
IROLE bll = Bll_Utilitity.GetRole();
IROLEPERMISSION rp_bll = Bll_Utilitity.GetRolePermission();
role = bll.Get(role.ROLE_ID);
if (role == null)
{
return(RedirectToAction("Index", "ROLE"));
}
if (role.ROLE_ID == null)
{
return(RedirectToAction("Index", "ROLE"));
}
if (CommonConfig.isForDemo && role.ROLE_ID.ToLower() == "admin")
{
TempData["ErrMsg"] = "演示版本，admin角色无法删除";
return(RedirectToAction("Index", "ROLE"));
}
IEnumerable <string> permissions_list = rp_bll.GetPermissionIds(role.ROLE_ID);
string permissions = "";
foreach (string t in permissions_list)
{
permissions = t + ",";
}
if (permissions.EndsWith(","))
{
permissions = permissions.Substring(0, permissions.Length - 1);
}
string change_content = "角色ID：" + role.ROLE_ID + ",角色名称：" + role.ROLE_NAME + ",角色权限："
+ permissions;
IList <String> list = new List <String>();
IEnumerable <String> p_list = list.AsEnumerable <String>();
rp_bll.Save(role.ROLE_ID, p_list);
bll.Delete(role.ROLE_ID);
IOPLOG op_bll = Bll_Utilitity.GetOpLog();
TB_OP_LOG log = new TB_OP_LOG();
log.OP_USER_ID = (string)Session["last_user_id"];
log.OPER_NAME = "角色删除";
log.OPER_IP = IpHelper.GetClientIP();
log.OPER_TIME = DateTime.Now;
log.OPER_DESC = "角色删除（" + change_content + "）";
op_bll.AddLog(log);
return(RedirectToAction("Index", "ROLE"));
}
public ActionResult CreateSave()
{
if (Session["last_user_id"] == null)
{
return(RedirectToAction("Index", "Login"));
}
string user_id = (string)Session["last_user_id"];
if (!p_helper.hasPermission("0106", user_id))
{
return(RedirectToAction("Index", "Login"));
}
IROLEPERMISSION rp_bll = Bll_Utilitity.GetRolePermission();
IPERMISSION p_bll = Bll_Utilitity.GetPermission();
IEnumerable <TB_PERMISSION> list_permission = p_bll.ListAll();
Dictionary <string, bool> checkState = new Dictionary <string, bool>();
foreach (TB_PERMISSION bean in list_permission)
{
checkState.Add(bean.PERMISSION_ID, false);
}
IROLE bll = Bll_Utilitity.GetRole();
string role_id = Request["role.ROLE_ID"];
string role_name = Request["role.ROLE_NAME"];
TB_ROLE role = new TB_ROLE();
role.ROLE_ID = role_id;
role.ROLE_NAME = role_name;
string permissions = Request["permission"];
string[] ps = null;
if (!String.IsNullOrEmpty(permissions))
{
ps = permissions.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries);
if (ps != null && ps.Length > 0)
{
for (int ii = 0; ii < ps.Length; ii++)
{
if (checkState.ContainsKey(ps[ii]))
{
checkState[ps[ii]] = true;
}
}
}
}
role.PERMISSION_LIST = list_permission;
bool isError = false;
if (string.IsNullOrEmpty(role_id))
{
ModelState.AddModelError("role.ROLE_ID", "角色ID不能为空");
isError = true;
}
if (string.IsNullOrEmpty(role_name))
{
ModelState.AddModelError("role.ROLE_NAME", "角色名称不能为空");
isError = true;
}
if (isError)
{
ViewData["role"] = role;
ViewData["check_state"] = checkState;
return(View("Create"));
}
bll.Insert(role);
string change_content = "角色ID：" + role.ROLE_ID + ",角色名称：" + role.ROLE_NAME + ",角色权限："
+ permissions;
IOPLOG op_bll = Bll_Utilitity.GetOpLog();
TB_OP_LOG log = new TB_OP_LOG();
log.OP_USER_ID = (string)Session["last_user_id"];
log.OPER_NAME = "角色添加";
log.OPER_IP = IpHelper.GetClientIP();
log.OPER_TIME = DateTime.Now;
log.OPER_DESC = "角色添加（" + change_content + "）";
op_bll.AddLog(log);
IList <String> list = new List <String>();
if (ps != null)
{
foreach (string permission_id in ps)
{
list.Add(permission_id);
}
}
rp_bll.Save(role.ROLE_ID, list);
return(RedirectToAction("Index", "Role"));
}
public ActionResult EditSave()
{
if (Session["last_user_id"] == null)
{
return(RedirectToAction("Index", "Login"));
}
string user_id = (string)Session["last_user_id"];
if (!p_helper.hasPermission("0107", user_id))
{
return(RedirectToAction("Index", "Login"));
}
IROLEPERMISSION rp_bll = Bll_Utilitity.GetRolePermission();
IPERMISSION p_bll = Bll_Utilitity.GetPermission();
IEnumerable <TB_PERMISSION> list_permission = p_bll.ListAll();
Dictionary <string, bool> checkState = new Dictionary <string, bool>();
foreach (TB_PERMISSION bean in list_permission)
{
checkState.Add(bean.PERMISSION_ID, false);
}
IROLE bll = Bll_Utilitity.GetRole();
string role_id = Request["role.ROLE_ID"];
string role_name = Request["role.ROLE_NAME"];
if (CommonConfig.isForDemo && role_id.ToLower() == "admin")
{
TempData["ErrMsg"] = "演示版本，admin角色无法编辑";
return(RedirectToAction("Index", "ROLE"));
}
TB_ROLE role = new TB_ROLE();
role.ROLE_ID = role_id;
role.ROLE_NAME = role_name;
string permissions = Request["permission"];
string[] ps = null;
if (!String.IsNullOrEmpty(permissions))
{
ps = permissions.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries);
if (ps != null && ps.Length > 0)
{
for (int ii = 0; ii < ps.Length; ii++)
{
if (checkState.ContainsKey(ps[ii]))
{
checkState[ps[ii]] = true;
}
}
}
}
role.PERMISSION_LIST = list_permission;
string change_content = "";
TB_ROLE old_role = bll.Get(role.ROLE_ID);
if (old_role.ROLE_NAME != role.ROLE_NAME)
{
change_content += "角色名称，" + old_role.ROLE_NAME + "改为" + role.ROLE_NAME;
}
IEnumerable <string> permission_ids = rp_bll.GetPermissionIds(role.ROLE_ID);
IList <string> pa = new List <string>();
if (ps != null && ps.Length > 0)
{
pa = ps.ToList <string>();
}
IList <string> pb = permission_ids.ToList <string>();
string result = CollectionUtilitity.compare("原角色权限", "现角色权限", pa, pb);
if (result != "")
{
if (change_content != "")
{
change_content += "," + result;
}
}
bool isError = false;
if (string.IsNullOrEmpty(role_id))
{
ModelState.AddModelError("role.ROLE_ID", "角色ID不能为空");
isError = true;
}
if (string.IsNullOrEmpty(role_name))
{
ModelState.AddModelError("role.ROLE_NAME", "角色名称不能为空");
isError = true;
}
if (isError)
{
ViewData["role"] = role;
ViewData["check_state"] = checkState;
return(View("Edit"));
}
bll.Update(role);
IList <String> list = new List <String>();
if (ps != null)
{
foreach (string permission_id in ps)
{
list.Add(permission_id);
}
}
rp_bll.Save(role.ROLE_ID, list);
IOPLOG op_bll = Bll_Utilitity.GetOpLog();
TB_OP_LOG log = new TB_OP_LOG();
log.OP_USER_ID = (string)Session["last_user_id"];
log.OPER_NAME = "角色编辑";
log.OPER_IP = IpHelper.GetClientIP();
log.OPER_TIME = DateTime.Now;
log.OPER_DESC = "角色编辑（" + change_content + "）";
op_bll.AddLog(log);
return(RedirectToAction("Index", "Role"));
}
