private void btnLoadMarkFromFile_Click(object sender, EventArgs e) { SySal.OperaDb.OperaDbTransaction trans = null; try { frmLoadMarkFromFile lm = new frmLoadMarkFromFile(); lm.NumberBrick = lvBricks.SelectedItems[0].SubItems[0].Text; if (lm.ShowDialog() == DialogResult.OK) { trans = SySal.OperaDb.Schema.DB.BeginTransaction(); long nextmark = SySal.OperaDb.Convert.ToInt32(new SySal.OperaDb.OperaDbCommand("SELECT NVL(MAX(ID_MARK),0) FROM TB_TEMPLATEMARKSETS WHERE ID_EVENTBRICK = " + lvBricks.SelectedItems[0].SubItems[0].Text, SySal.OperaDb.Schema.DB, trans).ExecuteScalar()) + 1; foreach (SySal.BasicTypes.Vector v in lm.MarkSet.Marks) { SySal.OperaDb.Schema.TB_TEMPLATEMARKSETS.Insert(0L, System.Convert.ToInt64(lvBricks.SelectedItems[0].SubItems[0].Text), nextmark++, v.X, v.Y, 1, 1, lm.MarkSet.type.ToString(), (int)v.Z); } trans.Commit(); lvBricks.SelectedItems[0].Selected = true; } } catch (Exception x) { try { if (trans != null) { trans.Rollback(); } } catch (Exception) {} MessageBox.Show(x.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btnInsertCSMark_Click(object sender, EventArgs e) { SySal.OperaDb.OperaDbTransaction trans = null; try { frmInsertMarkFromDB im = new frmInsertMarkFromDB(); im.NumberBrick = lvBricks.SelectedItems[0].SubItems[0].Text; if (im.ShowDialog() == DialogResult.OK) { trans = SySal.OperaDb.Schema.DB.BeginTransaction(); int nextmark = SySal.OperaDb.Convert.ToInt32(new SySal.OperaDb.OperaDbCommand("SELECT NVL(MAX(ID_MARK) + 1,0) FROM TB_TEMPLATEMARKSETS WHERE ID_EVENTBRICK = " + lvBricks.SelectedItems[0].SubItems[0].Text, SySal.OperaDb.Schema.DB, trans).ExecuteScalar()); new SySal.OperaDb.OperaDbCommand("INSERT INTO TB_TEMPLATEMARKSETS (ID_EVENTBRICK, ID_MARK, POSX, POSY, MARKROW, MARKCOL, SHAPE, SIDE) (SELECT " + lvBricks.SelectedItems[0].SubItems[0].Text + ",ID_MARK + " + nextmark + ",POSX,POSY,MARKROW,MARKCOL,SHAPE,1 FROM TB_TEMPLATEMARKSETS WHERE ID_EVENTBRICK=" + im.CsBrick + ")", SySal.OperaDb.Schema.DB, trans).ExecuteNonQuery(); trans.Commit(); ListViewItem lvi = lvBricks.SelectedItems[0]; lvi.Selected = false; lvi.Selected = true; } } catch (Exception x) { try { if (trans != null) { trans.Rollback(); } } catch (Exception) { } MessageBox.Show(x.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }