//设置升降法初始参数
public ActionResult ParameterSettingData()
{
var sr = new StreamReader(Request.InputStream);
var stream = sr.ReadToEnd();
JavaScriptSerializer js = new JavaScriptSerializer();
UpDownExperiment experiment = js.Deserialize <UpDownExperiment>(stream);
experiment.udt_Creationtime = DateTime.Now;
experiment.udt_RecordEmployeeId = LangleyPublic.adminId;
dbDrive.Insert(experiment);
UpDownGroup upDownGroup = new UpDownGroup();
upDownGroup.dudt_ExperimentId = experiment.id;
upDownGroup.dudt_Stepd = experiment.udt_Stepd;
dbDrive.Insert(upDownGroup);
UpDownDataTable upDownDataTable = new UpDownDataTable();
upDownDataTable.dtup_DataTableId = upDownGroup.Id;
upDownDataTable.dtup_Standardstimulus = LiftingPublic.SelectState(experiment).GetStandardStimulus(experiment.udt_Initialstimulus);
upDownDataTable.dtup_Initialstimulus = experiment.udt_Initialstimulus;
upDownDataTable.dtup_response = 0;
var isTure = dbDrive.Insert(upDownDataTable);
string[] str = { isTure.ToString(), upDownGroup.Id.ToString(), experiment.udt_ProdectName };
return(Json(str));//需要传输本次实验的ID
}
public ActionResult UpdateUPparSeting()
{
var sr = new StreamReader(Request.InputStream);
var stream = sr.ReadToEnd();
JavaScriptSerializer js = new JavaScriptSerializer();
UpDownExperiment upDownExperiment = ude;
upDownExperiment.udt_Distribution = js.Deserialize <UpDownExperiment>(stream).udt_Distribution;
var isTure = dbDrive.Update(upDownExperiment);
double[] xArray = new double[udv.Count];
int[] vArray = new int[udv.Count];
for (int i = 0; i < udv.Count; i++)
{
xArray[i] = udv[i].dtup_Standardstimulus;
vArray[i] = LiftingPublic.Filp(udv[i].dtup_response, upDownExperiment.udt_Flipresponse);
}
var lr = LiftingPublic.SelectState(upDownExperiment);
var up = lr.GetReturn(xArray, vArray, upDownExperiment.udt_Initialstimulus, upDownExperiment.udt_Stepd, out double z, upDownExperiment.udt_Instrumentresolution, out double z1);
double[] prec = lr.GetPrec(up.μ0_final, up.σ0_final);
var group = upDownExperiment.udt_Groupingstate == 0 ? "不分组" : "多组试验";
double[] rpse = lr.ResponsePointStandardError(up.Sigma_mu, up.Sigma_sigma);
string[] str = { isTure.ToString(), up.μ0_final.ToString(), up.σ0_final.ToString(), up.Sigma_mu.ToString(), up.Sigma_sigma.ToString(), up.A.ToString(), up.M.ToString(), up.B.ToString(), up.b.ToString(), prec[1].ToString(), prec[0].ToString(), rpse[0].ToString(), rpse[1].ToString(), up.p.ToString(), up.G.ToString(), up.n.ToString(), up.H.ToString(), "升降法：" + lr.DistributionNameAndMethodStandardName() + "/" + group };//[0]表示修改状态，[1]代表修改后的试验参数
return(Json(str));
}
//导出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));
}
public ActionResult UpDownMethod(int udg_id)
{
UpDownMethodModel upDM = new UpDownMethodModel();
UpDownGroup upDownGroup = dbDrive.GetDownGroup(udg_id);
UpDownExperiment upDownExperiment = dbDrive.GetUpDownExperiment(upDownGroup.dudt_ExperimentId);
List <UpDownGroup> upDownGroups = dbDrive.GetUpDownGroups(upDownExperiment.id);
var lr = LiftingPublic.SelectState(upDownExperiment);
upDM.id = udg_id;
upDM.ExperimentalId = upDownGroup.dudt_ExperimentId;
upDM.ExperimentalLabelName = lr.DistributionNameAndMethodStandardName();
upDM.ProductName = upDownExperiment.udt_ProdectName;
upDM.Groupingstate = upDownExperiment.udt_Groupingstate == 0 ? "不分组" : "多组试验";
upDM.IsLastGroup = upDownGroups[0].Id == udg_id ? true : false;
int count = 0;
for (int i = 0; i < upDownGroups.Count; i++)
{
count++;
if (upDownGroups[i].Id == udg_id)
{
break;
}
}
upDM.GroupNumber = count;
return(View(upDM));
}
public ActionResult MultipleExperimentsCalculated(int ExperimentalId)
{
List <UpDownGroup> list_udg = dbDrive.GetUpDownGroups(ExperimentalId);
UpDownExperiment upDownExperiment = dbDrive.GetUpDownExperiment(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];
int n = 0;
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_Initialstimulus, 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;
n += up.n;
}
var mtr = LiftingPublic.SelectState(dbDrive.GetUpDownExperiment(ExperimentalId)).MultigroupTestResult(nj, Gj, Hj, muj, sigmaj);
string[] value = { mtr.μ0_final.ToString(), mtr.σ0_final.ToString(), mtr.Sigma_mu.ToString(), mtr.Sigma_sigma.ToString(), mtr.prec01.ToString(), mtr.prec999.ToString(), mtr.rpse01.ToString(), mtr.rpse999.ToString(), n.ToString() };
return(Json(value));
}
public ActionResult Fchs_ResponsePointIntervalEstimation(int ExperimentalId, double Fchs_StimulusQuantity, double cjl_zxsp, int textNumber, double favg, double fsigma, double fsigmaavg, double fsigmasigma)
{
UpDownExperiment upDownExperiment = dbDrive.GetUpDownExperiment(ExperimentalId);
var vfr = LiftingPublic.SelectState(upDownExperiment).VarianceFunctionResponsePointIntervalEstimated(cjl_zxsp, textNumber, Fchs_StimulusQuantity, favg, fsigma, fsigmaavg, fsigmasigma);
string[] value = { "(" + vfr[1].ToString("f6") + "," + vfr[0].ToString("f6") + ")", "(" + vfr[3].ToString("f6") + "," + vfr[2].ToString("f6") + ")", "(" + vfr[5].ToString("f6") + "," + vfr[4].ToString("f6") + ")", "(" + vfr[7].ToString("f6") + "," + vfr[6].ToString("f6") + ")" };
return(Json(value));
}
public ActionResult Likelihood(double BatchConfidenceLevel, double yMin, double yMax, int Y_Axis, int intervalTypeSelection, double favg, double fsigma, int ExperimentalId, int udg_id)
{
UpDownExperiment ude = dbDrive.GetUpDownExperiment(ExperimentalId);
List <UpDownDataTable> list_udt = dbDrive.GetUpDownDataTables(udg_id);
var lr = LiftingPublic.SelectState(ude);
double[] xArray = new double[list_udt.Count];
int[] vArray = new int[list_udt.Count];
for (int i = 0; i < list_udt.Count; i++)
{
xArray[i] = list_udt[i].dtup_Initialstimulus;
vArray[i] = LiftingPublic.Filp(list_udt[i].dtup_response, ude.udt_Flipresponse);
}
var srd = lr.QuasiLikelihoodRatioMethod(yMax, yMin, Y_Axis, BatchConfidenceLevel, favg, fsigma, xArray, vArray, intervalTypeSelection);
LangleyPublic.sideReturnData = srd;
LangleyPublic.aArray.Clear();
LangleyPublic.bArray.Clear();
LangleyPublic.cArray.Clear();
double ceiling = srd.responsePoints.Min();
double lower = srd.responsePoints.Max();
for (int i = 0; i < srd.responseProbability.Length; i++)
{
LangleyPublic.aArray.Add("[" + srd.responsePoints[i] + "," + srd.responseProbability[i] + "]");
if (double.IsInfinity(srd.Y_Ceilings[i]))
{
LangleyPublic.bArray.Add("[" + lower + "," + srd.responseProbability[i] + "]");
}
else
{
LangleyPublic.bArray.Add("[" + srd.Y_Ceilings[i] + "," + srd.responseProbability[i] + "]");
}
if (double.IsInfinity(srd.Y_LowerLimits[i]))
{
LangleyPublic.cArray.Add("[" + ceiling + "," + srd.responseProbability[i] + "]");
}
else
{
LangleyPublic.cArray.Add("[" + srd.Y_LowerLimits[i] + "," + srd.responseProbability[i] + "]");
}
}
if (intervalTypeSelection == 0)
{
LangleyPublic.incredibleIntervalType = "拟然比区间计算-单侧置信区间";
}
else
{
LangleyPublic.incredibleIntervalType = "拟然比区间计算-双侧置信区间";
}
LangleyPublic.incredibleLevelName = BatchConfidenceLevel.ToString();
return(Json(true));
}
[HttpPost]//计算当前组数据
public ActionResult CalculateCurrentData(int udg_id)
{
List <UpDownView> list_udv = dbDrive.GetUpDownViews(udg_id);
UpDownExperiment upDownExperiment = dbDrive.GetUpDownExperiment(list_udv[0].dudt_ExperimentId);
var lr = LiftingPublic.SelectState(upDownExperiment);
var up = LiftingPublic.Upanddown(list_udv, upDownExperiment, lr);
double[] prec = lr.GetPrec(up.μ0_final, up.σ0_final);
double[] rpse = lr.ResponsePointStandardError(up.Sigma_mu, up.Sigma_sigma);
string[] value = { up.μ0_final.ToString(), up.σ0_final.ToString(), up.Sigma_mu.ToString(), up.Sigma_sigma.ToString(), up.A.ToString(), up.M.ToString(), up.B.ToString(), up.b.ToString(), prec[0].ToString(), prec[1].ToString(), rpse[0].ToString(), rpse[1].ToString(), up.p.ToString(), up.G.ToString(), up.n.ToString(), up.H.ToString() };
return(Json(value));
}
//新增多组实验页面
public ActionResult Manyexperiments(string ExperimentalId, string average, string standardDeviation)
{
int Experimentalid = Int32.Parse(ExperimentalId);
ManyexperimentsModel manyexperimentsModel = new ManyexperimentsModel();
List <UpDownGroup> list_udg = dbDrive.GetUpDownGroups(Experimentalid);
UpDownExperiment upDownExperiment = dbDrive.GetUpDownExperiment(Experimentalid);
manyexperimentsModel.previousSetNumber = list_udg[list_udg.Count - 1].dudt_Stepd;
manyexperimentsModel.currentSetNumber = list_udg.Count + 1;
manyexperimentsModel.ProductName = upDownExperiment.udt_ProdectName;
manyexperimentsModel.stimulusQuantity = average;
manyexperimentsModel.stepLength = standardDeviation;
manyexperimentsModel.distribution = LiftingPublic.SelectState(upDownExperiment).DistributionNameAndMethodStandardName();
return(View(manyexperimentsModel));
}
public ActionResult ResponsePointIntervalEstimation(int ExperimentalId, int udg_id, double Srb_ProbabilityResponse, double Srb_Confidencelevel, double fq, double favg, double fsigma)
{
List <UpDownView> list_udv = dbDrive.GetUpDownViews(udg_id);
UpDownExperiment upDownExperiment = dbDrive.GetUpDownExperiment(ExperimentalId);
double[] xArray = new double[list_udv.Count];
int[] vArray = new int[list_udv.Count];
for (int i = 0; i < list_udv.Count; i++)
{
xArray[i] = list_udv[i].dtup_Initialstimulus;
vArray[i] = LiftingPublic.Filp(list_udv[i].dtup_response, upDownExperiment.udt_Flipresponse);
}
var ies = LiftingPublic.SelectState(upDownExperiment).ResponsePointIntervalEstimated(Srb_ProbabilityResponse, Srb_Confidencelevel, xArray, vArray, fq, favg, fsigma);
string[] str = { "(" + ies[0].Confidence.Down.ToString("f6") + "," + ies[0].Confidence.Up.ToString("f6") + ")", "(" + ies[0].Mu.Down.ToString("f6") + "," + ies[0].Mu.Up.ToString("f6") + ")", "(" + ies[0].Sigma.Down.ToString("f6") + "," + ies[0].Sigma.Up.ToString("f6") + ")", "(" + ies[1].Confidence.Down.ToString("f6") + "," + ies[1].Confidence.Up.ToString("f6") + ")", "(" + ies[1].Mu.Down.ToString("f6") + "," + ies[1].Mu.Up.ToString("f6") + ")", "(" + ies[1].Sigma.Down.ToString("f6") + "," + ies[1].Sigma.Up.ToString("f6") + ")" };
return(Json(str));
}
public ActionResult Variancefunction(double BatchConfidenceLevel, double yMin, double yMax, int Y_Axis, int intervalTypeSelection, double favg, double fsigma, int ExperimentalId, int textNumber, double fsigmaavg, double fsigmasigma)
{
UpDownExperiment ude = dbDrive.GetUpDownExperiment(ExperimentalId);
var lr = LiftingPublic.SelectState(ude);
var srd = lr.VarianceFunctionMethod(yMax, yMin, Y_Axis, BatchConfidenceLevel, favg, fsigma, intervalTypeSelection, textNumber, fsigmaavg, fsigmasigma);
LangleyPublic.sideReturnData = srd;
LangleyPublic.aArray.Clear();
LangleyPublic.bArray.Clear();
LangleyPublic.cArray.Clear();
double ceiling = srd.responsePoints.Min();
double lower = srd.responsePoints.Max();
for (int i = 0; i < srd.responseProbability.Length; i++)
{
LangleyPublic.aArray.Add("[" + srd.responsePoints[i] + "," + srd.responseProbability[i] + "]");
if (double.IsInfinity(srd.Y_Ceilings[i]))
{
LangleyPublic.bArray.Add("[" + lower + "," + srd.responseProbability[i] + "]");
}
else
{
LangleyPublic.bArray.Add("[" + srd.Y_Ceilings[i] + "," + srd.responseProbability[i] + "]");
}
if (double.IsInfinity(srd.Y_LowerLimits[i]))
{
LangleyPublic.cArray.Add("[" + ceiling + "," + srd.responseProbability[i] + "]");
}
else
{
LangleyPublic.cArray.Add("[" + srd.Y_LowerLimits[i] + "," + srd.responseProbability[i] + "]");
}
}
if (intervalTypeSelection == 0)
{
LangleyPublic.incredibleIntervalType = "GJB377单侧区间估计方法";
}
else
{
LangleyPublic.incredibleIntervalType = "GJB377双侧区间估计方法";
}
LangleyPublic.incredibleLevelName = BatchConfidenceLevel.ToString();
return(Json(true));
}
public ActionResult RevocationData(int udg_id, int ExperimentalId)
{
List <UpDownDataTable> list_udt = dbDrive.GetUpDownDataTables(udg_id);
UpDownExperiment upDownExperiment = dbDrive.GetUpDownExperiment(ExperimentalId);
var lr = LiftingPublic.SelectState(upDownExperiment);
var xAndV = LiftingPublic.GetXArrayAndVArray(list_udt, upDownExperiment);
if (list_udt.Count == 1)
{
string[] value = { "false", list_udt.Count.ToString(), list_udt[list_udt.Count - 1].dtup_Initialstimulus.ToString(), lr.StepsNumber(xAndV.xArray, xAndV.vArray).ToString() };
return(Json(value));
}
UpDownDataTable upDownDataTable = list_udt[list_udt.Count - 1];
var isTure = dbDrive.Delete(upDownDataTable);
List <UpDownDataTable> list_udtDelete = dbDrive.GetUpDownDataTables(udg_id);
var xAndVDelete = LiftingPublic.GetXArrayAndVArray(list_udtDelete, upDownExperiment);
string[] valueDelete = { isTure.ToString(), (list_udt.Count - 1).ToString(), list_udtDelete[list_udtDelete.Count - 1].dtup_Initialstimulus.ToString(), lr.StepsNumber(xAndVDelete.xArray, xAndVDelete.vArray).ToString() };
return(Json(valueDelete));
}
public ActionResult ManyexperimentsSetings(int ExperimentalId)
{
var sr = new StreamReader(Request.InputStream);
var stream = sr.ReadToEnd();
JavaScriptSerializer js = new JavaScriptSerializer();
ManyexperimentsModel mm = js.Deserialize <ManyexperimentsModel>(stream);
UpDownGroup upDownGroup = new UpDownGroup();
UpDownDataTable upDownDataTable = new UpDownDataTable();
upDownGroup.dudt_ExperimentId = ExperimentalId;
upDownGroup.dudt_Stepd = double.Parse(mm.stepLength);
dbDrive.Insert(upDownGroup);
upDownDataTable.dtup_DataTableId = upDownGroup.Id;
upDownDataTable.dtup_Initialstimulus = double.Parse(mm.stimulusQuantity);
upDownDataTable.dtup_Standardstimulus = LiftingPublic.SelectState(dbDrive.GetUpDownExperiment(ExperimentalId)).GetStandardStimulus(upDownDataTable.dtup_Initialstimulus);
upDownDataTable.dtup_response = 0;
bool isTure = dbDrive.Insert(upDownDataTable);
string[] value = { isTure.ToString(), upDownGroup.Id.ToString() };
return(Json(value));
}
public ActionResult InsertData(string response, int udg_id, int ExperimentalId)
{
List <UpDownDataTable> list_udt = dbDrive.GetUpDownDataTables(udg_id);
UpDownGroup upDownGroup = dbDrive.GetDownGroup(udg_id);
UpDownExperiment upDownExperiment = dbDrive.GetUpDownExperiment(ExperimentalId);
var lr = LiftingPublic.SelectState(upDownExperiment);
list_udt[list_udt.Count - 1].dtup_response = int.Parse(response);
var xAndV = LiftingPublic.GetXArrayAndVArray(list_udt, upDownExperiment);
var up = lr.GetReturn(xAndV.xArray, xAndV.vArray, upDownExperiment.udt_Initialstimulus, upDownGroup.dudt_Stepd, out double z, upDownExperiment.udt_Instrumentresolution, out double z1);
UpDownDataTable upDownDataTable = new UpDownDataTable();
upDownDataTable.dtup_DataTableId = udg_id;
upDownDataTable.dtup_Initialstimulus = z1;
upDownDataTable.dtup_response = 0;
upDownDataTable.dtup_Standardstimulus = z;
bool isTure = dbDrive.Insert(upDownDataTable);
List <UpDownGroup> list_udg = dbDrive.GetUpDownGroups(upDownExperiment.id);
List <UpDownDataTable> list_udtInsert = dbDrive.GetUpDownDataTables(udg_id);
var xAndVInsert = LiftingPublic.GetXArrayAndVArray(list_udtInsert, upDownExperiment);
string[] value = { isTure.ToString(), LiftingPublic.CurrentSetNumber(list_udg, udg_id).ToString(), (list_udtInsert.Count).ToString(), lr.StepsNumber(xAndVInsert.xArray, xAndVInsert.vArray).ToString(), z1.ToString() };
return(Json(value));
}
public ActionResult ComprehensiveList(int ude_id)
{
List <ComprehensiveResultsModel> list_crm = new List <ComprehensiveResultsModel>();
List <UpDownGroup> list_udg = dbDrive.GetUpDownGroups(ude_id);
UpDownExperiment upDownExperiment = dbDrive.GetUpDownExperiment(ude_id);
var lr = LiftingPublic.SelectState(upDownExperiment);
for (int i = 0; i < list_udg.Count; i++)
{
ComprehensiveResultsModel comprehensiveResultsModel = new ComprehensiveResultsModel();
List <UpDownView> list_udv = dbDrive.GetUpDownViews(list_udg[i].Id);
var up = LiftingPublic.Upanddown(list_udv, upDownExperiment, lr);
double[] prec = lr.GetPrec(up.μ0_final, up.σ0_final);
comprehensiveResultsModel.setNumber = i + 1;
comprehensiveResultsModel.stimulusQuantity = list_udv[0].dtup_Initialstimulus;
comprehensiveResultsModel.stepLength = list_udv[0].dudt_Stepd;
comprehensiveResultsModel.sampleNumber = list_udv.Count();
comprehensiveResultsModel.average = up.μ0_final;
comprehensiveResultsModel.standardDeviation = up.σ0_final;
comprehensiveResultsModel.msde = up.Sigma_mu;
comprehensiveResultsModel.sdsde = up.Sigma_sigma;
comprehensiveResultsModel.temptationNumber = up.n;
comprehensiveResultsModel.G = up.G;
comprehensiveResultsModel.H = up.H;
comprehensiveResultsModel.A = up.A;
comprehensiveResultsModel.B = up.B;
comprehensiveResultsModel.M = up.M;
comprehensiveResultsModel.b = up.b;
comprehensiveResultsModel.p = up.p;
comprehensiveResultsModel.percentage01 = prec[1];
comprehensiveResultsModel.percentage999 = prec[0];
list_crm.Add(comprehensiveResultsModel);
}
list_crm.Reverse();
return(Json(new { code = "", msg = "", count = list_crm.Count(), data = list_crm }, JsonRequestBehavior.AllowGet));
}
//单组试验结果数据
public ActionResult GetAllsingleunitList(int udg_id)
{
List <UpDownView> list_udv = dbDrive.GetUpDownViews(udg_id);
UpDownExperiment upDownExperiment = dbDrive.GetUpDownExperiment(list_udv[0].dudt_ExperimentId);
var lr = LiftingPublic.SelectState(upDownExperiment);
var up = LiftingPublic.Upanddown(list_udv, upDownExperiment, lr);
List <SingleExperimentTable> singleExperimentTables = new List <SingleExperimentTable>();
for (int w = 0; w < up.result_i.Length; w++)
{
SingleExperimentTable singleExperimentTable = new SingleExperimentTable();
singleExperimentTable.i = up.result_i[w];
singleExperimentTable.i2 = up.result_i[w] * up.result_i[w];
singleExperimentTable.i2mi1 = up.result_i[w] * up.result_i[w] * up.mi[w];
singleExperimentTable.i2vi = up.result_i[w] * up.result_i[w] * up.vi[w];
singleExperimentTable.imi1 = up.result_i[w] * up.mi[w];
singleExperimentTable.ivi = up.result_i[w] * up.vi[w];
singleExperimentTable.mi = up.mi[w];
singleExperimentTable.vi = up.vi[w];
singleExperimentTables.Add(singleExperimentTable);
}
//code--信息状态，默认为0，msg--返回信息，count--数据条数，data--数据
return(Json(new { code = "", msg = "", count = up.result_i.Length, data = singleExperimentTables }, JsonRequestBehavior.AllowGet));
}
public ActionResult Experiment_query(string cpmc, string startdate, string stopdate)
{
List <UpDownExperiment> udes = dbDrive.GetUpDownExperiments(LangleyPublic.adminId);
if (startdate != "" && stopdate != "")
{
DateTime st = Convert.ToDateTime(startdate);
DateTime et = Convert.ToDateTime(stopdate);
udes = dbDrive.QueryExperimentTable(cpmc, st, et.AddDays(1), LangleyPublic.adminId);
}
else
{
udes = dbDrive.QueryExperimentTable(cpmc, LangleyPublic.adminId);
}
return(Json(new { code = 0, msg = "", fenye = 5, count = udes.Count, data = LiftingPublic.GetQueryModels(dbDrive, udes) }, JsonRequestBehavior.AllowGet));
}
public ActionResult ResponsePoint(int ExperimentalId, string average, string standardDeviation, double ResponsePointValue)
{
var rpc = LiftingPublic.SelectState(dbDrive.GetUpDownExperiment(ExperimentalId)).ResponsePointCalculation(ResponsePointValue, double.Parse(standardDeviation), double.Parse(average));
return(Json(rpc));
}
public ActionResult StimulusQuantity(int ExperimentalId, string average, string standardDeviation, double StimulusQuantityValue)
{
var rpc = LiftingPublic.SelectState(dbDrive.GetUpDownExperiment(ExperimentalId)).ResponseProbabilityCalculation(StimulusQuantityValue, double.Parse(average), double.Parse(standardDeviation));
return(Json(rpc));
}
public static string UpDownFreeSpireExcel(UpDownExperiment upDownExperiment, List <UpDownView> upDownViews, int grop, List <UpDownView> upDownViews1, int[] nj, double[] Gj, double[] Hj, double[] muj, double[] sigmaj, LiftingAlgorithm lr, List <UpDownGroup> upDownGroups)
{
var up = LiftingPublic.Upanddown(upDownViews, upDownExperiment, lr);
var mtr = lr.MultigroupTestResult(nj, Gj, Hj, muj, sigmaj);
Workbook book = new Workbook();
Worksheet sheet = book.Worksheets[0];
var iCellcount = 1;
//1.设置表头
if (grop == 0)
{
sheet.Range[1, iCellcount++].Text = "单组升降法试验记录及数据处理结果";
}
else
{
sheet.Range[1, iCellcount++].Text = "多组升降法试验数据处理结果";
}
sheet.Range["A1:AO1"].Merge();
sheet.Range["A1:AO1"].Style.HorizontalAlignment = HorizontalAlignType.Center;
sheet.Range["A2:C2"].Text = "产品名称";
sheet.Range["A2:C2"].Merge();
sheet.Range["D2:L2"].Text = upDownExperiment.udt_ProdectName;
sheet.Range["D2:L2"].Merge();
sheet.Range["M2:O2"].Text = "产品数量";
sheet.Range["M2:O2"].Merge();
if (grop == 0)
{
sheet.Range["P2:U2"].Text = upDownViews.Count.ToString();
}
else
{
sheet.Range["P2:U2"].Text = upDownViews1.Count.ToString();
}
sheet.Range["P2:U2"].Merge();
sheet.Range["V2:Z2"].Text = "技术条件";
sheet.Range["V2:Z2"].Merge();
sheet.Range["AA2:AO2"].Text = upDownExperiment.udt_Technicalconditions;
sheet.Range["AA2:AO2"].Merge();
sheet.Range["A3:C3"].Text = "试验时间";
sheet.Range["A3:C3"].Merge();
sheet.Range["D3:L3"].Text = upDownExperiment.udt_Creationtime.ToString("yyyy-MM-dd HH:mm");
sheet.Range["D3:L3"].Merge();
int count = 7;
string[] s = { "D", "E", "F", "G", "H", "I", "J", "K", "L", "M", "N", "O", "P", "Q", "R", "S", "T", "U", "V", "W", "X", "Y", "Z", "AA", "AB", "AC", "AD", "AE", "AF", "AG", "AH", "AI", "AJ", "AK", "AL", "AM", "AN", "AO" };
if (grop == 0)
{
sheet.Range["M3:Q3"].Text = "初始刺激量";
sheet.Range["M3:Q3"].Merge();
sheet.Range["R3:U3"].Text = upDownViews[0].dtup_Initialstimulus.ToString();
sheet.Range["R3:U3"].Merge();
sheet.Range["V3:Y3"].Text = "步长";
sheet.Range["V3:Y3"].Merge();
sheet.Range["Z3:AG3"].Text = upDownViews[0].dudt_Stepd.ToString();
sheet.Range["Z3:AG3"].Merge();
sheet.Range["AH3:AK3"].Text = "台阶数";
sheet.Range["AH3:AK3"].Merge();
sheet.Range["AL3:AO3"].Text = up.n.ToString();
sheet.Range["AL3:AO3"].Merge();
sheet.Range["A4:C4"].Text = "假设分布/分析方法";
sheet.Range["A4:C4"].Merge();
sheet.Range["D4:L4"].Text = LiftingPublic.DistributionState(lr);
sheet.Range["D4:L4"].Merge();
sheet.Range["M4:Q4"].Text = "翻转响应";
sheet.Range["M4:Q4"].Merge();
sheet.Range["R4:U4"].Text = upDownExperiment.udt_Flipresponse == 0 ? "否" : "是";
sheet.Range["R4:U4"].Merge();
sheet.Range["V4:Y4"].Text = "分辨率";
sheet.Range["V4:Y4"].Merge();
sheet.Range["Z4:AO4"].Text = upDownExperiment.udt_Instrumentresolution.ToString();
sheet.Range["Z4:AO4"].Merge();
sheet.Range["A5:AO5"].Merge();
sheet.Range["A6"].Text = "i";
sheet.Range["B6"].Text = "X";
if (upDownExperiment.udt_Standardstate == 1)
{
sheet.Range["C6"].Text = "Ln";
}
else if (upDownExperiment.udt_Standardstate == 2)
{
sheet.Range["C6"].Text = "Log";
}
else if (upDownExperiment.udt_Standardstate == 3)
{
sheet.Range["C6"].Text = "幂";
}
for (int i = 0; i < s.Length; i++)
{
sheet.Range["" + s[i] + "6"].Text = (i + 1).ToString();
}
int zero = 0;
for (int i = 0; i < up.result_i.Length; i++)
{
sheet.Range["A" + count + ""].Text = up.result_i[i].ToString();
if (up.result_i[i] == 0)
{
zero = count;
}
count++;
}
for (int j = 0; j < upDownViews.Count; j++)
{
sheet.Range["B" + zero + ""].Text = upDownViews[j].dtup_Initialstimulus.ToString();
if (upDownExperiment.udt_Standardstate != 0)
{
sheet.Range["C" + zero + ""].Text = upDownViews[j].dtup_Standardstimulus.ToString();
}
sheet.Range["" + s[j] + "" + zero + ""].Text = upDownViews[j].dtup_response.ToString();
if (upDownViews[j].dtup_response == 1)
{
zero++;
}
else
{
zero--;
}
}
}
else
{
sheet.Range["M3:Q3"].Text = "总组数";
sheet.Range["M3:Q3"].Merge();
sheet.Range["R3:U3"].Text = upDownGroups.Count.ToString();
sheet.Range["R3:U3"].Merge();
sheet.Range["V3:Y3"].Text = "仪器分辨率";
sheet.Range["V3:Y3"].Merge();
sheet.Range["Z3:AG3"].Text = upDownExperiment.udt_Instrumentresolution.ToString();
sheet.Range["Z3:AG3"].Merge();
sheet.Range["A4:C4"].Text = "假设分布/分析方法";
sheet.Range["A4:C4"].Merge();
sheet.Range["D4:L4"].Text = LiftingPublic.DistributionState(lr);
sheet.Range["D4:L4"].Merge();
sheet.Range["M4:Q4"].Text = "翻转响应";
sheet.Range["M4:Q4"].Merge();
sheet.Range["R4:U4"].Text = upDownExperiment.udt_Flipresponse == 0 ? "否" : "是";
sheet.Range["R4:U4"].Merge();
}
if (grop == 0)
{
count = UpDown(up.μ0_final, up.σ0_final, count, sheet, up.Sigma_mu, up.Sigma_sigma, lr, up.n);
count++;
sheet.Range["A" + count + ":AO" + count + ""].Text = "升降法中间数据：试探次数：" + up.n + ",A:" + up.A + ",B:" + up.B + ",M:" + up.M + ",b:" + up.b + ",G:" + up.G + "";
sheet.Range["A" + count + ":AO" + count + ""].Merge();
}
else
{
int n = 0;
foreach (var i in nj)
{
n += i;
}
count = UpDown(mtr.μ0_final, mtr.σ0_final, count, sheet, mtr.Sigma_mu, mtr.Sigma_sigma, lr, n);
}
for (int w = 0; w < s.Length; w++)
{
sheet.Range["" + s[w] + "1:" + s[w] + "" + count + ""].ColumnWidth = 4;
}
sheet.Range["A2:AO" + count + ""].BorderInside(LineStyleType.Thin, Color.Black);
sheet.Range["A2:AO" + count + ""].BorderAround(LineStyleType.Medium, Color.Black);
if (grop == 0)
{
var strFullName = @"C:\升降法\" + "单组升降法" + DateTime.Now.ToString("yyyy-MM-dd-HH-mm-ss") + ".xlsx";
book.SaveToFile(strFullName, ExcelVersion.Version2010);
return(strFullName);
}
else
{
var strFullName = @"C:\升降法\" + "多组升降法" + DateTime.Now.ToString("yyyy-MM-dd-HH-mm-ss") + ".xlsx";
book.SaveToFile(strFullName, ExcelVersion.Version2010);
return(strFullName);
}
}
//获取全部试验数据
public ActionResult GetAllExperiments(int page = 1, int limit = 20)
{
List <UpDownExperiment> udes = dbDrive.GetUpDownExperiments(LangleyPublic.adminId);
List <UpDownExperiment> PagesLet = new List <UpDownExperiment>();
int last = udes.Count - (page - 1) * limit;
int first = 0;
if (page * limit < udes.Count)
{
first = udes.Count - page * limit;
}
for (int i = first; i < last; i++)
{
PagesLet.Add(udes[i]);
}
return(Json(new { code = 0, msg = "", fenye = 5, count = udes.Count, data = LiftingPublic.GetQueryModels(dbDrive, PagesLet, first) }, JsonRequestBehavior.AllowGet));
}
