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();
//
}
}
}
private void btnAddVariableToReport_Click(object sender, EventArgs e)
{
//
if (objSelectedReport == null || objSelectedReport.er_id == 0)
{
return;
}
int dv_id = (((KeyValuePair <int, string>)cbListDVID.SelectedItem).Key);
if (objSelectedReport != null)
{
// link to event
string query = "insert into linkreport2variable values('" + objSelectedReport.er_id + "','" + dv_id + "','1','1')";
objSelectedReport.query(query);
// Reload report list
loadLinkedVariable(objSelectedReport.er_id);
}
}
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);
//
}
}
}
}
