PSI.DAL/PerchaseInStoreDAL.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
{
        /// <summary>
        /// 关于采购单的处理类
        /// </summary>
       public  class PerchaseInStoreDAL:BaseDAL<PerchaseInStoreInfoModel>
        {
                PerchaseGoodsDAL pgDAL = new PerchaseGoodsDAL();
                ViewPerChaseGoodsDAL vpgDAL = new ViewPerChaseGoodsDAL();
                /// <summary>
                /// 添加采购单
                /// </summary>
                /// <param name="perchaseInfo"></param>
                /// <param name="perGoodsList"></param>
                /// <returns>采购单编号 与 采购单号</returns>
                public string AddPerchaseInfo(PerchaseInStoreInfoModel perchaseInfo, List<PerchaseGoodsInfoModel> perGoodsList)
                {
                        //采购单表的列名
                        string cols = "UnitId,StoreId,DealPerson,PayDesp,ThisAmount,Remark,TotalAmount,YHAmount,PerchaseNo,Creator,CreateTime";
                        if (perchaseInfo.PayTime != null)
                                cols += ",PayTime,IsPayed,IsPayFull";
                        //插入采购商品列表的列名
                        string sgCols = "PerId,GoodsId,GUnit,Count,PerPrice,Amount,Remark";
                        //生成采购单号---保存采购单信息--保存采购商品明细列表
                        return SqlHelper.ExecuteTrans<string>(cmd =>
                        {
                                try
                                {
                                        //获取生成的采购单号
                                        cmd.CommandText = "makePerNo";
                                        cmd.CommandType = CommandType.StoredProcedure;
                                        object perNo = cmd.ExecuteScalar();
                                        cmd.Parameters.Clear();
                                        if (perNo != null && perNo.ToString() != "")
                                        {
                                                //保存入库单
                                                perchaseInfo.PerchaseNo = perNo.ToString();
                                                SqlModel inStock = CreateSql.GetInsertSqlAndParas<PerchaseInStoreInfoModel>(perchaseInfo, cols, 1);
                                                cmd.CommandText = inStock.Sql;
                                                foreach (var p in inStock.SqlParaArray)
                                                {
                                                        cmd.Parameters.Add(p);
                                                }
                                                cmd.CommandType = CommandType.Text;
                                                object oPerId = cmd.ExecuteScalar();
                                                cmd.Parameters.Clear();

                                                if (oPerId != null && oPerId.GetInt() > 0)