| | |
| | | [ApiExplorerSettings(GroupName = "Excel导入")] |
| | | [ApiController] |
| | | [Route("api/[controller]")] |
| | | //[ChannelActionFilter] |
| | | [ChannelActionFilter] |
| | | public class ImportExcelController : Controller |
| | | { |
| | | |
| | |
| | | list.json2 = list.json2; |
| | | return Json(list); |
| | | } |
| | | //list.json3 = ExcelCheckData(myModel); //数据验证 |
| | | //if (list.json3.code == "300") |
| | | //{ |
| | | // list.json3 = list.json3; |
| | | // return Json(list); |
| | | //} |
| | | list.json3 = ExcelImportSubmit(dataTable, FileCode); //数据导入 |
| | | if (list.json3.code == "300") |
| | | { |
| | | list.json3 = list.json3; |
| | | return Json(list); |
| | | } |
| | | return Json(list); |
| | | } |
| | | #endregion |
| | |
| | | catch (Exception e) |
| | | { |
| | | mes.code = "300"; |
| | | mes.Message = e.Message; |
| | | mes.message = e.Message; |
| | | } |
| | | return mes; |
| | | } |
| | |
| | | List<DataTable> dataTable = myModel.TableData; |
| | | list = ExcelCheckBLL.ExcelCheckData(FileCode, dataTable, out StuCode, out message, out count); |
| | | mes.code = StuCode; |
| | | mes.Message = message; |
| | | mes.message = message; |
| | | mes.count = count; |
| | | mes.data = list; |
| | | return mes; |
| | |
| | | catch (Exception e) |
| | | { |
| | | mes.code = "300"; |
| | | mes.Message = e.Message; |
| | | mes.message = e.Message; |
| | | } |
| | | return mes; |
| | | } |