public void on() { this.connection = SQLjec.getInstance().conn(); this.cmd = this.connection.CreateCommand(); this.connection.Open(); }
public void sql_update(bool ex) { bool flag = !ex; if (flag) { this.connection = SQLjec.getInstance().conn(); this.cmd = this.connection.CreateCommand(); this.connection.Open(); } string text = ""; string text2 = ""; byte b = 0; foreach (string[] current in this.values) { text = string.Concat(new string[] { text, current[0], "='", current[1], "'" }); b += 1; bool flag2 = (int)b < this.values.Count; if (flag2) { text += ","; } } byte b2 = 0; foreach (string[] current2 in this.values2) { text2 = string.Concat(new string[] { text2, current2[0], "='", current2[1], "'" }); b2 += 1; bool flag3 = (int)b2 < this.values2.Count; if (flag3) { text2 += " and "; } } this.cmd.CommandText = string.Concat(new string[] { "update ", this._table, " set ", text, " where ", text2 }); this.cmd.CommandType = CommandType.Text; this.cmd.ExecuteNonQuery(); bool flag4 = !ex; if (flag4) { this.connection.Close(); } else { this.values.Clear(); this.values2.Clear(); } }