| | |
| | | |
| | | namespace VueWebApi.Controllers |
| | | { |
| | | [RoutePrefix(prefix: "api/BasicSetting")] |
| | | [RoutePrefix(prefix: "api/ImportExcel")] |
| | | [ControllerGroup("Excel导入模板验证", "在线接口")] |
| | | public class ImportExcelController : ApiController |
| | | { |
| | |
| | | list = list.Where(s => s.FileCode == FileCode).ToList(); |
| | | var filename = list[0].FileName + ".xls"; |
| | | string fileip = System.Configuration.ConfigurationManager.AppSettings["FileIP"]; |
| | | var msg = fileip + "/apis/Excel/" + filename; |
| | | var msg = fileip + "/Excel/" + filename; |
| | | mes.code = "200"; |
| | | mes.data = msg; |
| | | return TJson.toJson(mes); |
| | |
| | | /// <summary> |
| | | /// Excel导入文件上传、模板验证、数据量、验证 |
| | | /// </summary> |
| | | /// <param name="files">上传文件</param> |
| | | /// <param name="FileCode">文件编码</param> |
| | | /// <param name="files">上传文件</param> |
| | | /// <returns></returns> |
| | | [Route(template: "ExcelModelCheck")] |
| | | [HttpGet] |
| | | public HttpResponseMessage ExcelModelCheck(HttpPostedFileBase files, string FileCode = null) |
| | | [HttpPost] |
| | | public HttpResponseMessage ExcelModelCheck() |
| | | { |
| | | |
| | | string FileCode = HttpContext.Current.Request["FileCode"].ToString(); |
| | | HttpPostedFile files = HttpContext.Current.Request.Files[0]; |
| | | ExcelModelCheck list = new ExcelModelCheck(); |
| | | Dictionary<object, object> dList = new Dictionary<object, object>(); |
| | | list.json1 = ExcelCheckUpload(files, FileCode); //文件上传 |
| | |
| | | [Route(template: "ExcelCheckUpload")] |
| | | [HttpGet] |
| | | [HiddenApi] |
| | | public ToMessage ExcelCheckUpload(HttpPostedFileBase files, string FileCode = null) |
| | | public ToMessage ExcelCheckUpload(HttpPostedFile files, string FileCode = null) |
| | | { |
| | | try |
| | | { |
| | |
| | | else if (Directory.Exists(path) == false)//如果不存在就创建file文件夹 |
| | | { |
| | | Directory.CreateDirectory(path); //添加文件夹 |
| | | files.SaveAs(savePath); //将选择的文件保存到指定文件夹下 |
| | | mes.code = "200"; |
| | | mes.Message = "文件上传成功!"; |
| | | } |
| | | else if (Directory.Exists(savePath) == true) //如果存在重名文件就提示 |
| | | { |
| | |
| | | [Route(template: "ExcelCheckUpload")] |
| | | [HttpGet] |
| | | [HiddenApi] |
| | | public ToMessage ExcelCheck(HttpPostedFileBase files, string FileCode = null) |
| | | public ToMessage ExcelCheck(HttpPostedFile files, string FileCode = null) |
| | | { |
| | | try |
| | | { |
| | |
| | | /// <param name="FileCode">文件编码</param> |
| | | /// <returns></returns> |
| | | [HiddenApi] |
| | | public ToMessage ExcelCheckCount(HttpPostedFileBase files, string FileCode = null) |
| | | public ToMessage ExcelCheckCount(HttpPostedFile files, string FileCode = null) |
| | | { |
| | | string savePath; |
| | | |
| | |
| | | /// <param name="FileCode">文件编码</param> |
| | | /// <param name="FileName">文件名称</param> |
| | | /// <returns></returns> |
| | | [HiddenApi] |
| | | [Route(template: "ExcelCheckData")] |
| | | [HttpPost] |
| | | public HttpResponseMessage ExcelCheckData(string FileCode = null, string FileName = null) |
| | | { |
| | | string message = ""; |
| | |
| | | /// <param name="FileCode">文件编码</param> |
| | | /// <param name="FileName">文件名称</param> |
| | | /// <returns></returns> |
| | | [HiddenApi] |
| | | [Route(template: "ExcelImportSubmit")] |
| | | [HttpPost] |
| | | public HttpResponseMessage ExcelImportSubmit(string FileCode = null, string FileName = null) |
| | | { |
| | | var username = HttpContext.Current.Request.Cookies["admin"].Value.ToString(); //登录用户名 |