/// <summary>
/// 生成 DELETE FROM [TableName] WHERE [condition1]=@condition1 AND [condition2]=@condition2
/// </summary>
/// <param name="model">载有生成信息的Model</param>
/// <param name="conditions">需要匹配的成员集合</param>
/// <returns>删除字符串结果</returns>
public string DeleteWithCondition(SqlModel model, params string[] conditions)
{
StringBuilder sql = new StringBuilder(Delete(model));
ConditionTemplate template = new ConditionTemplate();
sql.Append(template.Condition(model, conditions));
return(sql.ToString());
}
/// <summary>
/// 根据model信息生成 SELECT [member1],[member2]... FROM [TableName] WHERE [condition1]=@condition,[condition2]=@condition2.....
/// </summary>
/// <param name="model">载有生成信息的Model</param>
/// <param name="condition_models">需要匹配的成员集合</param>
/// <returns>查询字符串结果</returns>
public string SelectWithCondition(SqlModel model, params string[] conditions)
{
var select = Select(model);
StringBuilder sql = new StringBuilder(select);
ConditionTemplate template = new ConditionTemplate();
sql.Append(template.Condition(model, conditions));
return(sql.ToString());
}
