/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(ALS.Model.actions model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_actions(");
strSql.Append("customID,portName,arrCommand,actionInfo,cmdLength)");
strSql.Append(" values (");
strSql.Append("@customID,@portName,@arrCommand,@actionInfo,@cmdLength)");
MySqlParameter[] parameters =
{
new MySqlParameter("@customID", MySqlDbType.Int32, 20),
new MySqlParameter("@portName", MySqlDbType.VarChar, 255),
new MySqlParameter("@arrCommand", MySqlDbType.Binary),
new MySqlParameter("@actionInfo", MySqlDbType.VarChar, 255),
new MySqlParameter("@cmdLength", MySqlDbType.Int32, 20),
};
parameters[0].Value = model.customID;
parameters[1].Value = model.portName;
parameters[2].Value = model.arrCommand;
parameters[3].Value = model.actionInfo;
parameters[4].Value = model.cmdLength;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ALS.Model.actions DataRowToModel(DataRow row)
{
ALS.Model.actions model = new ALS.Model.actions();
if (row != null)
{
if (row["ID"] != null && row["ID"].ToString() != "")
{
model.ID = long.Parse(row["ID"].ToString());
}
if (row["customID"] != null && row["customID"].ToString() != "")
{
model.customID = long.Parse(row["customID"].ToString());
}
if (row["portName"] != null)
{
model.portName = row["portName"].ToString();
}
if (row["arrCommand"] != null && row["arrCommand"].ToString() != "")
{
model.arrCommand = (byte[])row["arrCommand"];
}
if (row["actionInfo"] != null)
{
model.actionInfo = row["actionInfo"].ToString();
}
if (row["cmdLength"] != null && row["cmdLength"].ToString() != "")
{
model.cmdLength = int.Parse(row["cmdLength"].ToString());
}
}
return(model);
}
private void btnVeinOpen_Click(object sender, EventArgs e)
{
ALS.Model.actions modact = new ALS.Model.actions();
ALS.BLL.actions bllact = new ALS.BLL.actions();
Button b = sender as Button;
if (b.Tag != null)
{
switch (b.Tag.ToString())
{
case "1":
modact.arrCommand = Cls.Comm_Main.LiquidLevel.liquidLevel1Up;
modact.actionInfo = "静脉壶液面上升";
break;
case "2":
modact.arrCommand = Cls.Comm_Main.LiquidLevel.liquidLevel1Down;
modact.actionInfo = "静脉壶液面下降";
break;
case "3":
modact.arrCommand = Cls.Comm_Main.LiquidLevel.liquidLevel2Up;
modact.actionInfo = "动脉壶液面上升";
break;
case "4":
modact.arrCommand = Cls.Comm_Main.LiquidLevel.liquidLevel2Down;
modact.actionInfo = "动脉壶液面下降";
break;
case "5":
modact.arrCommand = Cls.Comm_Main.LiquidLevel.liquidLevel3Up;
modact.actionInfo = "M1液面上升";
break;
case "6":
modact.arrCommand = Cls.Comm_Main.LiquidLevel.liquidLevel3Down;
modact.actionInfo = "M1液面下降";
break;
}
}
modact.customID = m_customID;
modact.portName = Port_Main.PortName;
modact.cmdLength = modact.arrCommand.Length;
if (bllact.Add(modact))
{
ShowActions(m_customID);
}
}
private void btnVoiseClose_Click(object sender, EventArgs e)
{
ALS.Model.actions modact = new ALS.Model.actions();
ALS.BLL.actions bllact = new ALS.BLL.actions();
Button b = sender as Button;
switch (b.Tag.ToString())
{
case "voise1":
modact.arrCommand = Cls.Comm_Main.CmdAlarmLamp.Alarm1;
modact.actionInfo = "报警音1";
break;
case "voise2":
modact.arrCommand = Cls.Comm_Main.CmdAlarmLamp.Alarm2;
modact.actionInfo = "报警音2";
break;
case "lightclose":
modact.arrCommand = Cls.Comm_Main.CmdAlarmLamp.AllLightClose;
modact.actionInfo = "所有灯关闭";
break;
case "lightred":
modact.arrCommand = Cls.Comm_Main.CmdAlarmLamp.RedTwinkle;
modact.actionInfo = "红灯闪烁";
break;
case "lightyellow":
modact.arrCommand = Cls.Comm_Main.CmdAlarmLamp.YellowTwinkle;
modact.actionInfo = "黄灯闪烁";
break;
case "lightgreen":
modact.arrCommand = Cls.Comm_Main.CmdAlarmLamp.GreenAlways;
modact.actionInfo = "绿灯常亮";
break;
}
modact.customID = m_customID;
modact.portName = Port_Main.PortName;
modact.cmdLength = modact.arrCommand.Length;
if (bllact.Add(modact))
{
ShowActions(m_customID);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(ALS.Model.actions model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_actions set ");
strSql.Append("customID=@customID,");
strSql.Append("portName=@portName,");
strSql.Append("arrCommand=@arrCommand,");
strSql.Append("actionInfo=@actionInfo");
strSql.Append("cmdLength = @cmdLength");
strSql.Append(" where ID=@ID");
MySqlParameter[] parameters =
{
new MySqlParameter("@customID", MySqlDbType.Int32, 20),
new MySqlParameter("@portName", MySqlDbType.VarChar, 255),
new MySqlParameter("@arrCommand", MySqlDbType.Binary),
new MySqlParameter("@actionInfo", MySqlDbType.VarChar, 255),
new MySqlParameter("@cmdLength", MySqlDbType.Int32, 20),
new MySqlParameter("@ID", MySqlDbType.Int32, 20)
};
parameters[0].Value = model.customID;
parameters[1].Value = model.portName;
parameters[2].Value = model.arrCommand;
parameters[3].Value = model.actionInfo;
parameters[4].Value = model.cmdLength;
parameters[5].Value = model.ID;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ALS.Model.actions GetModel(long ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID,customID,portName,arrCommand,actionInfo,cmdLength from tb_actions ");
strSql.Append(" where ID=@ID");
MySqlParameter[] parameters =
{
new MySqlParameter("@ID", MySqlDbType.Int32)
};
parameters[0].Value = ID;
ALS.Model.actions model = new ALS.Model.actions();
DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
private void rbtnAddActionOfAD_Click(object sender, EventArgs e)
{
if (m_ADID == 0)
{
MessageBox.Show("请选择气泡检测器");
return;
}
if (!(this.rbtnOpenAD.Checked) && !(this.rbtnCloseAD.Checked))
{
MessageBox.Show("请选择气泡检测器状态");
return;
}
ALS.Model.actions modact = new ALS.Model.actions();
ALS.BLL.actions bllact = new ALS.BLL.actions();
switch (m_ADID)
{
case 1:
if (rbtnOpenAD.Checked)
{
modact.arrCommand = Cls.Comm_Main.CmdBubble.OpenBubble1;
modact.actionInfo = "气泡检测器1打开";
}
else
{
modact.arrCommand = Cls.Comm_Main.CmdBubble.CloseBubble1;
modact.actionInfo = "气泡检测器1关闭";
}
break;
case 2:
if (rbtnOpenAD.Checked)
{
modact.arrCommand = Cls.Comm_Main.CmdBubble.OpenBubble2;
modact.actionInfo = "气泡检测器2打开";
}
else
{
modact.arrCommand = Cls.Comm_Main.CmdBubble.CloseBubble2;
modact.actionInfo = "气泡检测器2关闭";
}
break;
case 3:
if (rbtnOpenAD.Checked)
{
modact.arrCommand = Cls.Comm_Main.CmdBubble.OpenBubble3;
modact.actionInfo = "气泡检测器3打开";
}
else
{
modact.arrCommand = Cls.Comm_Main.CmdBubble.CloseBubble3;
modact.actionInfo = "气泡检测器3关闭";
}
break;
}
modact.customID = m_customID;
modact.portName = Port_Main.PortName;
modact.cmdLength = modact.arrCommand.Length;
if (bllact.Add(modact))
{
ShowActions(m_customID);
}
}
private void btnAddActionOfV_Click(object sender, EventArgs e)
{
byte[] vstate = new byte[6];
StringBuilder sb = new StringBuilder();
ALS.Model.actions modact = new ALS.Model.actions();
ALS.BLL.actions bllact = new ALS.BLL.actions();
if (chkV1.Checked)
{
sb.Append("V1夹管,"); vstate[0] = 0x01;
}
else
{
sb.Append("V1松管,"); vstate[0] = 0x00;
}
if (chkV2.Checked)
{
sb.Append("V2夹管,"); vstate[1] = 0x01;
}
else
{
sb.Append("V2松管,"); vstate[1] = 0x00;
}
if (chkV3.Checked)
{
sb.Append("V3夹管,"); vstate[2] = 0x01;
}
else
{
sb.Append("V3松管,"); vstate[2] = 0x00;
}
if (chkV4.Checked)
{
sb.Append("V4夹管,"); vstate[3] = 0x01;
}
else
{
sb.Append("V4松管,"); vstate[3] = 0x00;
}
if (chkV5.Checked)
{
sb.Append("V5夹管,"); vstate[4] = 0x01;
}
else
{
sb.Append("V5松管,"); vstate[4] = 0x00;
}
if (chkV6.Checked)
{
sb.Append("V6夹管."); vstate[5] = 0x01;
}
else
{
sb.Append("V6松管."); vstate[5] = 0x00;
}
string info = sb.ToString();
if (DialogResult.OK == MessageBox.Show("请确认夹管阀状态是否正确:[" + info + "] ?", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question))
{
modact.actionInfo = info;
modact.customID = m_customID;
modact.portName = Port_Main.PortName;
modact.arrCommand = Cls.Comm_Main.CmdValve.SetVState(vstate[0], vstate[1], vstate[2], vstate[3], vstate[4], vstate[5]);
modact.cmdLength = modact.arrCommand.Length;
if (bllact.Add(modact))
{
ShowActions(m_customID);
}
}
}
private void btnAddActionOfPump_Click(object sender, EventArgs e)
{
if (m_pumpID == 0)
{
MessageBox.Show("请选择泵!");
return;
}
if ((!rbtnClockwise.Checked) && (!rbtnAntiClockwise.Checked) && (!rbtnIsRun.Checked))
{
MessageBox.Show("请选择泵运转方向!");
return;
}
//当选择所有泵时，必须选择rbtnIsRun
if (rbtnAllPump.Checked)
{
if (rbtnIsRun.Checked == false)
{
MessageBox.Show("请选择所有泵的运转状态,此处必须选择停止!");
return;
}
}
//if (lblPumpSpeed.Text == "0.0" && (!rbtnIsRun.Checked))
//{
// MessageBox.Show("请设定泵速!");
// return;
//}
if (m_modc != null)
{
//当前选择的自定义步骤
m_customID = (int)m_modc.ID;
//添加泵动作
//针对创新模式中，预计 预冲量的确认需要计算：
//第一部分：预冲量 以自定义步骤中 BP运转时间 * 速度；
//第二部分：预冲量 以自定义步骤中 RP运转时间 * 速度；
//当添加的动作里包含 BP 或 RP 运转时，需要更新该步骤中的累计流量字段；
//注：原有字段 timeCount ,存储 累计流量
ALS.Model.actions modact = new ALS.Model.actions();
modact.customID = m_customID;
m_bPumpDirection = rbtnClockwise.Checked ? true : false;
m_bPumpRun = rbtnIsRun.Checked ? false : true;
modact.arrCommand = Cls.Comm_PeristalticPump.Command(m_pumpID, Convert.ToDouble(this.lblPumpSpeed.Text), m_bPumpRun, m_bPumpDirection);
modact.portName = _port_Pump.PortName;
modact.cmdLength = modact.arrCommand.Length;
if (m_bPumpRun)
{
modact.actionInfo = m_strPumpText + "," + m_strPumpDirection + "," + lblPumpSpeed.Text + "mL/min,持续时间:" + lbltsPump.Text + ",预计流量:" + lblml.Text + "mL";
}
else
{
modact.actionInfo = m_strPumpText + ",停止运行!";
}
ALS.BLL.actions bllact = new ALS.BLL.actions();
if (bllact.Add(modact))
{
////如果泵ID为1
//if(m_pumpID==1)
//{
// m_modc.timeCount = int.Parse(lblml.Text);
// new BLL.customactions().Update(m_modc);
//}
DataSet dsact = bllact.GetList("customID='" + m_customID + "'", true);
this.dgActions.DataSource = dsact.Tables[0];
this.dgActions.Refresh();
}
}
else
{
MessageBox.Show("请选择需要添加操作的步骤", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
}
private void btnAddActionOfV_Click(object sender, EventArgs e)
{
if (m_VID == 0)
{
MessageBox.Show("请选择夹管阀");
return;
}
if (!(rbtnClampV.Checked) && !(rbtnLooseV.Checked))
{
MessageBox.Show("请选择夹管阀动作状态");
return;
}
ALS.Model.actions modact = new ALS.Model.actions();
ALS.BLL.actions bllact = new ALS.BLL.actions();
switch (m_VID)
{
case 1:
if (rbtnClampV.Checked)
{
modact.arrCommand = Cls.Comm_Main.CmdValve.ClampV1;
modact.actionInfo = "夹管阀1夹管";
}
else
{
modact.arrCommand = Cls.Comm_Main.CmdValve.LoosenV1;
modact.actionInfo = "夹管阀1松管";
}
break;
case 2:
if (rbtnClampV.Checked)
{
modact.arrCommand = Cls.Comm_Main.CmdValve.ClampV2;
modact.actionInfo = "夹管阀2夹管";
}
else
{
modact.arrCommand = Cls.Comm_Main.CmdValve.LoosenV2;
modact.actionInfo = "夹管阀2松管";
}
break;
case 3:
if (rbtnClampV.Checked)
{
modact.arrCommand = Cls.Comm_Main.CmdValve.ClampV3;
modact.actionInfo = "夹管阀3夹管";
}
else
{
modact.arrCommand = Cls.Comm_Main.CmdValve.LoosenV3;
modact.actionInfo = "夹管阀3松管";
}
break;
case 4:
if (rbtnClampV.Checked)
{
modact.arrCommand = Cls.Comm_Main.CmdValve.ClampV4;
modact.actionInfo = "夹管阀4夹管";
}
else
{
modact.arrCommand = Cls.Comm_Main.CmdValve.LoosenV4;
modact.actionInfo = "夹管阀4松管";
}
break;
case 5:
if (rbtnClampV.Checked)
{
modact.arrCommand = Cls.Comm_Main.CmdValve.ClampV5;
modact.actionInfo = "夹管阀5夹管";
}
else
{
modact.arrCommand = Cls.Comm_Main.CmdValve.LoosenV5;
modact.actionInfo = "夹管阀5松管";
}
break;
case 6:
if (rbtnClampV.Checked)
{
modact.arrCommand = Cls.Comm_Main.CmdValve.ClampV6;
modact.actionInfo = "夹管阀6夹管";
}
else
{
modact.arrCommand = Cls.Comm_Main.CmdValve.LoosenV6;
modact.actionInfo = "夹管阀6松管";
}
break;
}
modact.customID = m_customID;
modact.portName = Port_Main.PortName;
modact.cmdLength = modact.arrCommand.Length;
if (bllact.Add(modact))
{
ShowActions(m_customID);
}
}
private void btnAddActionOfPump_Click(object sender, EventArgs e)
{
if (m_pumpID == 0)
{
MessageBox.Show("请选择泵!");
return;
}
if ((!rbtnClockwise.Checked) && (!rbtnAntiClockwise.Checked) && (!rbtnIsRun.Checked))
{
MessageBox.Show("请选择泵运转方向!");
return;
}
//当选择所有泵时，必须选择rbtnIsRun
if (rbtnAllPump.Checked)
{
if (rbtnIsRun.Checked == false)
{
MessageBox.Show("请选择所有泵的运转状态,此处必须选择停止!");
return;
}
}
if (lblPumpSpeed.Text == "0.0" && (!rbtnIsRun.Checked))
{
MessageBox.Show("请设定泵速!");
return;
}
if (m_modc != null)
{
m_customID = (int)m_modc.ID;
ALS.Model.actions modact = new ALS.Model.actions();
modact.customID = m_customID;
m_bPumpDirection = rbtnClockwise.Checked ? true : false;
m_bPumpRun = rbtnIsRun.Checked ? false : true;
modact.arrCommand = Cls.Comm_PeristalticPump.Command(m_pumpID, Convert.ToDouble(this.lblPumpSpeed.Text), m_bPumpRun, m_bPumpDirection);
modact.portName = _port_Pump.PortName;
modact.cmdLength = modact.arrCommand.Length;
if (m_bPumpRun)
{
modact.actionInfo = m_strPumpText + "," + m_strPumpDirection + "," + lblPumpSpeed.Text + "mL/min,持续时间:" + lbltsPump.Text + ",预计流量:" + lblml.Text + "mL";
}
else
{
modact.actionInfo = m_strPumpText + ",停止运行!";
}
ALS.BLL.actions bllact = new ALS.BLL.actions();
if (bllact.Add(modact))
{
DataSet dsact = bllact.GetList("customID='" + m_customID + "'", true);
this.dgActions.DataSource = dsact.Tables[0];
this.dgActions.Refresh();
}
}
else
{
MessageBox.Show("请选择需要添加操作的步骤", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
}
