public void addNewRecord() { string fio = dtWorker.Rows[0]["fio"].ToString(); string date = _Date.convert(date_AddRecord.DateTime); string time_start = tmEdt_start.TimeSpan.ToString(); string time_end = tmEdt_end.TimeSpan.ToString(); string time_span = (TimeSpan.Parse(time_end) - TimeSpan.Parse(time_start)).ToString(); string time_add = DateTime.Now.ToShortTimeString().ToString(); string id_tn = dtWorker.Rows[0]["id_tn"].ToString(); string subunit = lUp_subunit.Text; string work = lUp_work.Text; string id_work = lUp_work.GetColumnValue("id_work").ToString(); string id_subunit_worker = dtWorker.Rows[0]["id_subunit"].ToString(); string position = dtWorker.Rows[0]["position"].ToString(); string other = memoOther.Text; string comand = comandInsert(fio, position, subunit, id_work, work, date, time_start, time_end, other, time_add, id_tn, time_span, id_subunit_worker); if (_Sql.UpdateComand(comand)) { //msgbox.msg = "Запись добавлена успешно."; XtraMessageBox.Show("Запись добавлена успешно.", "Добавление записи"); } }
private void btn_delete_Click(object sender, EventArgs e) { GridView view = (GridView)grid_total.FocusedView; try { string totalId = view.GetFocusedRowCellValue("id").ToString(); string comand = "delete total where id=" + totalId; if (_sql.UpdateComand(comand)) { XtraMessageBox.Show("Запись успешно удалена.", "Внимание"); } } catch { XtraMessageBox.Show("Ошибка, запись не выделена.", "Ошибка"); } }