stocksadapterlogic.cs

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

using System;
using System.Data;
using System.Data.SqlClient;
using System.Collections.Generic;
using System.Text;

namespace DataModal.HidaKitDataSetTableAdapters
{
    public partial class STOCKSTableAdapter
    {
        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;
        }

        public void InitLogic()
        {
            Adapter.AcceptChangesDuringUpdate = false;
        }
    }

    public partial class STOCK_DETAILTableAdapter
    {
        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;
        }

        public void InitLogic()
        {
            Adapter.AcceptChangesDuringUpdate = false;
            Adapter.RowUpdating += new SqlRowUpdatingEventHandler(Adapter_RowUpdating);
        }

        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);
            }
        }
    }
}