List <NsiFileCashes> GetDBList(int lim, Status status, FLType fz_type) { List <NsiFileCashes> data = new List <NsiFileCashes>(); using (var db = _govDb.GetContext()) { data = db.NsiFileCashes .AsNoTracking() .Where(x => x.Status == status && x.Fz_type == fz_type) .OrderByDescending(x => x.Date) .Take(lim) .ToList(); } return(data); }
/// <summary> /// Получение списка файлов из кэша. /// </summary> /// <param name="lim"></param> /// <param name="status"></param> /// <param name="fz_type"></param> /// <param name="basepath"></param> /// <param name="dirtype"></param> /// <returns></returns> public List <NsiFileCashes> GetNsiDBList(int lim, Status status, FLType fz_type, string basepath, string dirtype) { //throw new NotImplementedException(); List <NsiFileCashes> data = new List <NsiFileCashes>(); using (var db = _govDb.GetContext()) { data = db.NsiFileCashes .AsNoTracking() .Where(x => x.Status == status && x.Fz_type == fz_type && x.BaseDir == basepath && x.Dirtype == dirtype) .OrderBy(x => x.Date) //.OrderByDescending(x => x.Date) .Take(lim) .ToList(); } return(data); }
private void SaveFTPPath(List <FtpListItem> ListFile, string ftpDir, string baseDir, Status status, FLType fz) { foreach (FtpListItem item in ListFile) { if (!GetDBfile(item.FullName)) { var filesave = new NsiFileCashes(); filesave.Date = item.Modified; filesave.Size = item.Size; filesave.Full_path = item.FullName; filesave.Zip_file = item.Name; filesave.BaseDir = baseDir; filesave.Dirtype = ftpDir; filesave.Fz_type = fz; filesave.Status = status; filesave.Modifid_date = DateTime.Now; SavePath(filesave); } } }