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);
}
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();
}
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 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));
}
