예제 #1
0
        private void btnNew_Click(object sender, EventArgs e)
        {
            if (!MainForm.isPowerUser)
            {
                return;
            }

            FormMemorandum form = new FormMemorandum();

            if (form.ShowDialog() == DialogResult.OK)
            {
                OleDbCommand cmd = new OleDbCommand("", connection);

                cmd.CommandText =
                    "insert into MEMORANDUMS (MEMORANDUM_TYPE) \n" +
                    "values('" + MainForm.StrToSQLStr(form.memorandumText) + "')";

                if (MainForm.cmdExecute(cmd) < 0)
                {
                    MessageBox.Show("Failed to create new record", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    return;
                }

                FillList();

                MainForm.LocateGridRecord(form.memorandumText, "MEMORANDUM_TYPE", 1, dgvMemorandums);
            }
        }
예제 #2
0
        private void EditRecord()
        {
            if (!MainForm.isPowerUser)
            {
                return;
            }

            if (dgvMemorandums.Rows.Count == 0)
            {
                return;
            }

            FormMemorandum form = new FormMemorandum();

            int    id  = Convert.ToInt32(dgvMemorandums.CurrentRow.Cells["MEMORANDUM_ID"].Value);
            string mem = dgvMemorandums.CurrentRow.Cells["MEMORANDUM_TYPE"].Value.ToString();

            form.memorandumId   = id;
            form.memorandumText = mem;

            if (form.ShowDialog() == DialogResult.OK)
            {
                if (string.Compare(mem, form.memorandumText) != 0)
                {
                    OleDbCommand cmd = new OleDbCommand("", connection);

                    cmd.CommandText =
                        "update MEMORANDUMS set \n" +
                        "MEMORANDUM_TYPE='" + MainForm.StrToSQLStr(form.memorandumText) + "' \n" +
                        "where MEMORANDUM_ID=" + id.ToString();

                    if (MainForm.cmdExecute(cmd) < 0)
                    {
                        MessageBox.Show("Failed to update record", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);

                        return;
                    }

                    FillList();

                    MainForm.LocateGridRecord(form.memorandumText.Trim(), "MEMORANDUM_TYPE", 1, dgvMemorandums);
                }
            }
        }