/// <summary> /// 获得所有 /// </summary> /// <param name="fileType">文件类别</param> /// <returns></returns> public System.Data.DataTable GetAllInfo(CE_FileType fileType) { string strSql = "select a.SortName as 类别名称,b.SortName as 父级类别名称, a.SortID as 类别ID, " + " b.SortID as 父级类别ID from FM_FileSort as a left join FM_FileSort as b on " + " a.ParentID = b.SortID where a.FileType = " + (int)fileType; return(GlobalObject.DatabaseServer.QueryInfo(strSql)); }
/// <summary> /// 获得体系文件结构树 /// </summary> /// <param name="fileType">文件类别</param> /// <returns></returns> public System.Data.DataTable GetTreeInfo(CE_FileType fileType) { string strSql = " select ID,Name,ParentID,FileNo from ( " + " select CAST( SortID as varchar(50)) as ID , SortName as Name, " + " CAST( ParentID as varchar(50)) as ParentID, '' as FileNo, FileType " + " from FM_FileSort Union " + " select 'File' + CAST( FileID as varchar(50)),[FileName] + '(' + FileNo + ')' as [FileName], " + " CAST( a.SortID as varchar(50)), FileNo, b.FileType " + " from FM_FileList as a inner join FM_FileSort as b on a.SortID = b.SortID " + " where DeleteFlag = 0) as a where FileType = " + (int)fileType; return(GlobalObject.DatabaseServer.QueryInfo(strSql)); }