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; // } // }