/// <summary>
/// 创建以delete from开头语的SQL语句
/// </summary>
/// <param name="tablename"></param>
/// <param name="whereParam"></param>
/// <returns></returns>
public static DBBuilder Delete(string tablename = null, dynamic whereParam = null)
{
var builder = new DBBuilder("DELETE ");
if (tablename != null)
{
builder.From(tablename);
}
if (whereParam != null)
{
builder.Where(whereParam);
}
return(builder);
}
/// <summary>
/// 创建以select FieldName1,FieldName2 from TableName开头的SQL语句
/// </summary>
/// <param name="tablename">要查询的表名</param>
/// <param name="whereParam">要查询的字段名</param>
/// <returns></returns>
public static DBBuilder Select(string tablename = null, object whereParam = null)
{
var builder = new DBBuilder("SELECT ");
if (tablename != null)
{
builder.Append("*").From(tablename);
}
if (whereParam != null)
{
builder.Where(whereParam);
}
return(builder);
}
/// <summary>
/// 创建以update开头语的SQL语句
/// </summary>
/// <param name="tablename"></param>
/// <param name="setParam"></param>
/// <param name="whereParam"></param>
/// <returns></returns>
public static DBBuilder Update(string tablename = null, dynamic setParam = null, dynamic whereParam = null)
{
var builder = new DBBuilder("UPDATE ");
if (tablename != null)
{
builder.Table(tablename);
}
if (setParam != null)
{
builder.Set(setParam);
}
if (whereParam != null)
{
builder.Where(whereParam);
}
return(builder);
}