protected void UpdateCommand(DatabaseParameters keys, DatabaseParameters values, string table) { int num; StringBuilder builder = new StringBuilder("UPDATE " + table + " SET "); if (values != null) { for (num = 0; num < values.Count; num++) { builder.Append(values[num].FieldName + " = " + (((values[num].ParamType == DBDataType.Formula) || (values[num].ParamType == DBDataType.SQLFormula)) ? values[num].FieldValue : ((values[num].FieldValue.Length > 0) ? ((values[num].IsUnicode ? "N" : "") + "'" + values[num].FieldValue + "'") : (values[num].IsNullable ? "NULL" : "''"))) + ","); } } builder.Remove(builder.Length - 1, 1); if (keys != null) { for (num = 0; num < keys.Count; num++) { builder.Append((num == 0) ? " WHERE " : (" " + keys[num].ParamLinkage.ToString() + " ")); builder.Append(((keys[num].ParamType == DBDataType.Formula) || (keys[num].ParamType == DBDataType.SQLFormula)) ? (keys[num].FieldName + " = " + keys[num].FieldValue) : (keys[num].FieldName + " = '" + keys[num].FieldValue + "'")); } } sql = builder.ToString(); }
private static void SelectCommand(DatabaseParameters Parameters, string TableNames) { DatabaseParametersGroup parametersGroup = new DatabaseParametersGroup(); parametersGroup.Add(Parameters); string[] tableNames = new string[] { TableNames }; SelectCommand(parametersGroup, tableNames); }
public static void InsertCommand(DatabaseParameters keys, string table) { StringBuilder builder = new StringBuilder(); StringBuilder builder2 = new StringBuilder(); for (int i = 0; i < keys.Count; i++) { builder.Append(keys[i].FieldName + ","); builder2.Append((((keys[i].ParamType == DBDataType.Formula) || (keys[i].ParamType == DBDataType.SQLFormula)) ? keys[i].FieldValue : (((keys[i].FieldValue.Length > 0)) ? ("'" + keys[i].FieldValue + "'") : "NULL")) + ","); } builder.Remove(builder.Length - 1, 1); builder2.Remove(builder2.Length - 1, 1); sql = "INSERT INTO " + table + " ( " + builder.ToString() + " ) VALUES (" + builder2.ToString() + ")"; }
public static void DeleteCommand(DatabaseParameters keys, string table) { StringBuilder builder = new StringBuilder("DELETE FROM " + table + " "); if (keys != null) { for (int i = 0; i < keys.Count; i++) { builder.Append((i == 0) ? " WHERE " : (" " + keys[i].ParamLinkage.ToString() + " ")); builder.Append(((keys[i].ParamType == DBDataType.Formula) || (keys[i].ParamType == DBDataType.SQLFormula)) ? (keys[i].FieldName + keys[i].ParamCompare + keys[i].FieldValue) : (keys[i].FieldName + keys[i].ParamCompare + "'" + keys[i].FieldValue + "'")); } } sql = builder.ToString(); }
public void Remove(DatabaseParameters value) { base.List.Remove(value); }
public void Insert(int index, DatabaseParameters value) { base.List.Insert(index, value); }
public int IndexOf(DatabaseParameters value) { return base.List.IndexOf(value); }
public int Add(DatabaseParameters value) { return base.List.Add(value); }
public int IndexOf(DatabaseParameters value) { return(base.List.IndexOf(value)); }
public int Add(DatabaseParameters value) { return(base.List.Add(value)); }