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>);
}
