bigclient_listdal.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.BigCustomers
{
    public class bigclient_listDal
    {
        #region 添加大客户销售明细
        /// <summary>
        /// 添加大客户销售明细
        /// </summary>
        /// <param name="bigclient_id">大客户销售单据编号</param>
        /// <param name="Product_id">商品编号</param>
        /// <param name="bigclient_list_color">销售颜色</param>
        /// <param name="bigclient_list_price">销售单价</param>
        /// <param name="bigclient_lis_size1">尺码1数量</param>
        /// <param name="bigclient_lis_size2">尺码2数量</param>
        /// <param name="bigclient_lis_size3">尺码3数量</param>
        /// <param name="bigclient_lis_size4">尺码4数量</param>
        /// <param name="bigclient_lis_size5">尺码5数量</param>
        /// <param name="bigclient_lis_size6">尺码6数量</param>
        /// <param name="bigclient_lis_size7">尺码7数量</param>
        /// <returns>添加大客户销售单据影响的行数</returns>
        public int Addbigclient_list(string bigclient_id, string Product_id, string bigclient_list_color, decimal bigclient_list_price, int bigclient_lis_size1, int bigclient_lis_size2, int bigclient_lis_size3, int bigclient_lis_size4, int bigclient_lis_size5, int bigclient_lis_size6, int bigclient_lis_size7)
        {
            string commandtext = "bigclient_list_Add";
            SqlParameter id = new SqlParameter("@bigclient_id", SqlDbType.Char, 20);
            SqlParameter productid = new SqlParameter("@Product_id", SqlDbType.Char, 20);
            SqlParameter color = new SqlParameter("@bigclient_list_color", SqlDbType.VarChar,10);
            SqlParameter price = new SqlParameter("@bigclient_list_price", SqlDbType.Decimal);
            SqlParameter size1 = new SqlParameter("@bigclient_lis_size1", SqlDbType.Int);
            SqlParameter size2 = new SqlParameter("@bigclient_lis_size2", SqlDbType.Int);
            SqlParameter size3 = new SqlParameter("@bigclient_lis_size3", SqlDbType.Int);
            SqlParameter size4 = new SqlParameter("@bigclient_lis_size4", SqlDbType.Int);
            SqlParameter size5 = new SqlParameter("@bigclient_lis_size5", SqlDbType.Int);
            SqlParameter size6 = new SqlParameter("@bigclient_lis_size6", SqlDbType.Int);
            SqlParameter size7 = new SqlParameter("@bigclient_lis_size7", SqlDbType.Int);
            id.Value = bigclient_id;
            productid.Value = Product_id;
            color.Value = bigclient_list_color;
            price.Value = bigclient_list_price;
            size1.Value = bigclient_lis_size1;
            size2.Value = bigclient_lis_size2;
            size3.Value = bigclient_lis_size3;
            size4.Value = bigclient_lis_size4;
            size5.Value = bigclient_lis_size5;
            size6.Value = bigclient_lis_size6;
            size7.Value = bigclient_lis_size7;


            return SqlHelper.ExecuteNonQuery(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, new SqlParameter[] { id, productid,color,price, size1, size2, size3, size4, size5, size6, size7 });
        }
        #endregion

        #region 通过大客户销售单据编号查找销售单据信息
        /// <summary>
        /// 通过大客户销售单据编号查找销售单据信息
        /// </summary>
        /// <param name="bigclient_id">大客户销售单据编号</param>
        /// <returns></returns>
        public List<Model.BigCustomers.bigclient_listModel> bigclient_listSelectByID(string bigclient_id)
        {
            List<Model.BigCustomers.bigclient_listModel> li = new List<Model.BigCustomers.bigclient_listModel>();
            string commandtext = "bigclient_listByID_Select";
            SqlParameter id = new SqlParameter("@bigclient_id", SqlDbType.Char, 20);
            id.Value = bigclient_id;
            DataSet ds = new DataSet();
            SqlHelper.FillDataSet(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, ds, new string[] { }, new SqlParameter[] { id });
            foreach (DataRow item in ds.Tables[0].Rows)
            {
                Model.BigCustomers.bigclient_listModel inf = new Model.BigCustomers.bigclient_listModel();
                inf.bigclient_id = item["bigclient_id"].ToString().Trim();
                inf.Product_id = item["Product_id"].ToString().Trim();
                inf.bigclient_list_color = item["bigclient_list_color"].ToString ();
                inf.bigclient_list_price = (decimal)item["bigclient_list_price"];
                inf.bigclient_lis_size1 = (int)item["bigclient_lis_size1"];
                inf.bigclient_lis_size2 = (int)item["bigclient_lis_size2"];
                inf.bigclient_lis_size3 = (int)item["bigclient_lis_size3"];
                inf.bigclient_lis_size4 = (int)item["bigclient_lis_size4"];
                inf.bigclient_lis_size5 = (int)item["bigclient_lis_size5"];
                inf.bigclient_lis_size6 = (int)item["bigclient_lis_size6"];
                inf.bigclient_lis_size7 = (int)item["bigclient_lis_size7"];
                li.Add(inf);
            }
            return li;
        }
        #endregion

        #region 修改大客户销售单据(退货)
        /// <summary>
        /// 修改大客户销售单据(退货)
        /// </summary>
        /// <param name="bigclient_id">采购销售单据编号</param>
        /// <param name="bigclient_assessor">销售审核人</param>
        /// <param name="bigclient_state">会计审核</param>
        /// <param name="bigclient_type_id">销售类型ID</param>
        /// <returns>返回修改信息影响的行数</returns>
        public List<Model.BigCustomers.bigclientModel> bigclientReturnUpdate(string bigclient_id, string bigclient_assessor, string bigclient_state, string bigclient_type_id)
        {
            List<Model.BigCustomers.bigclientModel> list = new List<Model.BigCustomers.bigclientModel>();
            string commandtext = "bigclientReturn_Update";
            SqlParameter id = new SqlParameter("@bigclient_id", SqlDbType.Char, 20);
            SqlParameter assessor = new SqlParameter("@bigclient_assessor", SqlDbType.VarChar, 50);
            SqlParameter state = new SqlParameter("@bigclient_state", SqlDbType.VarChar,10);
            SqlParameter typeid = new SqlParameter("@bigclient_type_id", SqlDbType.Char, 20);
            id.Value = bigclient_id;
            assessor.Value = bigclient_assessor;
            state.Value = bigclient_state;
            typeid.Value = bigclient_type_id;
            SqlHelper.ExecuteNonQuery(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, new SqlParameter[] { id, assessor, state, typeid });
            return list;
        }
        #endregion

        #region 删除销售明细
        /// <summary>
        /// 删除销售明细
        /// </summary>
        /// <param name="stockformid">采购单据编号</param>
        /// <returns>返回删除大客户销售单据影响的行数</returns>
        public int bigclient_listDelete(string bigclient_id)
        {
            string com = "bigclient_list_Delete";
            SqlParameter id = new SqlParameter("@bigclient_id", SqlDbType.Char, 20);
            id.Value = bigclient_id;
            return SqlHelper.ExecuteNonQuery(SqlHelper.conStr, CommandType.StoredProcedure, com, new SqlParameter[] { id });
        }
        #endregion

        #region 查询所有销售明细
        /// <summary>
        /// 查询所有销售明细
        /// </summary>
        /// <returns></returns>
        public List<Model.BigCustomers.bigclient_listModel> bigclient_listSelect()
        {
            List<Model.BigCustomers.bigclient_listModel> li = new List<Model.BigCustomers.bigclient_listModel>();
            string commandtext = "bigclient_list_Select";
            DataSet ds = new DataSet();
            SqlHelper.FillDataSet(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, ds, new string[] { }, null);
            foreach (DataRow item in ds.Tables[0].Rows)
            {
                Model.BigCustomers.bigclient_listModel inf = new Model.BigCustomers.bigclient_listModel();
                inf.bigclient_id = item["bigclient_id"].ToString().Trim();
                inf.Product_id = item["Product_id"].ToString().Trim();
                inf.bigclient_list_color = item["bigclient_list_color"].ToString();
                inf.bigclient_list_price = (decimal)item["bigclient_list_price"];
                inf.bigclient_lis_size1 = (int)item["bigclient_lis_size1"];
                inf.bigclient_lis_size2 = (int)item["bigclient_lis_size2"];
                inf.bigclient_lis_size3 = (int)item["bigclient_lis_size3"];
                inf.bigclient_lis_size4 = (int)item["bigclient_lis_size4"];
                inf.bigclient_lis_size5 = (int)item["bigclient_lis_size5"];
                inf.bigclient_lis_size6 = (int)item["bigclient_lis_size6"];
                inf.bigclient_lis_size7 = (int)item["bigclient_lis_size7"];
                li.Add(inf);
            }
            return li;
        }
        #endregion
    }
}