/// <summary> /// 获取指定权限的详细信息 /// </summary> /// <param name="actionid"></param> public ActionBLL(int actionid) : base() { _actionid = -1; ActionDAL dal = new ActionDAL(connectionString); RADinfo_MIS_COST.Model.Action model = dal.GetDetails(actionid); if (model != null) { _actionid = model.ActionId; _actionname = model.ActionName; _actionstr = model.ActionStr; _actioncolumnid = model.ActionColumnid; _link = model.Link; } }
/// <summary> /// 获取所有的权限 /// </summary> /// <returns></returns> public ArrayList GetActions() { ArrayList actions = new ArrayList(); using (SqlDataReader reader = RunProcedure("sp_GetAllAction", null)) { while (reader.Read()) { RADinfo_MIS_COST.Model.Action model = new RADinfo_MIS_COST.Model.Action(); model.ActionId = Convert.ToInt32(reader["actionid"]); model.ActionName = Convert.ToString(reader["actionname"]); actions.Add(model); } } return(actions); }
/// <summary> /// 获取指定权限分栏外的所有权限 /// </summary> /// <param name="actioncolumnid"></param> /// <returns></returns> public ArrayList GetExcludeActions(int actioncolumnid) { ArrayList actions = new ArrayList(); SqlParameter[] parameters = { new SqlParameter("@actioncolumnid", SqlDbType.Int) }; parameters[0].Value = actioncolumnid; using (SqlDataReader reader = RunProcedure("sp_GetExcludeAction_columnid", parameters)) { while (reader.Read()) { RADinfo_MIS_COST.Model.Action model = new RADinfo_MIS_COST.Model.Action(); model.ActionId = Convert.ToInt32(reader["actionid"]); model.ActionName = Convert.ToString(reader["actionname"]); actions.Add(model); } } return(actions); }
/// <summary> /// 获取指定权限的详细信息 /// </summary> /// <param name="actionid"></param> /// <returns></returns> public RADinfo_MIS_COST.Model.Action GetDetails(int actionid) { RADinfo_MIS_COST.Model.Action model = new RADinfo_MIS_COST.Model.Action(); SqlParameter[] parameters = { new SqlParameter("@actionid", SqlDbType.Int) }; parameters[0].Value = actionid; using (SqlDataReader reader = RunProcedure("sp_GetAction", parameters)) { if (reader.Read()) { model.ActionId = Convert.ToInt32(reader["actionid"]); model.ActionName = Convert.ToString(reader["actionname"]); model.ActionStr = Convert.ToString(reader["actionstr"]); model.ActionColumnid = Convert.ToInt32(reader["actioncolumnid"]); model.Link = Convert.ToString(reader["link"]); } } return(model); }
/// <summary> /// 获取指定用户的所有权限 /// </summary> /// <param name="masterid"></param> /// <returns></returns> public ArrayList GetAction(string masterid) { ArrayList actions = new ArrayList(); SqlParameter[] parameters = { new SqlParameter("@masterid", SqlDbType.VarChar) }; parameters[0].Value = masterid; using (SqlDataReader reader = RunProcedure("sp_GetAction_Master", parameters)) { while (reader.Read()) { RADinfo_MIS_COST.Model.Action action = new RADinfo_MIS_COST.Model.Action(); action.ActionId = Convert.ToInt32(reader["actionid"]); action.ActionName = Convert.ToString(reader["actionname"]); action.Link = Convert.ToString(reader["link"]); actions.Add(action); } } return(actions); }