public void BingindUiData(MainCircuitMode vo)
{
checkBox1.Checked = vo.SingleCheck;
checkBox2.Checked = vo.DoubleCheck;
checkBox3.Checked = vo.ForwardCheck;
checkBox4.Checked = vo.ReverseCheck;
checkBox9.Checked = vo.BipolarCheck;
checkBox10.Checked = vo.GroundReturnCheck;
checkBox11.Checked = vo.MetalReturnCheck;
checkBox12.Checked = vo.VoltageFullCheck;
checkBox14.Checked = vo.VoltageEightyCheck;
checkBox13.Checked = vo.VoltageSeventyCheck;
checkBox5.Checked = vo.ResistanceHighCheck;
checkBox6.Checked = vo.ResistanceLowCheck;
checkBox15.Checked = vo.RectAcVolMaxCheck;
checkBox16.Checked = vo.RectAcVolNormCheck;
checkBox17.Checked = vo.RectAcVolMinCheck;
checkBox18.Checked = vo.RectAcVolExtrMinCheck;
checkBox19.Checked = vo.InvAcVolNormCheck;
checkBox20.Checked = vo.InvAcVolMaxCheck;
checkBox21.Checked = vo.InvAcVolMinCheck;
checkBox22.Checked = vo.InvAcVolExtrMinCheck;
checkBox7.Checked = vo.VolModeComb;
checkBox8.Checked = vo.chkUnbalanced;
}
private bool Addnew(MainCircuitMode vo)
{
using (OleDbConnection conn = CreateConnection())
{
//设置SQL语句
StringBuilder sql = new StringBuilder();
StringBuilder param = new StringBuilder();
sql.Append("INSERT INTO MainCircuitMode (");
param.Append(" VALUES (");
sql.Append(" SingleCheck");
param.Append("").Append(Convert.ToInt32(vo.SingleCheck) * -1).Append("");
sql.Append(", DoubleCheck");
param.Append(", ").Append(Convert.ToInt32(vo.DoubleCheck) * -1).Append("");
sql.Append(", ForwardCheck");
param.Append(", ").Append(Convert.ToInt32(vo.ForwardCheck) * -1).Append("");
sql.Append(", ReverseCheck");
param.Append(", ").Append(Convert.ToInt32(vo.ReverseCheck) * -1).Append("");
sql.Append(", BipolarCheck");
param.Append(", ").Append(Convert.ToInt32(vo.BipolarCheck) * -1).Append("");
sql.Append(", GroundReturnCheck");
param.Append(", ").Append(Convert.ToInt32(vo.GroundReturnCheck) * -1).Append("");
sql.Append(", MetalReturnCheck");
param.Append(", ").Append(Convert.ToInt32(vo.MetalReturnCheck) * -1).Append("");
sql.Append(", ParallelReturnCheck");
param.Append(", ").Append(Convert.ToInt32(vo.ParallelReturnCheck) * -1).Append("");
sql.Append(", VoltageFullCheck");
param.Append(", ").Append(Convert.ToInt32(vo.VoltageFullCheck) * -1).Append("");
sql.Append(", VoltageEightyCheck");
param.Append(", ").Append(Convert.ToInt32(vo.VoltageEightyCheck) * -1).Append("");
sql.Append(", VoltageSeventyCheck");
param.Append(", ").Append(Convert.ToInt32(vo.VoltageSeventyCheck) * -1).Append("");
sql.Append(", ResistanceHighCheck");
param.Append(", ").Append(Convert.ToInt32(vo.ResistanceHighCheck) * -1).Append("");
sql.Append(", ResistanceLowCheck");
param.Append(", ").Append(Convert.ToInt32(vo.ResistanceLowCheck) * -1).Append("");
sql.Append(", RectAcVolMaxCheck");
param.Append(", ").Append(Convert.ToInt32(vo.RectAcVolMaxCheck) * -1).Append("");
sql.Append(", RectAcVolNormCheck");
param.Append(", ").Append(Convert.ToInt32(vo.RectAcVolNormCheck) * -1).Append("");
sql.Append(", RectAcVolMinCheck");
param.Append(", ").Append(Convert.ToInt32(vo.RectAcVolMinCheck) * -1).Append("");
sql.Append(", RectAcVolExtrMinCheck");
param.Append(", ").Append(Convert.ToInt32(vo.RectAcVolExtrMinCheck) * -1).Append("");
sql.Append(", InvAcVolMaxCheck");
param.Append(", ").Append(Convert.ToInt32(vo.InvAcVolMaxCheck) * -1).Append("");
sql.Append(", InvAcVolNormCheck");
param.Append(", ").Append(Convert.ToInt32(vo.InvAcVolNormCheck) * -1).Append("");
sql.Append(", InvAcVolMinCheck");
param.Append(", ").Append(Convert.ToInt32(vo.InvAcVolMinCheck) * -1).Append("");
sql.Append(", InvAcVolExtrMinCheck");
param.Append(", ").Append(Convert.ToInt32(vo.InvAcVolExtrMinCheck) * -1).Append("");
sql.Append(", chkUnbalanced");
param.Append(", ").Append(Convert.ToInt32(vo.chkUnbalanced) * -1).Append("");
sql.Append(")").Append(param).Append(");");
OleDbCommand insertcmd = new OleDbCommand(sql.ToString(), conn);
insertcmd.ExecuteNonQuery();
}
ResetConn();
return true;
}
private bool UpdateOrAddnew(MainCircuitMode vo)
{
if (!queryExists(vo))
{
return Addnew(vo);
}
else
{
return Update(vo);
}
}
private bool Update(MainCircuitMode vo)
{
StringBuilder sql = new StringBuilder();//当时在这里定义，是为了在出现异常的时候看看我的SQL语句是否正确
using (OleDbConnection conn = CreateConnection())
{
sql.Append("UPDATE MainCircuitMode SET SingleCheck=").Append(Convert.ToInt32(vo.SingleCheck) * -1);
sql.Append(", DoubleCheck=").Append(Convert.ToInt32(vo.DoubleCheck) * -1);
sql.Append(", ForwardCheck=").Append(Convert.ToInt32(vo.ForwardCheck) * -1);
sql.Append(", ReverseCheck=").Append(Convert.ToInt32(vo.ReverseCheck) * -1);
sql.Append(", BipolarCheck=").Append(Convert.ToInt32(vo.BipolarCheck) * -1);
sql.Append(", GroundReturnCheck=").Append(Convert.ToInt32(vo.GroundReturnCheck) * -1);
sql.Append(", MetalReturnCheck=").Append(Convert.ToInt32(vo.MetalReturnCheck) * -1);
sql.Append(", ParallelReturnCheck=").Append(Convert.ToInt32(vo.ParallelReturnCheck) * -1);
sql.Append(", VoltageFullCheck=").Append(Convert.ToInt32(vo.VoltageFullCheck) * -1);
sql.Append(", VoltageEightyCheck=").Append(Convert.ToInt32(vo.VoltageEightyCheck) * -1);
sql.Append(", VoltageSeventyCheck=").Append(Convert.ToInt32(vo.VoltageSeventyCheck) * -1);
sql.Append(", ResistanceHighCheck=").Append(Convert.ToInt32(vo.ResistanceHighCheck) * -1);
sql.Append(", ResistanceLowCheck=").Append(Convert.ToInt32(vo.ResistanceLowCheck) * -1);
sql.Append(", RectAcVolMaxCheck=").Append(Convert.ToInt32(vo.RectAcVolMaxCheck) * -1);
sql.Append(", RectAcVolNormCheck=").Append(Convert.ToInt32(vo.RectAcVolNormCheck) * -1);
sql.Append(", RectAcVolMinCheck=").Append(Convert.ToInt32(vo.RectAcVolMinCheck));
sql.Append(", RectAcVolExtrMinCheck=").Append(Convert.ToInt32(vo.RectAcVolExtrMinCheck) * -1);
sql.Append(", InvAcVolMaxCheck=").Append(Convert.ToInt32(vo.InvAcVolMaxCheck) * -1);
sql.Append(", InvAcVolNormCheck=").Append(Convert.ToInt32(vo.InvAcVolNormCheck) * -1);
sql.Append(", InvAcVolMinCheck=").Append(Convert.ToInt32(vo.InvAcVolMinCheck) * -1);
sql.Append(", InvAcVolExtrMinCheck=").Append(Convert.ToInt32(vo.InvAcVolExtrMinCheck) * -1);
sql.Append(", VolModeComb=").Append(Convert.ToInt32(vo.VolModeComb) * -1);
sql.Append(", chkUnbalanced=").Append(Convert.ToInt32(vo.chkUnbalanced) * -1);
sql.Append(" WHERE ID = ").Append(vo.ID);
//定义command对象，并执行相应的SQL语句
OleDbCommand myCommand = new OleDbCommand(sql.ToString(), conn);
myCommand.ExecuteNonQuery(); //执行SELECT的时候我们是用的ExecuteReader()
}
ResetConn();
return true;
}
private bool LoadData(MainCircuitMode vo)
{
using (OleDbConnection conn = CreateConnection())
{
string sql = "Select * from MainCircuitMode ";
if (vo.ID != -1)
{
sql += "where ID = " + vo.ID;
}
OleDbCommand myCommand = new OleDbCommand(sql, conn);
OleDbDataReader reader = myCommand.ExecuteReader(); //执行command并得到相应的DataReader
if (reader.Read())
{
fillVOData(vo, reader);
ResetConn();
}
else
{
ResetConn();
return false;
}
}
return true;
}
private void fillVOData(MainCircuitMode vo, OleDbDataReader reader)
{
vo.ID = (Int32)reader["ID"];
vo.SingleCheck = Convert.ToBoolean(reader["SingleCheck"]);
vo.DoubleCheck = Convert.ToBoolean(reader["DoubleCheck"]);
vo.ForwardCheck = Convert.ToBoolean(reader["ForwardCheck"]);
vo.ReverseCheck = Convert.ToBoolean(reader["ReverseCheck"]);
vo.BipolarCheck = Convert.ToBoolean(reader["BipolarCheck"]);
vo.GroundReturnCheck = Convert.ToBoolean(reader["GroundReturnCheck"]);
vo.MetalReturnCheck = Convert.ToBoolean(reader["MetalReturnCheck"]);
vo.ParallelReturnCheck = Convert.ToBoolean(reader["ParallelReturnCheck"]);
vo.VoltageFullCheck = Convert.ToBoolean(reader["VoltageFullCheck"]);
vo.VoltageEightyCheck = Convert.ToBoolean(reader["VoltageEightyCheck"]);
vo.VoltageSeventyCheck = Convert.ToBoolean(reader["VoltageSeventyCheck"]);
vo.ResistanceHighCheck = Convert.ToBoolean(reader["ResistanceHighCheck"]);
vo.ResistanceLowCheck = Convert.ToBoolean(reader["ResistanceLowCheck"]);
vo.RectAcVolMaxCheck = Convert.ToBoolean(reader["RectAcVolMaxCheck"]);
vo.RectAcVolNormCheck = Convert.ToBoolean(reader["RectAcVolNormCheck"]);
vo.RectAcVolMinCheck = Convert.ToBoolean(reader["RectAcVolMinCheck"]);
vo.RectAcVolExtrMinCheck = Convert.ToBoolean(reader["RectAcVolExtrMinCheck"]);
vo.InvAcVolMaxCheck = Convert.ToBoolean(reader["InvAcVolMaxCheck"]);
vo.InvAcVolMinCheck = Convert.ToBoolean(reader["InvAcVolMinCheck"]);
vo.InvAcVolExtrMinCheck = Convert.ToBoolean(reader["InvAcVolExtrMinCheck"]);
vo.VolModeComb = Convert.ToBoolean(reader["VolModeComb"]);
vo.chkUnbalanced = Convert.ToBoolean(reader["chkUnbalanced"]);
}
