/// <summary>
/// 取得取得實體存放資料清單
/// </summary>
/// <param name="storageSourceType">檔案來源類別</param>
/// <param name="sourceId">來源項目的Id</param>
/// <param name="pageIndex">分頁索引</param>
/// <param name="pageSize">分頁大小</param>
/// <param name="sortField">排序欄位</param>
/// <param name="sortDesc">升降冪排序</param>
/// <returns>實體存放資料清單</returns>
public IList <StorageFileVO> GetStorageFileListBySourceId(StorageFileVO.StorageSourceType storageSourceType, int sourceId, int pageIndex, int pageSize, string sortField, bool sortDesc)
{
DetachedCriteria dCriteria = DetachedCriteria.For <StorageFileVO>();
dCriteria.Add(Expression.Eq("SourceType", (int)storageSourceType));
dCriteria.Add(Expression.Eq("SourceId", sourceId));
if (!string.IsNullOrEmpty(sortField))
{
if (sortDesc)
{
dCriteria.AddOrder(Order.Desc(sortField));
}
else
{
dCriteria.AddOrder(Order.Asc(sortField));
}
}
int count = NHibernateDao.CountByDetachedCriteria(dCriteria);
if (count == 0)
{
return(null);
}
return(NHibernateDao.SearchByDetachedCriteria <StorageFileVO>(dCriteria, pageIndex, pageSize));
}
/// <summary>
/// 取得實體存放資料筆數 By SourceId
/// </summary>
/// <param name="storageSourceType">檔案來源類別</param>
/// <param name="sourceId">來源項目的Id</param>
/// <returns>實體存放資料清單筆數</returns>
public int CountStorageFileListBySourceId(StorageFileVO.StorageSourceType storageSourceType, int sourceId)
{
DetachedCriteria dCriteria = DetachedCriteria.For <StorageFileVO>();
dCriteria.Add(Expression.Eq("SourceType", (int)storageSourceType));
dCriteria.Add(Expression.Eq("SourceId", sourceId));
return(NHibernateDao.CountByDetachedCriteria(dCriteria));
}
/// <summary>
/// 刪除實體存放資料 By SourceId
/// </summary>
/// <param name="storageSourceType">檔案來源類別</param>
/// <param name="sourceId">來源項目的Id</param>
public void DeleteStorageFileBySourceId(StorageFileVO.StorageSourceType storageSourceType, int sourceId)
{
IList <StorageFileVO> storageFileList = GetStorageFileList(storageSourceType, sourceId);
if (storageFileList != null && storageFileList.Count > 0)
{
for (int i = 0; i < storageFileList.Count; i++)
{
DeleteStorageFile(storageFileList[i]);
}
}
}
/// <summary>
/// 取得取得實體存放資料清單
/// </summary>
/// <param name="storageSourceType">檔案來源類別</param>
/// <param name="sourceId">來源項目的Id</param>
/// <returns>實體存放資料清單</returns>
public IList <StorageFileVO> GetStorageFileList(StorageFileVO.StorageSourceType storageSourceType, int sourceId)
{
DetachedCriteria dCriteria = DetachedCriteria.For <StorageFileVO>();
dCriteria.Add(Expression.Eq("SourceType", (int)storageSourceType));
dCriteria.Add(Expression.Eq("SourceId", sourceId));
int count = NHibernateDao.CountByDetachedCriteria(dCriteria);
if (count == 0)
{
return(null);
}
return(NHibernateDao.SearchByDetachedCriteria <StorageFileVO>(dCriteria));
}
/// <summary>
/// 取得取得實體存放資料清單
/// </summary>
/// <param name="storageSourceType">檔案來源類別</param>
/// <param name="sourceId">來源項目的Id</param>
/// <returns>實體存放資料清單</returns>
public IList <StorageFileVO> GetStorageFileList(StorageFileVO.StorageSourceType storageSourceType, int sourceId)
{
return(StorageFileDao.GetStorageFileList(storageSourceType, sourceId));
}
/// <summary>
/// 取得實體存放資料筆數 By SourceId
/// </summary>
/// <param name="storageSourceType">檔案來源類別</param>
/// <param name="sourceId">來源項目的Id</param>
/// <returns>實體存放資料清單筆數</returns>
public int CountStorageFileListBySourceId(StorageFileVO.StorageSourceType storageSourceType, int sourceId)
{
return(StorageFileDao.CountStorageFileListBySourceId(storageSourceType, sourceId));
}
/// <summary>
/// 取得取得實體存放資料清單
/// </summary>
/// <param name="storageSourceType">檔案來源類別</param>
/// <param name="sourceId">來源項目的Id</param>
/// <param name="pageIndex">分頁索引</param>
/// <param name="pageSize">分頁大小</param>
/// <param name="sortField">排序欄位</param>
/// <param name="sortDesc">升降冪排序</param>
/// <returns>實體存放資料清單</returns>
public IList <StorageFileVO> GetStorageFileListBySourceId(StorageFileVO.StorageSourceType storageSourceType, int sourceId, int pageIndex, int pageSize, string sortField, bool sortDesc)
{
return(StorageFileDao.GetStorageFileListBySourceId(storageSourceType, sourceId, pageIndex, pageSize, sortField, sortDesc));
}
