Ejemplo n.º 1
0
        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));
        }
Ejemplo n.º 2
0
        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));
        }