xs_pricelistdal.cs

来自「为了便于企业对客户按照地区进行统计查询分析」· CS 代码 · 共 119 行

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

namespace DataAccess.DAL
{
    class XS_PriceListDAL
    {
        DataAccess.Comm.Comm c = new DataAccess.Comm.Comm();
        /// <summary>
        /// 添加清单设置**********************************
        /// </summary>
        /// <param name="CusCode"></param>
        /// <returns></returns>
        public List<XS_PriceList> SelectXS_PriceList(string CusCode)
        {
            SqlConnection sqlcnn = c.conn();
            SqlCommand sqlcmd = new SqlCommand();
            sqlcmd.CommandText = "SelectXS_PriceList";

            sqlcmd.CommandType = CommandType.StoredProcedure;
            sqlcmd.Parameters.AddWithValue("@CusCode", CusCode);
            sqlcmd.Connection = sqlcnn;
            SqlDataReader reader = null;
            List<XS_PriceList> list = new List<XS_PriceList>();
            try
            {
                sqlcnn.Open();
                reader = sqlcmd.ExecuteReader();
                while (reader.Read())
                {
                    XS_PriceList xs_pricelist = new XS_PriceList();
                    xs_pricelist.CusCode = reader["CusCode"].ToString();
                    xs_pricelist.WareCode = reader["WareCode"].ToString();
                    xs_pricelist.Quantity =Convert.ToDecimal( reader["Quantity"].ToString());
                    xs_pricelist.CapitalUnitPrice = Convert.ToDecimal(reader["CapitalUnitPrice"].ToString());
                    xs_pricelist.PriceDate = Convert.ToDateTime(reader["PriceDate"].ToString());
                    list.Add(xs_pricelist);
                }
            }
            catch (SqlException e)
            {
                throw e;
            }
            finally
            {
                if (sqlcnn.State != ConnectionState.Closed)
                {
                    sqlcnn.Close();
                }
            }
            return list;
        }

        /// <summary>
        /// 添加清單設置
        /// </summary>
        /// <param name="insert_xs_pricelist"></param>
        public void InsertXS_PriceList(XS_PriceList insert_xs_pricelist)
        {
            SqlParameter[] parameters = { 
					new SqlParameter("@CusCode", SqlDbType.VarChar,20),
					new SqlParameter("@WareCode", SqlDbType.VarChar,20),
					new SqlParameter("@Quantity", SqlDbType.Decimal,9),
					new SqlParameter("@CapitalUnitPrice", SqlDbType.Decimal,9),
					new SqlParameter("@PriceDate", SqlDbType.DateTime)}; 
            parameters[0].Value = insert_xs_pricelist.CusCode;
            parameters[1].Value = insert_xs_pricelist.WareCode;
            parameters[2].Value = insert_xs_pricelist.Quantity;
            parameters[3].Value = insert_xs_pricelist.CapitalUnitPrice;
            parameters[4].Value = insert_xs_pricelist.PriceDate;
            c.Excute("InsertXS_PriceList", parameters);
        }
        /// <summary>
        /// 更新清单设置
        /// </summary>
        /// <param name="update_xs_pricelist"></param>
        public void UpdateXS_PriceList(XS_PriceList update_xs_pricelist)
        {

            SqlParameter[] parameters = { 
					new SqlParameter("@CusCode", SqlDbType.VarChar,20),
					new SqlParameter("@WareCode", SqlDbType.VarChar,20),
					new SqlParameter("@Quantity", SqlDbType.Decimal,9),
					new SqlParameter("@CapitalUnitPrice", SqlDbType.Decimal,9),
					new SqlParameter("@PriceDate", SqlDbType.DateTime)};
            parameters[0].Value = update_xs_pricelist.CusCode;
            parameters[1].Value = update_xs_pricelist.WareCode;
            parameters[2].Value = update_xs_pricelist.Quantity;
            parameters[3].Value = update_xs_pricelist.CapitalUnitPrice;
            parameters[4].Value = update_xs_pricelist.PriceDate;
            c.Excute("UpdateXS_PriceList", parameters);
        }
        /// <summary>
        /// 删除清单设置
        /// </summary>
        /// <param name="delete_xs_pricelist"></param>
        public void DeleteXS_PriceList(XS_PriceList delete_xs_pricelist)
        {

            SqlParameter[] parameters = { 
					new SqlParameter("@CusCode", SqlDbType.VarChar,20),
					new SqlParameter("@WareCode", SqlDbType.VarChar,20),
					new SqlParameter("@Quantity", SqlDbType.Decimal,9),
					new SqlParameter("@CapitalUnitPrice", SqlDbType.Decimal,9),
					new SqlParameter("@PriceDate", SqlDbType.DateTime)};
            parameters[0].Value = delete_xs_pricelist.CusCode;
            parameters[1].Value = delete_xs_pricelist.WareCode;
            parameters[2].Value = delete_xs_pricelist.Quantity;
            parameters[3].Value = delete_xs_pricelist.CapitalUnitPrice;
            parameters[4].Value = delete_xs_pricelist.PriceDate;
            c.Excute("DeleteXS_PriceList", parameters);
        }
    }
}