productadddal.cs

c#三层架构项目开发的全过程

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Model;
using System.Data;
using System.Data.SqlClient;
namespace DAL.Goods
{
   public class ProductAddDal
    {
       #region 添加商品
       public int Addproduct(string product_id, int brand_ID, decimal product_saleprice, decimal product_costprice, decimal product_tradeprice, string producttype_name)
        {
            string cmdtextm1 = "Product_Add";
            SqlParameter mt3 = new SqlParameter("@Product_id", SqlDbType.Char,20);
            mt3.Value = product_id;
            SqlParameter mt2 = new SqlParameter("@brand_ID", SqlDbType.Int );
            mt2.Value = brand_ID;

            SqlParameter mt4 = new SqlParameter("@Product_SalePrice", SqlDbType.Decimal);
            mt4.Value = product_saleprice;
            SqlParameter mt5 = new SqlParameter("@Product_CostPrice", SqlDbType.Decimal);
            mt5.Value = product_costprice;
            SqlParameter mt6 = new SqlParameter("@Product_TradePrice", SqlDbType.Decimal);
            mt6.Value = product_tradeprice;
            SqlParameter mid = new SqlParameter("@product_name", SqlDbType.VarChar, 30);
            mid.Value = producttype_name;
            return SqlHelper.ExecuteNonQuery(SqlHelper.conStr, CommandType.StoredProcedure, cmdtextm1, new SqlParameter[] { mt3, mt2, mt4, mt5, mt6, mid });
        }
        #endregion

       #region 添加商品明细单
       public int AddProductType(string product_id,string producttype_name, string producttype_brand, int producttype_S1, int producttype_S2, int producttype_S3, int producttype_S4, int producttype_S5, int producttype_S6, int producttype_S7, string producttype_color)
       {
           string com = "InsertProductType";
           SqlParameter id = new SqlParameter("@Product_id",SqlDbType.Char,20);
           SqlParameter na = new SqlParameter("@ProductType_name", SqlDbType.Char, 20);
           SqlParameter br = new SqlParameter("@ProductType_brand",SqlDbType.VarChar,10);
           SqlParameter s1 = new SqlParameter("@ProductType_S1",SqlDbType.SmallInt);
           SqlParameter s2 = new SqlParameter("@ProductType_S2",SqlDbType.SmallInt);
           SqlParameter s3 = new SqlParameter("@ProductType_S3",SqlDbType.SmallInt);
           SqlParameter s4 = new SqlParameter("@ProductType_S4",SqlDbType.SmallInt);
           SqlParameter s5 = new SqlParameter("@ProductType_S5", SqlDbType.SmallInt);
           SqlParameter s6 = new SqlParameter("@ProductType_S6", SqlDbType.SmallInt);
           SqlParameter s7 = new SqlParameter("@ProductType_S7", SqlDbType.SmallInt);
           SqlParameter co = new SqlParameter("@ProductType_color", SqlDbType.VarChar,10);
           id.Value = product_id;
           na.Value = producttype_name;
           br.Value = producttype_brand;
           s1.Value = producttype_S1;
           s2.Value = producttype_S2;
           s3.Value = producttype_S3;
           s4.Value = producttype_S4;
           s5.Value = producttype_S5;
           s6.Value = producttype_S6;
           s7.Value = producttype_S7;
           co.Value = producttype_color;
           return SqlHelper.ExecuteNonQuery(SqlHelper.conStr, CommandType.StoredProcedure, com, new SqlParameter[] { id,na,br,s1,s2,s3,s4,s5,s6,s7,co });
       }
        #endregion


    }
}