好资源导航 » 文章资讯 » jquery.form.js异步提交表单详解

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

2024-02-25 02:05:03 43

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

引入脚本:

//前端代码:


󰀠浏览文件



下载范例

//提交表单 $("#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); } });

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

DataTabledb=ExcelToDataTable(file,file.FileName,0);
intfailcount=0;
intsuccesscount=0;
if(db!=null&&db.Rows.Count>0)
{
foreach(DataRowdrindb.Rows)
{
stringmobile=dr["手机号码"].ToString().Trim();
stringtruename=dr["姓名"].ToString().Trim();
stringiskejizhuanyuan=dr["科技专员"].ToString().Trim();
stringsex=dr["性别"].ToString().Trim();

///
///Excel文件导成Datatable
///
///Excel文件目录地址
///Datatable表名
///Excelsheetindex
///
publicstaticDataTableExcelToDataTable(stringstrFilePath,stringstrTableName,intiSheetIndex)
{
varstrExtName=Path.GetExtension(strFilePath);

vardt=newDataTable();
if(!string.IsNullOrEmpty(strTableName))
{
dt.TableName=strTableName;
}

if(strExtName.Equals(".xls"))
{
using(varfile=newFileStream(strFilePath,FileMode.Open,FileAccess.Read))
{
varworkbook=newHSSFWorkbook(file);
varsheet=workbook.GetSheetAt(iSheetIndex);

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

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

vardr=dt.NewRow();
foreach(variteminrow.Cells)
{
switch(item.CellType)
{
caseCellType.Boolean:
dr[item.ColumnIndex]=item.BooleanCellValue;
break;
caseCellType.Error:
dr[item.ColumnIndex]=ErrorEval.GetText(item.ErrorCellValue);
break;
caseCellType.Formula:
switch(item.CachedFormulaResultType)
{
caseCellType.Boolean:
dr[item.ColumnIndex]=item.BooleanCellValue;
break;
caseCellType.Error:
dr[item.ColumnIndex]=ErrorEval.GetText(item.ErrorCellValue);
break;
caseCellType.Numeric:
if(DateUtil.IsCellDateFormatted(item))
{
dr[item.ColumnIndex]=item.DateCellValue.ToString("yyyy-MM-ddhh:MM:ss");
}
else
{
dr[item.ColumnIndex]=item.NumericCellValue;
}
break;
caseCellType.String:
varstr=item.StringCellValue;
if(!string.IsNullOrEmpty(str))
{
dr[item.ColumnIndex]=str;
}
else
{
dr[item.ColumnIndex]=null;
}
break;
caseCellType.Unknown:
caseCellType.Blank:
default:
dr[item.ColumnIndex]=string.Empty;
break;
}
break;
caseCellType.Numeric:
if(DateUtil.IsCellDateFormatted(item))
{
dr[item.ColumnIndex]=item.DateCellValue.ToString("yyyy-MM-ddhh:MM:ss");
}
else
{
dr[item.ColumnIndex]=item.NumericCellValue;
}
break;
caseCellType.String:
varstrValue=item.StringCellValue;
if(!string.IsNullOrEmpty(strValue))
{
dr[item.ColumnIndex]=strValue;
}
else
{
dr[item.ColumnIndex]=null;
}
break;
caseCellType.Unknown:
caseCellType.Blank:
default:
dr[item.ColumnIndex]=string.Empty;
break;
}
}
dt.Rows.Add(dr);
}
}
}
returndt;
}

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

返回顶部
514930285
czq8825@qq.com

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

热门推荐

随机推荐