bp(net core)+easyui+efcore实现仓储管理系统——入库管理之二(三十八)

时间：2023-03-08 19:19:02
bp(net core)+easyui+efcore实现仓储管理系统——入库管理之二(三十八)

abp(net core)+easyui+efcore实现仓储管理系统目录

abp(net core)+easyui+efcore实现仓储管理系统——EasyUI前端页面框架 (十八)

abp(net core)+easyui+efcore实现仓储管理系统——ABP WebAPI与EasyUI结合增删改查之八(三十四)

在上一篇文章abp(net core)+easyui+efcore实现仓储管理系统——入库管理之一(三十七)中我们创建了入库单的实体类，并使用CodeFirst功能创建了数据库表，接下我们来创建一些有关与入库单有关的DTO类与查询分页类。

四、定义应用服务接口需要用到的DTO类

为了在进行查询入库单表头，我们需要创建, PagedInStockResultRequestDto类，用来将查询条件数据传递到基础设施层.

1. 在Visual Studio 2017的“解决方案资源管理器”中，右键单击“ABP.TPLMS.Application”项目，在弹出菜单中选择“添加” > “新建文件夹”，并重命名为“InStocks”

2. 使用鼠标右键单击我们刚才创建的“InStocks”文件夹，在弹出菜单中选择“添加” > “新建文件夹”，并重命名为“Dto”。

3．右键单击“Dto”文件夹，然后选择“添加” > “类”。 将类命名为 Paged InStockResultRequestDto，然后选择“添加”。代码如下。

using Abp.Application.Services.Dto;

using System;

using System.Collections.Generic;

using System.Text; 

namespace ABP.TPLMS.InStocks.Dto

{

    public class PagedInStockResultRequestDto : PagedResultRequestDto

    {

        public string Keyword { get; set; }

        public string InStockNo { get; set; }

        public DateTime BeginTime { get; set; }

        DateTime m_EndTime;

        /// <summary>

        /// 查询截止日期，如果当前时间小于100年前，就给一个默认日期（明天）

        /// </summary>

        public DateTime EndTime { get

            {

                if (m_EndTime < DateTime.Now.AddYears(-))

                    return DateTime.Now.AddDays();

                else

                    return m_EndTime;

                    }            

            set

            {

                m_EndTime = value;

            }

                }

        public string OwnerName { get; set; }

        public string No { get; set; }

    }

}

4．右键单击“Dto”文件夹，然后选择“添加” > “类”。 将类命名为 PagedInStockDetailResultRequestDto，然后选择“添加”。此类根据入库单单号查询入库单的明细数据。代码如下。

using Abp.Application.Services.Dto;

using System;

using System.Collections.Generic;

using System.Text;

namespace ABP.TPLMS.InStocks.Dto

{

    public class PagedInStockDetailResultRequestDto : PagedResultRequestDto

    {

        public string Keyword { get; set; }

        public string InStockNo { get; set; }  

    }

}

5．右键单击“Dto”文件夹，然后选择“添加” > “类”。 将类命名为 PagedInStockDetailLocResultRequestDto，然后选择“添加”。此类根据入库单明细的ID查询入库单某条明细数据的库位信息。代码如下。

using Abp.Application.Services.Dto;

using System;

using System.Collections.Generic;

using System.Text;

namespace ABP.TPLMS.InStocks.Dto

{

    public class PagedInStockDetailLocResultRequestDto : PagedResultRequestDto

    {

        public string Keyword { get; set; }

        public int InStockOrderDetailId { get; set; }  

    }

}

6．右键单击“Dto”文件夹，然后选择“添加” > “类”。 将类命名为 InStockOrderDto，然后选择“添加”。代码如下。

using Abp.Application.Services.Dto;

using Abp.AutoMapper;

using ABP.TPLMS.Entitys;

using System;

using System.Collections.Generic;

using System.Text;

namespace ABP.TPLMS.InStocks.Dto

{

    [AutoMapFrom(typeof(InStockOrder))]

    public class InStockOrderDto : EntityDto<int>

    {

        public string No { get; set; }

        /// <summary>

        /// 客户名称

        /// </summary>

        public string CustomerName { get; set; }

        public string WarehouseType { get; set; }

        /// <summary>

        /// 客户代码

        /// </summary>

        public string CustomerCode { get; set; }

        /// <summary>

        /// 送货单号

        /// </summary>

        public string DeliveryNo { get; set; }

        /// <summary>

        /// 仓库号

        /// </summary>

        public string WarehouseNo { get; set; }

        /// <summary>

        /// 货主

        /// </summary>

        public string OwnerName { get; set; }

        /// <summary>

        /// 毛重

        /// </summary>

        public decimal Gwt { get; set; }

        public decimal Nwt { get; set; }

        public int PackageQty { get; set; }

        /// <summary>

        /// 接收时间

        /// </summary>

        public string ReceiveTime { get; set; }

        /// <summary>

        /// 接收人

        /// </summary>

        public string Receiver { get; set; }

        public string Oper { get; set; }

        public int Status { get; set; }

        public string OwnerCode { get; set; }

        /// <summary>

        /// 预计送货时间

        /// </summary>

        public string PreDeliveryTime { get; set; }

        /// <summary>

        /// 审核人

        /// </summary>

        public string Checker { get; set; }

        public string CheckTime { get; set; }

        public string Remark { get; set; }

        public DateTime CreationTime { get; set; }

        public string LastUpdateTime { get; set; }

        public string LastOper { get; set; }

        public List<InStockOrderDetailDto> InStockOrderDetail { get; set; }

    } 

}

7．右键单击“Dto”文件夹，然后选择“添加” > “类”。 将类命名为 CreateUpdateInStockOrderDto，然后选择“添加”。代码如下。

using Abp.Application.Services.Dto;

using Abp.AutoMapper;

using ABP.TPLMS.Entitys;

using System;

using System.Collections.Generic;

using System.ComponentModel.DataAnnotations;

using System.Text;

namespace ABP.TPLMS.InStocks.Dto

{

    [AutoMapTo(typeof(InStockOrder))]

    public  class CreateUpdateInStockOrderDto : EntityDto<int>

    {

        public const int MaxLength = ;

        [StringLength()]

        [Required]

        public string No { get; set; }

        /// <summary>

        /// 客户名称

        /// </summary>

        [StringLength(MaxLength)]

        [Required]

        public string CustomerName { get; set; } 

        public string WarehouseType { get; set; }

        /// <summary>

        /// 客户代码

        /// </summary>

        [StringLength()]

        [Required]

        public string CustomerCode { get; set; }

        /// <summary>

        /// 送货单号

        /// </summary>

        public string DeliveryNo { get; set; }

        /// <summary>

        /// 仓库号

        /// </summary>

        public string WarehouseNo { get; set; }

        /// <summary>

        /// 货主

        /// </summary>

        [StringLength(MaxLength)]

        [Required]

        public string OwnerName { get; set; }

        public decimal Gwt { get; set; }

        public decimal Nwt { get; set; }

        public int PackageQty { get; set; }

        /// <summary>

        /// 接收时间

        /// </summary>

        [StringLength()]

        public string ReceiveTime { get; set; }

        /// <summary>

        /// 接收人

        /// </summary>

        [StringLength()]

        public string Receiver { get; set; }

        [StringLength()]

        public string Oper { get; set; }

        public int Status { get; set; }

    [StringLength()]

        public string OwnerCode { get; set; }

        /// <summary>

        /// 预计送货时间

        /// </summary>

        [StringLength()]

        public string PreDeliveryTime { get; set; }

        /// <summary>

        /// 审核人

        /// </summary>

        [StringLength()]

        public string Checker { get; set; }

        [StringLength()]

        public string CheckTime { get; set; }

        [StringLength()]

        public string Remark { get; set; }

        public DateTime CreationTime { get; set; }

        [StringLength()]

        public string LastUpdateTime { get; set; }

        [StringLength()]

        public string LastOper { get; set; }

        public List<CreateUpdateInStockOrderDetailDto> InStockOrderDetail { get; set; }

    }

}
   8. 重复上面的第6-7步，我们来创建InStockDetailDto与CreateUpdateInStockDetailDto、InStockDetailLocDto与CreateUpdateInStockDetailLocDto。

8.1 InStockDetailDto

using Abp.Application.Services.Dto;

using Abp.AutoMapper;

using Abp.Domain.Entities;

using Abp.Domain.Entities.Auditing;

using ABP.TPLMS.Entitys;

using System;

using System.Collections.Generic;

using System.ComponentModel.DataAnnotations;

using System.ComponentModel.DataAnnotations.Schema;

using System.Text;

namespace ABP.TPLMS.InStocks.Dto

{

    [AutoMapFrom(typeof(InStockOrderDetail))]

    public class InStockOrderDetailDto : EntityDto<int>

    {        

        public int SupplierId { get; set; }      

        public string CargoCode { get; set; }

        public string HSCode { get; set; }

        public string CargoName { get; set; }

        public string Spcf { get; set; }        

        public string Unit { get; set; }

        public string Country { get; set; }

        public string Brand { get; set; }

        public string Curr { get; set; }

        public string Package { get; set; }

        public decimal Length { get; set; }

        public decimal Width { get; set; }

        public decimal Height { get; set; }

        public decimal Vol { get; set; } 

        public decimal Price { get; set; }

        public decimal TotalAmt { get; set; }

        public decimal GrossWt { get; set; }

        public decimal NetWt { get; set; }

        public DateTime CreationTime { get; set; }      

        public string InStockNo { get; set; }

        public int SeqNo { get; set; }

        public decimal Qty { get; set; }

        public decimal LawfQty { get; set; }

        public decimal SecdLawfQty { get; set; }      

        public string LawfUnit { get; set; }

        public string SecdLawfUnit { get; set; }        

        public string Batch { get; set; }

        public int DeliveryOrderDetailId { get; set; }

        [NotMapped]

        public List<InStockOrderDetailLoc> InStockOrderDetailLoc { get; set; }

    }

}

8.2 CreateUpdateInStockDetailDto

using Abp.Application.Services.Dto;

using Abp.AutoMapper;

using Abp.Domain.Entities;

using Abp.Domain.Entities.Auditing;

using ABP.TPLMS.Entitys;

using System;

using System.Collections.Generic;

using System.ComponentModel.DataAnnotations;

using System.ComponentModel.DataAnnotations.Schema;

using System.Text;

namespace ABP.TPLMS.InStocks.Dto

{

    [AutoMapTo(typeof(InStockOrderDetail))]

    public class CreateUpdateInStockOrderDetailDto : EntityDto<int>

    {

        public const int MaxLength = ;

        public int SupplierId { get; set; }

        [MaxLength()]

        public string CargoCode { get; set; }

        [MaxLength()]

        public string HSCode { get; set; }

        [MaxLength(MaxLength)]

        public string CargoName { get; set; }

        [MaxLength(MaxLength)]

        public string Spcf { get; set; }

        [MaxLength()]

        public string Unit { get; set; }

        [MaxLength()]

        public string Country { get; set; }

        [MaxLength()]

        public string Brand { get; set; }

        [MaxLength()]

        public string Curr { get; set; }

        [MaxLength()]

        public string Package { get; set; }

        public decimal Length { get; set; }

        public decimal Width { get; set; }

        public decimal Height { get; set; }

        public decimal Vol { get; set; }

        public decimal Price { get; set; }

        public decimal TotalAmt { get; set; }

        public decimal GrossWt { get; set; }

        public decimal NetWt { get; set; }

         public DateTime CreationTime { get; set; }

        [MaxLength()]

        public string InStockNo { get; set; }

        public int SeqNo { get; set; }

        public decimal Qty { get; set; }

        public decimal LawfQty { get; set; }

        public decimal SecdLawfQty { get; set; }

        [MaxLength()]

        public string LawfUnit { get; set; }

        [MaxLength()]

        public string SecdLawfUnit { get; set; }

        [MaxLength()]

        public string Batch { get; set; }

        public int DeliveryOrderDetailId { get; set; }

         [NotMapped]

        public List<InStockOrderDetailLoc> InStockOrderDetailLoc { get; set; }

     }

}

8.3  InStockDetailLocDto

using Abp.Application.Services.Dto;

using Abp.AutoMapper;

using Abp.Domain.Entities;

using Abp.Domain.Entities.Auditing;

using ABP.TPLMS.Entitys;

using System;

using System.Collections.Generic;

using System.ComponentModel.DataAnnotations;

using System.Text;

namespace ABP.TPLMS.InStocks.Dto

{

   public class InStockOrderDetailLocDto :  EntityDto<int>

    {

         [AutoMapFrom(typeof(InStockOrderDetailLoc))]

        public InStockOrderDetailLocDto()

        {

            this.Qty = ;

            this.SeqNo = ;

            this.Loc = string.Empty;

            this.CreationTime = DateTime.Now;

            this.InStockOrderDetailId = ;

        }     

        public int InStockOrderDetailId { get; set; }

        public int SeqNo { get; set; }

        public string Loc { get; set; }

        public decimal Qty { get; set; }

        public DateTime CreationTime { get; set; }

    }

}

8.4  CreateUpdateInStockDetailLocDto。

using Abp.Application.Services.Dto;

using Abp.AutoMapper;

using Abp.Domain.Entities;

using Abp.Domain.Entities.Auditing;

using ABP.TPLMS.Entitys;

using System;

using System.Collections.Generic;

using System.ComponentModel.DataAnnotations;

using System.Text;

namespace ABP.TPLMS.InStocks.Dto

{

   public class CreateUpdateInStockOrderDetailLocDto : EntityDto<int>

    {

        [AutoMapTo(typeof(InStockOrderDetailLoc))]

        public CreateUpdateInStockOrderDetailLocDto()

        {

            this.Qty = ;

            this.SeqNo = ;

            this.Loc = string.Empty;

            this.CreationTime = DateTime.Now;

            this.InStockOrderDetailId = ;

        }

       public int InStockOrderDetailId { get; set; }

        public int SeqNo { get; set; }

        [StringLength()]

        public string Loc { get; set; }

        public decimal Qty { get; set; }

        public DateTime CreationTime { get; set; }

    }

}