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();
}