$("#file1").change(function () { var file = $('#file1')[0].files;//原生的js上files属性存放着input选中的文件数据 if (file.lenght <= 0) return alert('请选择文件上传')//判断是否选择文件上传 var formdata = new FormData();//实例化一个formdata对象 //FormData 接口提供了一种表示表单数据的键值对 key/value 的构造方式 formdata.append('avatar', file[0]);//通过formdata上的append()方法来追加数据 $.ajax({ url: '../PanDian/sctp',//请求访问的地址 type: 'post',//请求访问方式 data: formdata,//数据在这里 processData: false,//true会将传递的数据以字符串形式上传,false则不会转换,原样上传 contentType: false,//true默认会将发送数据的格式转换成字符串,false则会禁止默认行为 success: function (res) { console.log(res) } }) });
static object locker1 = new object(); public JsonResult sctp() { string r1 = ""; lock (locker1) { string code = ""; string msg = ""; string img = ""; string thumb = ""; try { HttpPostedFileBase file1 = Request.Files[0]; if (file1 == null) { code = "0"; msg = "未找到上传的文件!"; } else { string n1 = file1.FileName; n1 = n1.ToLower(); FileInfo fi = new FileInfo(n1); string n2 = ""; int n3 = n1.IndexOf("."); if (n3 > 0) { n2 = n1.Substring(0, n3); } else { n2 = n1; } string kzm = fi.Extension; kzm = kzm.ToLower(); if (kzm == ".xls" || kzm == ".xlsx" ) { string wjj = DateTime.Now.ToString("yyyyMMdd"); if (Directory.Exists(Server.MapPath("../UploadFile/jkm_temp/" + wjj)) == false)//如果不存在就创建file文件夹 { Directory.CreateDirectory(Server.MapPath("../UploadFile/jkm_temp/" + wjj)); } if (Directory.Exists(Server.MapPath("../UploadFile/jkm/" + wjj)) == false)//如果不存在就创建file文件夹 { Directory.CreateDirectory(Server.MapPath("../UploadFile/jkm/" + wjj)); } string wjm = DateTime.Now.ToString("HHmmssfff") + 3; string file3 = "../UploadFile/jkm_temp/" + wjj + "/" + wjm + kzm; file1.SaveAs(Server.MapPath(file3)); r1 = "../UploadFile/jkm_temp/" + wjj + "/" + wjm + kzm; string r3 = r1.Replace("..", "~"); string r2 = "~/UploadFile/jkm/" + wjj + "/" + wjm + kzm; string r4 = "../UploadFile/jkm/" + wjj + "/" + wjm + kzm; string r5 = r2.Replace(".", "m."); code = "1"; msg = "上传成功!"; } else { code = "0"; msg = "文件后缀不正确!"; } }
} catch (Exception e1) { string r10 = e1.Message; code = "0"; msg = r10; } return Json(new { code = code, msg = msg, img = img, thumb = thumb }, JsonRequestBehavior.AllowGet); } }
//在nuget添加Spire.Xls
using Spire.Xls;
private Model.sys.return1 dr1(string userid,int pdid,string fileName) { Model.sys.return1 r1 = new Model.sys.return1(); r1.code = ""; r1.msg = ""; Workbook wb = new Workbook(); List
try { wb.LoadFromFile(@fileName); for (int i = 1; i < wb.Worksheets[0].Rows.Count(); i++) { var row = wb.Worksheets[0].Rows[i]; string[] rows = new string[25]; for (int i1 = 0; i1 < 7; i1++) { rows[i1] = row.Cells[i1].Value.ToString().Trim(); } if (rows[1] == null || rows[1] == "") { break; } else { Model.pandian.pandian_kucun_mx m_d = new Model.pandian.pandian_kucun_mx(); m_d.wzbm = rows[1].Trim(); m_d.wzmc = rows[2].Trim(); m_d.ggxh = rows[3].Trim(); m_d.jldw = rows[4].Trim(); decimal jhdj = 0; decimal sl = 0; decimal.TryParse(rows[5].Trim(),out jhdj); decimal.TryParse(rows[6].Trim(), out sl); m_d.create_userid = userid; m_d.pandian_id = pdid; m_d.jhdj = jhdj; m_d.kcsl = sl; if (m_d.wzbm != "" && m_d.kcsl >0) { list_datas1.Add(m_d); } } } List
} catch (Exception ex) { r1.code = "0"; r1.msg = ex.Message; } return r1; }
参考链接
发表评论