private SqlStatement CopyToStatement(SqlWhereCollection where, Sqls.TableTypes tableType)
{
var column = new Rds.ExportSettingsColumnCollection();
var param = new Rds.ExportSettingsParamCollection();
column.ReferenceType(function: Sqls.Functions.SingleColumn); param.ReferenceType();
column.ReferenceId(function: Sqls.Functions.SingleColumn); param.ReferenceId();
column.Title(function: Sqls.Functions.SingleColumn); param.Title();
column.ExportSettingId(function: Sqls.Functions.SingleColumn); param.ExportSettingId();
column.Ver(function: Sqls.Functions.SingleColumn); param.Ver();
column.AddHeader(function: Sqls.Functions.SingleColumn); param.AddHeader();
column.ExportColumns(function: Sqls.Functions.SingleColumn); param.ExportColumns();
column.Creator(function: Sqls.Functions.SingleColumn); param.Creator();
column.Updator(function: Sqls.Functions.SingleColumn); param.Updator();
column.CreatedTime(function: Sqls.Functions.SingleColumn); param.CreatedTime();
column.UpdatedTime(function: Sqls.Functions.SingleColumn); param.UpdatedTime();
if (!Comments.InitialValue())
{
column.Comments(function: Sqls.Functions.SingleColumn);
param.Comments();
}
return(Rds.InsertExportSettings(
tableType: tableType,
param: param,
select: Rds.SelectExportSettings(column: column, where : where),
addUpdatorParam: false));
}
private SqlStatement CopyToStatement(SqlWhereCollection where, Sqls.TableTypes tableType)
{
var column = new Rds.ExportSettingsColumnCollection();
var param = new Rds.ExportSettingsParamCollection();
column.ReferenceType(function: Sqls.Functions.SingleColumn); param.ReferenceType();
column.ReferenceId(function: Sqls.Functions.SingleColumn); param.ReferenceId();
column.Title(function: Sqls.Functions.SingleColumn); param.Title();
column.ExportSettingId(function: Sqls.Functions.SingleColumn); param.ExportSettingId();
column.Ver(function: Sqls.Functions.SingleColumn); param.Ver();
column.AddHeader(function: Sqls.Functions.SingleColumn); param.AddHeader();
column.ExportColumns(function: Sqls.Functions.SingleColumn); param.ExportColumns();
column.Comments(function: Sqls.Functions.SingleColumn); param.Comments();
column.Creator(function: Sqls.Functions.SingleColumn); param.Creator();
column.Updator(function: Sqls.Functions.SingleColumn); param.Updator();
column.CreatedTime(function: Sqls.Functions.SingleColumn); param.CreatedTime();
column.UpdatedTime(function: Sqls.Functions.SingleColumn); param.UpdatedTime();
ColumnNames().ForEach(columnName =>
{
column.Add(
columnBracket: $"[{columnName}]",
columnName: columnName,
function: Sqls.Functions.SingleColumn);
param.Add(
columnBracket: $"[{columnName}]",
name: columnName);
});
return Rds.InsertExportSettings(
tableType: tableType,
param: param,
select: Rds.SelectExportSettings(column: column, where: where),
addUpdatorParam: false);
}