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);
        }
Esempio n. 2
0
        /// <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);
                }
            }
        }