小程序logo设计_jquery.form.js异步提交表单详解

jquery.form.js异步提交表单详解       这篇文章主要为大家详细介绍了jquery.form.js异步提交表单的方法,具有一定的参考价值,感兴趣的小伙伴们可以参考一下

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

引入脚本:

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

span input type="text" name="uploadfile-1" id="uploadfile-1" readonly a href="javascript:void();" rel="external nofollow" i #xf0020; /i 浏览文件 /a input type="file" multiple name="file-1" /span input type="button" value="保存"/ a href="/files/企业表.xls" rel="external nofollow" target="_blank" 下载范例 /a div /div /form
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; esscount = 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();
/// 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, ess.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;

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




扫描二维码分享到微信