private SqlStatement CopyToStatement(SqlWhereCollection where, Sqls.TableTypes tableType)
{
var column = new Rds.GroupsColumnCollection();
var param = new Rds.GroupsParamCollection();
column.TenantId(function: Sqls.Functions.SingleColumn); param.TenantId();
column.GroupId(function: Sqls.Functions.SingleColumn); param.GroupId();
column.Ver(function: Sqls.Functions.SingleColumn); param.Ver();
column.GroupName(function: Sqls.Functions.SingleColumn); param.GroupName();
column.Body(function: Sqls.Functions.SingleColumn); param.Body();
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.InsertGroups(
tableType: tableType,
param: param,
select: Rds.SelectGroups(column: column, where : where),
addUpdatorParam: false));
}
private SqlStatement CopyToStatement(SqlWhereCollection where, Sqls.TableTypes tableType)
{
var column = new Rds.GroupsColumnCollection();
var param = new Rds.GroupsParamCollection();
column.TenantId(function: Sqls.Functions.SingleColumn); param.TenantId();
column.GroupId(function: Sqls.Functions.SingleColumn); param.GroupId();
column.Ver(function: Sqls.Functions.SingleColumn); param.Ver();
column.GroupName(function: Sqls.Functions.SingleColumn); param.GroupName();
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 (!Body.InitialValue())
{
column.Body(function: Sqls.Functions.SingleColumn);
param.Body();
}
if (!Comments.InitialValue())
{
column.Comments(function: Sqls.Functions.SingleColumn);
param.Comments();
}
return(Rds.InsertGroups(
tableType: tableType,
param: param,
select: Rds.SelectGroups(column: column, where : where),
addUpdatorParam: false));
}
private static SqlColumnCollection HistoryColumn(List <Column> columns)
{
var sqlColumn = new Rds.GroupsColumnCollection()
.GroupId()
.Ver();
columns.ForEach(column => sqlColumn.GroupsColumn(column.ColumnName));
return(sqlColumn);
}
