/// <summary>
/// 得到一个对象实体
/// </summary>
public HR_Test.Model.SelTestResult_B GetModel(string methodName)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID,methodName,f_bb,f_n,f_n1,f_rb,y,Fo,Fpb,Frb,Fbb,Fn,Fn1,Z,S,W,I,Eb,σpb,σrb,σbb,U,Mean,SD,Mid,CV,saveCurve from tb_SelTestResult_B ");
strSql.Append(" where methodName=@methodName");
OleDbParameter[] parameters =
{
new OleDbParameter("@methodName", OleDbType.VarChar, 200)
};
parameters[0].Value = methodName;
HR_Test.Model.SelTestResult_B model = new HR_Test.Model.SelTestResult_B();
DataSet ds = DbHelperOleDb.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(HR_Test.Model.SelTestResult_B model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_SelTestResult_B(");
strSql.Append("methodName,f_bb,f_n,f_n1,f_rb,y,Fo,Fpb,Frb,Fbb,Fn,Fn1,Z,S,W,I,Eb,σpb,σrb,σbb,U,Mean,SD,Mid,CV,saveCurve)");
strSql.Append(" values (");
strSql.Append("@methodName,@f_bb,@f_n,@f_n1,@f_rb,@y,@Fo,@Fpb,@Frb,@Fbb,@Fn,@Fn1,@Z,@S,@W,@I,@Eb,@σpb,@σrb,@σbb,@U,@Mean,@SD,@Mid,@CV,@saveCurve)");
OleDbParameter[] parameters =
{
new OleDbParameter("@methodName", OleDbType.VarChar, 100),
new OleDbParameter("@f_bb", OleDbType.Boolean, 1),
new OleDbParameter("@f_n", OleDbType.Boolean, 1),
new OleDbParameter("@f_n1", OleDbType.Boolean, 1),
new OleDbParameter("@f_rb", OleDbType.Boolean, 1),
new OleDbParameter("@y", OleDbType.Boolean, 1),
new OleDbParameter("@Fo", OleDbType.Boolean, 1),
new OleDbParameter("@Fpb", OleDbType.Boolean, 1),
new OleDbParameter("@Frb", OleDbType.Boolean, 1),
new OleDbParameter("@Fbb", OleDbType.Boolean, 1),
new OleDbParameter("@Fn", OleDbType.Boolean, 1),
new OleDbParameter("@Fn1", OleDbType.Boolean, 1),
new OleDbParameter("@Z", OleDbType.Boolean, 1),
new OleDbParameter("@S", OleDbType.Boolean, 1),
new OleDbParameter("@W", OleDbType.Boolean, 1),
new OleDbParameter("@I", OleDbType.Boolean, 1),
new OleDbParameter("@Eb", OleDbType.Boolean, 1),
new OleDbParameter("@σpb", OleDbType.Boolean, 1),
new OleDbParameter("@σrb", OleDbType.Boolean, 1),
new OleDbParameter("@σbb", OleDbType.Boolean, 1),
new OleDbParameter("@U", OleDbType.Boolean, 1),
new OleDbParameter("@Mean", OleDbType.Boolean, 1),
new OleDbParameter("@SD", OleDbType.Boolean, 1),
new OleDbParameter("@Mid", OleDbType.Boolean, 1),
new OleDbParameter("@CV", OleDbType.Boolean, 1),
new OleDbParameter("@saveCurve", OleDbType.Boolean, 1)
};
parameters[0].Value = model.methodName;
parameters[1].Value = model.f_bb;
parameters[2].Value = model.f_n;
parameters[3].Value = model.f_n1;
parameters[4].Value = model.f_rb;
parameters[5].Value = model.y;
parameters[6].Value = model.Fo;
parameters[7].Value = model.Fpb;
parameters[8].Value = model.Frb;
parameters[9].Value = model.Fbb;
parameters[10].Value = model.Fn;
parameters[11].Value = model.Fn1;
parameters[12].Value = model.Z;
parameters[13].Value = model.S;
parameters[14].Value = model.W;
parameters[15].Value = model.I;
parameters[16].Value = model.Eb;
parameters[17].Value = model.σpb;
parameters[18].Value = model.σrb;
parameters[19].Value = model.σbb;
parameters[20].Value = model.U;
parameters[21].Value = model.Mean;
parameters[22].Value = model.SD;
parameters[23].Value = model.Mid;
parameters[24].Value = model.CV;
parameters[25].Value = model.saveCurve;
int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public HR_Test.Model.SelTestResult_B DataRowToModel(DataRow row)
{
HR_Test.Model.SelTestResult_B model = new HR_Test.Model.SelTestResult_B();
if (row != null)
{
if (row["ID"] != null && row["ID"].ToString() != "")
{
model.ID = int.Parse(row["ID"].ToString());
}
if (row["methodName"] != null)
{
model.methodName = row["methodName"].ToString();
}
if (row["f_bb"] != null && row["f_bb"].ToString() != "")
{
if ((row["f_bb"].ToString() == "1") || (row["f_bb"].ToString().ToLower() == "true"))
{
model.f_bb = true;
}
else
{
model.f_bb = false;
}
}
if (row["f_n"] != null && row["f_n"].ToString() != "")
{
if ((row["f_n"].ToString() == "1") || (row["f_n"].ToString().ToLower() == "true"))
{
model.f_n = true;
}
else
{
model.f_n = false;
}
}
if (row["f_n1"] != null && row["f_n1"].ToString() != "")
{
if ((row["f_n1"].ToString() == "1") || (row["f_n1"].ToString().ToLower() == "true"))
{
model.f_n1 = true;
}
else
{
model.f_n1 = false;
}
}
if (row["f_rb"] != null && row["f_rb"].ToString() != "")
{
if ((row["f_rb"].ToString() == "1") || (row["f_rb"].ToString().ToLower() == "true"))
{
model.f_rb = true;
}
else
{
model.f_rb = false;
}
}
if (row["y"] != null && row["y"].ToString() != "")
{
if ((row["y"].ToString() == "1") || (row["y"].ToString().ToLower() == "true"))
{
model.y = true;
}
else
{
model.y = false;
}
}
if (row["Fo"] != null && row["Fo"].ToString() != "")
{
if ((row["Fo"].ToString() == "1") || (row["Fo"].ToString().ToLower() == "true"))
{
model.Fo = true;
}
else
{
model.Fo = false;
}
}
if (row["Fpb"] != null && row["Fpb"].ToString() != "")
{
if ((row["Fpb"].ToString() == "1") || (row["Fpb"].ToString().ToLower() == "true"))
{
model.Fpb = true;
}
else
{
model.Fpb = false;
}
}
if (row["Frb"] != null && row["Frb"].ToString() != "")
{
if ((row["Frb"].ToString() == "1") || (row["Frb"].ToString().ToLower() == "true"))
{
model.Frb = true;
}
else
{
model.Frb = false;
}
}
if (row["Fbb"] != null && row["Fbb"].ToString() != "")
{
if ((row["Fbb"].ToString() == "1") || (row["Fbb"].ToString().ToLower() == "true"))
{
model.Fbb = true;
}
else
{
model.Fbb = false;
}
}
if (row["Fn"] != null && row["Fn"].ToString() != "")
{
if ((row["Fn"].ToString() == "1") || (row["Fn"].ToString().ToLower() == "true"))
{
model.Fn = true;
}
else
{
model.Fn = false;
}
}
if (row["Fn1"] != null && row["Fn1"].ToString() != "")
{
if ((row["Fn1"].ToString() == "1") || (row["Fn1"].ToString().ToLower() == "true"))
{
model.Fn1 = true;
}
else
{
model.Fn1 = false;
}
}
if (row["Z"] != null && row["Z"].ToString() != "")
{
if ((row["Z"].ToString() == "1") || (row["Z"].ToString().ToLower() == "true"))
{
model.Z = true;
}
else
{
model.Z = false;
}
}
if (row["S"] != null && row["S"].ToString() != "")
{
if ((row["S"].ToString() == "1") || (row["S"].ToString().ToLower() == "true"))
{
model.S = true;
}
else
{
model.S = false;
}
}
if (row["W"] != null && row["W"].ToString() != "")
{
if ((row["W"].ToString() == "1") || (row["W"].ToString().ToLower() == "true"))
{
model.W = true;
}
else
{
model.W = false;
}
}
if (row["I"] != null && row["I"].ToString() != "")
{
if ((row["I"].ToString() == "1") || (row["I"].ToString().ToLower() == "true"))
{
model.I = true;
}
else
{
model.I = false;
}
}
if (row["Eb"] != null && row["Eb"].ToString() != "")
{
if ((row["Eb"].ToString() == "1") || (row["Eb"].ToString().ToLower() == "true"))
{
model.Eb = true;
}
else
{
model.Eb = false;
}
}
if (row["σpb"] != null && row["σpb"].ToString() != "")
{
if ((row["σpb"].ToString() == "1") || (row["σpb"].ToString().ToLower() == "true"))
{
model.σpb = true;
}
else
{
model.σpb = false;
}
}
if (row["σrb"] != null && row["σrb"].ToString() != "")
{
if ((row["σrb"].ToString() == "1") || (row["σrb"].ToString().ToLower() == "true"))
{
model.σrb = true;
}
else
{
model.σrb = false;
}
}
if (row["σbb"] != null && row["σbb"].ToString() != "")
{
if ((row["σbb"].ToString() == "1") || (row["σbb"].ToString().ToLower() == "true"))
{
model.σbb = true;
}
else
{
model.σbb = false;
}
}
if (row["U"] != null && row["U"].ToString() != "")
{
if ((row["U"].ToString() == "1") || (row["U"].ToString().ToLower() == "true"))
{
model.U = true;
}
else
{
model.U = false;
}
}
if (row["Mean"] != null && row["Mean"].ToString() != "")
{
if ((row["Mean"].ToString() == "1") || (row["Mean"].ToString().ToLower() == "true"))
{
model.Mean = true;
}
else
{
model.Mean = false;
}
}
if (row["SD"] != null && row["SD"].ToString() != "")
{
if ((row["SD"].ToString() == "1") || (row["SD"].ToString().ToLower() == "true"))
{
model.SD = true;
}
else
{
model.SD = false;
}
}
if (row["Mid"] != null && row["Mid"].ToString() != "")
{
if ((row["Mid"].ToString() == "1") || (row["Mid"].ToString().ToLower() == "true"))
{
model.Mid = true;
}
else
{
model.Mid = false;
}
}
if (row["CV"] != null && row["CV"].ToString() != "")
{
if ((row["CV"].ToString() == "1") || (row["CV"].ToString().ToLower() == "true"))
{
model.CV = true;
}
else
{
model.CV = false;
}
}
if (row["saveCurve"] != null && row["saveCurve"].ToString() != "")
{
if ((row["saveCurve"].ToString() == "1") || (row["saveCurve"].ToString().ToLower() == "true"))
{
model.saveCurve = true;
}
else
{
model.saveCurve = false;
}
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(HR_Test.Model.SelTestResult_B model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_SelTestResult_B set ");
strSql.Append("methodName=@methodName,");
strSql.Append("f_bb=@f_bb,");
strSql.Append("f_n=@f_n,");
strSql.Append("f_n1=@f_n1,");
strSql.Append("f_rb=@f_rb,");
strSql.Append("y=@y,");
strSql.Append("Fo=@Fo,");
strSql.Append("Fpb=@Fpb,");
strSql.Append("Frb=@Frb,");
strSql.Append("Fbb=@Fbb,");
strSql.Append("Fn=@Fn,");
strSql.Append("Fn1=@Fn1,");
strSql.Append("Z=@Z,");
strSql.Append("S=@S,");
strSql.Append("W=@W,");
strSql.Append("I=@I,");
strSql.Append("Eb=@Eb,");
strSql.Append("σpb=@σpb,");
strSql.Append("σrb=@σrb,");
strSql.Append("σbb=@σbb,");
strSql.Append("U=@U,");
strSql.Append("Mean=@Mean,");
strSql.Append("SD=@SD,");
strSql.Append("Mid=@Mid,");
strSql.Append("CV=@CV,");
strSql.Append("saveCurve=@saveCurve");
strSql.Append(" where ID=@ID");
OleDbParameter[] parameters =
{
new OleDbParameter("@methodName", OleDbType.VarChar, 100),
new OleDbParameter("@f_bb", OleDbType.Boolean, 1),
new OleDbParameter("@f_n", OleDbType.Boolean, 1),
new OleDbParameter("@f_n1", OleDbType.Boolean, 1),
new OleDbParameter("@f_rb", OleDbType.Boolean, 1),
new OleDbParameter("@y", OleDbType.Boolean, 1),
new OleDbParameter("@Fo", OleDbType.Boolean, 1),
new OleDbParameter("@Fpb", OleDbType.Boolean, 1),
new OleDbParameter("@Frb", OleDbType.Boolean, 1),
new OleDbParameter("@Fbb", OleDbType.Boolean, 1),
new OleDbParameter("@Fn", OleDbType.Boolean, 1),
new OleDbParameter("@Fn1", OleDbType.Boolean, 1),
new OleDbParameter("@Z", OleDbType.Boolean, 1),
new OleDbParameter("@S", OleDbType.Boolean, 1),
new OleDbParameter("@W", OleDbType.Boolean, 1),
new OleDbParameter("@I", OleDbType.Boolean, 1),
new OleDbParameter("@Eb", OleDbType.Boolean, 1),
new OleDbParameter("@σpb", OleDbType.Boolean, 1),
new OleDbParameter("@σrb", OleDbType.Boolean, 1),
new OleDbParameter("@σbb", OleDbType.Boolean, 1),
new OleDbParameter("@U", OleDbType.Boolean, 1),
new OleDbParameter("@Mean", OleDbType.Boolean, 1),
new OleDbParameter("@SD", OleDbType.Boolean, 1),
new OleDbParameter("@Mid", OleDbType.Boolean, 1),
new OleDbParameter("@CV", OleDbType.Boolean, 1),
new OleDbParameter("@saveCurve", OleDbType.Boolean, 1),
new OleDbParameter("@ID", OleDbType.Integer, 4)
};
parameters[0].Value = model.methodName;
parameters[1].Value = model.f_bb;
parameters[2].Value = model.f_n;
parameters[3].Value = model.f_n1;
parameters[4].Value = model.f_rb;
parameters[5].Value = model.y;
parameters[6].Value = model.Fo;
parameters[7].Value = model.Fpb;
parameters[8].Value = model.Frb;
parameters[9].Value = model.Fbb;
parameters[10].Value = model.Fn;
parameters[11].Value = model.Fn1;
parameters[12].Value = model.Z;
parameters[13].Value = model.S;
parameters[14].Value = model.W;
parameters[15].Value = model.I;
parameters[16].Value = model.Eb;
parameters[17].Value = model.σpb;
parameters[18].Value = model.σrb;
parameters[19].Value = model.σbb;
parameters[20].Value = model.U;
parameters[21].Value = model.Mean;
parameters[22].Value = model.SD;
parameters[23].Value = model.Mid;
parameters[24].Value = model.CV;
parameters[25].Value = model.saveCurve;
parameters[26].Value = model.ID;
int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
