vendition_infodal.cs

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using Model;
using System.Configuration;
namespace DAL.Branch
{
    public class Vendition_infoDal
    {
        #region 添加销售单据明细
        public int Getvendition_info(string info_id, int vendition_id, string info_brand, string info_color, int info_size1, int info_size2, int info_size3, int info_size4, int info_size5, int info_size6, int info_size7, int info_sum, string info_name, string info_price, string info_Member_ID, string info_Member_name)
        {
            string vinfo = "Vendition_infoAdd";
            SqlParameter id = new SqlParameter("@info_id" ,SqlDbType.Char,10);
            id.Value = "info_id";
            SqlParameter tid = new SqlParameter("@vendition_id", SqlDbType.Char, 10);
            tid.Value = "vendition_id";
            SqlParameter br = new SqlParameter("@info_brand",SqlDbType.VarChar,10);
            br.Value = "info_brand";
            SqlParameter cl = new SqlParameter("@info_color",SqlDbType.VarChar,10);
            cl.Value = "info_color";
            SqlParameter si1 = new SqlParameter("@info_size1",SqlDbType.Int );
            si1.Value = "info_size1";
            SqlParameter si2 = new SqlParameter("@info_size2",SqlDbType.Int );
            si2.Value = "info_size2";
            SqlParameter si3 = new SqlParameter("@info_size3", SqlDbType.Int);
            si3.Value = "info_size3";
            SqlParameter si4 = new SqlParameter("@info_size4", SqlDbType.Int);
            si4.Value = "info_size4";
            SqlParameter si5 = new SqlParameter("@info_size5", SqlDbType.Int);
            si5.Value = "info_size5";
            SqlParameter si6 = new SqlParameter("@info_size6", SqlDbType.Int);
            si6.Value = "info_size6";
            SqlParameter si7 = new SqlParameter("@info_size7", SqlDbType.Int);
            si7.Value = "info_size7";
            SqlParameter sum = new SqlParameter("@info_sum",SqlDbType.Int);
            sum.Value = "info_sum";
            SqlParameter name = new SqlParameter("@info_name", SqlDbType.Int);
            name.Value = "info_name";
            SqlParameter price = new SqlParameter("@info_price",SqlDbType.VarChar,10);
            price.Value = "info_price";
            SqlParameter mid = new SqlParameter("@info_Member_ID",SqlDbType.VarChar,10);
            mid.Value = "info_Member_ID";
            SqlParameter mname = new SqlParameter("@info_Member_name",SqlDbType.VarChar,10);
            mname.Value = "info_Member_name";
            return SqlHelper.ExecuteNonQuery(SqlHelper.conStr, CommandType.StoredProcedure, vinfo, new SqlParameter[] { id, tid, br, cl, si1, si2, si3, si4, si5, si6, si7, sum, name, price, mid, mname });
        }
        #endregion





        #region 添加退货单据明细
        /// <summary>
        /// 添加退货单据明细
        /// </summary>
        /// <param name="vendition_id"></param>
        /// <param name="info_productID"></param>
        /// <param name="info_color"></param>
        /// <param name="info_size1"></param>
        /// <param name="info_size2"></param>
        /// <param name="info_size3"></param>
        /// <param name="info_size4"></param>
        /// <param name="info_size5"></param>
        /// <param name="info_size6"></param>
        /// <param name="info_size7"></param>
        /// <param name="info_name"></param>
        /// <param name="info_price"></param>
        /// <returns></returns>
        public int vendition_infoAdd(string vendition_id, string info_productID, string info_color, int info_size1, int info_size2, int info_size3, int info_size4, int info_size5, int info_size6, int info_size7, int info_sum,string info_name)
        {
            string vinfo = "Vendition_infoBackAdd";
            SqlParameter tid = new SqlParameter("@vendition_id", SqlDbType.Char, 20);
            tid.Value = vendition_id;
            SqlParameter br = new SqlParameter("@info_productID", SqlDbType.Char, 20);
            br.Value = info_productID;
            SqlParameter cl = new SqlParameter("@info_color", SqlDbType.VarChar, 10);
            cl.Value = info_color;
            SqlParameter si1 = new SqlParameter("@info_size1", SqlDbType.Int);
            si1.Value = info_size1;
            SqlParameter si2 = new SqlParameter("@info_size2", SqlDbType.Int);
            si2.Value = info_size2;
            SqlParameter si3 = new SqlParameter("@info_size3", SqlDbType.Int);
            si3.Value = info_size3;
            SqlParameter si4 = new SqlParameter("@info_size4", SqlDbType.Int);
            si4.Value = info_size4;
            SqlParameter si5 = new SqlParameter("@info_size5", SqlDbType.Int);
            si5.Value = info_size5;
            SqlParameter si6 = new SqlParameter("@info_size6", SqlDbType.Int);
            si6.Value = info_size6;
            SqlParameter si7 = new SqlParameter("@info_size7", SqlDbType.Int);
            si7.Value = info_size7;
            SqlParameter price = new SqlParameter("@info_sum", SqlDbType.Int);
            price.Value = info_sum;
            SqlParameter infoname = new SqlParameter("@info_name", SqlDbType.VarChar, 30);
            infoname.Value = info_name;
            return SqlHelper.ExecuteNonQuery(SqlHelper.conStr, CommandType.StoredProcedure, vinfo, new SqlParameter[] { tid, br, cl, si1, si2, si3, si4, si5, si6, si7, price,infoname });
        }
        #endregion

    }
}