コード例 #1
0
        private SqlStatement CopyToStatement(SqlWhereCollection where, Sqls.TableTypes tableType)
        {
            var column = new Rds.MailAddressesColumnCollection();
            var param  = new Rds.MailAddressesParamCollection();

            column.OwnerId(function: Sqls.Functions.SingleColumn); param.OwnerId();
            column.OwnerType(function: Sqls.Functions.SingleColumn); param.OwnerType();
            column.MailAddressId(function: Sqls.Functions.SingleColumn); param.MailAddressId();
            column.Ver(function: Sqls.Functions.SingleColumn); param.Ver();
            column.MailAddress(function: Sqls.Functions.SingleColumn); param.MailAddress();
            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.InsertMailAddresses(
                       tableType: tableType,
                       param: param,
                       select: Rds.SelectMailAddresses(column: column, where : where),
                       addUpdatorParam: false));
        }
コード例 #2
0
        private SqlStatement CopyToStatement(SqlWhereCollection where, Sqls.TableTypes tableType)
        {
            var column = new Rds.MailAddressesColumnCollection();
            var param  = new Rds.MailAddressesParamCollection();

            column.OwnerId(function: Sqls.Functions.SingleColumn); param.OwnerId();
            column.OwnerType(function: Sqls.Functions.SingleColumn); param.OwnerType();
            column.MailAddressId(function: Sqls.Functions.SingleColumn); param.MailAddressId();
            column.Ver(function: Sqls.Functions.SingleColumn); param.Ver();
            column.MailAddress(function: Sqls.Functions.SingleColumn); param.MailAddress();
            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.InsertMailAddresses(
                       tableType: tableType,
                       param: param,
                       select: Rds.SelectMailAddresses(column: column, where : where),
                       addUpdatorParam: false));
        }