public async Task <ActionResult> IuputFromExcel(OemDataViewModel model) { DataTable data = new DataTable(); await Task.Run(() => { string strExcel = ""; OpenFileDialog openFileDialog = new OpenFileDialog(); openFileDialog.InitialDirectory = "c:\\"; //注意这里写路径时要用c:\\而不是c:\ openFileDialog.Filter = "文本文件|*.*|C#文件|*.cs|所有文件|*.*"; openFileDialog.RestoreDirectory = true; openFileDialog.FilterIndex = 1; if (openFileDialog.ShowDialog() == DialogResult.OK) { strExcel = openFileDialog.FileName; } data = ExcelToDataTable(strExcel); }); return(Json(data)); }
//[HttpPost] //[ValidateAntiForgeryToken] public async Task <ActionResult> Query(OemDataViewModel model) { if (ModelState.IsValid) { using (OemDataServiceClient client = new OemDataServiceClient()) { await Task.Run(() => { StringBuilder where = new StringBuilder(); if (model != null) { if (!string.IsNullOrEmpty(model.LotNumber)) { where.AppendFormat(" {0} Key LIKE '{1}%'" , where.Length > 0 ? "AND" : string.Empty , model.LotNumber.ToString().Trim().ToUpper()); } if (!string.IsNullOrEmpty(model.OrderNumber)) { where.AppendFormat(" {0} OrderNumber LIKE '{1}%'" , where.Length > 0 ? "AND" : string.Empty , model.OrderNumber.ToString().Trim().ToUpper()); } if (!string.IsNullOrEmpty(model.PackageNo)) { where.AppendFormat(" {0} PackageNo LIKE '{1}%'" , where.Length > 0 ? "AND" : string.Empty , model.PackageNo.ToString().Trim().ToUpper()); } if (!string.IsNullOrEmpty(model.PnName)) { where.AppendFormat(" {0} PnName LIKE '{1}%'" , where.Length > 0 ? "AND" : string.Empty , model.PnName.ToString().Trim().ToUpper()); } if (!string.IsNullOrEmpty(model.Grade)) { where.AppendFormat(" {0} Grade LIKE '{1}%'" , where.Length > 0 ? "AND" : string.Empty , model.Grade.ToString().Trim().ToUpper()); } if (!string.IsNullOrEmpty(model.Color)) { where.AppendFormat(" {0} Color LIKE '{1}%'" , where.Length > 0 ? "AND" : string.Empty , model.Color.ToString().Trim().ToUpper()); } if (!string.IsNullOrEmpty(model.PsSubCode)) { where.AppendFormat(" {0} PsSubCode LIKE '{1}%'" , where.Length > 0 ? "AND" : string.Empty , model.PsSubCode.ToString().Trim().ToUpper()); } if (!string.IsNullOrEmpty(model.Status)) { where.AppendFormat(" {0} Status LIKE '{1}%'" , where.Length > 0 ? "AND" : string.Empty , model.Status.ToString().Trim().ToUpper()); } } PagingConfig cfg = new PagingConfig() { OrderBy = "Key", Where = where.ToString() }; MethodReturnResult <IList <OemData> > result = client.Get(ref cfg); if (result.Code == 0) { ViewBag.PagingConfig = cfg; ViewBag.OemDataList = result.Data; } }); } } if (Request.IsAjaxRequest()) { return(PartialView("_ListPartial", model)); } else { return(View(model)); } }