username@email.com
2025-05-09 66beb245e516809514642c00922f0339bf760518
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
123
124
125
126
127
128
129
130
131
132
133
134
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using CY.IBaseDAL;
using CY.Model;
using CY.Infrastructure.Query;
 
namespace CY.IDAL
{
    /// <summary>
    /// 办公系统意向客户-数据库操作接口
    /// </summary>
    public interface IOA_IntentionCustomerDAL : ICommonDAL, IPaging<OA_IntentionCustomer>, IGetAllModel<OA_IntentionCustomer>
    {
        /// <summary>
        /// 获取最大的customerId
        /// </summary>
        /// <param name="FirmId"></param>
        /// <returns></returns>
        OA_IntentionCustomer getMaxCustomerIdModel(Guid FirmId);
        /// <summary>
        /// 获取所有意向客户列表
        /// </summary>
        /// <param name="FirmId"></param>
        /// <returns></returns>
        IEnumerable<Model.OA_IntentionCustomer> getAllIntentionCustomer(Guid FirmId);
        /// <summary>
        /// 根据Keyid获取单个客户
        /// </summary>
        /// <param name="Keyid"></param>
        /// <returns></returns>
        OA_IntentionCustomer getSingleIntentionCustomer(string Keyid);
        /// <summary>
        /// 判断公司名字是否存在
        /// </summary>
        /// <param name="CompanyName"></param>
        /// <returns></returns>
        bool isExistCompanyName(String CompanyName, Guid FirmId, int ID);
        /// <summary>
        /// 获取查询集合
        /// </summary>
        /// <param name="FirmId"></param>
        /// <param name="CompanyName"></param>
        /// <param name="beginTime"></param>
        /// <param name="endTime"></param>
        /// <returns></returns>
        IEnumerable<Model.OA_IntentionCustomer> getAllIntentionCustomer(Pagination pa, Guid FirmId, string CompanyName, DateTime? beginTime, DateTime? endTime
                                                                             , string SourcesInfoId, string CustomerIndustriesId
                                                                              , string AccountManagerId, string BusinessManagerId
                                                                               , string CustomerTypeId, string TurnoverIntentionId
                                                                               , string CustomerStatusId, string DegreeImportanId
                                                                                , string Province, string City, string County);
        /// <summary>
        /// 模糊查询公司名称
        /// </summary>
        /// <param name="CompanyName"></param>
        /// <param name="FirmId"></param>
        /// <returns></returns>
        IEnumerable<Model.OA_IntentionCustomer> SelectListByName(String CompanyName, Guid FirmId);
        /// <summary>
        /// 意向客户访问记录
        /// </summary>
        /// <param name="pa"></param>
        /// <param name="FirmId"></param>
        /// <param name="CompanyName"></param>
        /// <param name="beginTime"></param>
        /// <param name="endTime"></param>
        /// <param name="SourcesInfoId"></param>
        /// <param name="CustomerIndustriesId"></param>
        /// <param name="AccountManagerId"></param>
        /// <param name="BusinessManagerId"></param>
        /// <param name="CustomerTypeId"></param>
        /// <param name="TurnoverIntentionId"></param>
        /// <param name="CustomerStatusId"></param>
        /// <param name="DegreeImportanId"></param>
        /// <param name="Province"></param>
        /// <param name="City"></param>
        /// <param name="County"></param>
        /// <param name="selNupdoor"></param>
        /// <param name="Nupdoor"></param>
        /// <param name="selNphone"></param>
        /// <param name="Nphone"></param>
        /// <param name="selNqq"></param>
        /// <param name="Nqq"></param>
        /// <param name="selNmessage"></param>
        /// <param name="Nmessage"></param>
        /// <param name="selNemial"></param>
        /// <param name="Nemial"></param>
        /// <param name="selNDirectMail"></param>
        /// <param name="NDirectMail"></param>
        /// <param name="selNall"></param>
        /// <param name="Nall"></param>
        /// <returns></returns>
        IEnumerable<Model.OA_IntentionCustomer> getAllIntentionCustomerList(Pagination pa,
            Guid FirmId,
            string CompanyName,
            DateTime? beginTime,
            DateTime? endTime,
            string SourcesInfoId,
            string CustomerIndustriesId,
            string AccountManagerId,
            string BusinessManagerId,
            string CustomerTypeId,
            string TurnoverIntentionId,
            string CustomerStatusId,
            string DegreeImportanId,
            string Province,
            string City,
            string County,
            string selNupdoor,
            string Nupdoor,
            string selNphone,
            string Nphone,
            string selNqq,
            string Nqq,
            string selNmessage,
            string Nmessage,
            string selNemial,
            string Nemial,
            string selNDirectMail,
            string NDirectMail,
            string selNall,
            string Nall
            );
 
        /// <summary>
        /// 根据客户编号获取客户
        /// </summary>
        /// <param name="Keyid">客户编号</param>
        /// <returns></returns>
        IEnumerable<OA_IntentionCustomer> SelectListListByCustomId(string Keyid, Guid MemberId);
    }
}