/// <summary>
/// 创建以insert into开头语的SQL语句
/// </summary>
/// <returns></returns>
public static DBBuilder Insert(string tablename = null, dynamic valueParam = null)
{
var builder = new DBBuilder("INSERT INTO ");
if (tablename != null && valueParam != null)
{
var dp = new DBParameterList(valueParam);
builder.Table(tablename, dp.ParameterNames.ToArray()).Values(dp);
}
else if (tablename != null)
{
builder.Table(tablename);
}
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);
}