public void loadCbListVariable()
{
Dictionary <int, string> mapVariable = new Dictionary <int, string>();
List <Eqpdatavariable> listEqpVariable = Eqpdatavariable.load();
foreach (Eqpdatavariable obj in listEqpVariable)
{
if (obj.dv_type == 1)
{
// EQP const
continue;
}
else if (obj.dv_type == 2)
{
mapVariable.Add(obj.dv_id, "SVID_" + obj.dv_uuid + "_" + obj.dv_name);
}
else if (obj.dv_type == 3)
{
mapVariable.Add(obj.dv_id, "DVID_" + obj.dv_uuid + "_" + obj.dv_name);
}
}
cbListDVID.DataSource = new BindingSource(mapVariable, null);
cbListDVID.DisplayMember = "Value";
cbListDVID.ValueMember = "Key";
//
}
public static List <Eqpdatavariable> load(string query)
{
List <Eqpdatavariable> list = new List <Eqpdatavariable>();
MySqlDataReader rd = null;
try
{
MySqlConnection conn = Main.getConnection();
if (conn == null)
{
return(list);
}
if (query == null || query.Length == 0)
{
query = "select * from eqpdatavariable";
}
Log.Info("Query: " + query);
MySqlCommand cmd = new MySqlCommand(query, conn);
rd = cmd.ExecuteReader();
while (rd.Read())
{
Eqpdatavariable obj = new Eqpdatavariable();
obj.dv_id = Convert.ToInt32(rd["dv_id"].ToString()); // Primary
obj.eqp_id = Convert.ToInt32(rd["eqp_id"].ToString());
obj.dv_type = Convert.ToInt32(rd["dv_type"].ToString());
obj.dv_uuid = rd["dv_uuid"].ToString();
obj.dv_name = rd["dv_name"].ToString();
obj.dv_unit = rd["dv_unit"].ToString();
obj.dv_limitmin = rd["dv_limitmin"].ToString();
obj.dv_limitmax = rd["dv_limitmax"].ToString();
obj.dv_default = rd["dv_default"].ToString();
obj.dv_datatype = Convert.ToInt32(rd["dv_datatype"].ToString());
obj.dv_secs = rd["dv_secs"].ToString();
obj.dv_value = rd["dv_value"].ToString();
obj.dv_valuetext = rd["dv_valuetext"].ToString();
obj.dv_updateby = rd["dv_updateby"].ToString();
obj.dv_lastupdate = Convert.ToInt32(rd["dv_lastupdate"].ToString());
obj.sts = Convert.ToInt32(rd["sts"].ToString());
list.Add(obj);
}
rd.Close();
}
catch (MySqlException e)
{
Log.Error("Error: " + e.Message);
}
finally
{
if (rd != null)
{
rd.Close();
}
}
return(list);
}
public static Eqpdatavariable loadUUID(string uuid)
{
MySqlDataReader rd = null;
try
{
MySqlConnection conn = Main.getConnection();
if (conn == null)
{
return(null);
}
string query = "select * from eqpdatavariable where dv_uuid='" + uuid + "'";
Log.Info("Query: " + query);
MySqlCommand cmd = new MySqlCommand(query, conn);
rd = cmd.ExecuteReader();
Eqpdatavariable obj = new Eqpdatavariable();
while (rd.Read())
{
obj.dv_id = Convert.ToInt32(rd["dv_id"].ToString()); // Primary
obj.eqp_id = Convert.ToInt32(rd["eqp_id"].ToString());
obj.dv_type = Convert.ToInt32(rd["dv_type"].ToString());
obj.dv_uuid = rd["dv_uuid"].ToString();
obj.dv_name = rd["dv_name"].ToString();
obj.dv_unit = rd["dv_unit"].ToString();
obj.dv_limitmin = rd["dv_limitmin"].ToString();
obj.dv_limitmax = rd["dv_limitmax"].ToString();
obj.dv_default = rd["dv_default"].ToString();
obj.dv_datatype = Convert.ToInt32(rd["dv_datatype"].ToString());
obj.dv_secs = rd["dv_secs"].ToString();
obj.dv_value = rd["dv_value"].ToString();
obj.dv_valuetext = rd["dv_valuetext"].ToString();
obj.dv_updateby = rd["dv_updateby"].ToString();
obj.dv_lastupdate = Convert.ToInt32(rd["dv_lastupdate"].ToString());
obj.sts = Convert.ToInt32(rd["sts"].ToString());
break;
}
rd.Close();
return(obj);
}
catch (MySqlException e)
{
Log.Error("Query: " + e.Message);
}
finally
{
if (rd != null)
{
rd.Close();
}
}
return(null);
}
private void loadEquipmentDataVariavle()
{
metroGridEquipmentDataVariable.DataSource = Eqpdatavariable.loadDt("select * from eqpdatavariable where dv_type=3 and sts<>3");
metroGridEquipmentDataVariable.Columns["dv_id"].Visible = false;
metroGridEquipmentDataVariable.Columns["eqp_id"].Visible = false;
metroGridEquipmentDataVariable.Columns["dv_type"].Visible = false;
metroGridEquipmentDataVariable.Columns["dv_default"].Visible = false;
metroGridEquipmentDataVariable.Columns["dv_limitmin"].Visible = false;
metroGridEquipmentDataVariable.Columns["dv_limitmax"].Visible = false;
metroGridEquipmentDataVariable.Columns["dv_datatype"].Visible = false;
metroGridEquipmentDataVariable.Columns["dv_valuetext"].Visible = false;
metroGridEquipmentDataVariable.AutoResizeColumns();
}
private void loadLinkedVariable(int er_id)
{
metroGridlinkedVariable.DataSource = null;
//
metroGridlinkedVariable.DataSource = Eqpdatavariable.loadDt("select r.* from eqpdatavariable r, linkreport2variable l where l.er_id='" + er_id + "' and l.dv_id=r.dv_id and r.sts<>3");
metroGridlinkedVariable.Columns["dv_id"].Visible = false;
metroGridlinkedVariable.Columns["eqp_id"].Visible = false;
metroGridlinkedVariable.Columns["dv_type"].Visible = false;
metroGridlinkedVariable.Columns["dv_default"].Visible = false;
metroGridlinkedVariable.Columns["dv_limitmin"].Visible = false;
metroGridlinkedVariable.Columns["dv_limitmax"].Visible = false;
metroGridlinkedVariable.Columns["dv_datatype"].Visible = false;
metroGridlinkedVariable.Columns["dv_valuetext"].Visible = false;
metroGridlinkedVariable.AutoResizeColumns();
}
private void metroGridlinkedVariable_Click(object sender, EventArgs e)
{
int Count = metroGridlinkedVariable.SelectedRows.Count;
if (Count > 0)
{
DataGridViewRow row = metroGridlinkedVariable.SelectedRows[0];
Eqpdatavariable obj = new Eqpdatavariable(row);
View.EqpdatavariableForm dlg = new View.EqpdatavariableForm();
dlg.objEqpdatavariable = obj;
dlg.ShowDialog();
//
loadLinkedVariable(objSelectedReport.er_id);
//
}
}
private void metroGridEquipmentDataVariable_Click(object sender, EventArgs e)
{
if (metroGridEquipmentDataVariable.SelectedRows.Count > 0)
{
DataGridViewRow row = metroGridEquipmentDataVariable.SelectedRows[0];
Eqpdatavariable obj = new Eqpdatavariable(row);
View.EqpdatavariableForm dlg = new View.EqpdatavariableForm();
dlg.objEqpdatavariable = obj;
dlg.ShowDialog();
//
if (dlg.DialogResult == DialogResult.OK)
{
loadEquipmentDataVariavle();
}
//
}
}
private void metroGridEquipmentConstant_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyData == Keys.Delete)
{
int Count = metroGridEquipmentConstant.SelectedRows.Count;
if (Count > 0)
{
DataGridViewRow row = metroGridEquipmentConstant.SelectedRows[0];
Eqpdatavariable obj = new Eqpdatavariable(row);
DialogResult dr = MessageBox.Show("Delete equipment constant data [" + obj.dv_uuid + "]??", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
if (dr == DialogResult.Yes)
{
// Update DB
obj.delete();
//
loadEquipmentConst();
//
}
}
}
}
private void metroGridlinkedVariable_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyData == Keys.Delete)
{
int Count = metroGridlinkedVariable.SelectedRows.Count;
if (Count > 0)
{
DataGridViewRow row = metroGridlinkedVariable.SelectedRows[0];
Eqpdatavariable obj = new Eqpdatavariable(row);
//
DialogResult dr = MessageBox.Show("Remove link this variable to report [" + obj.dv_uuid + "]?", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
if (dr == DialogResult.Yes)
{
// Update DB
obj.query("delete from linkreport2variable where er_id='" + objSelectedReport.er_id + "' and dv_id='" + obj.dv_id + "'");
//
loadLinkedVariable(objSelectedReport.er_id);
//
}
}
}
}
private void gemStatusRefresh()
{
Eqpdatavariable _GEM_ControlState = null; // Eqpdatavariable.loadUUID("70");
Eqpdatavariable _GEM_CommunicationsState = null; // Eqpdatavariable.loadUUID("73");
if (_GEM_ControlState == null || _GEM_CommunicationsState == null)
{
return;
}
//
int _GEM_ControlState_dv_value = Convert.ToInt16(_GEM_ControlState.dv_value);
if (_GEM_ControlState_dv_value == 1)
{
// GEM OFFLINE
controlStateOFFLINE.BackColor = Color.Green;
controlStateONLINE_LOCAL.BackColor = Color.White;
controlStateONLINE_REMOTE.BackColor = Color.White;
//
}
else if (_GEM_ControlState_dv_value == 2)
{
// GEM OFFLINE
controlStateOFFLINE.BackColor = Color.White;
controlStateONLINE_LOCAL.BackColor = Color.Green;
controlStateONLINE_REMOTE.BackColor = Color.White;
//
}
else if (_GEM_ControlState_dv_value == 3)
{
// GEM OFFLINE
controlStateOFFLINE.BackColor = Color.White;
controlStateONLINE_LOCAL.BackColor = Color.White;
controlStateONLINE_REMOTE.BackColor = Color.Green;
//
}
//
//
int _GEM_CommunicationsState_value = Convert.ToInt16(_GEM_CommunicationsState.dv_value);
if (_GEM_CommunicationsState_value == 1)
{
// GEM OFFLINE
controlStateSTART.BackColor = Color.Green;
controlStateSTOP.BackColor = Color.White;
controlStateRESUME.BackColor = Color.White;
controlStateABORT.BackColor = Color.White;
controlStatePAUSE.BackColor = Color.White;
//
}
else if (_GEM_CommunicationsState_value == 2)
{
// GEM OFFLINE
controlStateSTART.BackColor = Color.White;
controlStateSTOP.BackColor = Color.Green;
controlStateRESUME.BackColor = Color.White;
controlStateABORT.BackColor = Color.White;
controlStatePAUSE.BackColor = Color.White;
//
}
else if (_GEM_CommunicationsState_value == 3)
{
// GEM OFFLINE
controlStateSTART.BackColor = Color.White;
controlStateSTOP.BackColor = Color.White;
controlStateRESUME.BackColor = Color.Green;
controlStateABORT.BackColor = Color.White;
controlStatePAUSE.BackColor = Color.White;
//
}
else if (_GEM_CommunicationsState_value == 4)
{
// GEM OFFLINE
controlStateSTART.BackColor = Color.White;
controlStateSTOP.BackColor = Color.White;
controlStateRESUME.BackColor = Color.White;
controlStateABORT.BackColor = Color.Green;
controlStatePAUSE.BackColor = Color.White;
//
}
else if (_GEM_CommunicationsState_value == 5)
{
// GEM OFFLINE
controlStateSTART.BackColor = Color.White;
controlStateSTOP.BackColor = Color.White;
controlStateRESUME.BackColor = Color.White;
controlStateABORT.BackColor = Color.White;
controlStatePAUSE.BackColor = Color.Green;
//
}
//
}
