private SqlStatement CopyToStatement(SqlWhereCollection where, Sqls.TableTypes tableType)
{
var column = new Rds.DemosColumnCollection();
var param = new Rds.DemosParamCollection();
column.DemoId(function: Sqls.Functions.SingleColumn); param.DemoId();
column.Ver(function: Sqls.Functions.SingleColumn); param.Ver();
column.TenantId(function: Sqls.Functions.SingleColumn); param.TenantId();
column.Title(function: Sqls.Functions.SingleColumn); param.Title();
column.LoginId(function: Sqls.Functions.SingleColumn); param.LoginId();
column.Passphrase(function: Sqls.Functions.SingleColumn); param.Passphrase();
column.MailAddress(function: Sqls.Functions.SingleColumn); param.MailAddress();
column.Initialized(function: Sqls.Functions.SingleColumn); param.Initialized();
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.InsertDemos(
tableType: tableType,
param: param,
select: Rds.SelectDemos(column: column, where : where),
addUpdatorParam: false));
}
private SqlStatement CopyToStatement(SqlWhereCollection where, Sqls.TableTypes tableType)
{
var column = new Rds.DemosColumnCollection();
var param = new Rds.DemosParamCollection();
column.DemoId(function: Sqls.Functions.SingleColumn); param.DemoId();
column.Ver(function: Sqls.Functions.SingleColumn); param.Ver();
column.TenantId(function: Sqls.Functions.SingleColumn); param.TenantId();
column.Passphrase(function: Sqls.Functions.SingleColumn); param.Passphrase();
column.MailAddress(function: Sqls.Functions.SingleColumn); param.MailAddress();
column.Initialized(function: Sqls.Functions.SingleColumn); param.Initialized();
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 (!Title.InitialValue())
{
column.Title(function: Sqls.Functions.SingleColumn);
param.Title();
}
if (!Comments.InitialValue())
{
column.Comments(function: Sqls.Functions.SingleColumn);
param.Comments();
}
return(Rds.InsertDemos(
tableType: tableType,
param: param,
select: Rds.SelectDemos(column: column, where : where),
addUpdatorParam: false));
}