提交

username@email.com

2025-05-21 a980cd04341d71216e0f59bd4b7327fe9fc50032

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using CY.IBaseDAL;
using CY.Model;
using CY.Infrastructure.Query;
using CY.Model.Inquiry;
 
namespace CY.IDAL.Inquiry
{
    /// <summary>
    /// 纸张相关数据库操作接口
    /// </summary>
    public interface IPaperInfoDAL : ICommonDAL
    {
        /// <summary>
        /// 分页获取纸张列表
        /// </summary>
        /// <param name="paperName">品牌名称</param>
        /// <param name="pa">分页参数</param>
        /// <returns></returns>
        IEnumerable<SysInquiry_PaperInfo> GetPaperListByPaging(string paperName,int paperTypeId,string status, Pagination pa);
 
        /// <summary>
        /// 获取纸张类型下的所有有效纸张
        /// </summary>
        /// <param name="paperTypeId"></param>
        /// <returns></returns>
        IEnumerable<SysInquiry_PaperInfo> GetPaperListByPaperType(int paperTypeId);
 
        /// <summary>
        /// 根据paperId获取纸张信息
        /// </summary>
        /// <param name="paperId"></param>
        /// <returns></returns>
        IEnumerable<SysInquiry_PaperInfo> GetPaperList(int paperId);
 
        /// <summary>
        /// 根据paperId获取其对应的品牌列表
        /// </summary>
        /// <param name="paperId"></param>
        /// <returns></returns>
        IEnumerable<SysInquiry_BrandInfo> GetBrandInfoListByPaper(int paperId);
 
        /// <summary>
        /// 判断是否有相同的纸扎名称
        /// </summary>
        /// <param name="brandName"></param>
        /// <returns></returns>
        bool IsExistspeperName(string peperName);
 
        /// <summary>
        /// 获取最新的纸张编号
        /// </summary>
        /// <returns></returns>
        int GetNewPaperId();
 
        /// <summary>
        /// 新增纸张
        /// </summary>
        /// <param name="modelList"></param>
        /// <returns></returns>
        bool InsertPaper(IList<SysInquiry_PaperInfo> modelList,IList<SysInquiry_BrandListByPaper> brandList);
 
        /// <summary>
        /// 修改纸张
        /// </summary>
        /// <param name="modelList"></param>
        /// <returns></returns>
        bool UpdatePaper(IList<SysInquiry_PaperInfo> modelList, IList<SysInquiry_BrandListByPaper> brandList);
 
        /// <summary>
        /// 获取有效的纸张列表(不包括自带纸)
        /// </summary>
        /// <returns></returns>
        IEnumerable<SysInquiry_PaperInfo> GetPaperList();
        /// <summary>
        /// 获取有效的纸张列表(包括自带纸)
        /// </summary>
        /// <returns></returns>
        IEnumerable<SysInquiry_PaperInfo> GetAllPaperList();
 
        /// <summary>
        /// 根据纸张Id和品牌ID获取纸价列表
        /// </summary>
        /// <param name="paperId"></param>
        /// <param name="firmId"></param>
        /// <param name="customerId"></param>
        /// <returns></returns>
        IEnumerable<Inquiry_PaperPriceInfo> GetAllPaperPriceList(int paperId, int brandId, Guid inquiryId);
 
        /// <summary>
        /// 根据纸张Id和品牌ID保存纸价
        /// </summary>
        /// <param name="modelList"></param>
        /// <returns></returns>
        bool SavePaperPrice(List<Inquiry_PaperPriceInfo> modelList, InquiryCondition inquiryCondition);
 
        /// <summary>
        /// 获取纸张的吨价
        /// </summary>
        /// <param name="paperId"></param>
        /// <param name="gramWeight"></param>
        /// <param name="brandId"></param>
        /// <returns></returns>
        decimal GetTonsOfPrice(int paperId, int gramWeight, int brandId, Guid inquiryId);
 
         /// <summary>
        /// 获取纸张的品牌列表，第一个是默认品牌
        /// </summary>
        /// <param name="paperId"></param>
        /// <returns></returns>
        IList<SysInquiry_BrandInfo> GetBrandInfoByPaper(int paperId);
 
        /// <summary>
        /// 获取最新排序顺序
        /// </summary>
        /// <returns></returns>
        int GetOrderNumByMax(int paperTypeId);
    }
}