samplesum.cs

来自「C#高级编程第6版随书源代码 值得下载」· CS 代码 · 共 36 行

using System;
using System.Data;
using System.Data.SqlClient;
using System.Data.SqlTypes;
using Microsoft.SqlServer.Server;


[Serializable]
[Microsoft.SqlServer.Server.SqlUserDefinedAggregate(Format.Native)]
public struct SampleSum
{
   private int sum;

   public void Init()
   {
      sum = 0;
   }

   public void Accumulate(SqlInt32 Value)
   {
      sum += Value.Value;
   }

   public void Merge(SampleSum Group)
   {
      sum += Group.sum;
   }

   public SqlInt32 Terminate()
   {
      return new SqlInt32(sum);
   }


}