PSI.DAL/StockStoreDAL.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using PSI.Common;
using PSI.DbUtility;
using PSI.Models.DModels;
using PSI.Models.VModels;
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace PSI.DAL
{
        public class StockStoreDAL : BaseDAL<StockStoreInfoModel>
        {
                StStockGoodsDAL sgDAL = new StStockGoodsDAL();
                ViewStStockGoodsDAL vssgDAL = new ViewStStockGoodsDAL();
                /// <summary>
                ///    获取指定的入库单信息
                /// </summary>
                /// <param name="stockId"></param>
                /// <returns></returns>
                public StockStoreInfoModel GetStockInfo(int stockId)
                {
                        string cols = "StockId,StockNo,StoreId,DealPerson,Creator,CreateTime,IsChecked,Remark";
                        return GetById(stockId, cols);
                }

                /// <summary>
                /// 添加入库单
                /// </summary>
                /// <param name="stockInfo"></param>
                /// <param name="stockGoodsList"></param>
                /// <returns>入库单编号 与 入库单号</returns>
                public string AddStockInfo(StockStoreInfoModel stockInfo, List<StStockGoodsInfoModel> stockGoodsList)
                {
                        //入库单表的列名
                        string cols = "StoreId,DealPerson,Remark,StockNo,Creator,CreateTime";
                        //插入期初库存商品列表的列名
                        string sgCols = "StockId,GoodsId,StCount,StPrice,StAmount,Remark";
                        //生成入库单号---保存入库单信息--保存入库商品明细列表
                        return SqlHelper.ExecuteTrans<string>(cmd =>
                        {
                                try
                                {
                                        //获取生成的入库单号
                                        cmd.CommandText = "makeStockNo";
                                        cmd.CommandType = CommandType.StoredProcedure;
                                        object stockNo = cmd.ExecuteScalar();
                                        cmd.Parameters.Clear();
                                        if (stockNo != null && stockNo.ToString() != "")
                                        {
                                                //保存入库单
                                                stockInfo.StockNo = stockNo.ToString();
                                                SqlModel inStock = CreateSql.GetInsertSqlAndParas<StockStoreInfoModel>(stockInfo, cols, 1);
                                                cmd.CommandText = inStock.Sql;
                                                foreach (var p in inStock.SqlParaArray)
                                                {
                                                        cmd.Parameters.Add(p);