PSI.DAL/SaleOutStoreDAL.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>
        /// 销售单DAL处理类
        /// </summary>
        public class SaleOutStoreDAL:BaseDAL<SaleOutStoreInfoModel>
        {
                SaleGoodsDAL sgDAL = new SaleGoodsDAL();
                ViewSaleGoodsDAL vsgDAL = new ViewSaleGoodsDAL();

                /// <summary>
                /// 获取指定的销售单信息
                /// </summary>
                /// <param name="saleId"></param>
                /// <returns></returns>
                public SaleOutStoreInfoModel GetSaleOutStoreInfo(int saleId)
                {
                        string cols = "SaleId,SaleOutNo,UnitId,StoreId,DealPerson,PayDesp,ThisAmount,YHAmount,Creator,CreateTime,IsChecked,Remark,TotalAmount,IsPayed,IsPayFull";
                        return GetById(saleId, cols);
                }

                /// <summary>
                /// 添加销售单
                /// </summary>
                /// <param name="saleInfo"></param>
                /// <param name="saleGoodsList"></param>
                /// <returns>销售单编号 与 销售单号</returns>
                public string AddSaleOutStoreInfo(SaleOutStoreInfoModel saleInfo, List<SaleGoodsInfoModel> saleGoodsList)
                {
                        //销售单表的列名
                        string cols = "UnitId,StoreId,DealPerson,PayDesp,ThisAmount,Remark,TotalAmount,YHAmount,SaleOutNo,Creator,CreateTime";
                        if (saleInfo.PayTime != null)
                                cols += ",PayTime,IsPayed,IsPayFull";
                        //插入销售商品列表的列名
                        string sgCols = "SaleId,GoodsId,GUnit,Count,SalePrice,Amount,Remark";
                        //生成销售单号---保存销售单信息--保存销售商品明细列表
                        return SqlHelper.ExecuteTrans<string>(cmd =>
                        {
                                try
                                {
                                        //获取生成的销售单号
                                        cmd.CommandText = "makeSaleNo";
                                        cmd.CommandType = CommandType.StoredProcedure;
                                        object saleNo = cmd.ExecuteScalar();
                                        cmd.Parameters.Clear();
                                        if (saleNo != null && saleNo.ToString() != "")
                                        {
                                                //保存销售单