void WriteSelectAllMethod()
{
var sql = SelectAllInfoCreator.Create(TableInfo).Sql;
file.AppendLine("public static SqlInfo Select()");
file.OpenBracket();
file.AppendLine("const string sql = @\"");
file.AppendAll(sql);
file.AppendLine();
file.AppendLine("\";");
file.AppendLine();
file.AppendLine("return new SqlInfo { CommandText = sql };");
file.CloseBracket();
}
void WriteSelectAllByValidFlagMethod()
{
var sql = SelectAllInfoCreator.Create(TableInfo).Sql;
file.AppendLine("public static SqlInfo SelectByValidFlag()");
file.OpenBracket();
file.AppendLine("const string sql = @\"");
file.AppendAll(sql + " WHERE [VALID_FLAG] = '1'");
file.AppendLine();
file.AppendLine("\";");
file.AppendLine();
file.AppendLine("return new SqlInfo { CommandText = sql };");
file.CloseBracket();
}
