public Dictionary <int, string> GetFilesName(IEnumerable <int> ids, FileLinkType type)
{
var res = new Dictionary <int, string>();
if (ids.Count() == 0)
{
return(res);
}
var query = $"select i.ParentId, f.FileName from Files f inner join ItemsFilesLinks i on f.ItemID = i.FileId " +
$"where f.ItemId in (select FileId from ItemsFilesLinks where LinkType = 3 and ParentTypeId = 1 and ParentId in ({string.Join(",",ids)}))";
var ds = _newLoader.Execute(query);
var dt = ds.Tables[0];
foreach (DataRow dr in dt.Rows)
{
var id = (int)dr[0];
if (!res.ContainsKey(id))
{
res.Add(id, dr[1].ToString());
}
}
return(res);
}
public static void SetFileByFileLinkType(this ICommonCollection <ItemFileLink> files, int typeId, AttachedFile file, FileLinkType fileLinkType)
{
var link = files.FirstOrDefault(i => i.LinkType == (short)fileLinkType);
if (link != null)
{
link.File = file;
}
else if (file != null)
{
files.Add(new ItemFileLink
{
ParentTypeId = typeId,
LinkType = (short)fileLinkType,
File = file
});
}
}
public static int?GetFileIdByFileLinkType(this List <ItemFileLink> files, FileLinkType fileLinkType)
{
return(files.FirstOrDefault(i => i.LinkType == (short)fileLinkType)?.FileId);
}
public static AttachedFile GetFileByFileLinkType(this ICommonCollection <ItemFileLink> files, FileLinkType fileLinkType)
{
return(files.FirstOrDefault(i => i.LinkType == (short)fileLinkType)?.File);
}
