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