コード例 #1
0
        public static string GetCS(string cs, string mode, Configs config)
        {
            if (string.IsNullOrEmpty(cs) || config.ConnectionStrings.Any(x => x.Key.ToLower() == cs.ToLower()) == false)
            {
                cs = "default";
            }
            int index = cs.LastIndexOf("_");

            if (index > 0)
            {
                cs = cs.Substring(0, index);
            }
            if (mode?.ToLower() == "read")
            {
                var reads = config.ConnectionStrings.Where(x => x.Key.StartsWith(cs + "_")).Select(x => x.Key).ToList();
                if (reads.Count > 0)
                {
                    Random r = new Random();
                    var    v = r.Next(0, reads.Count);
                    cs = reads[v];
                }
            }
            return(cs);
        }
コード例 #2
0
ファイル: FileHelper.cs プロジェクト: zz110/WTM
        /// <summary>
        /// 上传文件并返回FileAttachmentVM(后台代码使用)
        /// </summary>
        /// <param name="vm"></param>
        /// <param name="FileData"></param>
        /// <param name="con"></param>
        /// <param name="FileName"></param>
        /// <param name="savePlace"></param>
        /// <param name="groupName"></param>
        /// <returns></returns>
        public static FileAttachmentVM GetFileByteForUpload(FileAttachmentVM vm, Stream FileData, Configs con, string FileName = null, SaveFileModeEnum?savePlace = null, string groupName = null)
        {
            savePlace = savePlace == null ? con.FileUploadOptions.SaveFileMode : savePlace;
            var ext = string.Empty;

            if (string.IsNullOrEmpty(FileName) == false)
            {
                var dotPos = FileName.LastIndexOf('.');
                ext = FileName.Substring(dotPos + 1);
            }
            vm.Entity.FileName = FileName;
            vm.Entity.FileExt  = ext;

            if (savePlace == SaveFileModeEnum.Database)
            {
                using (var dataStream = new MemoryStream())
                {
                    FileData.CopyTo(dataStream);
                    vm.Entity.FileData = dataStream.ToArray();
                }
            }
            else if (savePlace == SaveFileModeEnum.Local)
            {
                string pathHeader = con.FileUploadOptions.UploadDir;
                if (!Directory.Exists(pathHeader))
                {
                    Directory.CreateDirectory(pathHeader);
                }
                var fullPath = Path.Combine(con.FileUploadOptions.UploadDir, $"{Guid.NewGuid().ToNoSplitString()}.{vm.Entity.FileExt}");
                using (var fileStream = File.Create(fullPath))
                {
                    FileData.CopyTo(fileStream);
                    vm.Entity.Path     = fullPath;
                    vm.Entity.FileData = null;
                }
            }
            else if (savePlace == SaveFileModeEnum.DFS)
            {
                using (var dataStream = new MemoryStream())
                {
                    StorageNode node = null;
                    FileData.CopyTo(dataStream);

                    if (!string.IsNullOrEmpty(groupName))
                    {
                        node = FDFSClient.GetStorageNode(groupName);
                    }
                    else
                    {
                        node = FDFSClient.GetStorageNode();
                    }

                    if (node != null)
                    {
                        vm.Entity.Path      = "/" + FDFSClient.UploadFile(node, dataStream.ToArray(), vm.Entity.FileExt);
                        vm.Entity.GroupName = node.GroupName;
                    }
                    vm.Entity.FileData = null;
                }
                FileData.Dispose();
            }
            return(vm);
        }
コード例 #3
0
ファイル: FileHelper.cs プロジェクト: zz110/WTM
        /// <summary>
        /// 通过FileId获取其文件流
        /// </summary>
        /// <param name="fileid"></param>
        /// <param name="dc"></param>
        /// <param name="con"></param>
        /// <returns></returns>
        public static byte[] GetFileByteForDownLoadById(Guid fileid, IDataContext dc, Configs con)
        {
            byte[]         data = null;
            FileAttachment fi   = dc.Set <FileAttachment>().Where(x => x.ID == fileid).FirstOrDefault();

            if (fi != null)
            {
                SaveFileModeEnum saveMode = fi.SaveFileMode == null ? con.FileUploadOptions.SaveFileMode : fi.SaveFileMode.Value;
                data = GetBytes(saveMode, fi, dc);
            }
            return(data);
        }
コード例 #4
0
ファイル: FileHelper.cs プロジェクト: zz110/WTM
        /// <summary>
        /// 根据定义的SaveFileModeEnum模式,获取File信息放入XSSFWorkbook中
        /// </summary>
        /// <param name="xssfworkbook"></param>
        /// <param name="fa"></param>
        /// <param name="con"></param>
        /// <returns></returns>
        public static XSSFWorkbook GetXSSFWorkbook(XSSFWorkbook xssfworkbook, FileAttachment fa, Configs con)
        {
            var saveMode = fa.SaveFileMode == null ? con.FileUploadOptions.SaveFileMode : fa.SaveFileMode;

            if (saveMode == SaveFileModeEnum.Database)
            {
                using (MemoryStream ms = new MemoryStream(fa.FileData))
                {
                    xssfworkbook = new XSSFWorkbook(ms);
                }
            }
            if (saveMode == SaveFileModeEnum.Local)
            {
                using (FileStream file = new FileStream(fa.Path, FileMode.Open, FileAccess.Read))
                {
                    xssfworkbook = new XSSFWorkbook(file);
                }
            }
            if (saveMode == SaveFileModeEnum.DFS)
            {
                using (MemoryStream ms = new MemoryStream(FDFSClient.DownloadFile(fa.GroupName, fa.Path.TrimStart('/'))))
                {
                    xssfworkbook = new XSSFWorkbook(ms);
                }
            }
            return(xssfworkbook);
        }
コード例 #5
0
        /// <summary>
        /// 上传文件并返回FileAttachmentVM(后台代码使用)
        /// </summary>
        /// <param name="vm"></param>
        /// <param name="FileData"></param>
        /// <param name="con"></param>
        /// <param name="FileName"></param>
        /// <param name="savePlace"></param>
        /// <returns></returns>
        public static FileAttachmentVM GetFileByteForUpload(FileAttachmentVM vm, Stream FileData, Configs con, string FileName = null, SaveFileModeEnum?savePlace = null)
        {
            savePlace = savePlace == null ? con.SaveFileMode : savePlace;
            var ext = string.Empty;

            if (string.IsNullOrEmpty(FileName) == false)
            {
                var dotPos = FileName.LastIndexOf('.');
                ext = FileName.Substring(dotPos + 1);
            }
            vm.Entity.FileName = FileName;
            vm.Entity.FileExt  = ext;

            if (savePlace == SaveFileModeEnum.Database)
            {
                using (var dataStream = new System.IO.MemoryStream())
                {
                    FileData.CopyTo(dataStream);
                    vm.Entity.FileData          = new FileAttachmentData();
                    vm.Entity.FileData.FileData = dataStream.ToArray();
                }
            }
            else if (savePlace == SaveFileModeEnum.Local)
            {
                string pathHeader = con.UploadDir;
                if (!Directory.Exists(pathHeader))
                {
                    Directory.CreateDirectory(pathHeader);
                }

                var fullPath = $"{pathHeader}/{Guid.NewGuid().ToNoSplitString()}.{vm.Entity.FileExt}";
                using (var fileStream = File.Create(fullPath))
                {
                    FileData.CopyTo(fileStream);
                    vm.Entity.Path     = fullPath;
                    vm.Entity.FileData = new FileAttachmentData();
                }
            }
            FileData.Dispose();
            return(vm);
        }
コード例 #6
0
        /// <summary>
        /// 下载文件 HSSFWorkbook
        /// </summary>
        /// <param name="hssfworkbook"></param>
        /// <param name="fa"></param>
        /// <param name="con"></param>
        /// <returns></returns>
        public static HSSFWorkbook GetHSSWorkbook(HSSFWorkbook hssfworkbook, FileAttachment fa, Configs con)
        {
            var saveMode = fa.SaveFileMode == null ? con.SaveFileMode : fa.SaveFileMode;

            if (saveMode == SaveFileModeEnum.Database)
            {
                using (MemoryStream ms = new MemoryStream(fa.FileData.FileData))
                {
                    hssfworkbook = new HSSFWorkbook(ms);
                }
            }
            if (saveMode == SaveFileModeEnum.Local)
            {
                using (FileStream file = new FileStream(fa.Path, FileMode.Open, FileAccess.Read))
                {
                    hssfworkbook = new HSSFWorkbook(file);
                }
            }
            return(hssfworkbook);
        }