storedal.cs

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

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

namespace DAL.Store
{
    public class StoreDal
    {
        #region 获取单据ID
        /// <summary>
        /// 获取单据ID
        /// </summary>
        /// <returns>返回采购单据编号的数据集</returns>
        public List<Model.Stock.Stock_SetailsModel> SelectStockFormID()
        {
            string commandtext = "StockFormID_Select";
            DataSet ds = new DataSet();
            SqlHelper.FillDataSet(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, ds, new string[] { }, null);
            List<Model.Stock.Stock_SetailsModel> li = new List<Model.Stock.Stock_SetailsModel>();
            foreach (DataRow dr in ds.Tables[0].Rows)
            {
                Model.Stock.Stock_SetailsModel inf = new Model.Stock.Stock_SetailsModel();
                inf.stockform_id = dr["StockForm_id"].ToString();
                li.Add(inf);
            }
            return li;
        }
        #endregion
        #region 通过采购时间获取单据ID
        /// <summary>
        /// 通过采购时间获取单据ID
        /// </summary>
        /// <returns>返回采购单据编号的数据集</returns>
        public  List<Model.Stock.Stock_SetailsModel> SelectStockFormIDByTime(DateTime stocktime)
        {
            string commandtext = "StockFormID_Select";
            SqlParameter time = new SqlParameter("@StockForm_time",SqlDbType.DateTime);
            time.Value = stocktime;
            DataSet ds = new DataSet();
            SqlHelper.FillDataSet(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, ds, new string[] { }, new SqlParameter[]{time});
            List<Model.Stock.Stock_SetailsModel> li = new List<Model.Stock.Stock_SetailsModel>();
            foreach (DataRow dr in ds.Tables[0].Rows)
            {
                Model.Stock.Stock_SetailsModel inf = new Model.Stock.Stock_SetailsModel();
                inf.stockform_id = dr["StockForm_id"].ToString();
                li.Add(inf);
            }
            return li;
        }
        #endregion
        #region 获取单据ID（带参数）
        /// <summary>
        /// 通过单据类型ID获取类型单据
        /// </summary>
        /// <param name="stock_type_id">提供单据类型</param>
        /// <returns></returns>
        public List<Model.Stock.Stock_SetailsModel> SelectStockFormIDwhere(int stock_type_id)
        {
            string commandtext = "StockFormID_SelectWhere";
            SqlParameter xstock_type_id = new SqlParameter("@Stock_Type_id", SqlDbType.Int);
            xstock_type_id.Value = stock_type_id;
            DataSet ds = new DataSet();
            SqlHelper.FillDataSet(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, ds, new string[] { }, new SqlParameter[] { xstock_type_id });
            List<Model.Stock.Stock_SetailsModel> li = new List<Model.Stock.Stock_SetailsModel>();
            foreach (DataRow dr in ds.Tables[0].Rows)
            {
                Model.Stock.Stock_SetailsModel inf = new Model.Stock.Stock_SetailsModel();
                inf.stockform_id = dr["StockForm_id"].ToString();
                li.Add(inf);
            }
            return li;
        }
        #endregion
        #region 获取仓库ID
        /// <summary>
        /// 找出所有仓库的ID
        /// </summary>
        /// <returns>仓库ID数据集</returns>
        public List<Model.Store.StoreModel> SelectStoreID()
        {
            string commandtext = "StoreID_Select";
            DataSet ds = new DataSet();
            SqlHelper.FillDataSet(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, ds, new string[] { },null);
            List<Model.Store.StoreModel> li = new List<Model.Store.StoreModel>();
            foreach (DataRow item in ds.Tables[0].Rows)
            {
                Model.Store.StoreModel inf = new Model.Store.StoreModel();
                inf.store_id = (int)item["Shop_id"];
                li.Add(inf);
                
            }
            return li;
        }
        #endregion
        #region 获取类型ID（类型名称）
        /// <summary>
        /// 通过单据类型名称查询单据类型ID
        /// </summary>
        /// <param name="stock_type_name"></param>
        /// <returns></returns>
        public int GettypeID(string stock_type_name)
        {
            string commandtext = "get_stocktypeid";
            SqlParameter xtypename = new SqlParameter("Stock_Type_Name", SqlDbType.VarChar, 10);
            xtypename.Value = stock_type_name;

            DataSet ds = new DataSet();
            SqlHelper.FillDataSet(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, ds, new string[] { }, new SqlParameter[] { xtypename });
            Model.Store.StoreModel mo = new Model.Store.StoreModel();
            foreach (DataRow item in ds.Tables[0].Rows)
            {
               
                 mo.store_type = (int)item["Stock_Type_id"];
            }
            int x = mo.store_type;
            return x;
        }
        #endregion
        #region 显示入库单据信息
        /// <summary>
        /// 以通过审核的单据来显示出入库所需字段
        /// </summary>
        /// <returns>入库所需字段</returns>
        public List<Model.Stock.Stock_SetailsModel> InsertStoreShow(int stock_type_id,string stockformid)
        {
            string commandtext = "Stock_Setails_ViewShow";
            //从DropDownList中获取单据号
            SqlParameter xstockformid = new SqlParameter("@StockForm_id", SqlDbType.Char, 20);
            xstockformid.Value = stockformid;
            SqlParameter xstock_type_id = new SqlParameter("@Stock_Type_id", SqlDbType.Int);
            xstock_type_id.Value = stock_type_id;

            DataSet ds = new DataSet();
            SqlHelper.FillDataSet(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, ds, new string[] { }, new SqlParameter[] { xstockformid, xstock_type_id });
            List<Model.Stock.Stock_SetailsModel> li = new List<Model.Stock.Stock_SetailsModel>();
            foreach (DataRow item in ds.Tables[0].Rows)
            {
                Model.Stock.Stock_SetailsModel inf = new Model.Stock.Stock_SetailsModel();
                inf.product_id = item["product_id"].ToString();
                inf.product_name = item["product_name"].ToString();
                inf.stock_setails_s1 = (int)item["stock_setails_s1"];
                inf.stock_setails_s2 = (int)item["stock_setails_s2"];
                inf.stock_setails_s3 = (int)item["stock_setails_s3"];
                inf.stock_setails_s4 = (int)item["stock_setails_s4"];
                inf.stock_setails_s5 = (int)item["stock_setails_s5"];
                inf.stock_setails_s6 = (int)item["stock_setails_s6"];
                inf.stock_setails_s7 = (int)item["stock_setails_s7"];
                inf.stock_setails_brand = item["brand_Name"].ToString();
                inf.stock_setails_color = item["stock_setails_color"].ToString();
                inf.stock_setails_sum = (int)item["stock_setails_sum"];

                li.Add(inf);
            }
            return li;
        }
        #endregion
        #region 各种单据入库(有则修改)
        /// <summary>
        /// 各种单据入库
        /// </summary>
        /// <param name="storeid">仓库ID</param>
        /// <param name="product_id">商品ID</param>
        /// <param name="store_color">商品颜色</param>
        /// <param name="store_size1">尺码32</param>
        /// <param name="store_size2">尺码33</param>
        /// <param name="store_size3">尺码34</param>
        /// <param name="store_size4">尺码35</param>
        /// <param name="store_size5">尺码36</param>
        /// <param name="store_size6">尺码37</param>
        /// <param name="store_size7">尺码38</param>
        /// <param name="store_sum">该行产品数量</param>
        /// <returns>入库</returns>
        public int InsertStoreUp(int storeid, string product_id, string store_color, int store_size1, int store_size2, int store_size3,int store_size4,int store_size5,int store_size6,int store_size7,int store_sum)
        {
            string commandtext = "InsertStoreUp";
            SqlParameter xstore_id = new SqlParameter("@Store_id", SqlDbType.Int);
            SqlParameter xproduct_id = new SqlParameter("@product_id",SqlDbType.Char,20);
            SqlParameter xstore_color = new SqlParameter("@Store_color",SqlDbType.VarChar,10);
            SqlParameter xstore_size1 = new SqlParameter("@Store_size1",SqlDbType.Int);
            SqlParameter xstore_size2 = new SqlParameter("@Store_size2",SqlDbType.Int);
            SqlParameter xstore_size3 = new SqlParameter("@Store_size3",SqlDbType.Int);
            SqlParameter xstore_size4 = new SqlParameter("@Store_size4",SqlDbType.Int);
            SqlParameter xstore_size5 = new SqlParameter("@Store_size5",SqlDbType.Int);
            SqlParameter xstore_size6 = new SqlParameter("@Store_size6",SqlDbType.Int);
            SqlParameter xstore_size7 = new SqlParameter("@Store_size7",SqlDbType.Int);
            SqlParameter xstore_sum = new SqlParameter("@Store_sum", SqlDbType.Int);
            xstore_id.Value = storeid;
            xproduct_id.Value = product_id.Trim();
            xstore_color.Value = store_color.Trim();
            xstore_size1.Value = store_size1;
            xstore_size2.Value = store_size2;
            xstore_size3.Value = store_size3;
            xstore_size4.Value = store_size4;
            xstore_size5.Value = store_size5;
            xstore_size6.Value = store_size6;
            xstore_size7.Value = store_size7;
            xstore_sum.Value = store_sum;
            return SqlHelper.ExecuteNonQuery(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, new SqlParameter[] { xstore_id, xproduct_id,xstore_color,xstore_size1, xstore_size2, xstore_size3, xstore_size4, xstore_size5, xstore_size6, xstore_size7, xstore_sum });
        }
        #endregion
        #region 各种单据出库
        /// <summary>
        /// 各种单据出库
        /// </summary>
        /// <param name="storeid"></param>
        /// <param name="product_id"></param>
        /// <param name="store_color"></param>
        /// <param name="store_size1"></param>
        /// <param name="store_size2"></param>
        /// <param name="store_size3"></param>
        /// <param name="store_size4"></param>
        /// <param name="store_size5"></param>
        /// <param name="store_size6"></param>
        /// <param name="store_size7"></param>
        /// <param name="store_sum"></param>
        /// <returns></returns>
        public int OutStoreUp(int storeid, string product_id, string store_color, int store_size1, int store_size2, int store_size3, int store_size4, int store_size5, int store_size6, int store_size7, int store_sum)
        {