/// <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); }