ProductSet.cs

using System.Data.Linq;
using System.Data.Linq.Mapping;
using System.Data.SqlClient;
using System.Reflection;

namespace ProductManager.Model
{
    /*
     *声明一个强类型化的 DataContext 将所有 Table 集合声明为上下文的成员。
     *GetTable<TEntity>()是查询的主入口点。当创建强类型的 DataContext 时，
     *新生成的 TEntitys 属性会封装对此方法的调用。
     */
    [Database(Name = "ProductSet")]
    public partial class ProductSet : DataContext
    {
        public Table<Client> Client; // base.GetTable<Client>()
        public Table<ProductType> ProductType; // base.GetTable<ProductType>()
        public ProductSet(SqlConnection sql) : base(sql) { }

        #region ProductType 存储过程
        private void InsertProductType(ProductType obj)
        {
            this.InsertProductType(obj.TypeID, obj.TypeName);
        }

        private void UpdateProductType(ProductType obj)
        {
            this.UpdateProductType(obj.TypeID, obj.TypeName);
        }

        private void DeleteProductType(ProductType obj)
        {
            this.DeleteProductType(obj.TypeID);
        }

        [Function(Name = "dbo.InsertProductType")]
        public int InsertProductType([Parameter(Name = "TypeID", DbType = "VarChar(10)")] string typeID, [Parameter(Name = "TypeName", DbType = "VarChar(20)")] string typeName)
        {
            IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), typeID, typeName);
            return ((int)(result.ReturnValue));
        }

        [Function(Name = "dbo.UpdateProductType")]
        public int UpdateProductType([Parameter(Name = "TypeID", DbType = "VarChar(10)")] string typeID, [Parameter(Name = "TypeName", DbType = "VarChar(20)")] string typeName)
        {
            IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), typeID, typeName);
            return ((int)(result.ReturnValue));
        }

        [Function(Name = "dbo.DeleteProductType")]
        public int DeleteProductType([Parameter(Name = "TypeID", DbType = "VarChar(10)")] string typeID)
        {
            IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), typeID);
            return ((int)(result.ReturnValue));
        }
        #endregion

        #region Client 存储过程
        private void InsertClient(Client obj)
        {
            this.Insert_Client(obj.ClientID, obj.ClientName, obj.Linkman, obj.LinkPhone, obj.Fax, obj.Email, obj.Address, obj.Memo);
        }

        private void UpdateClient(Client obj)
        {
            this.Update_Client(obj.ClientID, obj.ClientName, obj.Linkman, obj.LinkPhone, obj.Fax, obj.Email, obj.Address, obj.Memo);
        }

        private void DeleteClient(Client obj)
        {
            this.Delete_Client(obj.ClientID);
        }

        [Function(Name = "dbo.Insert_Client")]
        public int Insert_Client([Parameter(Name = "ClientID", DbType = "VarChar(10)")] string clientID, [Parameter(Name = "ClientName", DbType = "VarChar(20)")] string clientName, [Parameter(Name = "Linkman", DbType = "VarChar(20)")] string linkman, [Parameter(Name = "LinkPhone", DbType = "VarChar(15)")] string linkPhone, [Parameter(Name = "Fax", DbType = "VarChar(15)")] string fax, [Parameter(Name = "Email", DbType = "VarChar(30)")] string email, [Parameter(Name = "Address", DbType = "NVarChar(100)")] string address, [Parameter(Name = "Memo", DbType = "NVarChar(50)")] string memo)
        {
            IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), clientID, clientName, linkman, linkPhone, fax, email, address, memo);
            return ((int)(result.ReturnValue));
        }

        [Function(Name = "dbo.Update_Client")]
        public int Update_Client([Parameter(Name = "ClientID", DbType = "VarChar(10)")] string clientID, [Parameter(Name = "ClientName", DbType = "VarChar(20)")] string clientName, [Parameter(Name = "Linkman", DbType = "VarChar(20)")] string linkman, [Parameter(Name = "LinkPhone", DbType = "VarChar(15)")] string linkPhone, [Parameter(Name = "Fax", DbType = "VarChar(15)")] string fax, [Parameter(Name = "Email", DbType = "VarChar(30)")] string email, [Parameter(Name = "Address", DbType = "NVarChar(100)")] string address, [Parameter(Name = "Memo", DbType = "NVarChar(50)")] string memo)
        {
            IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), clientID, clientName, linkman, linkPhone, fax, email, address, memo);
            return ((int)(result.ReturnValue));
        }

        [Function(Name = "dbo.Delete_Client")]
        public int Delete_Client([Parameter(Name = "ClientID", DbType = "VarChar(10)")] string clientID)
        {
            IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), clientID);
            return ((int)(result.ReturnValue));
        }
        #endregion
    }
}