storebll.cs

来自「c#三层架构项目开发的全过程」· CS 代码 · 共 211 行

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Model;
using DAL;
using Model.Stock;

namespace BLL.Store
{
    public class StoreBll
    {
        //DAL.Store.StoreDal dalshow = new DAL.Store.StoreDal();
        DAL.Store.StoreDal dalshow;
        public StoreBll()
        {
            dalshow = new DAL.Store.StoreDal();
        }
        #region 通过采购时间获取单据ID
        /// <summary>
        /// 找出采购单据编号
        /// </summary>
        /// <returns>返回采购单据编号的数据集</returns>
        public List<Model.Stock.Stock_SetailsModel> SelectStockFormIDByTime(DateTime stocktime)
        {
            return dalshow.SelectStockFormIDByTime(stocktime);
        }
        #endregion

        #region 获取单据ID
        /// <summary>
        /// 获取单据ID
        /// </summary>
        /// <returns>返回采购单据编号的数据集</returns>
        public List<Model.Stock.Stock_SetailsModel> SelectStockFormID()
        {
            return dalshow.SelectStockFormID();
        }
        #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)
        {
            return dalshow.SelectStockFormIDwhere(stock_type_id);
        }
        #endregion
        #region 获取仓库ID
        /// <summary>
        /// 找出所有仓库的ID
        /// </summary>
        /// <returns>仓库ID数据集</returns>
        public List<Model.Store.StoreModel> SelectStoreID()
        {
            return dalshow.SelectStoreID();
        }
        #endregion
        #region 获取类型ID（类型名称）
        /// <summary>
        /// 通过单据类型名称查询单据类型ID
        /// </summary>
        /// <param name="stock_type_name"></param>
        /// <returns></returns>
        public int GettypeID(string stock_type_name)
        {
            return dalshow.GettypeID(stock_type_name);
        }
        #endregion
        #region 显示入库单据信息
        /// <summary>
        /// 以通过审核的单据来显示出入库所需字段
        /// </summary>
        /// <param name="stockformid">通过审核的单据</param>
        /// <returns>入库所需字段</returns>
        public List<Model.Stock.Stock_SetailsModel> InsertStoreShow(int stock_type_id, string stockformid)
        {
            return dalshow.InsertStoreShow(stock_type_id, stockformid);
        }
        #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)
        {
            return dalshow.InsertStoreUp(storeid, product_id, store_color, store_size1, store_size2, store_size3, store_size4, store_size5, store_size6, store_size7, store_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)
        {
            return dalshow.OutStoreUp(storeid, product_id, store_color, store_size1, store_size2, store_size3, store_size4, store_size5, store_size6, store_size7, store_sum);
        }
        #endregion
        #region 各种单据入库(无则添加)
        public int InsertStoreInto(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)
        {
            return dalshow.InsertStoreInto(storeid, product_id, store_color, store_size1, store_size2, store_size3, store_size4, store_size5, store_size6, store_size7, store_sum);
        }
        #endregion
        #region 查询该仓库有无该商品（商品名称）
        public int InsertStoreCheck(string product_id, int store_id, string store_color)
        {
            return dalshow.InsertStoreCheck(product_id,store_id,store_color);
        }
        #endregion

        #region 通过商品在库存中的编号，颜色以及库存编号查找尺码是否大于所填写的数据
        /// <summary>
        /// 通过商品在库存中的编号，颜色以及库存编号查找尺码是否大于所填写的数据
        /// </summary>
        /// <param name="stock_id">库存ID（店铺）</param>
        /// <param name="product_id">商品编号</param>
        /// <param name="store_color">商品颜色</param>
        /// <returns></returns>
        public Model.Store.StoreModel SelectStoreByProduct(int stock_id, string product_id, string store_color)
        {
            return dalshow.SelectStoreByProduct(stock_id, product_id, store_color);
        }
        #endregion
        #region 查询仓库所有信息
        /// <summary>
        /// 查询仓库所有信息
        /// </summary>
        /// <returns></returns>
        public List<Model.Store.StoreModel> SelectStoreAll()
        {
            return dalshow.SelectStoreAll();
        }
         #endregion
        #region 获取商品颜色
        /// <summary>
        /// 获取商品颜色
        /// </summary>
        /// <returns></returns>
        public List<Model.Store.StoreModel> GetProductColor()
        {
            return dalshow.GetProductColor();
        }
         #endregion
        #region 修改单据状态-调拨（单据号，状态）
        /// <summary>
        /// 修改单据状态-调拨
        /// </summary>
        /// <param name="remove_id"></param>
        /// <param name="remove_state"></param>
        /// <returns></returns>
        public int Upstate(string remove_id, string remove_state)
        {
            return dalshow.Upstate(remove_id, remove_state);
        }
        #endregion

        #region 修改单据状态-采购（单据号，状态）
        /// <summary>
        /// 修改单据状态-采购
        /// </summary>
        /// <param name="remove_id"></param>
        /// <param name="remove_state"></param>
        /// <returns></returns>
        public int UpstateStock(string StockForm_id, string StockForm_OKText,int Stock_Type_id)
        {
            return dalshow.UpstateStock(StockForm_id, StockForm_OKText, Stock_Type_id);
        }
        #endregion

        #region 修改单据状态-总部发退货（单据号，状态）
        /// <summary>
        /// 修改单据状态
        /// </summary>
        /// <param name="remove_id"></param>
        /// <param name="remove_state"></param>
        /// <returns></returns>
        public int UpstateInvoice(string invoice_id, string invoice_state)
        {
            return dalshow.UpstateInvoice(invoice_id, invoice_state);
        }
        #endregion
    }
}