public ActionResult Details(TB_PERMISSION permission) { IPERMISSION bll = Bll_Utilitity.GetPermission(); permission = bll.Get(permission.PERMISSION_ID); return(View(permission)); }
public ActionResult CreateSave(TB_PERMISSION permission) { if (Session["last_user_id"] == null) { return(RedirectToAction("Index", "Login")); } string user_id = (string)Session["last_user_id"]; if (!p_helper.hasPermission("0102", user_id)) { return(RedirectToAction("Index", "Login")); } IPERMISSION bll = Bll_Utilitity.GetPermission(); bll.Insert(permission); 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 = string.Format("权限添加(权限编号:{0},权限名称:{1})", permission.PERMISSION_ID, permission.PERMISSION_NAME); op_bll.AddLog(log); return(RedirectToAction("Index", "Permission")); }
public void Update(TB_PERMISSION m_TB_PERMISSION) { string sql = ""; sql = "update [TB_PERMISSION] set [PERMISSION_NAME]={@PERMISSION_NAME},[PARENT_PERMISSION_ID]={@PARENT_PERMISSION_ID} where [PERMISSION_ID] = {@PERMISSION_ID} "; sql = sql.Replace("{@PERMISSION_ID}", Common.sqlNull(m_TB_PERMISSION.PERMISSION_ID)); sql = sql.Replace("{@PERMISSION_NAME}", Common.sqlNull(m_TB_PERMISSION.PERMISSION_NAME)); sql = sql.Replace("{@PARENT_PERMISSION_ID}", Common.sqlNull(m_TB_PERMISSION.PARENT_PERMISSION_ID)); using (var conn = Common.GetSqlConnection()) { var n = conn.Execute(sql); } }
public TB_PERMISSION Get(string PERMISSION_ID) { TB_PERMISSION m_TB_PERMISSION = null; using (var conn = Common.GetSqlConnection()) { String sql = "select [PERMISSION_ID],[PERMISSION_NAME],[PARENT_PERMISSION_ID] from [TB_PERMISSION] where [PERMISSION_ID]={@PERMISSION_ID}"; sql = sql.Replace("{@PERMISSION_ID}", Common.sqlNull(PERMISSION_ID)); var list = conn.Query <TB_PERMISSION>(sql).ToList(); m_TB_PERMISSION = list.FirstOrDefault(); } return(m_TB_PERMISSION); }
public ActionResult EditSave(TB_PERMISSION permission) { if (Session["last_user_id"] == null) { return(RedirectToAction("Index", "Login")); } string user_id = (string)Session["last_user_id"]; if (!p_helper.hasPermission("0103", user_id)) { return(RedirectToAction("Index", "Login")); } IPERMISSION bll = Bll_Utilitity.GetPermission(); TB_PERMISSION old_permission = bll.Get(permission.PERMISSION_ID); string change_content = ""; if (old_permission.PERMISSION_NAME != permission.PERMISSION_NAME) { change_content += "权限名称," + old_permission.PERMISSION_NAME + "改为" + permission.PERMISSION_NAME + ""; } if (old_permission.PARENT_PERMISSION_ID != permission.PARENT_PERMISSION_ID) { if (change_content != "") { change_content += ","; } change_content += "父权限ID," + old_permission.PARENT_PERMISSION_ID + "改为" + permission.PARENT_PERMISSION_ID + ""; } if (change_content != "") { bll.Update(permission); 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", "Permission")); }
public void Insert(TB_PERMISSION m_TB_PERMISSION) { String sql = "insert into TB_PERMISSION"; sql += "(PERMISSION_ID,PERMISSION_NAME,PARENT_PERMISSION_ID)"; sql += " values("; sql += Common.sqlNull(m_TB_PERMISSION.PERMISSION_ID); sql += ","; sql += Common.sqlNull(m_TB_PERMISSION.PERMISSION_NAME); sql += ","; sql += Common.sqlNull(m_TB_PERMISSION.PARENT_PERMISSION_ID); sql += ");"; using (var conn = Common.GetSqlConnection()) { var n = conn.Execute(sql); } }
public ActionResult Edit(TB_PERMISSION permission) { if (Session["last_user_id"] == null) { return(RedirectToAction("Index", "Login")); } string user_id = (string)Session["last_user_id"]; if (!p_helper.hasPermission("0103", user_id)) { return(RedirectToAction("Index", "Login")); } IPERMISSION bll = Bll_Utilitity.GetPermission(); permission = bll.Get(permission.PERMISSION_ID); if (permission == null) { return(RedirectToAction("Index", "Permission")); } IEnumerable <TB_PERMISSION> list = bll.ListAll(); list = addEmptyItemAndRemoveOne(list, permission); IEnumerable <SelectListItem> items = from value in list select new SelectListItem { Text = value.PERMISSION_NAME, Value = value.PERMISSION_ID, Selected = (value.PERMISSION_ID == permission.PARENT_PERMISSION_ID) }; ViewBag.PARENT_PERMISSION_ID = items; return(View(permission)); }
private IEnumerable <TB_PERMISSION> addEmptyItemAndRemoveOne(IEnumerable <TB_PERMISSION> ienum, TB_PERMISSION one) { IList <TB_PERMISSION> list = ienum as IList <TB_PERMISSION>; if (one != null) { for (int i = 0; i < list.Count; i++) { if (list[i].PERMISSION_ID == one.PERMISSION_ID) { list.RemoveAt(i); i--; } } } list.Add(new TB_PERMISSION() { PERMISSION_ID = "", PERMISSION_NAME = "", PARENT_PERMISSION_ID = "" }); return(list as IEnumerable <TB_PERMISSION>); }
public ActionResult Delete(TB_PERMISSION permission) { if (Session["last_user_id"] == null) { return(RedirectToAction("Index", "Login")); } string user_id = (string)Session["last_user_id"]; if (!p_helper.hasPermission("0104", user_id)) { return(RedirectToAction("Index", "Login")); } if (permission == null) { return(RedirectToAction("Index", "Permission")); } IPERMISSION bll = Bll_Utilitity.GetPermission(); permission = bll.Get(permission.PERMISSION_ID); if (permission == null) { ViewBag.ErrMsg = "未找到指定的权限"; int pageIndex = 1; if (Session["pageId"] != null) { pageIndex = (int)Session["pageId"]; } int total = 0; int pageSize = CommonConfig.admin_page_size; IEnumerable <TB_PERMISSION> list = bll.GetList(pageIndex, pageSize, out total); var pagedList = new StaticPagedList <TB_PERMISSION>(list, pageIndex, pageSize, total); Session["pageId"] = pageIndex; return(View("Index", pagedList)); } bool child_exist = bll.existsChild(permission.PERMISSION_ID); if (child_exist) { ViewBag.ErrMsg = "该项存在子权限,请先删除子权限再删除该项"; int pageIndex = 1; if (Session["pageId"] != null) { pageIndex = (int)Session["pageId"]; } int total = 0; int pageSize = CommonConfig.admin_page_size; IEnumerable <TB_PERMISSION> list = bll.GetList(pageIndex, pageSize, out total); var pagedList = new StaticPagedList <TB_PERMISSION>(list, pageIndex, pageSize, total); Session["pageId"] = pageIndex; return(View("Index", pagedList)); } bll.Delete(permission.PERMISSION_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 = string.Format("权限删除(权限编号:{0},权限名称:{1})", permission.PERMISSION_ID, permission.PERMISSION_NAME); op_bll.AddLog(log); return(RedirectToAction("Index", "Permission")); }
public IEnumerable <TB_PERMISSION> 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 PERMISSION_ID "; using ( SqlConnection conn = new SqlConnection(DbConfig.connStr)) { conn.Open(); sql = "select [PERMISSION_ID],[PERMISSION_NAME],[PARENT_PERMISSION_ID] from [TB_PERMISSION]" + 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_PERMISSION> list = new List <TB_PERMISSION>(); for (int i = 0; i < dt.Rows.Count; i++) { DataRow row = dt.Rows[i]; TB_PERMISSION m = new TB_PERMISSION(); m.PERMISSION_ID = dt.Rows[i]["PERMISSION_ID"] as string; m.PERMISSION_NAME = dt.Rows[i]["PERMISSION_NAME"] as string; if (dt.Rows[i]["PARENT_PERMISSION_ID"] != null) { m.PARENT_PERMISSION_ID = dt.Rows[i]["PARENT_PERMISSION_ID"] as string; } list.Add(m); } return(list as IEnumerable <TB_PERMISSION>); }