예제 #1
0
        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));
        }
예제 #2
0
        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));
        }