T-SQL 批量插入，更新

　　　　public void Initialize(Dictionary<long, long> code)
        {
            var sql = @"
                declare @code_list xml
                set        @code_list=N'
                <CodeList>
                    {0}
                </CodeList>'
                insert into        ZTOSubscribe(FormCode,BillCode,SubscribeState,UpdataTime,Remark)
                select            T.c.value('(./FormCode,text())[1]','bigint'),T.c.value('(./BillCode,text())[1]','bigint'),0,GETDATE(),''
                from                @code_list.nodes(N'/CodeList/Code') T(c) ";
            var sqlBlock = @"
                <Code>
                    <FormCode>{0}</FormCode>
                    <BillCode>{1}</BillCode>
                </Code>";
            var sqlExcute = string.Format(sql, string.Concat(code.Select(brf => string.Format(sqlBlock, brf.Key, brf.Value)).ToArray()));
            SqlHelper.ExecuteNonQuery("Data Source=.;Initial Catalog=Test;Integrated Security=SSPI;", CommandType.Text, sqlExcute);
        }

        public void Update(List<SubscribeResult> entity)
        {
            var sql = @"
            declare @subscribe_list xml
            set @subscribe_list=N'
            <SubscribeList>
                {0}
            </SubscribeList>
            '
            update    ZTOSubscribe
            set        SubscribeState = T.c.value(N'(./Status,text())[1]',N'bit'),UpdataTime = GETDATE(),Remark=T.c.value(N'(./Remark,text())[1]',N'nvarchar(80)')
            from        ZTOSubscribe o
                        join @subscribe_list.nodes(N'/SubscribeList/Subscribe') T(c) on T.c.value(N'(./FormCode,text())[1]',N'bigint')= o.FormCode";
            var sqlBlock = @"
            <Subscribe>
                    <FormCode>{0}</FormCode>
                    <Status>{1}</Status>
                    <Remark>{2}</Remark>
            </Subscribe>";
            var sqlExcute = string.Format(sql, string.Concat(entity.Select(x => string.Format(sqlBlock, x.OrderId, x.Status, x.Remark))));
            SqlHelper.ExecuteNonQuery("Data Source=.;Initial Catalog=Test;Integrated Security=SSPI;", CommandType.Text, sqlExcute);
        }