/// <summary> /// 取得Role資料 /// </summary> /// <returns></returns> public IEnumerable <RoleDTO> GetRoleData(PageDataVO pageDataVO) { List <string> param = new List <string>(); string condition = string.Empty; if (pageDataVO.WhereCondition != null) { for (int i = 0; i < pageDataVO.WhereCondition.Count; i++) { if (i != pageDataVO.WhereCondition.Count - 1) { condition = condition + pageDataVO.WhereCondition[i].Key + " like @p" + i.ToString() + " And "; } else { condition = condition + pageDataVO.WhereCondition[i].Key + " like @p" + i.ToString() + " "; } param.Add("%" + pageDataVO.WhereCondition[i].Value + "%"); } } else { condition = "1=1"; } string sqlStr = string.Format(@"Select [RoleID],[RoleName],[Description] From (Select ROW_NUMBER() OVER(ORDER BY {0} {1} ) AS row, * from [Role] where {2} ) as tb1 where row > @p{3} and row < @p{4} ", pageDataVO.OrderByColumn, pageDataVO.OrderByType, condition, param.Count, param.Count + 1); param.Add(pageDataVO.LowerBound.ToString()); param.Add(pageDataVO.UpperBound.ToString()); return(_dataAccess.QueryDataTable <RoleDTO>(sqlStr, param.ToArray())); }
/// <summary> /// 取得Role資料 /// </summary> /// <returns></returns> public IEnumerable <RoleVO> GetRoleData(PageDataVO pageDataVO) { pageDataVO.PageSize = pageDataVO.PageSize ?? Convert.ToInt32(ConfigurationManager.AppSettings["TablePageCount"]); pageDataVO.DataCount = _roleEfRepo.GetRoleCount(pageDataVO); if (pageDataVO.DataCount % pageDataVO.PageSize.Value == 0) { pageDataVO.AllPageNumber = pageDataVO.DataCount / pageDataVO.PageSize.Value; } else { pageDataVO.AllPageNumber = pageDataVO.DataCount / pageDataVO.PageSize.Value + 1; } pageDataVO.LowerBound = (pageDataVO.PageNumber - 1) * pageDataVO.PageSize.Value; pageDataVO.UpperBound = pageDataVO.LowerBound + pageDataVO.PageSize.Value + 1; if (pageDataVO.LowerBound >= pageDataVO.DataCount) { pageDataVO.UpperBound = pageDataVO.DataCount + 1; pageDataVO.LowerBound = pageDataVO.UpperBound - (pageDataVO.PageSize.Value + 1); } return(Utility.MigrationIEnumerable <RoleDTO, RoleVO>(_roleEfRepo.GetRoleData(pageDataVO))); }
/// <summary> /// 取得資料總筆數 /// 只有where條件會影響總筆數 /// </summary> /// <returns></returns> public int GetRoleCount(PageDataVO pageDataVO) { List <string> param = new List <string>(); string condition = string.Empty; if (pageDataVO.WhereCondition != null) { for (int i = 0; i < pageDataVO.WhereCondition.Count; i++) { if (i != pageDataVO.WhereCondition.Count - 1) { condition = condition + pageDataVO.WhereCondition[i].Key + " like @p" + i.ToString() + " And "; } else { condition = condition + pageDataVO.WhereCondition[i].Key + " like @p" + i.ToString() + " "; } param.Add("%" + pageDataVO.WhereCondition[i].Value + "%"); } } else { condition = "1=1"; } string sqlStr = string.Format(@"Select count(*) From [Role] where {0}", condition); return((int)_dataAccess.ExecuteScalar(sqlStr, param.ToArray())); }
public void QueryRoleFunctionEditRoleTest() { #region arrange List <RoleVO> reRoleVOList = new List <RoleVO>() { new RoleVO() { RoleID = 1, RoleName = "Admin", Description = "最高權限" }, new RoleVO() { RoleID = 2, RoleName = "A", Description = "A1" }, new RoleVO() { RoleID = 3, RoleName = "B", Description = "B1" } }; PageDataVO pageDataVO = new PageDataVO() { PageNumber = 1, WhereCondition = new List <KeyValueVO>() { new KeyValueVO() { Key = "RoleName", Value = "" } } }; _roleService.Stub(o => o.GetRoleData(pageDataVO)).Return(reRoleVOList); #endregion #region act var resultData = _target.QueryRoleFunctionEditRole(pageDataVO); var result = (RoleTableResultVO)((JsonResult)resultData).Data; var roleData = result.RoleData.ToList(); #endregion #region assert // 驗證資料 for (int i = 0; i < roleData.Count; i++) { Assert.AreEqual(roleData[i].RoleID, reRoleVOList[i].RoleID); Assert.AreEqual(roleData[i].RoleName, reRoleVOList[i].RoleName); Assert.AreEqual(roleData[i].Description, reRoleVOList[i].Description); } #endregion }
public void GetFunctionDataTest() { #region arrange List <FunctionVO> reFunctionVO = new List <FunctionVO>() { new FunctionVO() { FunctionID = 1, Url = "Role/RoleManagement", Title = "角色管理", Description = "瀏覽角色管理畫面", IsMenu = true, Parent = 0, ParentName = "No" }, new FunctionVO() { FunctionID = 2, Url = "Role/RoleAddEditDelete", Title = "編輯角色", Description = "角色新增修改刪除畫面", IsMenu = true, Parent = 1, ParentName = "角色管理" }, new FunctionVO() { FunctionID = 3, Url = "Role/EditRole", Title = "編輯", Description = "編輯角色", IsMenu = false, Parent = -1, ParentName = "Not Menu" } }; PageDataVO pageDataVO = new PageDataVO() { PageNumber = 1, PageSize = 5, WhereCondition = new List <KeyValueVO>() { new KeyValueVO() { Key = "Url", Value = "" } } }; _functionBO.Stub(o => o.GetFunctionData(pageDataVO)).Return(reFunctionVO); #endregion #region act var result = _target.GetFunctionData(pageDataVO).ToList(); #endregion #region assert for (int i = 0; i < result.Count(); i++) { Assert.AreEqual(result[i].FunctionID, reFunctionVO[i].FunctionID); Assert.AreEqual(result[i].Url, reFunctionVO[i].Url); Assert.AreEqual(result[i].Title, reFunctionVO[i].Title); Assert.AreEqual(result[i].Description, reFunctionVO[i].Description); Assert.AreEqual(result[i].IsMenu, reFunctionVO[i].IsMenu); Assert.AreEqual(result[i].Parent, reFunctionVO[i].Parent); Assert.AreEqual(result[i].ParentName, reFunctionVO[i].ParentName); } #endregion }
public ActionResult QueryFunction(PageDataVO pageDataVO) { FunctionTableResultVO result = new FunctionTableResultVO(); result.FunctionData = _functionService.GetFunctionData(pageDataVO); result.TableMaxPage = pageDataVO.AllPageNumber; return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult QueryRole(PageDataVO pageDataVO) { RoleTableResultVO result = new RoleTableResultVO(); result.RoleData = _roleService.GetRoleData(pageDataVO); result.TableMaxPage = pageDataVO.AllPageNumber; return(Json(result, JsonRequestBehavior.AllowGet)); }
public void GetRoleDataTest() { #region arrange List <RoleDTO> reRoleDTO = new List <RoleDTO>() { new RoleDTO() { RoleID = 1, RoleName = "Admin", Description = "最高權限" }, new RoleDTO() { RoleID = 2, RoleName = "A", Description = "A1" }, new RoleDTO() { RoleID = 3, RoleName = "B", Description = "B1" }, }; PageDataVO pageDataVO = new PageDataVO() { PageSize = 3, DataCount = 3, PageNumber = 1, LowerBound = 0, UpperBound = 2, WhereCondition = new List <KeyValueVO>() { new KeyValueVO() { Key = "RoleName", Value = "" } } }; _dataAccess.Stub(o => o.QueryDataTable <RoleDTO>(Arg <string> .Is.Anything, Arg <object[]> .Is.Anything)).Return(reRoleDTO); #endregion #region act var result = _target.GetRoleData(pageDataVO).ToList(); #endregion #region assert for (int i = 0; i < result.Count; i++) { Assert.AreEqual(result[i].RoleID, reRoleDTO[i].RoleID); Assert.AreEqual(result[i].RoleName, reRoleDTO[i].RoleName); Assert.AreEqual(result[i].Description, reRoleDTO[i].Description); } #endregion }
/// <summary> /// 取Table的資料包回來 /// 可以放在Application_Start、資料有新增、修改、刪除後的時候執行 /// </summary> public static void GetTableDataToCaching() { PageDataVO pageDataVO = new PageDataVO() { OrderByColumn = "UserID", OrderByType = "ASC" }; UserCheckVOList = _roleService.GetUserCheckByRole("1", pageDataVO).ToList(); }
public IEnumerable <FunctionCheckVO> GetFunctionByRole(RoleVO roleVO) { PageDataVO pageDataVO = new PageDataVO() { OrderByColumn = "FunctionID", OrderByType = "ASC" }; var functionCheckData = _functionService.GetFunctionCheckByRole(roleVO.RoleID.ToString(), pageDataVO); return(functionCheckData); }
public void GetFunctionByRoleTest() { #region arrange string id = "1"; List <FunctionCheckVO> reFunctionCheckVO = new List <FunctionCheckVO>() { new FunctionCheckVO() { FunctionID = 1, Url = "Role/RoleManagement", Title = "角色管理", Description = "瀏覽角色管理畫面", IsMenu = true, ParentName = "No", Check = true }, new FunctionCheckVO() { FunctionID = 2, Url = "Role/RoleAddEditDelete", Title = "編輯角色", Description = "角色新增修改刪除畫面", IsMenu = true, ParentName = "角色管理", Check = true }, new FunctionCheckVO() { FunctionID = 3, Url = "Role/EditRole", Title = "編輯", Description = "編輯角色", IsMenu = false, ParentName = "Not Menu", Check = false } }; PageDataVO pageDataVO = new PageDataVO() { OrderByColumn = "UserID", OrderByType = "ASC" }; _functionService.Stub(o => o.GetFunctionCheckByRole(Arg <string> .Is.Anything, Arg <PageDataVO> .Is.Anything)).Return(reFunctionCheckVO); #endregion #region act var resultData = _target.GetFunctionByRole(id, pageDataVO); var result = (List <FunctionCheckVO>)((JsonResult)resultData).Data; #endregion #region assert for (int i = 0; i < result.Count; i++) { Assert.AreEqual(result[i].RoleID, reFunctionCheckVO[i].RoleID); Assert.AreEqual(result[i].FunctionID, reFunctionCheckVO[i].FunctionID); Assert.AreEqual(result[i].Url, reFunctionCheckVO[i].Url); Assert.AreEqual(result[i].Title, reFunctionCheckVO[i].Title); Assert.AreEqual(result[i].Description, reFunctionCheckVO[i].Description); Assert.AreEqual(result[i].IsMenu, reFunctionCheckVO[i].IsMenu); Assert.AreEqual(result[i].ParentName, reFunctionCheckVO[i].ParentName); Assert.AreEqual(result[i].Check, reFunctionCheckVO[i].Check); } #endregion }
/// <summary> /// 取得Function資料 /// </summary> /// <returns></returns> public IEnumerable <FunctionDTO> GetFunctionData(PageDataVO pageDataVO) { List <string> param = new List <string>(); string condition = string.Empty; if (pageDataVO.WhereCondition != null) { for (int i = 0; i < pageDataVO.WhereCondition.Count; i++) { if (i != pageDataVO.WhereCondition.Count - 1) { if (pageDataVO.WhereCondition[i].Key == "IsMenu") { condition = condition + pageDataVO.WhereCondition[i].Key + " = @p" + i.ToString() + " And "; param.Add(pageDataVO.WhereCondition[i].Value); continue; } else { condition = condition + pageDataVO.WhereCondition[i].Key + " like @p" + i.ToString() + " And "; } } else { if (pageDataVO.WhereCondition[i].Key == "IsMenu") { condition = condition + pageDataVO.WhereCondition[i].Key + " = @p" + i.ToString() + " "; param.Add(pageDataVO.WhereCondition[i].Value); continue; } condition = condition + pageDataVO.WhereCondition[i].Key + " like @p" + i.ToString() + " "; } param.Add("%" + pageDataVO.WhereCondition[i].Value + "%"); } } else { condition = "1=1"; } string sqlStr = string.Format(@"Select [FunctionID], [Url], [Description], [IsMenu], [Parent], [Title] , case when A.[Parent] = -1 then 'Not Menu' when A.[Parent] = 0 then 'No' else (select B.[Title] from [Function] B where B.FunctionID = A.[Parent]) end as 'ParentName' From (Select ROW_NUMBER() OVER(ORDER BY {0} {1} ) AS row, * from [Function] where {2} ) as A where row > @p{3} and row < @p{4} ", pageDataVO.OrderByColumn, pageDataVO.OrderByType, condition, param.Count, param.Count + 1); param.Add(pageDataVO.LowerBound.ToString()); param.Add(pageDataVO.UpperBound.ToString()); return(_dataAccess.QueryDataTable <FunctionDTO>(sqlStr, param.ToArray())); }
public IEnumerable <FunctionVO> FunctionAddEditDelete() { PageDataVO pageDataVO = new PageDataVO() { PageNumber = 1, PageSize = 0 }; var functionData = _functionService.GetFunctionData(pageDataVO); return(functionData); }
public IEnumerable <UserCheckVO> GetUserByRole(RoleVO roleVO) { PageDataVO pageDataVO = new PageDataVO() { OrderByColumn = "UserID", OrderByType = "ASC" }; var userCheckData = _roleService.GetUserCheckByRole(roleVO.RoleID.ToString(), pageDataVO); return(userCheckData); }
public IEnumerable <RoleVO> RoleAddEditDelete() { // Thread.Sleep(1000); PageDataVO pageDataVO = new PageDataVO() { PageNumber = 1, PageSize = 0 }; var roleData = _roleService.GetRoleData(pageDataVO); return(roleData); }
public void GetUserByRoleTest() { #region arrange string roleID = "1"; List <UserCheckVO> reUserCheckVO = new List <UserCheckVO>() { new UserCheckVO() { RoleID = 1, UserID = 1, Check = true, UserName = "******", AccountName = "kevan" }, new UserCheckVO() { RoleID = 1, UserID = 2, Check = true, UserName = "******", AccountName = "A" }, new UserCheckVO() { RoleID = 1, UserID = 3, Check = false, UserName = "******", AccountName = "B" } }; PageDataVO pageDataVO = new PageDataVO() { OrderByColumn = "UserID", OrderByType = "ASC" }; _roleService.Stub(o => o.GetUserCheckByRole(Arg <string> .Is.Anything, Arg <PageDataVO> .Is.Anything)).Return(reUserCheckVO); #endregion #region act var resultData = _target.GetUserByRole(roleID, pageDataVO); var result = (List <UserCheckVO>)((JsonResult)resultData).Data; #endregion #region assert for (int i = 0; i < result.Count; i++) { Assert.AreEqual(result[i].RoleID, reUserCheckVO[i].RoleID); Assert.AreEqual(result[i].UserID, reUserCheckVO[i].UserID); Assert.AreEqual(result[i].Check, reUserCheckVO[i].Check); Assert.AreEqual(result[i].UserName, reUserCheckVO[i].UserName); Assert.AreEqual(result[i].AccountName, reUserCheckVO[i].AccountName); } #endregion }
/// <summary> /// 取得Role資料 /// </summary> /// <returns></returns> public IEnumerable <RoleDTO> GetRoleData(PageDataVO pageDataVO) { var result = (from role in _db.Role where role.RoleName == pageDataVO.WhereCondition[0].Value orderby role.RoleID select new RoleDTO() { RoleID = role.RoleID, RoleName = role.RoleName, Description = role.Description }); return(result.Skip(pageDataVO.LowerBound).Take(pageDataVO.PageSize == null ? 0 : Convert.ToInt32(pageDataVO.PageSize))); }
/// <summary> /// 取得資料總筆數 /// </summary> /// <param name="pageDataVO"></param> /// <returns></returns> public int GetRoleCount(PageDataVO pageDataVO) { var result = (from role in _db.Role where role.RoleName == pageDataVO.WhereCondition[0].Value orderby role.RoleID select new RoleDTO() { RoleID = role.RoleID, RoleName = role.RoleName, Description = role.Description }); return(result.Count()); }
public void GetUserCheckByRoleTest() { #region arrange string id = "1"; List <UserCheckDTO> reUserCheckDTO = new List <UserCheckDTO>() { new UserCheckDTO() { UserID = 1, UserName = "******", AccountName = "kevan", Check = true }, new UserCheckDTO() { UserID = 2, UserName = "******", AccountName = "A1", Check = true }, new UserCheckDTO() { UserID = 3, UserName = "******", AccountName = "B1", Check = false } }; PageDataVO pageDataVO = new PageDataVO() { OrderByColumn = "UserID", OrderByType = "ASC" }; _dataAccess.Stub(o => o.QueryDataTable <UserCheckDTO>(Arg <string> .Is.Anything, Arg <object[]> .Is.Anything)).Return(reUserCheckDTO); #endregion #region act var result = _target.GetUserCheckByRole(id, pageDataVO).ToList(); #endregion #region assert for (int i = 0; i < result.Count; i++) { Assert.AreEqual(result[i].UserID, reUserCheckDTO[i].UserID); Assert.AreEqual(result[i].UserName, reUserCheckDTO[i].UserName); Assert.AreEqual(result[i].AccountName, reUserCheckDTO[i].AccountName); Assert.AreEqual(result[i].Check, reUserCheckDTO[i].Check); } #endregion }
/// <summary> /// 取得角色設定使用者的資料 /// </summary> /// <param name="id"></param> /// <returns></returns> public IEnumerable <UserCheckDTO> GetUserCheckByRole(string id, PageDataVO pageDataVO) { List <string> param = new List <string>(); string sqlStr = string.Format(@"SELECT case when A.[RoleID] IS NULL then CAST(0 AS BIT) Else CAST(1 AS BIT) end AS 'Check' , B.[UserID],B.AccountName,B.UserName FROM (Select * From [RoleUser] where RoleID=@p0) A Right join [User] B on A.UserID = B.UserID Order By B.[{0}] {1}", pageDataVO.OrderByColumn, pageDataVO.OrderByType); param.Add(id); return(_dataAccess.QueryDataTable <UserCheckDTO>(sqlStr, param.ToArray())); }
/// <summary> /// 取得資料總筆數 /// </summary> /// <param name="pageDataVO"></param> /// <returns></returns> public int GetFunctionCount(PageDataVO pageDataVO) { var isMenu = Convert.ToBoolean(pageDataVO.WhereCondition[2].Value); var result = (from function in _db.Function where function.Url == pageDataVO.WhereCondition[0].Value && function.Title == pageDataVO.WhereCondition[1].Value && function.IsMenu == isMenu orderby function.FunctionID select new FunctionDTO() { FunctionID = function.FunctionID, Url = function.Url, Description = function.Description }); return(result.Count()); }
/// <summary> /// 取得Function資料 /// </summary> /// <returns></returns> public IEnumerable <FunctionDTO> GetFunctionData(PageDataVO pageDataVO) { var isMenu = Convert.ToBoolean(pageDataVO.WhereCondition[2].Value); var result = (from function in _db.Function where function.Url == pageDataVO.WhereCondition[0].Value && function.Title == pageDataVO.WhereCondition[1].Value && function.IsMenu == isMenu orderby function.FunctionID select new FunctionDTO() { FunctionID = function.FunctionID, Url = function.Url, Description = function.Description }); return(result.Skip(pageDataVO.LowerBound).Take(pageDataVO.PageSize == null ? 0 : Convert.ToInt32(pageDataVO.PageSize))); }
public void GetRoleDataTest() { #region arrange List<RoleVO> reRoleVOList = new List<RoleVO>() { new RoleVO(){ RoleID = 1 , RoleName = "Admin" , Description = "最高權限"}, new RoleVO(){ RoleID = 2 , RoleName = "A" , Description = "A1"}, new RoleVO(){ RoleID = 3 , RoleName = "B" , Description = "B1"}, }; PageDataVO pageDataVO = new PageDataVO() { PageNumber = 1, WhereCondition = new List<KeyValueVO>() { new KeyValueVO() { Key = "RoleName", Value = "" } } }; _roleBO.Stub(o => o.GetRoleData(pageDataVO)).Return(reRoleVOList); #endregion #region act var result = _target.GetRoleData(pageDataVO).ToList(); #endregion #region assert for (int i = 0; i < result.Count(); i++) { Assert.AreEqual(result[i].RoleID, reRoleVOList[i].RoleID); Assert.AreEqual(result[i].RoleName, reRoleVOList[i].RoleName); Assert.AreEqual(result[i].Description, reRoleVOList[i].Description); } #endregion }
/// <summary> /// 取得角色設定功能的資料 /// </summary> /// <param name="id"></param> /// <returns></returns> public IEnumerable <FunctionCheckDTO> GetFunctionCheckByRole(string id, PageDataVO pageDataVO) { List <string> param = new List <string>(); string sqlStr = string.Format(@"SELECT case when A.[RoleID] IS NULL then CAST(0 AS BIT) Else CAST(1 AS BIT) end AS 'Check' , B.[FunctionID],B.Url,B.Title, B.Description, B.IsMenu , case when B.[Parent] = -1 then 'Not Menu' when B.[Parent] = 0 then 'No' else (select C.[Title] from [Function] C where C.FunctionID = B.[Parent]) end as 'ParentName' FROM (Select * From [RoleFunction] where RoleID = @p0 ) A Right join [Function] B on A.FunctionID = B.FunctionID Order By B.[{0}] {1} ", pageDataVO.OrderByColumn, pageDataVO.OrderByType); param.Add(id); return(_dataAccess.QueryDataTable <FunctionCheckDTO>(sqlStr, param.ToArray())); }
/// <summary> /// 取得Function資料 /// </summary> /// <returns></returns> public IEnumerable <FunctionVO> GetFunctionData(PageDataVO pageDataVO) { pageDataVO.PageSize = pageDataVO.PageSize ?? Convert.ToInt32(ConfigurationManager.AppSettings["TablePageCount"]); pageDataVO.DataCount = _functionRepo.GetFunctionCount(pageDataVO); if (pageDataVO.PageSize != null && pageDataVO.PageSize != 0) { if (pageDataVO.DataCount % pageDataVO.PageSize.Value == 0) { pageDataVO.AllPageNumber = pageDataVO.DataCount / pageDataVO.PageSize.Value; } else { pageDataVO.AllPageNumber = pageDataVO.DataCount / pageDataVO.PageSize.Value + 1; } pageDataVO.LowerBound = (pageDataVO.PageNumber - 1) * pageDataVO.PageSize.Value; pageDataVO.UpperBound = pageDataVO.LowerBound + pageDataVO.PageSize.Value + 1; if (pageDataVO.LowerBound >= pageDataVO.DataCount) { pageDataVO.UpperBound = pageDataVO.DataCount + 1; pageDataVO.LowerBound = pageDataVO.UpperBound - (pageDataVO.PageSize.Value + 1); } } else { pageDataVO.UpperBound = pageDataVO.DataCount + 1; pageDataVO.LowerBound = 0; } if (string.IsNullOrEmpty(pageDataVO.OrderByColumn)) { pageDataVO.OrderByColumn = "FunctionID"; } IEnumerable <FunctionVO> result = Utility.MigrationIEnumerable <FunctionDTO, FunctionVO>(_functionRepo.GetFunctionData(pageDataVO)); return(result); }
public void GetFunctionCountTest() { #region arrange int reNumber = 3; PageDataVO pageDataVO = new PageDataVO() { PageSize = 3, DataCount = 3, PageNumber = 1, LowerBound = 0, UpperBound = 2, WhereCondition = new List <KeyValueVO>() { new KeyValueVO() { Key = "Url", Value = "" } } }; _dataAccess.Stub(o => o.ExecuteScalar(Arg <string> .Is.Anything, Arg <object[]> .Is.Anything)).Return(reNumber); #endregion #region act var result = _target.GetFunctionCount(pageDataVO); #endregion #region assert Assert.AreEqual(result, reNumber); #endregion }
public void GetFunctionCheckByRoleTest() { #region arrange string roleID = "1"; List <FunctionCheckVO> reFunctionCheckVO = new List <FunctionCheckVO>() { new FunctionCheckVO() { RoleID = 1, FunctionID = 1, Url = "Role/RoleManagement", Description = "瀏覽角色管理畫面", Check = true }, new FunctionCheckVO() { RoleID = 1, FunctionID = 2, Url = "Role/RoleAddEditDelete", Description = "角色新增修改刪除畫面", Check = true }, new FunctionCheckVO() { RoleID = 1, FunctionID = 3, Url = "Role/EditRole", Description = "編輯角色", Check = false } }; List <FunctionCheckDTO> reFunctionCheckDTO = new List <FunctionCheckDTO>() { new FunctionCheckDTO() { FunctionID = 1, Url = "Role/RoleManagement", Description = "瀏覽角色管理畫面", Check = true }, new FunctionCheckDTO() { FunctionID = 2, Url = "Role/RoleAddEditDelete", Description = "角色新增修改刪除畫面", Check = true }, new FunctionCheckDTO() { FunctionID = 3, Url = "Role/EditRole", Description = "編輯角色", Check = false } }; _roleFunctionEfRepo.Stub(o => o.GetFunctionCheckByRole(Arg <string> .Is.Anything)).Return(reFunctionCheckDTO); PageDataVO pageDataVO = new PageDataVO() { OrderByColumn = "UserID", OrderByType = "ASC" }; #endregion #region act var result = _target.GetFunctionCheckByRole(roleID, pageDataVO).ToList(); #endregion #region assert for (int i = 0; i < result.Count; i++) { Assert.AreEqual(result[i].FunctionID, reFunctionCheckVO[i].FunctionID); Assert.AreEqual(result[i].Url, reFunctionCheckVO[i].Url); Assert.AreEqual(result[i].Description, reFunctionCheckVO[i].Description); Assert.AreEqual(result[i].Check, reFunctionCheckVO[i].Check); } #endregion }
public ActionResult GetUserByRole(string id, PageDataVO pageDataVO) { var userCheckData = _roleService.GetUserCheckByRole(id, pageDataVO); return(Json(userCheckData, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 取得角色設定功能的資料 /// </summary> /// <param name="roleID"></param> /// <returns></returns> public IEnumerable <FunctionCheckVO> GetFunctionCheckByRole(string roleID, PageDataVO pageDataVO) { return(_functionBO.GetFunctionCheckByRole(roleID, pageDataVO)); }
/// <summary> /// 取得Function資料 /// </summary> /// <returns></returns> public IEnumerable <FunctionVO> GetFunctionData(PageDataVO pageDataVO) { return(_functionBO.GetFunctionData(pageDataVO)); }