· 7 years ago · Feb 13, 2019, 05:30 PM
1package com.devilapp.ring;
2
3import anywheresoftware.b4a.BA;
4import anywheresoftware.b4a.BA.IterableList;
5import anywheresoftware.b4a.ConnectorUtils;
6import anywheresoftware.b4a.keywords.Common;
7import anywheresoftware.b4a.keywords.StringBuilderWrapper;
8import anywheresoftware.b4a.objects.ListViewWrapper;
9import anywheresoftware.b4a.objects.RuntimePermissions;
10import anywheresoftware.b4a.objects.SpinnerWrapper;
11import anywheresoftware.b4a.objects.collections.List;
12import anywheresoftware.b4a.objects.collections.Map;
13import anywheresoftware.b4a.objects.collections.Map.MyMap;
14import anywheresoftware.b4a.objects.streams.File;
15import anywheresoftware.b4a.samples.httputils2.httputils2service;
16import anywheresoftware.b4a.sql.SQL;
17import anywheresoftware.b4a.sql.SQL.ResultSetWrapper;
18import com.google.android.gms.dynamite.ProviderConstants;
19import java.util.Arrays;
20
21public class dbutils {
22 public static String _db_blob = "";
23 public static String _db_integer = "";
24 public static String _db_real = "";
25 public static String _db_text = "";
26 public static String _vvvvvvv6 = "";
27 private static dbutils mostCurrent = new dbutils();
28 public Common __c = null;
29 public act_configura _act_configura = null;
30 public act_messaggi_da_numero _act_messaggi_da_numero = null;
31 public svr_allinea _svr_allinea = null;
32 public starter _vvvvv0 = null;
33 public httputils2service _vvvvvv5 = null;
34 public main _vvvvvvv2 = null;
35
36 public static Object getObject() {
37 throw new RuntimeException("Code module does not support this method.");
38 }
39
40 public static String _vv0(BA ba, String str) throws Exception {
41 String str2 = "";
42 str2 = _vvvv4(ba);
43 File file = Common.File;
44 if (!File.Exists(str2, str)) {
45 file = Common.File;
46 file = Common.File;
47 File.Copy(File.getDirAssets(), str, str2, str);
48 }
49 return str2;
50 }
51
52 public static String _vvv1(BA ba, SQL sql, String str, Map map, String str2) throws Exception {
53 String str3 = "";
54 str3 = "";
55 str3 = "";
56 StringBuilderWrapper stringBuilderWrapper = new StringBuilderWrapper();
57 stringBuilderWrapper.Initialize();
58 stringBuilderWrapper.Append("(");
59 int size = map.getSize() - 1;
60 for (int i = 0; i <= size; i++) {
61 String str4 = "";
62 str4 = "";
63 str4 = BA.ObjectToString(map.GetKeyAt(i));
64 String ObjectToString = BA.ObjectToString(map.GetValueAt(i));
65 if (i > 0) {
66 stringBuilderWrapper.Append(", ");
67 }
68 stringBuilderWrapper.Append(_vvvvvvv5(ba, str4)).Append(" ").Append(ObjectToString);
69 if (str4.equals(str2)) {
70 stringBuilderWrapper.Append(" PRIMARY KEY");
71 }
72 }
73 stringBuilderWrapper.Append(")");
74 str3 = "CREATE TABLE IF NOT EXISTS " + _vvvvvvv5(ba, str) + " " + stringBuilderWrapper.ToString();
75 Common.Log("CreateTable: " + str3);
76 sql.ExecNonQuery(str3);
77 return "";
78 }
79
80 public static String _vvv2(BA ba, SQL sql, String str, Map map) throws Exception {
81 String str2 = "";
82 StringBuilderWrapper stringBuilderWrapper = new StringBuilderWrapper();
83 stringBuilderWrapper.Initialize();
84 stringBuilderWrapper.Append("DELETE FROM " + _vvvvvvv5(ba, str) + " WHERE ");
85 if (map.getSize() == 0) {
86 Common.Log("WhereFieldEquals map empty!");
87 return "";
88 }
89 List list = new List();
90 list.Initialize();
91 IterableList Keys = map.Keys();
92 int size = Keys.getSize();
93 for (int i = 0; i < size; i++) {
94 String ObjectToString = BA.ObjectToString(Keys.Get(i));
95 if (list.getSize() > 0) {
96 stringBuilderWrapper.Append(" AND ");
97 }
98 stringBuilderWrapper.Append(_vvvvvvv5(ba, ObjectToString)).Append(" = ?");
99 list.Add(map.Get(ObjectToString));
100 }
101 Common.Log("DeleteRecord: " + stringBuilderWrapper.ToString());
102 sql.ExecNonQuery2(stringBuilderWrapper.ToString(), list);
103 return "";
104 }
105
106 public static String _vvv3(BA ba, SQL sql, String str) throws Exception {
107 String str2 = "";
108 str2 = "DROP TABLE IF EXISTS" + _vvvvvvv5(ba, str);
109 Common.Log("DropTable: " + str2);
110 sql.ExecNonQuery(str2);
111 return "";
112 }
113
114 public static String _vvvvvvv5(BA ba, String str) throws Exception {
115 return "[" + str + "]";
116 }
117
118 public static String _vvv4(BA ba, SQL sql, String str, String[] strArr, int i, boolean z) throws Exception {
119 int i2;
120 ResultSetWrapper resultSetWrapper = new ResultSetWrapper();
121 if (strArr != null) {
122 resultSetWrapper.setObject(sql.ExecQuery2(str, strArr));
123 } else {
124 resultSetWrapper.setObject(sql.ExecQuery(str));
125 }
126 Common.Log("ExecuteHtml: " + str);
127 StringBuilderWrapper stringBuilderWrapper = new StringBuilderWrapper();
128 stringBuilderWrapper.Initialize();
129 stringBuilderWrapper.Append("<html><body>").Append(Common.CRLF);
130 stringBuilderWrapper.Append("<style type='text/css'>").Append(_vvvvvvv6).Append("</style>").Append(Common.CRLF);
131 stringBuilderWrapper.Append("<table><thead><tr>").Append(Common.CRLF);
132 int columnCount = resultSetWrapper.getColumnCount() - 1;
133 for (i2 = 0; i2 <= columnCount; i2++) {
134 stringBuilderWrapper.Append("<th>").Append(resultSetWrapper.GetColumnName(i2)).Append("</th>");
135 }
136 stringBuilderWrapper.Append("</thead>");
137 stringBuilderWrapper.Append("</tr>").Append(Common.CRLF);
138 i2 = 0;
139 while (resultSetWrapper.NextRow()) {
140 if (i2 % 2 == 0) {
141 stringBuilderWrapper.Append("<tr>");
142 } else {
143 stringBuilderWrapper.Append("<tr class='odd'>");
144 }
145 int columnCount2 = resultSetWrapper.getColumnCount() - 1;
146 for (columnCount = 0; columnCount <= columnCount2; columnCount++) {
147 stringBuilderWrapper.Append("<td>");
148 if (z) {
149 stringBuilderWrapper.Append("<a href='http://").Append(BA.NumberToString(columnCount)).Append(".");
150 stringBuilderWrapper.Append(BA.NumberToString(i2));
151 stringBuilderWrapper.Append(".stub'>").Append(resultSetWrapper.GetString2(columnCount)).Append("</a>");
152 } else {
153 stringBuilderWrapper.Append(resultSetWrapper.GetString2(columnCount));
154 }
155 stringBuilderWrapper.Append("</td>");
156 }
157 stringBuilderWrapper.Append("</tr>").Append(Common.CRLF);
158 i2++;
159 }
160 resultSetWrapper.Close();
161 stringBuilderWrapper.Append("</table></body></html>");
162 return stringBuilderWrapper.ToString();
163 }
164
165 public static Map _vvv5(BA ba, SQL sql, String str, String[] strArr, int i, List list) throws Exception {
166 Map map;
167 List list2 = new List();
168 ResultSetWrapper resultSetWrapper = new ResultSetWrapper();
169 if (strArr != null) {
170 resultSetWrapper.setObject(sql.ExecQuery2(str, strArr));
171 } else {
172 resultSetWrapper.setObject(sql.ExecQuery(str));
173 }
174 Common.Log("ExecuteJSON: " + str);
175 List list3 = new List();
176 list3.Initialize();
177 while (resultSetWrapper.NextRow()) {
178 Map map2 = new Map();
179 map2.Initialize();
180 int columnCount = resultSetWrapper.getColumnCount() - 1;
181 for (int i2 = 0; i2 <= columnCount; i2++) {
182 switch (BA.switchObjectToInt(list.Get(i2), _db_text, _db_integer, _db_real)) {
183 case 0:
184 map2.Put(resultSetWrapper.GetColumnName(i2), resultSetWrapper.GetString2(i2));
185 break;
186 case 1:
187 map2.Put(resultSetWrapper.GetColumnName(i2), resultSetWrapper.GetLong2(i2));
188 break;
189 case 2:
190 map2.Put(resultSetWrapper.GetColumnName(i2), resultSetWrapper.GetDouble2(i2));
191 break;
192 default:
193 Common.Log("Invalid type: " + BA.ObjectToString(list.Get(i2)));
194 break;
195 }
196 }
197 list3.Add(map2.getObject());
198 if (i > 0 && list3.getSize() >= i) {
199 resultSetWrapper.Close();
200 map = new Map();
201 map.Initialize();
202 map.Put("root", list3.getObject());
203 return map;
204 }
205 }
206 resultSetWrapper.Close();
207 map = new Map();
208 map.Initialize();
209 map.Put("root", list3.getObject());
210 return map;
211 }
212
213 public static List _vvv6(BA ba, SQL sql, String str, String[] strArr, int i) throws Exception {
214 List list = new List();
215 IterableList _vvvv2 = _vvvv2(ba, sql, str, strArr, i);
216 List list2 = new List();
217 list2.Initialize();
218 int size = _vvvv2.getSize();
219 for (int i2 = 0; i2 < size; i2++) {
220 list2.Add(((String[]) _vvvv2.Get(i2))[0]);
221 }
222 return list2;
223 }
224
225 public static String _vvv7(BA ba, SQL sql, String str, String[] strArr, int i, List list) throws Exception {
226 list.Clear();
227 list.AddAll(_vvv6(ba, sql, str, strArr, i));
228 return "";
229 }
230
231 public static String _vvv0(BA ba, SQL sql, String str, String[] strArr, int i, ListViewWrapper listViewWrapper, boolean z) throws Exception {
232 listViewWrapper.Clear();
233 List list = new List();
234 List _vvvv2 = _vvvv2(ba, sql, str, strArr, i);
235 Arrays.fill(new String[0], "");
236 int size = _vvvv2.getSize() - 1;
237 for (int i2 = 0; i2 <= size; i2++) {
238 String[] strArr2 = (String[]) _vvvv2.Get(i2);
239 if (z) {
240 listViewWrapper.AddTwoLines2(BA.ObjectToCharSequence(strArr2[0]), BA.ObjectToCharSequence(strArr2[1]), strArr2);
241 } else {
242 listViewWrapper.AddSingleLine2(BA.ObjectToCharSequence(strArr2[0]), strArr2);
243 }
244 }
245 return "";
246 }
247
248 public static Map _vvvv1(BA ba, SQL sql, String str, String[] strArr) throws Exception {
249 Map map = new Map();
250 ResultSetWrapper resultSetWrapper = new ResultSetWrapper();
251 if (strArr != null) {
252 resultSetWrapper.setObject(sql.ExecQuery2(str, strArr));
253 } else {
254 resultSetWrapper.setObject(sql.ExecQuery(str));
255 }
256 Common.Log("ExecuteMap: " + str);
257 if (resultSetWrapper.NextRow()) {
258 map.Initialize();
259 int columnCount = resultSetWrapper.getColumnCount() - 1;
260 for (int i = 0; i <= columnCount; i++) {
261 map.Put(resultSetWrapper.GetColumnName(i).toLowerCase(), resultSetWrapper.GetString2(i));
262 }
263 resultSetWrapper.Close();
264 } else {
265 Common.Log("No records found.");
266 }
267 return map;
268 }
269
270 public static List _vvvv2(BA ba, SQL sql, String str, String[] strArr, int i) throws Exception {
271 ResultSetWrapper resultSetWrapper = new ResultSetWrapper();
272 if (strArr == null) {
273 strArr = new String[0];
274 Arrays.fill(strArr, "");
275 }
276 resultSetWrapper.setObject(sql.ExecQuery2(str, strArr));
277 Common.Log("ExecuteMemoryTable: " + str);
278 List list = new List();
279 list.Initialize();
280 while (resultSetWrapper.NextRow()) {
281 Object obj = new String[resultSetWrapper.getColumnCount()];
282 Arrays.fill(obj, "");
283 int columnCount = resultSetWrapper.getColumnCount() - 1;
284 for (int i2 = 0; i2 <= columnCount; i2++) {
285 obj[i2] = resultSetWrapper.GetString2(i2);
286 }
287 list.Add(obj);
288 if (i > 0 && list.getSize() >= i) {
289 break;
290 }
291 }
292 resultSetWrapper.Close();
293 return list;
294 }
295
296 public static String _vvvv3(BA ba, SQL sql, String str, String[] strArr, int i, SpinnerWrapper spinnerWrapper) throws Exception {
297 spinnerWrapper.Clear();
298 List list = new List();
299 List _vvvv2 = _vvvv2(ba, sql, str, strArr, i);
300 Arrays.fill(new String[0], "");
301 int size = _vvvv2.getSize() - 1;
302 for (int i2 = 0; i2 <= size; i2++) {
303 spinnerWrapper.Add(((String[]) _vvvv2.Get(i2))[0]);
304 }
305 return "";
306 }
307
308 public static String _vvvv4(BA ba) throws Exception {
309 RuntimePermissions runtimePermissions = new RuntimePermissions();
310 File file = Common.File;
311 if (File.getExternalWritable()) {
312 return runtimePermissions.GetSafeDirDefaultExternal("");
313 }
314 File file2 = Common.File;
315 return File.getDirInternal();
316 }
317
318 public static int _vvvv5(BA ba, SQL sql) throws Exception {
319 if (((int) Double.parseDouble(sql.ExecQuerySingleResult("SELECT count(*) FROM sqlite_master WHERE Type='table' AND name='DBVersion'"))) > 0) {
320 return (int) Double.parseDouble(sql.ExecQuerySingleResult("SELECT version FROM DBVersion"));
321 }
322 Map map = new Map();
323 String str = "DBVersion";
324 _vvv1(ba, sql, str, Common.createMap(new Object[]{ProviderConstants.API_COLNAME_FEATURE_VERSION, _db_integer}), ProviderConstants.API_COLNAME_FEATURE_VERSION);
325 sql.ExecNonQuery("INSERT INTO DBVersion VALUES (1)");
326 return 1;
327 }
328
329 public static String _vvvv6(BA ba, SQL sql, String str, List list) throws Exception {
330 String str2 = "";
331 StringBuilderWrapper stringBuilderWrapper = new StringBuilderWrapper();
332 StringBuilderWrapper stringBuilderWrapper2 = new StringBuilderWrapper();
333 StringBuilderWrapper stringBuilderWrapper3 = new StringBuilderWrapper();
334 if (list.getSize() <= 1 || !list.Get(0).equals(list.Get(1))) {
335 sql.BeginTransaction();
336 try {
337 int size = list.getSize() - 1;
338 for (int i = 0; i <= size; i++) {
339 stringBuilderWrapper.Initialize();
340 stringBuilderWrapper2.Initialize();
341 stringBuilderWrapper3.Initialize();
342 List list2 = new List();
343 list2.Initialize();
344 stringBuilderWrapper.Append("INSERT INTO [" + str + "] (");
345 Map map = new Map();
346 map.setObject((MyMap) list.Get(i));
347 IterableList Keys = map.Keys();
348 int size2 = Keys.getSize();
349 for (int i2 = 0; i2 < size2; i2++) {
350 String ObjectToString = BA.ObjectToString(Keys.Get(i2));
351 Object Get = map.Get(ObjectToString);
352 if (list2.getSize() > 0) {
353 stringBuilderWrapper2.Append(", ");
354 stringBuilderWrapper3.Append(", ");
355 }
356 stringBuilderWrapper2.Append(_vvvvvvv5(ba, ObjectToString));
357 stringBuilderWrapper3.Append("?");
358 list2.Add(Get);
359 }
360 stringBuilderWrapper.Append(stringBuilderWrapper2.ToString()).Append(") VALUES (").Append(stringBuilderWrapper3.ToString()).Append(")");
361 if (i == 0) {
362 Common.Log("InsertMaps (first query out of " + BA.NumberToString(list.getSize()) + "): " + stringBuilderWrapper.ToString());
363 }
364 sql.ExecNonQuery2(stringBuilderWrapper.ToString(), list2);
365 }
366 sql.TransactionSuccessful();
367 } catch (Exception e) {
368 (ba.processBA == null ? ba : ba.processBA).setLastException(e);
369 Common.Log(BA.ObjectToString(Common.LastException(ba)));
370 }
371 sql.EndTransaction();
372 return "";
373 }
374 Common.Log("Same Map found twice in list. Each item in the list should include a different map object.");
375 return "";
376 }
377
378 public static String _process_globals() throws Exception {
379 _db_real = "";
380 _db_integer = "";
381 _db_blob = "";
382 _db_text = "";
383 _db_real = BA.__b(new byte[]{(byte) 5, (byte) 3, (byte) 83, (byte) -74}, 580713);
384 _db_integer = BA.__b(new byte[]{(byte) 30, ConnectorUtils.RECT32, (byte) 1, (byte) -125, (byte) 23, (byte) 10, (byte) 28}, 937295);
385 _db_blob = BA.__b(new byte[]{(byte) 21, (byte) 10, (byte) 103, ConnectorUtils.NULL}, 655002);
386 _db_text = BA.__b(new byte[]{(byte) 3, (byte) 3, (byte) 35, (byte) -33}, 510262);
387 _vvvvvvv6 = BA.__b(new byte[]{(byte) 93}, 309483) + BA.__b(new byte[]{(byte) 94, (byte) 78, ConnectorUtils.RECT32, (byte) 74, (byte) 50, (byte) 33, (byte) 1, (byte) 76, (byte) 35, (byte) 62, ConnectorUtils.RECT32, (byte) 17, (byte) 110, (byte) 50, (byte) 65, (byte) 75, (byte) 98, (byte) 123, (byte) 77, (byte) 77, (byte) 33, (byte) 46, (byte) 24, (byte) 1, (byte) 57, (byte) 33, (byte) 1, (byte) 79, (byte) 100, (byte) 55, (byte) 16, (byte) 20, (byte) 122, (byte) 60, (byte) 30, (byte) 6, (byte) 48, (byte) 98, (byte) 86, (byte) 67, (byte) 33, (byte) 36, (byte) 24, (byte) 95, (byte) 48, (byte) 61, (byte) 68, (byte) 3, (byte) 112, (byte) 39, (byte) 25, (byte) 15, (byte) 60, (byte) 43, (byte) 6, (byte) 65, (byte) 61, (byte) 59, (byte) 29, (byte) 29, (byte) 110, (byte) 120, (byte) 31, (byte) 33}, 58003) + BA.__b(new byte[]{(byte) 94, (byte) 79, (byte) -14, (byte) 65, (byte) 112, (byte) 55, (byte) -67, (byte) 8, (byte) 55, (byte) 38, (byte) -17, (byte) 90, (byte) 109, (byte) 62, (byte) -21, (byte) 14, (byte) 59, (byte) 62, (byte) -66, (byte) 74, (byte) 120, (byte) 34, (byte) -30, (byte) 21, (byte) 102, (byte) 76, (byte) -24, (byte) 22, (byte) 39, (byte) 108, (byte) -2, (byte) 28, (byte) 53, (byte) 59, (byte) -26, ConnectorUtils.NULL, (byte) 116, (byte) 100, (byte) -32, (byte) 14, (byte) 45, (byte) 50, (byte) -67, (byte) 70, (byte) 103, (byte) 56, (byte) -90, (byte) 19, (byte) 102, (byte) 78, (byte) -18, ConnectorUtils.RECT32, (byte) 41, (byte) 32, (byte) -96, (byte) 17, (byte) 124, (byte) 61, (byte) -19, (byte) 31, (byte) 33, (byte) 54, (byte) -10, (byte) 19, (byte) 102, (byte) 113, (byte) -11, (byte) 24, (byte) 119, (byte) 53, (byte) -23, (byte) 69, (byte) 57, (byte) 40, (byte) -67, (byte) 77, (byte) 59, (byte) 45, (byte) -3, (byte) 76, (byte) 58, (byte) 38, (byte) -120}, 844704) + BA.__b(new byte[]{(byte) 94, (byte) 79, (byte) 39, (byte) -21, (byte) 124, (byte) 56, (byte) 32, (byte) -24, (byte) 35, (byte) 65, (byte) 62, (byte) -80, (byte) 126, (byte) 63, (byte) 62, (byte) -95, (byte) 52, (byte) 112, (byte) 113, (byte) -8, (byte) 106, (byte) 53, (byte) 123, (byte) -30, (byte) 45, (byte) 61, (byte) 100, (byte) -15, (byte) 57, (byte) 13}, 467283) + BA.__b(new byte[]{(byte) 94, (byte) 78, (byte) -47, (byte) -28, (byte) 52, (byte) 41, (byte) -60, (byte) -73, (byte) 58, (byte) 40, (byte) -127, (byte) -66, (byte) 125, (byte) 40, (byte) -108, (byte) -66, (byte) 61, (byte) 47, (byte) -48, (byte) -85, (byte) 117, (byte) 32, (byte) -104, (byte) -95, (byte) 103, (byte) 100, (byte) -48, (byte) -79, (byte) 33, (byte) 96, (byte) -37, (byte) -20, (byte) 39, (byte) 111, (byte) -5}, 288050) + BA.__b(new byte[]{(byte) 94, (byte) 79, (byte) 78, (byte) -106, (byte) 52, (byte) 40, (byte) 91, (byte) -54, (byte) 60, (byte) 104, (byte) 6, (byte) -59, (byte) 117, (byte) 41, (byte) 0, (byte) -36, (byte) 33, (byte) 103, (byte) 0, (byte) -43, (byte) 110, (byte) 57, (byte) 7, (byte) -52, (byte) 103, (byte) 101, (byte) 93, (byte) -41, (byte) 60, (byte) 39, ConnectorUtils.NULL, (byte) -47, (byte) 54, (byte) 39, (byte) 10, (byte) -104, (byte) 122, (byte) 100, ConnectorUtils.NULL, (byte) -44, (byte) 121, (byte) 96, (byte) 28, (byte) -68}, 555636) + BA.__b(new byte[]{(byte) 94, (byte) 79, (byte) -115, (byte) 15, (byte) 43, (byte) 108, (byte) -125, (byte) 13, (byte) 32, (byte) 60, (byte) -36, (byte) 21, Byte.MAX_VALUE, (byte) 56, (byte) -121, (byte) 29, (byte) 50, (byte) 62, (byte) -121, (byte) 3, (byte) 116, (byte) 119, (byte) -118, (byte) 24, (byte) 51, (byte) 32, (byte) -37, (byte) 81, (byte) 39, (byte) 104, (byte) -97, (byte) 7, (byte) 40, (byte) 116, (byte) -62, (byte) 77, (byte) 105, (byte) 55, (byte) -43, (byte) 95, (byte) 63}, 776627);
388 return "";
389 }
390
391 public static String _vvvv7(BA ba, SQL sql, int i) throws Exception {
392 sql.ExecNonQuery2("UPDATE DBVersion set version = ?", Common.ArrayToList(new Object[]{Integer.valueOf(i)}));
393 return "";
394 }
395
396 public static String _vvvv0(BA ba, SQL sql, String str, String str2, Object obj, Map map) throws Exception {
397 _vvvvv1(ba, sql, str, Common.createMap(new Object[]{str2, obj}), map);
398 return "";
399 }
400
401 public static String _vvvvv1(BA ba, SQL sql, String str, Map map, Map map2) throws Exception {
402 int i = 0;
403 String str2 = "";
404 if (map2.getSize() == 0) {
405 Common.Log("WhereFieldEquals map empty!");
406 return "";
407 } else if (map.getSize() == 0) {
408 Common.Log("Fields empty");
409 return "";
410 } else {
411 StringBuilderWrapper stringBuilderWrapper = new StringBuilderWrapper();
412 stringBuilderWrapper.Initialize();
413 stringBuilderWrapper.Append("UPDATE ").Append(_vvvvvvv5(ba, str)).Append(" SET ");
414 List list = new List();
415 list.Initialize();
416 IterableList Keys = map.Keys();
417 int size = Keys.getSize();
418 for (int i2 = 0; i2 < size; i2++) {
419 String ObjectToString = BA.ObjectToString(Keys.Get(i2));
420 stringBuilderWrapper.Append(_vvvvvvv5(ba, ObjectToString)).Append("=?");
421 stringBuilderWrapper.Append(",");
422 list.Add(map.Get(ObjectToString));
423 }
424 stringBuilderWrapper.Remove(stringBuilderWrapper.getLength() - 1, stringBuilderWrapper.getLength());
425 stringBuilderWrapper.Append(" WHERE ");
426 IterableList Keys2 = map2.Keys();
427 int size2 = Keys2.getSize();
428 while (i < size2) {
429 String ObjectToString2 = BA.ObjectToString(Keys2.Get(i));
430 stringBuilderWrapper.Append(_vvvvvvv5(ba, ObjectToString2)).Append(" = ?");
431 stringBuilderWrapper.Append(" AND ");
432 list.Add(map2.Get(ObjectToString2));
433 i++;
434 }
435 stringBuilderWrapper.Remove(stringBuilderWrapper.getLength() - " AND ".length(), stringBuilderWrapper.getLength());
436 Common.Log("UpdateRecord: " + stringBuilderWrapper.ToString());
437 sql.ExecNonQuery2(stringBuilderWrapper.ToString(), list);
438 return "";
439 }
440 }
441}