//导出excel public ActionResult GropingExcel(int udg_id, int ExperimentalId, int grop) { var strFullName = ""; try { UpDownExperiment upDownExperiment = dbDrive.GetUpDownExperiment(ExperimentalId); List <UpDownView> upDownViews = dbDrive.GetUpDownViews(udg_id); List <UpDownView> upDownViews1 = dbDrive.GetUpDownViews_UDEID(ExperimentalId); List <UpDownGroup> list_udg = dbDrive.GetUpDownGroups(ExperimentalId); var lr = LiftingPublic.SelectState(upDownExperiment); int[] nj = new int[list_udg.Count]; double[] Gj = new double[list_udg.Count]; double[] Hj = new double[list_udg.Count]; double[] muj = new double[list_udg.Count]; double[] sigmaj = new double[list_udg.Count]; for (int i = 0; i < list_udg.Count; i++) { List <UpDownDataTable> upDownDataTables = dbDrive.GetUpDownDataTables(list_udg[i].Id); var xAndV = LiftingPublic.GetXArrayAndVArray(upDownDataTables, upDownExperiment); var up = lr.GetReturn(xAndV.xArray, xAndV.vArray, upDownDataTables[0].dtup_Standardstimulus, list_udg[i].dudt_Stepd, out double z, upDownExperiment.udt_Instrumentresolution, out double z1); nj[i] = up.n; Gj[i] = up.G; Hj[i] = up.H; muj[i] = up.μ0_final; sigmaj[i] = up.σ0_final; } strFullName = FreeSpire.UpDownFreeSpireExcel(upDownExperiment, upDownViews, grop, upDownViews1, nj, Gj, Hj, muj, sigmaj, lr, list_udg); } catch (Exception ex) { } return(Json(strFullName, JsonRequestBehavior.AllowGet)); }
//导出excel public JsonResult ExportXls(int langlryExpTableId) { var strFullName = ""; try { LangleyExperimentTable langlryExpTable = dbDrive.GetLangleyExperimentTable(langlryExpTableId); List <LangleyDataTable> ldts = dbDrive.GetAllLangleyDataTable(langlryExpTable.let_Id); strFullName = FreeSpire.LangleyFreeSpireExcel(langlryExpTable, ldts); } catch (Exception ex) { } return(Json(strFullName, JsonRequestBehavior.AllowGet)); }
//导出excel public JsonResult ExportXls(int DoptimizeExpTableId) { var strFullName = ""; try { DoptimizeExperimentTable doptimizeExperimentTable = dbDrive.GetDoptimizeExperimentTable(DoptimizeExpTableId); List <DoptimizeDataTable> ddts = dbDrive.GetDoptimizeDataTables(doptimizeExperimentTable.det_Id); strFullName = FreeSpire.DoptimizeFreeSpireExcel(doptimizeExperimentTable, ddts); } catch (Exception ex) { } return(Json(strFullName, JsonRequestBehavior.AllowGet)); }