protected void SetUpdateSql(string tableName, SqlItemList setParameters, SqlItemList whereParameters)
{
if (setParameters.Count == 0)
{
throw new ApplicationException("set paramters is empty");
}
if (whereParameters.Count == 0)
{
throw new ApplicationException("where paramters is empty");
}
SetSqlFormat(
@"update {0}
set {1}
", tableName, GetCommaSetFieldParamList(setParameters.Select(x => x.FieldName).ToList()));
SetParameters(setParameters.Select(x => x.FieldValue).ToArray());
foreach (var i in whereParameters)
{
AddSqlWhereField(i.FieldName, i.FieldValue);
}
}
protected void SetInsertIntoSql(string tableName, SqlItemList parameters)
{
SetSqlFormat("insert into {0} ({1}) values ({2})", tableName, GetCommaFieldList(parameters.Select(x => x.FieldName).ToList()), GetCommaListOfChar('?', parameters.Count));
SetParameters(parameters.Select(x => x.FieldValue).ToArray());
}
