public long Update(string ConnectionString, string Condition) { if (this.Fields.Count < 1) { return(-101L); } Condition = Condition.Trim(); string commandText = "update `" + this.TableName + "` set "; MySQL.Parameter[] paras = new MySQL.Parameter[this.Fields.Count]; for (int i = 0; i < this.Fields.Count; i++) { if (i > 0) { commandText = commandText + ", "; } string str2 = commandText; commandText = str2 + "`" + this.Fields[i].Name + "` = ?" + this.Fields[i].CanonicalIdentifierName; paras[i] = new MySQL.Parameter(this.Fields[i].CanonicalIdentifierName, this.Fields[i].DbType, 0, ParameterDirection.Input, this.Fields[i].Value); } if (!string.IsNullOrEmpty(Condition)) { commandText = commandText + " where " + Condition; } commandText = commandText + "; select ifnull(ROW_COUNT(), -99999999)"; object obj2 = MySQL.ExecuteScalar(ConnectionString, commandText, paras); if (obj2 == null) { return(-102L); } this.Fields.Clear(); long num2 = (long)obj2; if (num2 == -99999999L) { return(0L); } return(num2); }
public long Insert(string ConnectionString) { if (this.Fields.Count < 1) { return(-101L); } string str = ""; string str2 = ""; MySQL.Parameter[] paras = new MySQL.Parameter[this.Fields.Count]; for (int i = 0; i < this.Fields.Count; i++) { if (i > 0) { str = str + ", "; str2 = str2 + ", "; } str = str + "`" + this.Fields[i].Name + "`"; str2 = str2 + "?" + this.Fields[i].CanonicalIdentifierName; paras[i] = new MySQL.Parameter(this.Fields[i].CanonicalIdentifierName, this.Fields[i].DbType, 0, ParameterDirection.Input, this.Fields[i].Value); } string commandText = "insert into `" + this.TableName + "` (" + str + ") values (" + str2 + "); select ifnull(LAST_INSERT_ID(), -99999999)"; object obj2 = MySQL.ExecuteScalar(ConnectionString, commandText, paras); if (obj2 == null) { return(-102L); } this.Fields.Clear(); long num2 = (long)obj2; if (num2 == -99999999L) { return(0L); } return(num2); }
public long Insert(string ConnectionString) { if (this.Fields.Count < 1) { return -101L; } string str = ""; string str2 = ""; MySQL.Parameter[] paras = new MySQL.Parameter[this.Fields.Count]; for (int i = 0; i < this.Fields.Count; i++) { if (i > 0) { str = str + ", "; str2 = str2 + ", "; } str = str + "`" + this.Fields[i].Name + "`"; str2 = str2 + "?" + this.Fields[i].CanonicalIdentifierName; paras[i] = new MySQL.Parameter(this.Fields[i].CanonicalIdentifierName, this.Fields[i].DbType, 0, ParameterDirection.Input, this.Fields[i].Value); } string commandText = "insert into `" + this.TableName + "` (" + str + ") values (" + str2 + "); select ifnull(LAST_INSERT_ID(), -99999999)"; object obj2 = MySQL.ExecuteScalar(ConnectionString, commandText, paras); if (obj2 == null) { return -102L; } this.Fields.Clear(); long num2 = (long) obj2; if (num2 == -99999999L) { return 0L; } return num2; }
public long Update(string ConnectionString, string Condition) { if (this.Fields.Count < 1) { return -101L; } Condition = Condition.Trim(); string commandText = "update `" + this.TableName + "` set "; MySQL.Parameter[] paras = new MySQL.Parameter[this.Fields.Count]; for (int i = 0; i < this.Fields.Count; i++) { if (i > 0) { commandText = commandText + ", "; } string str2 = commandText; commandText = str2 + "`" + this.Fields[i].Name + "` = ?" + this.Fields[i].CanonicalIdentifierName; paras[i] = new MySQL.Parameter(this.Fields[i].CanonicalIdentifierName, this.Fields[i].DbType, 0, ParameterDirection.Input, this.Fields[i].Value); } if (!string.IsNullOrEmpty(Condition)) { commandText = commandText + " where " + Condition; } commandText = commandText + "; select ifnull(ROW_COUNT(), -99999999)"; object obj2 = MySQL.ExecuteScalar(ConnectionString, commandText, paras); if (obj2 == null) { return -102L; } this.Fields.Clear(); long num2 = (long) obj2; if (num2 == -99999999L) { return 0L; } return num2; }