public string GenerateSql(IDbProvider provider, string parameterPrefix, BuilderData data)
{
var setSql = "";
foreach (var column in data.Columns)
{
if (setSql.Length > 0)
setSql += ", ";
setSql += string.Format("{0} = {1}{2}",
provider.EscapeColumnName(column.ColumnName),
parameterPrefix,
column.ParameterName);
}
var whereSql = "";
foreach (var column in data.Where)
{
if (whereSql.Length > 0)
whereSql += " and ";
whereSql += string.Format("{0} = {1}{2}",
provider.EscapeColumnName(column.ColumnName),
parameterPrefix,
column.ParameterName);
}
var sql = string.Format("update {0} set {1} where {2}",
data.ObjectName,
setSql,
whereSql);
return sql;
}
public string GenerateSql(IDbProvider provider, string parameterPrefix, BuilderData data)
{
//mod by liuhuisheng start
//var whereSql = "";
var whereSql = data.WhereSql;
//mod by liuhuisheng end
foreach (var column in data.Columns)
{
if (whereSql.Length > 0)
whereSql += " and ";
whereSql += string.Format("{0} = {1}{2}",
provider.EscapeColumnName(column.ColumnName),
parameterPrefix,
column.ParameterName);
}
var sql = string.Format("delete from {0} where {1}", data.ObjectName, whereSql);
return sql;
}
public string GenerateSql(IDbProvider provider, string parameterPrefix, BuilderData data)
{
var insertSql = "";
var valuesSql = "";
foreach (var column in data.Columns)
{
if (insertSql.Length > 0)
{
insertSql += ",";
valuesSql += ",";
}
insertSql += provider.EscapeColumnName(column.ColumnName);
valuesSql += parameterPrefix + column.ParameterName;
}
var sql = string.Format("insert into {0}({1}) values({2})",
data.ObjectName,
insertSql,
valuesSql);
return sql;
}
public BaseDeleteBuilder(IDbCommand command, string name)
{
Data = new BuilderData(command, name);
Actions = new ActionsHandler(Data);
}
public void SetUp()
{
this.dataObject = "MyData";
this.testObject = new BuilderData<string>(this.dataObject);
}
public void SetDataInheritance()
{
var testAnimal = new BuilderData<Mammal>(new Mammal());
testAnimal.SetData(new Chimpanzee());
Assert.Throws<ArgumentException>(() => testAnimal.SetData(new Animal()));
}
public void ConstructWithParametersDataObjectTest()
{
this.testObject = new BuilderData<string>(this.dataObject);
Assert.Throws<ArgumentNullException>(() => new BuilderData<string>(null));
}
public void TearDown()
{
this.testObject = null;
}
