orderadapterlogic.cs

很好呀！这是我们学校老师让做的学期末的课程设计

using System;
using System.Data;
using System.Data.Common;
using System.Data.SqlClient;
using System.Collections.Generic;
using System.Text;
using Orphean.WinFormHelper.Framework.BusinessLogic;

namespace DataModal.HidaKitDataSetTableAdapters
{
    public partial class ORDERSTableAdapter
    {
        private UpdateErrorHandler _handler;

        public void InitLogic()
        {
            _handler = new UpdateErrorHandler(new UpdatingHandler(_adapter_RowUpdating),
                                              new UpdatedHandler(Adapter_RowUpdated));
            Adapter.RowUpdating += new SqlRowUpdatingEventHandler(_handler.DataUpdating);
            Adapter.RowUpdated += new SqlRowUpdatedEventHandler(Adapter_RowUpdated);
            Adapter.AcceptChangesDuringUpdate = false;
        }

        void Adapter_RowUpdated(object sender, RowUpdatedEventArgs e)
        {
        }

        public void InitTransaction(SqlTransaction trans)
        {
            Adapter.InsertCommand.Transaction = trans;
            Adapter.DeleteCommand.Transaction = trans;
            Adapter.UpdateCommand.Transaction = trans;
            foreach (SqlCommand cmd in CommandCollection)
                cmd.Transaction = trans;
        }

        void _adapter_RowUpdating(object sender, RowUpdatingEventArgs e)
        {
            if (e.StatementType == StatementType.Insert || e.StatementType == StatementType.Update)
            {
                SqlConnection conn = ConnectionHelper.GetConnection();
                try
                {
                    CUSTOMERSTableAdapter adapter = HidaKitAdapterProxy.GetCustomerAdapter(conn);
                    if (adapter.GetDataByCustomerID((string)e.Row["CUSTOMER_ID"]).Rows.Count == 0)
                        throw new IDNotExistsException((string)e.Row["CUSTOMER_ID"],
                                                        string.Format(Resources.Messages.SCustomerNotFound, e.Row["CUSTOMER_ID"]));                    
                }
                finally
                {
                    ConnectionHelper.ReleaseConnection(conn);
                }
            }
        }


    }

    public partial class ORDERS_DETAILTableAdapter
    {
        public void InitLogic()
        {
            Adapter.RowUpdating += new SqlRowUpdatingEventHandler(_adapter_RowUpdating);
            Adapter.RowUpdated += new SqlRowUpdatedEventHandler(Adapter_RowUpdated);
            Adapter.AcceptChangesDuringUpdate = false;
        }

        public void InitTransaction(SqlTransaction trans)
        {
            Adapter.InsertCommand.Transaction = trans;
            Adapter.DeleteCommand.Transaction = trans;
            Adapter.UpdateCommand.Transaction = trans;
            foreach (SqlCommand cmd in CommandCollection)
                cmd.Transaction = trans;
        }

        void Adapter_RowUpdated(object sender, SqlRowUpdatedEventArgs e)
        {
        }

        void _adapter_RowUpdating(object sender, SqlRowUpdatingEventArgs e)
        {
            SqlConnection conn = ConnectionHelper.GetConnection();
            try
            {
                if (e.StatementType == StatementType.Insert || e.StatementType == StatementType.Update)
                {
                    PRODUCTSTableAdapter adapter2 = HidaKitAdapterProxy.GetProductAdapter(conn);
                    if (adapter2.GetDataByProductId((string)e.Row["PRODUCT_ID"]) == null)
                        throw new IDNotExistsException((string)e.Row["PRODUCT_ID"],
                                                      string.Format(Resources.Messages.SProductNotFound, e.Row["PRODUCT_ID"]));
                }                
            }
            finally
            {
                ConnectionHelper.ReleaseConnection(conn);
            }
        }
    }    
}