Esempio n. 1
0
 private void loadLinkedReport(int ee_id)
 {
     metroGridlinkedVariable.DataSource = null;
     metroGridLinkedReport.DataSource   = null;
     //
     metroGridLinkedReport.DataSource = Eqpreport.loadDt("select r.* from eqpreport r, linkevent2report l where l.ee_id='" + ee_id + "' and l.er_id=r.er_id and r.sts<>3");
     metroGridLinkedReport.Columns["er_id"].Visible  = false;
     metroGridLinkedReport.Columns["eqp_id"].Visible = false;
     metroGridLinkedReport.Columns["typ"].Visible    = false;
     metroGridLinkedReport.AutoResizeColumns();
 }
Esempio n. 2
0
        public void loadCbListreport()
        {
            Dictionary <int, string> mapSecsdata   = new Dictionary <int, string>();
            List <Eqpreport>         listEqpreport = Eqpreport.load();

            foreach (Eqpreport obj in listEqpreport)
            {
                mapSecsdata.Add(obj.er_id, obj.er_uuid + "_" + obj.er_reportname);
            }
            cbListReport.DataSource    = new BindingSource(mapSecsdata, null);
            cbListReport.DisplayMember = "Value";
            cbListReport.ValueMember   = "Key";
            //
        }
Esempio n. 3
0
 private void btnNEWER_Click(object sender, EventArgs e)
 {
     if (objSelectedReport != null && objSelectedReport.er_id > 0)
     {
         DialogResult dr = MessageBox.Show("Delete event??", "Confirm delete report", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
         if (dr == DialogResult.Yes)
         {
             // Update DB
             objSelectedReport.delete();
             // Reload Event list
             loadLinkedReport(objSelectedEvent.ee_id);
             btnNEWER.Text    = "NEW";
             btnUPDATEER.Text = "INSERT";
         }
     }
     else
     {
         if (btnNEWER.Text == "NEW")
         {
             btnNEWER.Text      = "CREATE LINK";
             btnUPDATEER.Text   = "INSERT";
             txt_er_uuid.Text   = "";
             txt_er_name.Text   = "";
             txt_er_sts.Checked = true;
             // Reload Event list
         }
         else
         {
             // create new report, and link to event
             objSelectedReport = new Eqpreport();
             objSelectedReport.er_reportname = txt_er_name.Text;
             objSelectedReport.er_uuid       = txt_er_uuid.Text;
             objSelectedReport.sts           = txt_er_sts.Checked == true ? 1 : 0;
             // Update DB
             objSelectedReport.insert();
             // link to event
             string query = "insert into linkevent2report values('" + objSelectedEvent.ee_id + "','" + objSelectedReport.er_id + "','1','1')";
             objSelectedReport.query(query);
             // create new report, and link to event
             btnNEWER.Text    = "NEW";
             btnUPDATEER.Text = "INSERT";
             // Reload report list
             loadLinkedReport(objSelectedEvent.ee_id);
             // reload combo list
             loadCbListreport();
             //
         }
     }
 }
Esempio n. 4
0
        public static List <Eqpreport> load(string query)
        {
            List <Eqpreport> list = new List <Eqpreport>();
            MySqlDataReader  rd   = null;

            try
            {
                MySqlConnection conn = Main.getConnection();
                if (conn == null)
                {
                    return(list);
                }
                if (query == null || query.Length == 0)
                {
                    query = "select * from eqpreport";
                }
                Log.Info("Query: " + query);
                MySqlCommand cmd = new MySqlCommand(query, conn);

                rd = cmd.ExecuteReader();

                while (rd.Read())
                {
                    Eqpreport obj = new Eqpreport();
                    obj.er_id         = Convert.ToInt32(rd["er_id"].ToString()); // Primary
                    obj.eqp_id        = Convert.ToInt32(rd["eqp_id"].ToString());
                    obj.er_uuid       = rd["er_uuid"].ToString();
                    obj.er_reportname = rd["er_reportname"].ToString();
                    obj.typ           = Convert.ToInt32(rd["typ"].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);
        }
Esempio n. 5
0
        public static Eqpreport loadUUID(string uuid)
        {
            MySqlDataReader rd = null;

            try
            {
                MySqlConnection conn = Main.getConnection();
                if (conn == null)
                {
                    return(null);
                }
                string query = "select * from eqpreport where er_uuid='" + uuid + "'";
                Log.Info("Query: " + query);
                MySqlCommand cmd = new MySqlCommand(query, conn);

                rd = cmd.ExecuteReader();
                Eqpreport obj = new Eqpreport();

                while (rd.Read())
                {
                    obj.er_id         = Convert.ToInt32(rd["er_id"].ToString()); // Primary
                    obj.eqp_id        = Convert.ToInt32(rd["eqp_id"].ToString());
                    obj.er_uuid       = rd["er_uuid"].ToString();
                    obj.er_reportname = rd["er_reportname"].ToString();
                    obj.typ           = Convert.ToInt32(rd["typ"].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);
        }
Esempio n. 6
0
        private void btnUPDATEER_Click(object sender, EventArgs e)
        {
            if (string.IsNullOrWhiteSpace(txt_er_uuid.Text))
            {
                MessageBox.Show("Report ID empty", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                txt_er_uuid.Focus();
                return;
            }
            if (string.IsNullOrWhiteSpace(txt_er_name.Text))
            {
                MessageBox.Show("Report name empty", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                txt_er_name.Focus();
                return;
            }

            if (objSelectedReport != null && objSelectedReport.er_id > 0)
            {
                objSelectedReport.er_reportname = txt_er_name.Text;
                objSelectedReport.er_uuid       = txt_er_uuid.Text;
                objSelectedReport.sts           = txt_er_sts.Checked == true ? 1 : 0;
                // Update DB
                objSelectedReport.update();
                // Reload Event list
                loadLinkedReport(objSelectedEvent.ee_id);
            }
            else
            {
                objSelectedReport = new Eqpreport();
                objSelectedReport.er_reportname = txt_er_name.Text;
                objSelectedReport.er_uuid       = txt_er_uuid.Text;
                objSelectedReport.sts           = txt_ee_sts.Checked == true ? 1 : 0;
                // Update DB
                objSelectedReport.insert();
                // Reload report list
                loadLinkedReport(objSelectedEvent.ee_id);
                // reload combo list
                loadCbListreport();
                //
            }
            //
            //
        }
Esempio n. 7
0
 private void metroGridLinkedReport_Click(object sender, EventArgs e)
 {
     if (metroGridLinkedReport.SelectedRows.Count > 0)
     {
         DataGridViewRow row = metroGridLinkedReport.SelectedRows[0];
         objSelectedReport = new Eqpreport(row);
         //
         //
         txt_er_uuid.Text   = objSelectedReport.er_uuid;
         txt_er_name.Text   = objSelectedReport.er_reportname;
         txt_er_sts.Checked = objSelectedReport.sts == 1;
         //
         loadLinkedVariable(objSelectedReport.er_id);
         //
         btnNEWER.Text    = "DELETE";
         btnUPDATEER.Text = "UPDATE";
     }
     else
     {
         metroGridlinkedVariable.DataSource = null;
     }
 }
Esempio n. 8
0
 private void metroGridLinkedReport_KeyDown(object sender, KeyEventArgs e)
 {
     if (e.KeyData == Keys.Delete)
     {
         int Count = metroGridLinkedReport.SelectedRows.Count;
         if (Count > 0)
         {
             DataGridViewRow row = metroGridLinkedReport.SelectedRows[0];
             Eqpreport       obj = new Eqpreport(row);
             //
             DialogResult dr = MessageBox.Show("Remove link this report to event [" + obj.er_uuid + "]??", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
             if (dr == DialogResult.Yes)
             {
                 // Update DB
                 obj.query("delete from linkevent2report where ee_id='" + objSelectedEvent.ee_id + "' and er_id='" + obj.er_id + "'");
                 //
                 loadLinkedReport(objSelectedEvent.ee_id);
                 //
             }
         }
     }
 }