jquery.form.js异步提交表单详解

本文实例为大家分享了jquery.form.js异步提交表单的具体代码，供大家参考，具体内容如下

引入脚本:

<script type="text/javascript" src="/js/jquery.form.min.js"></script>
<script src="/js/json2.js"></script>

//前端代码:
<form id="f1">
 <span class="btn-upload form-group">
 <input class="input-text upload-url radius" type="text" name="uploadfile-1" id="uploadfile-1" readonly><a href="javascript:void();" rel="external nofollow" class="btn btn-primary radius"><i class="iconfont">󰀠</i> 浏览文件</a>
 <input type="file" multiple name="file-1" class="input-file">
 </span>
 <input type="button" class="btn btn-warning radius mt-10 f-l mr-10" onclick="ImportData(this)" value="保存"/>
 <a href="/files/企业表.xls" rel="external nofollow" target="_blank" class="f-16 l-30 mt-10 f-l c-danger">下载范例</a>
 <div class="clearfix"></div>
 </form>


//提交表单
 $("#f1").ajaxSubmit({
 url: "/ImportAndCheck/ImportCompanyOperation/",
 type: "post",
 enctype: "multipart/form-data",
 dataType: "html",
 beforeSubmit: function () {
 $(obj).val("保存中...").attr("disabled", true);
 },
 success: function (response) {
 try {
 data = JSON.parse(response);
 if (data.code > 0) {
 layer.msg(data.msg, { time: 1000 });
 setTimeout(function () {
 window.location.href = "/ImportAndCheck/ImportCompany?status=0";
 }, 1000);
 } else {
 layer.msg(data.msg, { time: 1000 });
 $(obj).val("保存").attr("disabled", false);
 }
 } catch (err) {
 layer.msg("导入失败！", { time: 1000 });
 $(obj).val("保存").attr("disabled", false);
 }

 },
 error: function (XmlHttpRequest, textStatus, errorThrown) {
 layer.msg("导入失败", { time: 1000 });
 $(obj).val("保存").attr("disabled", false);
 }
 });

//服务端
HttpFileCollection files = System.Web.HttpContext.Current.Request.Files;
 ReturnJsonCode jsonCode = new ReturnJsonCode();
 if (files == null || files.Count == 0)
 {
 jsonCode.msg = "请选择上传的导入文件";
 return jsonCode;
 }
 //验证文件类型
 if (files != null && files.Count > 0)
 {
 HttpPostedFile file = null;
 file = files[0];
 //扩展名检查
 string picext = System.IO.Path.GetExtension(file.FileName).ToLower();
 if (picext != ".xls")
 {
 jsonCode.msg = "上传文件仅支持xls文档格式";
 return jsonCode;
 }

 DataTable db = ExcelToDataTable(file, file.FileName, 0);
 int failcount = 0;
 int successcount = 0;
 if (db != null && db.Rows.Count > 0)
 {
 foreach (DataRow dr in db.Rows)
 {
 string mobile = dr["手机号码"].ToString().Trim();
 string truename = dr["姓名"].ToString().Trim();
 string iskejizhuanyuan = dr["科技专员"].ToString().Trim();
 string sex = dr["性别"].ToString().Trim();

/// <summary>
 /// Excel文件导成Datatable
 /// </summary>
 /// <param name="strFilePath">Excel文件目录地址</param>
 /// <param name="strTableName">Datatable表名</param>
 /// <param name="iSheetIndex">Excel sheet index</param>
 /// <returns></returns>
 public static DataTable ExcelToDataTable(string strFilePath, string strTableName, int iSheetIndex)
 {
 var strExtName = Path.GetExtension(strFilePath);

 var dt = new DataTable();
 if (!string.IsNullOrEmpty(strTableName))
 {
 dt.TableName = strTableName;
 }

 if (strExtName.Equals(".xls"))
 {
 using (var file = new FileStream(strFilePath, FileMode.Open, FileAccess.Read))
 {
 var workbook = new HSSFWorkbook(file);
 var sheet = workbook.GetSheetAt(iSheetIndex);

 //列头
 foreach (var item in sheet.GetRow(sheet.FirstRowNum).Cells)
 {
 dt.Columns.Add(item.ToString(), typeof(string));
 }

 //写入内容
 var rows = sheet.GetRowEnumerator();
 while (rows.MoveNext())
 {
 IRow row = (HSSFRow)rows.Current;
 if (row.RowNum == sheet.FirstRowNum)
 {
 continue;
 }

 var dr = dt.NewRow();
 foreach (var item in row.Cells)
 {
 switch (item.CellType)
 {
 case CellType.Boolean:
 dr[item.ColumnIndex] = item.BooleanCellValue;
 break;
 case CellType.Error:
 dr[item.ColumnIndex] = ErrorEval.GetText(item.ErrorCellValue);
 break;
 case CellType.Formula:
 switch (item.CachedFormulaResultType)
 {
 case CellType.Boolean:
 dr[item.ColumnIndex] = item.BooleanCellValue;
 break;
 case CellType.Error:
 dr[item.ColumnIndex] = ErrorEval.GetText(item.ErrorCellValue);
 break;
 case CellType.Numeric:
 if (DateUtil.IsCellDateFormatted(item))
 {
 dr[item.ColumnIndex] = item.DateCellValue.ToString("yyyy-MM-dd hh:MM:ss");
 }
 else
 {
 dr[item.ColumnIndex] = item.NumericCellValue;
 }
 break;
 case CellType.String:
 var str = item.StringCellValue;
 if (!string.IsNullOrEmpty(str))
 {
 dr[item.ColumnIndex] = str;
 }
 else
 {
 dr[item.ColumnIndex] = null;
 }
 break;
 case CellType.Unknown:
 case CellType.Blank:
 default:
 dr[item.ColumnIndex] = string.Empty;
 break;
 }
 break;
 case CellType.Numeric:
 if (DateUtil.IsCellDateFormatted(item))
 {
 dr[item.ColumnIndex] = item.DateCellValue.ToString("yyyy-MM-dd hh:MM:ss");
 }
 else
 {
 dr[item.ColumnIndex] = item.NumericCellValue;
 }
 break;
 case CellType.String:
 var strValue = item.StringCellValue;
 if (!string.IsNullOrEmpty(strValue))
 {
 dr[item.ColumnIndex] = strValue;
 }
 else
 {
 dr[item.ColumnIndex] = null;
 }
 break;
 case CellType.Unknown:
 case CellType.Blank:
 default:
 dr[item.ColumnIndex] = string.Empty;
 break;
 }
 }
 dt.Rows.Add(dr);
 }
 }
 }
 return dt;
 }

以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持脚本之家。