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