private void toolOpenData_Click(object sender, EventArgs e) { openFileDialog1.Filter = "(txt文件)|*txt"; if (openFileDialog1.ShowDialog() == DialogResult.OK) { dataCenter = FileCenter.OpenFile(openFileDialog1.FileName); dataGridView1.DataSource = Report.GetTable(dataCenter); } }
public void ADDATTACH_IDTONEWTASK_ID(string NEWTASK_ID, string ATTACH_ID) { try { var newID = FileCenter.Clone(ATTACH_ID, Module.WKF); string connectionString = ConfigurationManager.ConnectionStrings["connectionstring"].ToString(); StringBuilder queryString = new StringBuilder(); //要記得改成正式-4 queryString.AppendFormat(@" UPDATE [{0}].dbo.TB_WKF_TASK SET ATTACH_ID='{2}' WHERE DOC_NBR='{1}' ", DBNAME, NEWTASK_ID, newID.ToString()); try { using (SqlConnection connection = new SqlConnection(connectionString)) { SqlCommand command = new SqlCommand(queryString.ToString(), connection); command.Connection.Open(); int count = command.ExecuteNonQuery(); connection.Close(); connection.Dispose(); } } catch { } finally { } } catch { } finally { } }
public async Task <MessageModel <UploadFileModel> > DeleteThisFile(int?fileId) { var data = new MessageModel <UploadFileModel>(); UploadFileModel upfileModels = new UploadFileModel(); if (!fileId.HasValue) { data.msg = "没参数"; return(data); } FileCenter tfile = await _fileCenterServices.QueryById(fileId.Value); if (tfile != null && tfile.ExterndAtt == SystemConst.FILE_EXTERNARR_THUMBONTHIS) { //检测一下,如果是主图,要重新生成主图和缩略图信息 //下载下来这个批次中排首的图,重新生成缩略图 FileCenter nextfile = await _fileCenterServices.GetFirstOneExceptMe(tfile.BatchId, tfile.Id); //更新这个图为主图 Stream s = AliYunOss.Instance.GetFileFromAliOss(nextfile.OssKey); if (nextfile != null) { string filethumbName = IdCreatorHelper.CreateIdNoTimestrap(SystemConst.PREF_THUMB_NAME_PUB_TREE, 6) + ".jpg"; string AliossFolder = DateTime.Now.ToString("yyyyMMddHH"); string newthumbUrl = await CreateThumb(s, nextfile.BatchId, AliossFolder + "/" + filethumbName); nextfile.ExterndAtt = SystemConst.FILE_EXTERNARR_THUMBONTHIS; //更新这个批次的缩略图信息 bool thumbok = await _fileCenterServices.UpdateThisFileUrlByBatchIdAndSeq(nextfile.BatchId, 0, newthumbUrl); bool isOk = await _fileCenterServices.Update(nextfile); upfileModels.MainPic = nextfile.Url; upfileModels.ThumbnailUrl = newthumbUrl; data.response = upfileModels; } } bool isOK = await _fileCenterServices.DeleteById(fileId.Value); data.msg = isOK ? "删除成功" : "删除失败"; return(data); }
public Result UpLoadFile() { System.Web.HttpRequest request = System.Web.HttpContext.Current.Request; // string taskID = request["ETID"].ToString().Trim(); //int ETClass = Convert.ToInt32(request["ETClass"].ToString().Trim()); // int tid = int.Parse(taskID); //var task = service.FindEntity<MyTest>(m => m.Id == tid); //if (task == null) return new Result("-1", "任务为空"); System.Web.HttpFileCollection fileCollection = request.Files; if (fileCollection.Count < 1) { return(new Result("-1", "上传失败,文件为空")); } var fileinfo = UploadHelper.UploadFile(fileCollection[0]); if (fileinfo.IsSuccess == false) { return(new Result("-1", "上传失败")); } FileCenter newfile = new FileCenter(); newfile.CreateDT = DateTime.Now; newfile.EndUserID = 0; newfile.RealName = fileinfo.OldFileName; newfile.FileName = fileinfo.NewFileName; newfile.FileUrl = fileinfo.FilePath; newfile.FileSize = fileCollection[0].ContentLength / 1000; newfile.CreateUserID = service.GetPersonID(ControllerContext.Request.Properties["WorkNo"].ToString());//请求人ID if (service.Insert <FileCenter>(newfile)) { //ET_TaskFiled ET_TaskFiled = new ET_TaskFiled(); //ET_TaskFiled.ETID = tid; //ET_TaskFiled.ETClass = ETClass; //ET_TaskFiled.FiledID = newfile.ID; //if (service.Insert<ET_TaskFiled>(ET_TaskFiled)) //{ return(new Result("0", newfile.ID.ToString())); //} } return(new Result("-1", "上传失败")); }
private async Task <FileCenter> CreateThumb(IFormFile tfile, string batchId, string fileName) { string timepre = Guid.NewGuid().ToString().Replace("-", ""); string tempfolder = _env.WebRootPath + "/" + SystemConst.TEMP_FOLDER_NAME; if (!Directory.Exists(tempfolder)) { Directory.CreateDirectory(tempfolder); } string tempfile = tempfolder + "/" + timepre + SystemConst.TEMP_IMGNAME_FOR_TREE; string tempthumbfile = tempfolder + "/" + timepre + SystemConst.TEMP_IMGNAME_FOR_TREE_THUMB; var stream = System.IO.File.Create(tempfile); await tfile.CopyToAsync(stream); stream.Close(); //压缩 ImageHelper.CompressImage(tempfile, tempthumbfile, 50, 10); var thumbstream = System.IO.File.Open(tempthumbfile, FileMode.Open); AliYunOss.Instance.PutFileToOss(thumbstream, fileName); thumbstream.Close(); System.IO.File.Delete(tempfile); System.IO.File.Delete(tempthumbfile); FileCenter f = new FileCenter(); f.BatchId = batchId; f.BatchSeq = 0;//序号0 一定设置是缩略图 f.CreateTime = DateTime.Now; f.FileName = "thumb" + tfile.FileName; f.FileSize = tfile.Length; f.Status = 0; f.OssKey = fileName; f.Url = AliYunOssConfig.Endpoint + "/" + fileName; f.ExterndAtt = SystemConst.FILE_EXTERNARR_THUMB; return(f); }
public async Task <MessageModel <UploadFileModel> > PushPic() { var data = new MessageModel <UploadFileModel>(); int currentIndex = 1; UploadFileModel upfileModels = new UploadFileModel(); string batchId = Request.Form["batchId"]; //先检查有没有batchid,如果有,说明已开始存入过,那么不需要new batchid if (string.IsNullOrEmpty(batchId)) { batchId = IdCreatorHelper.CreateId(SystemConst.PREF_BATCHID_FOR_PUB_TREE); } else { //找到此batchid 已累计增加的index ,用缓存缓住 string currindex = _cacheHelper.Get <string>(batchId); currentIndex = int.Parse(string.IsNullOrEmpty(currindex)?"1":currindex); } IFormFileCollection cols = Request.Form.Files; if (cols == null || cols.Count == 0) { data.msg = "没有上传文件"; return(data); } //上传到oss string AliossFolder = DateTime.Now.ToString("yyyyMMddHH"); List <FileCenter> dbfiles = new List <FileCenter>(); upfileModels.BatchId = batchId; List <IFormFile> postFiles = cols.ToList(); for (int i = 0; i < postFiles.Count; i++) { var tfile = postFiles[i]; string fileName = AliossFolder + "/" + IdCreatorHelper.CreateIdNoTimestrap(SystemConst.PREF_ALIOSS_FILENAME_FOR_TREE, 6) + ".jpg"; AliYunOss.Instance.PutFileToOss(tfile.OpenReadStream(), fileName); FileCenter f = new FileCenter(); if (currentIndex == 1)//默认第一个设置缩略图,设为主图 { string filethumbName = IdCreatorHelper.CreateIdNoTimestrap(SystemConst.PREF_THUMB_NAME_PUB_TREE, 6) + ".jpg"; FileCenter thumbfile = await CreateThumb(tfile, batchId, AliossFolder + "/" + filethumbName); dbfiles.Add(thumbfile); upfileModels.ThumbnailUrl = thumbfile.Url; upfileModels.MainPic = AliYunOssConfig.Endpoint + "/" + fileName; //第一个默认主图 f.ExterndAtt = SystemConst.FILE_EXTERNARR_THUMBONTHIS; //设置浮标,标明 缩略图建立在这个图上 } f.BatchId = batchId; f.BatchSeq = currentIndex; f.CreateTime = DateTime.Now; f.FileName = tfile.FileName; f.FileSize = tfile.Length; f.Status = 0; f.OssKey = fileName; f.Url = AliYunOssConfig.Endpoint + "/" + fileName; dbfiles.Add(f); currentIndex++; } _cacheHelper.Set <string>(batchId, currentIndex.ToString(), DateTime.Now.AddHours(1)); try { bool isok = await _fileCenterServices.AddIsIdentity(dbfiles); dbfiles.ForEach(u => upfileModels.files.Add(u.FileName, u.Id)); } catch (Exception ex) { string e = ex.ToString(); } //返回这一批次ID,返回已上传的ID data.response = upfileModels; return(data); }