loss_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.Loss
{
    public class loss_listDal
    {
        #region 添加损益明细
        /// <summary>
        /// 添加损益明细
        /// </summary>
        /// <param name="loss_id">损益单据编号</param>
        /// <param name="loss_list_product_id">商品ID</param>
        /// <param name="loss_list_color">损益商品颜色</param>
        /// <param name="loss_list_size1">损益尺码1数量</param>
        /// <param name="loss_list_size2">损益尺码2数量</param>
        /// <param name="loss_list_size3">损益尺码3数量</param>
        /// <param name="loss_list_size4">损益尺码4数量</param>
        /// <param name="loss_list_size5">损益尺码5数量</param>
        /// <param name="loss_list_size6">损益尺码6数量</param>
        /// <param name="loss_list_size7">损益尺码7数量</param>
        /// <param name="loss_list_sum">损益尺码总数量</param>
        /// <returns>返回添加损益明细影响的行数</returns>
        public int AddLoss_List(string loss_id, string loss_list_product_id, string loss_list_color, int loss_list_size1, int loss_list_size2, int loss_list_size3, int loss_list_size4, int loss_list_size5, int loss_list_size6, int loss_list_size7, int loss_list_sum)
        {
            string commandtext = "loss_list_Add";
            SqlParameter id = new SqlParameter("@loss_id", SqlDbType.VarChar, 50);
            SqlParameter pid = new SqlParameter("@loss_list_product_id", SqlDbType.Char,20);
            SqlParameter color = new SqlParameter("@loss_list_color", SqlDbType.VarChar,10);
            SqlParameter size1 = new SqlParameter("@loss_list_size1", SqlDbType.Int);
            SqlParameter size2 = new SqlParameter("@loss_list_size2", SqlDbType.Int);
            SqlParameter size3 = new SqlParameter("@loss_list_size3", SqlDbType.Int);
            SqlParameter size4 = new SqlParameter("@loss_list_size4", SqlDbType.Int);
            SqlParameter size5 = new SqlParameter("@loss_list_size5", SqlDbType.Int);
            SqlParameter size6 = new SqlParameter("@loss_list_size6", SqlDbType.Int);
            SqlParameter size7 = new SqlParameter("@loss_list_size7", SqlDbType.Int);
            SqlParameter sum = new SqlParameter("@loss_list_sum", SqlDbType.Int);

            id.Value = loss_id.Trim ();
            pid.Value = loss_list_product_id.Trim();
            color.Value = loss_list_color;
            size1.Value = loss_list_size1;
            size2.Value = loss_list_size2;
            size3.Value = loss_list_size3;
            size4.Value = loss_list_size4;
            size5.Value = loss_list_size5;
            size6.Value = loss_list_size6;
            size7.Value = loss_list_size7;
            sum.Value = loss_list_sum;
            return SqlHelper.ExecuteNonQuery(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, new SqlParameter[] { id, pid, color, size1, size2, size3, size4, size5, size6, size7,sum });
        }
        #endregion

        #region 通过损益单据编号删除损益明细
        /// <summary>
        /// 通过损益单据编号删除损益明细
        /// </summary>
        /// <param name="loss_id">采购单据编号</param>
        /// <returns>返回删除采购单据影响的行数</returns>
        public int StockSetailDeleteByID(string loss_id)
        {
            string com = "Loss_list_Delete";
            SqlParameter id = new SqlParameter("@loss_id", SqlDbType.Char, 20);
            id.Value = loss_id;
            return SqlHelper.ExecuteNonQuery(SqlHelper.conStr, CommandType.StoredProcedure, com, new SqlParameter[] { id });
        }
        #endregion

        #region 通过损益单据编号查询损益明细
        /// <summary>
        /// 通过损益单据编号查询损益明细
        /// </summary>
        /// <param name="loss_id">损益单据编号</param>
        /// <returns></returns>
        public List<Model.Loss.loss_listModel> Selectloss_listByID(string loss_id)
        {
            string commandtext = "loss_listByLossID_Select";
            SqlParameter id = new SqlParameter("@loss_id", SqlDbType.Char, 20);
            id.Value = loss_id;
            DataSet ds = new DataSet();
            SqlHelper.FillDataSet(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, ds, new string[] { }, new SqlParameter[] { id });
            List<Model.Loss.loss_listModel> li = new List<Model.Loss.loss_listModel>();
            foreach (DataRow dr in ds.Tables[0].Rows)
            {
                Model.Loss.loss_listModel inf = new Model.Loss.loss_listModel();
                inf.loss_id = dr["loss_id"].ToString().Trim();
                inf.loss_list_product_id = dr["loss_list_product_id"].ToString();
                inf.loss_list_color = dr["loss_list_color"].ToString ();
                inf.loss_list_size1 = (int)dr["loss_list_size1"];
                inf.loss_list_size2 = (int)dr["loss_list_size2"];
                inf.loss_list_size3 = (int)dr["loss_list_size3"];
                inf.loss_list_size4 = (int)dr["loss_list_size4"];
                inf.loss_list_size5 = (int)dr["loss_list_size5"];
                inf.loss_list_size6 = (int)dr["loss_list_size6"];
                inf.loss_list_size7 = (int)dr["loss_list_size7"];
                inf.loss_list_sum = (int)dr["loss_list_sum"];
                li.Add(inf);
            }
            return li;
        }
        #endregion

        #region 查询损益明细
        /// <summary>
        /// 查询损益明细
        /// </summary>
        /// <returns></returns>
        public List<Model.Loss.loss_listModel> loss_list_Select()
        {
            string commandtext = "loss_list_Select";
            DataSet ds = new DataSet();
            SqlHelper.FillDataSet(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, ds, new string[] { }, null);
            List<Model.Loss.loss_listModel> li = new List<Model.Loss.loss_listModel>();
            foreach (DataRow dr in ds.Tables[0].Rows)
            {
                Model.Loss.loss_listModel inf = new Model.Loss.loss_listModel();
                inf.loss_id = dr["loss_id"].ToString().Trim();
                inf.loss_list_product_id = dr["loss_list_product_id"].ToString().Trim ();
                inf.loss_list_color = dr["loss_list_color"].ToString();
                inf.loss_list_size1 = (int)dr["loss_list_size1"];
                inf.loss_list_size2 = (int)dr["loss_list_size2"];
                inf.loss_list_size3 = (int)dr["loss_list_size3"];
                inf.loss_list_size4 = (int)dr["loss_list_size4"];
                inf.loss_list_size5 = (int)dr["loss_list_size5"];
                inf.loss_list_size6 = (int)dr["loss_list_size6"];
                inf.loss_list_size7 = (int)dr["loss_list_size7"];
                inf.loss_list_sum = (int)dr["loss_list_sum"];
                li.Add(inf);
            }
            return li;
        }
        #endregion
    }
}