/// <summary>
/// 删除语句
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="t">删除条件实体</param>
/// <returns></returns>
public static bool DELETE <T>(T t)
{
string StrSql = string.Empty;
string WHERE = string.Empty;
string FAILEDS = string.Empty;
Dictionary <string, object> dic = DictionaryName <T>(t);
string PK = GetPrimaryKey(t.GetType().Name);
StrSql = SQL_DELETE.Replace("[{TABLE_NAME}]", t.GetType().Name);
foreach (var item in dic)
{
WHERE += " and " + item.Key + " ='" + item.Value + "' ";
}
StrSql = StrSql.Replace("{VALUES}", WHERE);
return(ExecuteNonQuery(StrSql) > 0 ? true : false);
}
private static void WriteDeletions(Stream stream, TableDescription[] tableDescriptions)
{
var deletions = tableDescriptions.Reverse().Select(tableDescription => SQL_DELETE.FormatInvariant(tableDescription.TableName()));
stream.WriteLines(deletions);
}
