private void parmExecute(EHow how) { if (allowUpdates == false && how != EHow.DISPLAY) return; string where = "", c = "", query = ""; int row = -1; int field; DataTable data = null; int offset = pcTable.offsetFields; if (tablesDataGrid.CurrentRow != null) { where = "WHERE "; row = tablesDataGrid.CurrentRow.Index; data = tablesDataGrid.DataSource as DataTable; for (int k = 0; k < pcTable.noKeyFields; k++) { int okfield = k + pcTable.offsetKeyFields; field = pcKeyFields[okfield].index; string value = data.Rows[row][field].ToString(); TPCField pcField = pcFields[offset + field]; string ready = sqlReady(pcField, value); where += c + pcFields[offset + field].name + " = " + ready; c = " AND "; } } string oldUsId = ""; string oldTmStamp = ""; string newUsId = ""; string newTmStamp = ""; if (row != -1) { int no = pcTable.noFields; oldUsId = data.Rows[row][no].ToString(); oldTmStamp = DateTime.Parse(data.Rows[row][no + 1].ToString()).ToString("yyyyMMddhhmmss"); } List<EntryItem> edits = new List<EntryItem>(pcTable.noFields); ScaffoldForm form = scaffoldForm = new ScaffoldForm(this, how, edits); int comboWidth = form.ClientSize.Width - 132; int editWidth = comboWidth - 18; // The next 3 lines are indicative of why properties are at best second class. Size size = form.MinimumSize; size.Height = pcTable.noFields * 24 + 66; form.MinimumSize = size; Dictionary<int, ComboBox> combos = new Dictionary<int, ComboBox>(); for (field = 0; field < pcTable.noFields; field++) { EntryItem edit = new EntryItem(); edits.Add(edit); TPCField pcField = pcFields[field + offset]; edit.ofType = pcField.type; edit.isNull = pcField.isNull == 1; if (how != EHow.ADD && (how == EHow.DELETE || how == EHow.DISPLAY || isKey(pcTable, field)) || (how == EHow.ADD && pcField.type == DBHandler.PC_SEQUENCE)) edit.isReadOnly = true; if (pcField.uppercase == 1 || isKey(pcTable, field) == true) edit.uppercase = true; Label label = edit.label = new Label(); label.Text = pcField.name; label.Top = field * 24 + 4; label.Left = 4; form.CapturePanel.Controls.Add(label); if (showSetup.Checked == true) LogDebug = label.Text + " " + label.Top + " " + label.Left; string setupWork = pcField.name; string value = ""; if (how == EHow.ADD || (how == EHow.CHANGE && isKey(pcTable, field) == false)) { value = row != -1 ? data.Rows[row][field].ToString() : ""; if (clearAdd.Checked == true && how == EHow.ADD) value = ""; int link; int pair; if (setupLink(pcTable, field, out link, out pair)) { setupWork += " Is Link Field"; if (sizeIsOk(link) == true) { setupWork += " and is not too large"; if (pair == 0) { newDropDown(edit, pcTable.index, link, field * 24 + 4, 124, comboWidth, value); combos.Add(link, edit.combo); edit.pair = pair; form.CapturePanel.Controls.Add(edit.combo); if (showSetup.Checked == true) LogDebug = setupWork; } else { setupWork += " is extra link pair field"; edit.isReadOnly = true; edit.combo = combos[link]; edit.pair = pair; edit.combo.SelectedIndexChanged += new EventHandler(editComboSelectedIndexChanged); edit.Text(field * 24 + 4, 124, editWidth, maxLength(pcField), value); List<EntryItem> list = (List<EntryItem>)edit.combo.Tag; list.Add(edit); form.CapturePanel.Controls.Add(edit.text); } continue; } } else if (pcField.noEnums > 0) { setupWork += " Is Enum Field"; enumDropDown(edit, field + offset, field * 24 + 4, 124, comboWidth, value); form.CapturePanel.Controls.Add(edit.combo); if (showSetup.Checked == true) LogDebug = setupWork; continue; } } value = row != -1 ? data.Rows[row][field].ToString() : ""; if (clearAdd.Checked == true && how == EHow.ADD) value = ""; switch (pcField.type) { case DBHandler.PC_CHAR: case DBHandler.PC_USERSTAMP: { setupWork += " Is Text Field"; edit.Text(field * 24 + 4, 124, editWidth, maxLength(pcField), value); form.CapturePanel.Controls.Add(edit.text); } break; case DBHandler.PC_DATE: { setupWork += " Is Date Field"; edit.Date(field * 24 + 4, 124, comboWidth, value); form.CapturePanel.Controls.Add(edit.date); } break; case DBHandler.PC_DATETIME: case DBHandler.PC_TIMESTAMP: { setupWork += " Is Date Time Field"; edit.Date(field * 24 + 4, 124, comboWidth * 8 / 14, value); form.CapturePanel.Controls.Add(edit.date); edit.Time(field * 24 + 4, 124 + edit.date.Width + 4, comboWidth * 6 / 14 - 4, value); form.CapturePanel.Controls.Add(edit.time); } break; case DBHandler.PC_TIME: { setupWork += " Is Time Field"; edit.Time(field * 24 + 4, 124, comboWidth, value); form.CapturePanel.Controls.Add(edit.time); } break; case DBHandler.PC_BOOLEAN: { setupWork += " Is Boolean"; edit.Combo(field * 24 + 4, 124, comboWidth, value); form.CapturePanel.Controls.Add(edit.combo); } break; case DBHandler.PC_BYTE: { setupWork += " Is Byte"; edit.Text(field * 24 + 4, 124, editWidth, maxLength(pcField), value); form.CapturePanel.Controls.Add(edit.text); } break; case DBHandler.PC_SHORT: { setupWork += " Is Short"; edit.Text(field * 24 + 4, 124, editWidth, maxLength(pcField), value); form.CapturePanel.Controls.Add(edit.text); } break; case DBHandler.PC_DOUBLE: { edit.Text(field * 24 + 4, 124, editWidth, maxLength(pcField), value); form.CapturePanel.Controls.Add(edit.text); } break; case DBHandler.PC_SEQUENCE: case DBHandler.PC_INT: { edit.Text(field * 24 + 4, 124, editWidth, maxLength(pcField), value); form.CapturePanel.Controls.Add(edit.text); } break; case DBHandler.PC_LONG: { edit.Text(field * 24 + 4, 124, editWidth, maxLength(pcField), value); form.CapturePanel.Controls.Add(edit.text); } break; } if (showSetup.Checked == true) LogDebug = setupWork; } switch (how) { case EHow.ADD: form.Text = "Add Record for " + pcTable.name; form.isAdd = true; form.isChange = false; form.isDelete = false; form.isDisplay = false; break; case EHow.CHANGE: form.Text = "Change Record on " + pcTable.name; form.isAdd = false; form.isChange = true; form.isDelete = false; form.isDisplay = false; break; case EHow.DELETE: form.Text = "Delete Record in " + pcTable.name; form.isAdd = false; form.isChange = false; form.isDelete = true; form.isDisplay = false; break; case EHow.DISPLAY: form.Text = "Display Record of " + pcTable.name; form.isAdd = false; form.isChange = false; form.isDelete = false; form.isDisplay = true; break; } DialogResult rc = form.ShowDialog(); if (rc != DialogResult.OK || how == EHow.DISPLAY) return; List<string> cells = new List<string>(pcTable.noFields); for (field = 0; field < pcTable.noFields; field++) cells.Add(edits[field].Value); connect.BeginTransaction(); try { DBHandler db = new DBHandler(connect); string sysdate = DateTime.Now.ToString("yyyyMMddhhmmss"); switch (how) { case EHow.ADD: newUsId = userName; newTmStamp = sysdate; query = "INSERT INTO " + pcTable.name; query += " VALUES "; c = "( "; for (field = 0; field < pcTable.noFields; field++) { query += c + sqlReady(pcFields[offset + field], cells[field], true, pcTable.name); c = ", "; } query += ", '" + userName + "', Sysdate)"; break; case EHow.CHANGE: newUsId = userName; newTmStamp = sysdate; query = "UPDATE " + pcTable.name; query += " SET "; c = ""; for (field = 0; field < pcTable.noFields; field++) { if (isKey(pcTable, field) == true) continue; query += c + pcFields[offset + field].name + " = " + sqlReady(pcFields[offset + field], cells[field]); c = ", "; } query += ", " + db.UsId + " = '" + userName + "', " + db.TmStamp + " = Sysdate"; query += " " + where; break; case EHow.DELETE: query = "DELETE FROM " + pcTable.name; query += " " + where; break; } using (AutoCursor.DatabaseCall) { try { if (showSQL.Checked == true) LogDebug = query; db.Execute(query); if (BinTables.HasValidation() == true) { if (validateAuditPython(pcTable, how, edits, oldUsId, newUsId, oldTmStamp, newTmStamp) == false) { connect.FlagRollback(); return; } showTableGrid(); } } catch (Exception ex) { connect.FlagRollback(); showException(ex); } } } finally { connect.EndTransaction(); } }
private bool validatePython(TPCRelation relation, EHow how, string fieldNames, string values) { string oldValues = how == EHow.ADD ? "[]" : values; string newValues = how == EHow.DELETE ? "[]" : values; string validate = string.Format("result = validate('{0}', {1}, {2}, {3}, {4})", relation.name, (int)how, fieldNames, oldValues, newValues); if (pcRelation.validate.Length > 0) { if (runValidate(pcRelation.validate, validate) == false) return false; } else { if (runValidate(pcApplication.validateOther, validate) == false) return false; } if (runValidate(pcApplication.validateAll, validate) == false) return false; return true; }
internal bool validateTablePython(EHow how, List<EntryItem> edits) { string oldValues = "["; string newValues = "["; string fieldNames = "["; string comma = ""; foreach (EntryItem plus in edits) { fieldNames += string.Format("{0}'{1}'", comma, plus.label.Text); if (how != EHow.ADD) oldValues += string.Format("{0}'{1}'", comma, plus.oldValue); if (how != EHow.DELETE) newValues += string.Format("{0}'{1}'", comma, plus.Value); comma = ", "; } fieldNames += "]"; oldValues += "]"; newValues += "]"; string validate = string.Format("result = validate('{0}', {1}, {2}, {3}, {4})", pcTable.name, (int)how, fieldNames, oldValues, newValues); if (pcTable.validate.Length > 0) { if (runValidate(pcTable.validate, validate) == false) return false; } else { if (runValidate(pcApplication.validateOther, validate) == false) return false; } return true; }
private bool validateAuditPython(TPCTable table, EHow how, List<EntryItem> edits, string oldUsId, string newUsId, string oldTmStamp, string newTmStamp) { string oldValues = "["; string newValues = "["; string fieldNames = "["; string comma = ""; foreach (EntryItem plus in edits) { fieldNames += string.Format("{0}'{1}'", comma, plus.label.Text); if (how != EHow.ADD) oldValues += string.Format("{0}'{1}'", comma, plus.oldValue); if (how != EHow.DELETE) newValues += string.Format("{0}'{1}'", comma, plus.Value); comma = ", "; } fieldNames += ", 'UsId', 'TmStamp']"; if (how != EHow.ADD) oldValues += string.Format(", '{0}', '{1}'", oldUsId, oldTmStamp); oldValues += "]"; if (how != EHow.DELETE) newValues += string.Format(", '{0}', '{1}'", newUsId, newTmStamp); newValues += "]"; string validate = string.Format("result = validate('{0}', {1}, {2}, {3}, {4})", table.name, (int)how, fieldNames, oldValues, newValues); if (runValidate(pcApplication.validateAll, validate) == false) return false; return true; }