/// <summary> /// 资料上传 /// </summary> /// <param name="model"></param> /// <returns></returns> public static List <IES.Resource.Model.File> ResourceFileUpload(IES.Resource.Model.File model) { HttpFileCollection files = HttpContext.Current.Request.Files; List <IES.Resource.Model.File> resourcefilelist = new List <IES.Resource.Model.File>(); for (int i = 0; i < files.Count; i++) { IESFile file = Upload(files[i]); if (file.FileGuid != null && file.FileGuid != string.Empty) { if (RemoteFileExists(file)) { FileBLL bll = new FileBLL(); file.FileType = file.GetFileType(); IES.Resource.Model.File resourcefile = new IES.Resource.Model.File { FileName = file.FileName, ServerID = file.ServerID, FileSize = file.FileSize, FileTitle = file.FileTitle, OCID = model.OCID, FolderID = model.FolderID, CourseID = model.CourseID, CreateUserID = UserService.CurrentUser.UserID, CreateUserName = UserService.CurrentUser.UserName, Ext = file.Ext, FileType = file.FileType, ShareRange = model.ShareRange }; resourcefile = bll.File_ADD(resourcefile); if (resourcefile.FileID > 0) { resourcefilelist.Add(resourcefile); } } } } return(resourcefilelist); }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; context.Response.AddHeader("Cache-Control", "no-cache,must-revalidate"); //FROM 1 资料 2 附件 var from = context.Request.QueryString["FROM"]; if (from.Equals("2")) { ///习题附件 List <IES.Resource.Model.Attachment> attachMentList = IES.Service.FileService.AttachmentUpload(); context.Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(attachMentList)); } else if (from.Equals("3")) { try { ///习题验证 ///读取Excel文件内容 HttpFileCollection files = HttpContext.Current.Request.Files; HttpPostedFile postFile = files[0]; string filehead = Guid.NewGuid().ToString().Replace("-", ""); string Ext = Path.GetExtension(postFile.FileName); string newFileName = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "Temp", filehead + Ext); postFile.SaveAs(newFileName); System.Data.DataTable table = NPOIHandler.ExcelToDataTable(newFileName, "Sheet1", true); DataTable resultTable = ImportCheck(table, int.Parse(context.Request.Form["Category"])); var obj = new { fileName = filehead + Ext, data = resultTable }; context.Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(obj)); } catch (Exception ex) { DataTable resultTable = BuildResultTable(); DataRow newRow = resultTable.NewRow(); newRow["Message"] = "导入文件格式错误!"; newRow["Status"] = "-2"; newRow["RowNumber"] = 1; resultTable.Rows.Add(newRow); var obj = new { fileName = "", data = resultTable }; context.Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(obj)); } } else if (from.Equals("4")) { ///习题导入 string serverFileName = context.Request.QueryString["fileName"]; int ocid = int.Parse(context.Request.QueryString["OCID"]); int courseId = int.Parse(context.Request.QueryString["CourseID"]); int category = int.Parse(context.Request.QueryString["Category"]); if (string.IsNullOrEmpty(serverFileName)) { context.Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(new { status = -2 }));; return; } string newFileName = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "Temp", serverFileName); System.Data.DataTable table = NPOIHandler.ExcelToDataTable(newFileName, "Sheet1", true); ///导入数据至数据库 DataTable resultTable = ExerciseInfo_Import(table, ocid, courseId, category); context.Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(new { status = 1, data = resultTable }));; } else { ///资料库文件导入 IES.Resource.Model.File fileModel = new IES.Resource.Model.File(); fileModel.OCID = int.Parse(context.Request.Form["OCID"]); fileModel.CourseID = int.Parse(context.Request.Form["CourseID"]); fileModel.FolderID = int.Parse(context.Request.Form["FolderID"] == "undefined" ? "0" : context.Request.Form["FolderID"]); fileModel.ShareRange = int.Parse(context.Request.Form["ShareRange"]); List <IES.Resource.Model.File> fileList = IES.Service.FileService.ResourceFileUpload(fileModel); context.Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(fileList)); } context.Response.End(); }