public virtual void getFormDataTo(cape.DynamicMap data) { if (!(data != null)) { return; } if (preservedFormData != null) { var keys = preservedFormData.getKeys(); if (keys != null) { var n = 0; var m = keys.Count; for (n = 0; n < m; n++) { var key = keys[n]; if (key != null) { data.set(key, preservedFormData.get(key)); } } } } System.Collections.Generic.List <string> keys1 = cape.Map.getKeys(fieldsById); if (keys1 != null) { var n2 = 0; var m2 = keys1.Count; for (n2 = 0; n2 < m2; n2++) { var key1 = keys1[n2]; if (key1 != null) { var widget = cape.Map.get(fieldsById, key1) as cave.ui.WidgetWithValue; if (!(widget != null)) { continue; } data.set(key1, widget.getWidgetValue()); } } } }
public virtual capex.data.SQLStatement prepareInsertStatement(string table, cape.DynamicMap data) { if (cape.String.isEmpty(table) || data == null || data.getCount() < 1) { return(null); } var sb = new cape.StringBuilder(); sb.append("INSERT INTO "); sb.append(table); sb.append(" ( "); var first = true; var keys = data.getKeys(); if (keys != null) { var n = 0; var m = keys.Count; for (n = 0; n < m; n++) { var key = keys[n]; if (key != null) { if (first == false) { sb.append(','); } sb.append(key as string); first = false; } } } sb.append(" ) VALUES ( "); first = true; if (keys != null) { var n2 = 0; var m2 = keys.Count; for (n2 = 0; n2 < m2; n2++) { var key1 = keys[n2]; if (key1 != null) { if (first == false) { sb.append(','); } sb.append('?'); first = false; } } } sb.append(" );"); var stmt = prepare(sb.toString()); if (stmt == null) { return(null); } if (keys != null) { var n3 = 0; var m3 = keys.Count; for (n3 = 0; n3 < m3; n3++) { var key2 = keys[n3]; if (key2 != null) { var o = data.get(key2); if (o is string || o is cape.StringObject) { stmt.addParamString(cape.String.asString(o)); } else if (o is cape.IntegerObject) { stmt.addParamInteger(cape.Integer.asInteger(o)); } else if (o is cape.LongIntegerObject) { stmt.addParamLongInteger(cape.LongInteger.asLong(o)); } else if (o is cape.DoubleObject) { stmt.addParamDouble(cape.Double.asDouble(o)); } else if (o is cape.BufferObject) { stmt.addParamBlob(((cape.BufferObject)o).toBuffer()); } else if (o is byte[]) { stmt.addParamBlob(o as byte[]); } else { var s = o as string; if (object.Equals(s, null)) { s = ""; } stmt.addParamString(s); } } } } return(stmt); }