public ApiResult GetAccessSignatureUrl( string ResourceID = "", string AccessKey = "", DateTime?AccessStartTime = null, DateTime?AccessExpiryTime = null) { var fileService = new SysFileIndexService(""); #region 从缓存中获取,如果不存在则重建缓存 var fileIndexCacheKey = new XuHos.Common.Cache.Keys.EntityCacheKey <SysFileIndex>(StringCacheKeyType.SysFileIndex, ResourceID); //获取缓存中的数据 var fileIndex = fileIndexCacheKey.FromCache(); //从数据库中重建索引 if (fileIndex == null) { if (ResourceID.Length == 32) { fileIndex = fileService.Single <SysFileIndex>(a => a.MD5 == ResourceID); } else { fileIndex = fileService.Single <SysFileIndex>(a => a.FileUrl == ResourceID); } if (fileIndex != null) { fileIndex.ToCache(fileIndexCacheKey, TimeSpan.FromHours(2)); } } #endregion //验证访问权限 if (fileIndex != null && (fileIndex.AccessKey == AccessKey || string.IsNullOrEmpty(fileIndex.AccessKey))) { var signUrl = XuHos.Common.Storage.Manager.Instance.GetReadAccessSignature( fileIndex.FileType, fileIndex.FileUrl, AccessStartTime, AccessExpiryTime); return(signUrl.ToApiResultForObject()); //return EnumApiStatus.BizOK.ToApiResultForApiStatus(signUrl); } else { return(EnumApiStatus.ApiUserUnauthorized.ToApiResultForApiStatus("", "AccessKey 与 ResourceID 不匹配")); } }
/// <summary> /// 医生 依据 MemberID查询 成员信息 /// </summary> /// <param name="MemberID"></param> /// <returns></returns> public ResponseUserMemberDTO GetMemberInfo(string MemberID) { var userMemberCacheKey = new XuHos.Common.Cache.Keys.EntityCacheKey <ResponseUserMemberDTO> (XuHos.Common.Cache.Keys.StringCacheKeyType.User_Member, MemberID); var member = userMemberCacheKey.FromCache(); if (member == null) { using (DBEntities db = new DBEntities()) { member = (from members in db.UserMembers where members.MemberID == MemberID && !members.IsDeleted select members).FirstOrDefault().Map <Entity.UserMember, ResponseUserMemberDTO>(); member.ToCache(userMemberCacheKey); } } return(member); }
/// <summary> /// 获取医生排版预约总数 /// </summary> /// <param name="ScheduleID"></param> /// <returns></returns> int getDoctorScheduleRegNum(string ScheduleID) { var cacheKey = new XuHos.Common.Cache.Keys.EntityCacheKey <int?>(StringCacheKeyType.Doctor_ScheduleRegNum, ScheduleID); var count = cacheKey.FromCache(); if (count == null) { using (DBEntities db = new DBEntities()) { //查询医生排版和对应预约数量 count = (from opd in db.Set <UserOPDRegister>().Where(c => c.IsDeleted == false && c.ScheduleID == ScheduleID) //目前没有库管管理(通过订单来判断) join order in db.Orders.Where(a => a.OrderState != EnumOrderState.Canceled) on opd.OPDRegisterID equals order.OrderOutID select opd.ScheduleID).Count(); //TODO:这里还没有做库存更新的处理 count.ToCache(cacheKey, TimeSpan.FromMinutes(5)); } } return(count.Value); }
public async Task <HttpResponseMessage> Download( string FileType, string ResourceID, string ResizeCMD = "") { return(await Task.Run <HttpResponseMessage>(async() => { HttpResponseMessage result = new HttpResponseMessage(HttpStatusCode.OK); SysFileIndexService fileService = new SysFileIndexService(CurrentOperatorUserID); SysFileIndex fileIndex = null; #region 修正命令 if (!string.IsNullOrEmpty(ResizeCMD) && !ResizeCMD.ToUpper().Contains("X")) { ResourceID = ResourceID + "." + ResizeCMD; ResizeCMD = ""; } #endregion ResourceID = ResourceID.ToUpper(); #region 从缓存中获取,如果不存在则重建缓存 var fileIndexCacheKey = new XuHos.Common.Cache.Keys.EntityCacheKey <SysFileIndex>(StringCacheKeyType.SysFileIndex, ResourceID); //获取缓存中的数据 fileIndex = fileIndexCacheKey.FromCache(); //从数据库中重建索引 if (fileIndex == null) { if (ResourceID.Length == 32) { fileIndex = fileService.Single <SysFileIndex>(a => a.MD5 == ResourceID && a.FileType == FileType); } else { fileIndex = fileService.Single <SysFileIndex>(a => a.FileUrl == ResourceID && a.FileType == FileType); } if (fileIndex != null) { fileIndex.ToCache(fileIndexCacheKey, TimeSpan.FromHours(2)); } } #endregion if (fileIndex != null) { string etag = string.Format("\"{0}\"", fileIndex.MD5); var tag = Request.Headers.IfNoneMatch.FirstOrDefault(); if (Request.Headers.IfModifiedSince.HasValue && tag != null && tag.Tag == etag) { result.StatusCode = HttpStatusCode.NotModified; } else { #region 重新读取文件 if (XuHos.Common.Storage.Manager.Instance.Exists(FileType, fileIndex.FileUrl)) { #region 文件存在 //不需要缩放 if (!string.IsNullOrEmpty(ResizeCMD) && FileType.ToLower() == "images") { //80X80 统一成小写 Exists 的时候 不区分大小,但是OpenFile确区分大小写 ResizeCMD = ResizeCMD.ToLower(); //E:\XXX\XXX.80X80.jpg var resizeImgOtputPath = string.Format("{0}.{1}", fileIndex.FileUrl, ResizeCMD); if (XuHos.Common.Storage.Manager.Instance.Exists(FileType, resizeImgOtputPath)) { var stream = await XuHos.Common.Storage.Manager.Instance.OpenFile(FileType, resizeImgOtputPath); result.Content = new StreamContent(stream); } else { var stream = await XuHos.Common.Storage.Manager.Instance.OpenFile(FileType, fileIndex.FileUrl); using (ImageMagick.MagickImage image = new ImageMagick.MagickImage(stream)) { ImageMagick.MagickGeometry size = new ImageMagick.MagickGeometry(ResizeCMD); image.Resize(size); var resizeStream = new System.IO.MemoryStream(); image.Write(resizeStream); await XuHos.Common.Storage.Manager.Instance.WriteFile(FileType, resizeImgOtputPath, resizeStream); result.Content = new ByteArrayContent(image.ToByteArray()); } } } else { var stream = await XuHos.Common.Storage.Manager.Instance.OpenFile(FileType, fileIndex.FileUrl); result.Content = new StreamContent(stream); } #endregion result.Content.Headers.ContentType = new MediaTypeHeaderValue("Store/octet-stream"); result.Content.Headers.Add("Content-Disposition", "attachment;filename=\"" + HttpUtility.UrlEncode(fileIndex.Remark) + "\""); result.Headers.ETag = new EntityTagHeaderValue(etag); result.Headers.CacheControl = new CacheControlHeaderValue(); result.Headers.CacheControl.Public = true; result.Headers.CacheControl.MaxAge = TimeSpan.FromHours(480); result.Content.Headers.Expires = DateTimeOffset.Now.AddDays(20); result.Content.Headers.LastModified = fileIndex.CreateTime; } else { result.StatusCode = HttpStatusCode.NotFound; } #endregion } } else { result.StatusCode = HttpStatusCode.NotFound; } return result; })); }
/// <summary> /// 上传文件 /// 日期:2016年9月28日 /// </summary> /// <param name="FileType">文件类型</param> /// <param name="Directory">文件保存路径</param> /// <param name="PreMD5">预处理Md5哈希值</param> /// <returns></returns> public async Task <ApiResult> Upload( string FileType = "images", string Directory = null, string PreMD5 = "", string AccessKey = "", string Name = "") { // 检查是否是 multipart/form-data if (!Request.Content.IsMimeMultipartContent("form-data")) { return(EnumApiStatus.BizError.ToApiResultForApiStatus("UnsupportedMediaType")); } try { //文件存储配置 var config = SysConfigService.Get <XuHos.Common.Config.Sections.IMGStore>(); SysFileIndex fileIndex = null; //通过缓存来判断文件是否已经上传了 XuHos.Common.Cache.Keys.EntityCacheKey <SysFileIndex> CacheKey; //预处理文件Hash,客户端进行哈希值计算 if (PreMD5 != "") { CacheKey = new XuHos.Common.Cache.Keys.EntityCacheKey <SysFileIndex>(StringCacheKeyType.SysFileIndex, PreMD5); //缓存中获取文件索引 fileIndex = CacheKey.FromCache(); } //文件已经存在,则使用妙传(不需要保存直接返回之前已经上传的问题) if (fileIndex != null) { //返回上传结果 return(new ResponseUploadFileDTO { UrlPrefix = config.UrlPrefix, FileName = string.IsNullOrEmpty(Name) ? string.Format("{0}/{1}", FileType, fileIndex.FileUrl) : Name, MD5 = fileIndex.MD5, FileSize = fileIndex.FileSize, FileSeq = fileIndex.MD5, AccessKey = fileIndex.AccessKey }.ToApiResultForObject()); } else { var httpPostFile = HttpContext.Current.Request.Files[0]; var FileStream = httpPostFile.InputStream; var RequestFileName = httpPostFile.FileName; FileStream.Seek(0, SeekOrigin.Begin); var FileMD5 = XuHos.Common.Utility.HashHelper.ComputeMD5(FileStream); //扩展名 var FileUrl = FileMD5 + Path.GetExtension(RequestFileName); var FileSize = FileStream.Length; //通过缓存来判断文件是否已经上传了 CacheKey = new XuHos.Common.Cache.Keys.EntityCacheKey <SysFileIndex>(StringCacheKeyType.SysFileIndex, FileMD5); //缓存中获取文件索引 fileIndex = CacheKey.FromCache(); //文件已经存在 if (fileIndex != null) { //返回上传结果 return(new ResponseUploadFileDTO { UrlPrefix = config.UrlPrefix, FileName = string.IsNullOrEmpty(Name) ? string.Format("{0}/{1}", fileIndex.FileType, fileIndex.FileUrl) : Name, MD5 = fileIndex.MD5, FileSize = fileIndex.FileSize, FileSeq = fileIndex.MD5, AccessKey = fileIndex.AccessKey }.ToApiResultForObject()); } //文件不存在的才保存到服务器 else { await XuHos.Common.Storage.Manager.Instance.WriteFile(FileType, FileUrl, FileStream); SysFileIndexService fileService = new SysFileIndexService(CurrentOperatorUserID); fileIndex = new SysFileIndex() { MD5 = FileMD5, FileType = FileType, FileUrl = FileUrl, FileSize = FileSize, Remark = string.IsNullOrEmpty(Name) ? FileUrl : Name, AccessKey = AccessKey }; var result = new ResponseUploadFileDTO { UrlPrefix = config.UrlPrefix, FileName = string.IsNullOrEmpty(Name) ? string.Format("{0}/{1}", FileType, FileUrl) : Name, MD5 = FileMD5, FileSize = FileSize, FileSeq = fileIndex.MD5, AccessKey = fileIndex.AccessKey }; var SaveFlag = false; //文件不存在 if (!fileService.Exists(a => a.MD5 == FileMD5)) { try { //添加记录 SaveFlag = fileService.Insert(fileIndex); } //主键冲突异常 catch (ConstraintException ex) { SaveFlag = true; } } else { fileService.Update(fileIndex); SaveFlag = true; } //保存成功 if (SaveFlag) { //设置缓存 fileIndex.ToCache(CacheKey, TimeSpan.FromHours(2)); return(result.ToApiResultForObject()); } else { return(EnumApiStatus.BizError.ToApiResultForApiStatus()); } } } } catch (Exception ex) { string msg = ex.Message; if (ex.InnerException != null) { msg += System.Environment.NewLine + ex.InnerException.Message; if (ex.InnerException.InnerException != null) { msg += System.Environment.NewLine + ex.InnerException.InnerException.Message; } } LogHelper.WriteError(ex); return(EnumApiStatus.BizError.ToApiResultForApiStatus("上传失败,错误:" + msg)); } }
public async Task <ApiResult> UploadDCM(string Md5 = "", string AccessKey = "") { var res = await Upload("dcm", "", PreMD5 : Md5, AccessKey : AccessKey); if (res.Status != 0) { return(res); } var data = res.Data as ResponseUploadFileDTO; var result = data.Map <ResponseUploadFileDTO, DcmDTO>(); #region //获取文件路径 string filePath = ""; //缓存中获取文件索引 var CacheKey = new XuHos.Common.Cache.Keys.EntityCacheKey <SysFileIndex>(StringCacheKeyType.SysFileIndex, result.MD5); SysFileIndex fileIndex = CacheKey.FromCache(); if (fileIndex != null) { filePath = fileIndex.FileUrl; } else { //从数据库中获取文件索引 var file = new SysFileIndexService(CurrentOperatorUserID).Single <SysFileIndex>(a => a.MD5 == result.MD5); if (file == null) { filePath = file.FileUrl; } } if (string.IsNullOrEmpty(filePath)) { return(EnumApiStatus.BizError.ToApiResultForApiStatus()); } #endregion #region//解析DCM文件参数 var config = SysConfigService.Get <IMGStore>(); var fileFullPath = Path.Combine(config.DirectorRootPath, filePath); Dictionary <string, string> tags = DCMHelper.TagRead(fileFullPath); string caseId = null; //病例号 string studyId = null; //检查号 string stuUid = null; if (tags != null) { tags.TryGetValue("0010,0020", out caseId); tags.TryGetValue("0008,0050", out studyId); tags.TryGetValue("0020,000d", out stuUid); } result.CaseID = caseId != null?caseId.Trim() : ""; result.StudyID = studyId != null?studyId.Trim() : ""; result.StuUID = stuUid != null?stuUid.TrimEnd('\0').Trim() : ""; #endregion return(result.ToApiResultForObject()); }
public async Task <ApiResult> UploadImageByBase64([FromBody] BLL.Sys.DTOs.Request.RequestUploadImageByBase64DTO request) { byte[] byteData = Convert.FromBase64String(request.Content.Replace("data:image/png;base64", "")); var FileType = "Images"; try { //文件存储配置 var config = SysConfigService.Get <XuHos.Common.Config.Sections.IMGStore>(); SysFileIndex fileIndex = null; var FileStream = new System.IO.MemoryStream(byteData); var FileMD5 = XuHos.Common.Utility.HashHelper.ComputeMD5(FileStream); //通过缓存来判断文件是否已经上传了 var CacheKey = new XuHos.Common.Cache.Keys.EntityCacheKey <SysFileIndex>(StringCacheKeyType.SysFileIndex, FileMD5); //缓存中获取文件索引 fileIndex = CacheKey.FromCache(); //文件已经存在 if (fileIndex != null) { //返回上传结果 return(new ResponseUploadFileDTO { UrlPrefix = config.UrlPrefix, FileName = string.Format("{0}/{1}", fileIndex.FileType, fileIndex.FileUrl), MD5 = fileIndex.MD5, FileSize = fileIndex.FileSize, FileSeq = request.FileSeq }.ToApiResultForObject()); } //文件不存在的才保存到服务器 else { SysFileIndexService fileService = new SysFileIndexService(CurrentOperatorUserID); //文件不存在 if (fileService.Exists(a => a.MD5 == FileMD5)) { fileIndex = fileService.Single <SysFileIndex>(a => a.MD5 == FileMD5); if (fileIndex != null) { //设置缓存 fileIndex.ToCache(CacheKey, TimeSpan.FromHours(2)); var result = new ResponseUploadFileDTO { UrlPrefix = config.UrlPrefix, FileName = string.Format("{0}/{1}", fileIndex.FileType, fileIndex.FileUrl), MD5 = fileIndex.MD5, FileSize = fileIndex.FileSize, FileSeq = request.FileSeq }; return(result.ToApiResultForObject()); } else { return(EnumApiStatus.BizError.ToApiResultForApiStatus()); } } else { //文件名 var FileUrl = Guid.NewGuid().ToString("N") + ".jpg"; var FileSize = FileStream.Length; await XuHos.Common.Storage.Manager.Instance.WriteFile(FileType, FileUrl, FileStream); fileIndex = new SysFileIndex() { MD5 = FileMD5, FileType = FileType, FileUrl = FileUrl, FileSize = FileSize, Remark = "", AccessKey = string.IsNullOrEmpty(request.AccessKey) ? "" : request.AccessKey }; var result = new ResponseUploadFileDTO { UrlPrefix = config.UrlPrefix, FileName = string.Format("{0}/{1}", FileType, FileUrl), MD5 = FileMD5, FileSize = FileSize, FileSeq = request.FileSeq, AccessKey = request.AccessKey }; var SaveFlag = false; //文件不存在 if (!fileService.Exists(a => a.MD5 == FileMD5)) { try { //添加记录 SaveFlag = fileService.Insert(fileIndex); } //主键冲突异常 catch (ConstraintException ex) { SaveFlag = true; } } else { SaveFlag = true; } //保存成功 if (SaveFlag) { //设置缓存 fileIndex.ToCache(CacheKey, TimeSpan.FromHours(2)); return(result.ToApiResultForObject()); } else { return(EnumApiStatus.BizError.ToApiResultForApiStatus()); } } } } catch (Exception ex) { string msg = ex.Message; if (ex.InnerException != null) { msg += System.Environment.NewLine + ex.InnerException.Message; if (ex.InnerException.InnerException != null) { msg += System.Environment.NewLine + ex.InnerException.InnerException.Message; } } LogHelper.WriteError(ex); return(EnumApiStatus.BizError.ToApiResultForApiStatus("上传失败,错误:" + msg)); } }
/// <summary> /// 根据用户编号获取用户信息 /// </summary> /// <param name="userId"></param> public ResponseUserDTO GetUserInfoByUserId(string userId) { if (string.IsNullOrEmpty(userId)) { return(default(ResponseUserDTO)); } var User_CacheKey = new XuHos.Common.Cache.Keys.EntityCacheKey <ResponseUserDTO>(StringCacheKeyType.User, userId); var userModel = User_CacheKey.FromCache(); if (userModel == null) { using (DBEntities db = new DBEntities()) { var query = from user in db.Users.Where(a => a.UserID == userId && a.IsDeleted == false) join userUid in db.ConversationIMUids on user.UserID equals userUid.UserID select new ResponseUserDTO() { CancelTime = user.CancelTime, Email = user.Email, Identifier = userUid.Identifier, UserID = user.UserID, Mobile = user.Mobile, Password = user.Password, PhotoUrl = user.PhotoUrl, RegTime = user.RegTime, UserType = user.UserType, UserState = user.UserState, UserLevel = user.UserLevel, UserAccount = user.UserAccount, OrgID = user.OrgCode, UserCNName = user.UserCNName, UserENName = user.UserENName, CreateUserID = user.CreateUserID }; userModel = query.FirstOrDefault(); if (userModel != null) { XuHos.BLL.User.Implements.UserMemberService service = new UserMemberService(); var MemberIsEmpty = service.GetMemberList(userModel.UserID).Find(a => a.Relation == EnumUserRelation.MySelf); //取 usercnname, 先取自己关系membername, 为空则取users.usercname,还为空则取手机号 var UserCNName = userModel.UserCNName; if (MemberIsEmpty != null && !string.IsNullOrWhiteSpace(MemberIsEmpty.MemberName)) { UserCNName = MemberIsEmpty.MemberName; } if (string.IsNullOrEmpty(UserCNName)) { UserCNName = userModel.Mobile; } userModel.UserCNName = UserCNName; userModel.UserENName = MemberIsEmpty != null ? MemberIsEmpty.MemberName : userModel.UserENName; userModel.MemberID = MemberIsEmpty != null ? MemberIsEmpty.MemberID : ""; userModel.IDType = MemberIsEmpty != null ? MemberIsEmpty.IDType : EnumUserCardType.IDCard; userModel.IDNumber = MemberIsEmpty != null ? MemberIsEmpty.IDNumber : ""; userModel.Gender = MemberIsEmpty != null ? MemberIsEmpty.Gender : EnumUserGender.Other; } userModel.ToCache(User_CacheKey, TimeSpan.FromMinutes(_GetUserInfoExpireMinutes())); } } return(userModel); }