public static String OrganizationList() { OrganizationListViewData view = new OrganizationListViewData(); view.List = new List <Organization>(); List <TreeNode> list; view.PageData = new PaginationData(); view.PageData.PageIndex = 1; view.PageData.PageSize = 10; view.PageData.PagintionJsFunction = "window.System.OrganizationList.search()"; view.PageData.OrderBy = "Code"; string sql = @"SELECT Name AS Text, CAST(UnitGuid AS NVARCHAR(36)) AS ID, CAST(ParentGuid AS NVARCHAR(36)) AS ParentID, '<i class=''ace-icon ' + Icon + '''></i>' AS Icon FROM dbo.Organization ORDER BY Code"; using (DbConnectionScope dcs = new DbConnectionScope()) { list = DbHelper.Db(sql).ToList <TreeNode>(); view.treeList = TreeNodeList.ToTreeNodeJson(list); } view.treeTitle = "组织架构"; TreeNode tr = list.FirstOrDefault(); if (tr == null) { tr = new TreeNode(); } sql = @"SELECT A.*, B.Name AS ParentName FROM dbo.Organization AS A LEFT JOIN dbo.Organization AS B ON A.ParentGuid = B.UnitGuid WHERE A.ParentGuid = @ParentGuid"; view.List = new Pagintion(sql, new { ParentGuid = tr.ID }, view.PageData).ToList <Organization>(); return(PageViewHelper.LoadPage("/System/OrganizationList.aspx", view)); }
public string Search(PaginationData pd) { OrganizationListViewData view = new OrganizationListViewData(); view.PageData = new BaseFrameWork.Model.PaginationData(); view.PageData.PageIndex = pd.PageIndex; view.PageData.PageSize = pd.PageSize; view.PageData.PagintionJsFunction = "window.System.OrganizationList.search()"; view.PageData.OrderBy = pd.OrderBy; string sql = @"SELECT A.*, B.Name AS ParentName FROM dbo.Organization AS A LEFT JOIN dbo.Organization AS B ON A.ParentGuid = B.UnitGuid WHERE 1 = 1 --AND A.ParentGuid = @ParentGuid AND 1 = 1"; view.List = new Pagintion(sql, null, view.PageData).ToList <Organization>(); string table = UserControlExcutor.RenderUserControl("/System/UserControl/OrganizationList.ascx", view); string pagination = UserControlExcutor.RenderUserControl("/System/CommonUserControl/Pagination.ascx", view.PageData); return(JsonHelper.ToJson(new { table = table, pagination = pagination })); }