//bootstrap fileinputbundles.Add(new ScriptBundle("~/Content/bootstrap-fileinput/js").Include("~/Content/bootstrap-fileinput/js/fileinput.min.js","~/Content/bootstrap-fileinput/js/fileinput_locale_zh.js"));bundles.Add(new StyleBundle("~/Content/bootstrap-fileinput/css").Include("~/Content/bootstrap-fileinput/css/fileinput.min.css"));@Scripts.Render("~/Content/bootstrap-fileinput/js")@Styles.Render("~/Content/bootstrap-fileinput/css")

<form><div class="modal fade" id="myModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel"><div class="modal-dialog modal-lg" role="document"><div class="modal-content"><div class="modal-header"><button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button><h4 class="modal-title" id="myModalLabel">請(qǐng)選擇Excel文件</h4></div><div class="modal-body"><a href="~/Data/ExcelTemplate/Order.xlsx" class="form-control" style="border:none;">下載導(dǎo)入模板</a><input type="file" name="txt_file" id="txt_file" multiple class="file-loading" /></div></div></div></div></form>

<input type="file" name="txt_file" id="txt_file" multiple class="file-loading" />

$(function () {//0.初始化fileinputvar oFileInput = new FileInput();oFileInput.Init("txt_file", "/api/OrderApi/ImportOrder");});//初始化fileinputvar FileInput = function () {var oFile = new Object();//初始化fileinput控件（第一次初始化）oFile.Init = function(ctrlName, uploadUrl) {var control = $('#' + ctrlName);//初始化上傳控件的樣式control.fileinput({language: 'zh', //設(shè)置語(yǔ)言u(píng)ploadUrl: uploadUrl, //上傳的地址allowedFileExtensions: ['jpg', 'gif', 'png'],//接收的文件后綴showUpload: true, //是否顯示上傳按鈕showCaption: false,//是否顯示標(biāo)題browseClass: "btn btn-primary", //按鈕樣式 //dropZoneEnabled: false,//是否顯示拖拽區(qū)域//minImageWidth: 50, //圖片的最小寬度//minImageHeight: 50,//圖片的最小高度//maxImageWidth: 1000,//圖片的最大寬度//maxImageHeight: 1000,//圖片的最大高度//maxFileSize: 0,//單位為kb，如果為0表示不限制文件大小//minFileCount: 0,maxFileCount: 10, //表示允許同時(shí)上傳的最大文件個(gè)數(shù)enctype: 'multipart/form-data',validateInitialCount:true,previewFileIcon: "<i class='glyphicon glyphicon-king'></i>",msgFilesTooMany: "選擇上傳的文件數(shù)量({n}) 超過(guò)允許的最大數(shù)值{m}！",});//導(dǎo)入文件上傳完成之后的事件$("#txt_file").on("fileuploaded", function (event, data, previewId, index) {$("#myModal").modal("hide");var data = data.response.lstOrderImport;if (data == undefined) {toastr.error('文件格式類(lèi)型不正確');return;}//1.初始化表格var oTable = new TableInit();oTable.Init(data);$("#div_startimport").show();});}return oFile;};

[ActionName("ImportOrder")]public object ImportOrder(){var oFile = HttpContext.Current.Request.Files["txt_file"];var lstOrderImport = new List<DTO_TO_ORDER_IMPORT>();#region 0.數(shù)據(jù)準(zhǔn)備var lstExistOrder = orderManager.Find();var lstOrderNo = lstExistOrder.Select(x => x.ORDER_NO).ToList();var lstTmModel = modelManager.Find();var lstTmMaterial = materialManager.Find();//var iMax_Import_Index = lstExistOrder.Max(x => x.IMPORT_INDEX);//iMax_Import_Index = iMax_Import_Index == null ? 0 : iMax_Import_Index.Value;#endregion#region 1.通過(guò)Stream得到Workbook對(duì)象IWorkbook workbook = null;if (oFile.FileName.EndsWith(".xls")){workbook = new HSSFWorkbook(oFile.InputStream);}else if(oFile.FileName.EndsWith(".xlsx")){workbook = new XSSFWorkbook(oFile.InputStream);}if (workbook == null){return new { };}//...............處理excel的邏輯//orderManager.Add(lstOrder);lstOrderImport = lstOrderImport.OrderBy(x => x.IMPORT_STATU).ToList();return new { lstOrderImport = lstOrderImport };}