如何使用C#代码实现数据库触发器的功能

[TonyWu66]

之前使用SQL的触发器来实现触发功能 如 删除入库单时从物料表的库存中减去相应的数量.

但如果我要改成用业务逻辑层代码实现此功能的话要怎么写.谢谢

[CutBug]

事件

[CutBug]

using System;
namespace ConsoleApplication1
{
    class Program
    {
        static void Main(string[] args)
        {

            Bank b = new Bank();
            b.BeforeClosed +=new Bank.BeforeBankCloseHandler(b_BeforeClosed);
            b.Close();
        }

        static void b_BeforeClosed(object sender, BeforeBankCloseEventArgs e)
        {
            Console.WriteLine("Bank'Name is:"+e.BankName);
            Console.WriteLine("Before bank is closed,I can do something");
        }

    }

    public class Bank
    {
        public delegate void BeforeBankCloseHandler(object sender, BeforeBankCloseEventArgs e);
        public event BeforeBankCloseHandler BeforeClosed;



        public void Close()
        {
            string bName = "China Bank";
            BeforeBankCloseEventArgs arg = new BeforeBankCloseEventArgs(bName);
            BeforeClosed(this, arg);
            Console.WriteLine("Bank Closed");
        }


    }

    public class BeforeBankCloseEventArgs : EventArgs
    {
        public BeforeBankCloseEventArgs(string m)
        {
            _bankName = m;
        }
        private string _bankName;
        public string BankName
        {
            get { return _bankName; }
            set { _bankName = value; }
        }

    }
}

输出:
Bank'Name is:China Bank
Before bank is closed,I can do something
Bank Closed

[天乐]

使劲顶顶楼上，这么用心，好人呐！

[TonyWu66]

自己顶一下

[TonyWu66]

感谢2楼.很详细,有复习了一下委托与事件.
谢谢!
想再听听其他高手的意见.

[che2piaopiao]

http://topic.csdn.net/u/20090227/16/9f795a88-45b5-47c7-b68e-a83ae0d74fd8.html

[TonyWu66]

没人这样做吗?

[TonyWu66]

请高手说说经验.谢谢!

[TonyWu66]

再顶起

[jsxxyzx]

二楼真是牛人那

[makegold]

看看解决方案

[ouranxiangyu]

楼主，问题解决了吗？ 代码分享一下呗