username@email.com
2025-05-14 99ddfbcecf0fa2881eb3a91028257eef87dab6de
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
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using CY.IDAL;
using CY.Model;
using AbstractFactory;
using CY.IBaseDAL;
using CY.Infrastructure.DESEncrypt;
using CY.Infrastructure.Query;
 
namespace CY.BLL
{
    /// <summary>
    /// 客户预付款记录的业务逻辑类
    /// </summary>
    public class OA_AdvanceMoneyRecordBLL
    {
        IOA_AdvanceMoneyRecordDAL _IOA_AdvanceMoneyRecordDal = null;
        /// <summary>
        /// 初始化构造
        /// </summary>
        public OA_AdvanceMoneyRecordBLL()
        {
            //获取OA_AdvanceMoneyRecord DAL实现
            _IOA_AdvanceMoneyRecordDal = Factory.GetDALByInterfaceName(DALInterface.IOA_AdvanceMoneyRecordDAL) as IOA_AdvanceMoneyRecordDAL;
        }
 
        /// <summary>
        /// 新增客户预付款记录
        /// </summary>
        /// <param name="m_OA_AdvanceMoneyRecord"></param>
        /// <returns></returns>
        public bool InsertModel(CY.Model.OA_AdvanceMoneyRecord m_OA_AdvanceMoneyRecord)
        {
            try
            {
                return _IOA_AdvanceMoneyRecordDal.InserModel( m_OA_AdvanceMoneyRecord);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
 
        /// <summary>
        /// 删除客户预付款记录
        /// </summary>
        /// <param name="rType"></param>
        /// <returns></returns>
        public bool DeleteModel(CY.Model.OA_AdvanceMoneyRecord rType)
        {
            try
            {
                _IOA_AdvanceMoneyRecordDal.DeleteModel(rType);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return true;
        }
         
        /// <summary>
        /// 根据客户编号查询客户预付款记录分页列表
        /// </summary>
        /// <param name="pa"></param>
        /// <param name="CustomerId"></param>
        /// <returns></returns>
        public IEnumerable<OA_AdvanceMoneyRecord> GetModelPageListForCustomer(Pagination pa, Guid CustomerId,DateTime? beginTime, DateTime? endTime, string Money)
        {
            string Condition = " CustomerId ='" + CustomerId + "' and OperatTypeId = '预付款存入'";
            if (beginTime.HasValue)
            {
                Condition += string.Format(" and CAST(LastUpdateTime AS DATE) >='{0}'", beginTime);
            }
 
            if (endTime.HasValue)
            {
                Condition += string.Format(" and CAST(LastUpdateTime AS DATE) <='{0}'", endTime);
            }
            if (!string.IsNullOrEmpty(Money))
            {
                Condition += string.Format(" and   OperatMoney='{0}'", Money);
            }
            Query query = new Query();
            IList<Criterion> criterias = new List<Criterion>()
            {
                new Criterion("", Condition),
                new Criterion("orderBy"," LastUpdateTime DESC ")
            };
            query.Criteria = criterias;
            return _IOA_AdvanceMoneyRecordDal.SelectModelPage(query, pa); 
        }
 
        /// <summary>
        /// 根据客户编号查询客户预付款记录分页列表
        /// </summary>
        /// <param name="pa"></param>
        /// <param name="CustomerId"></param>
        /// <returns></returns>
        public IEnumerable<OA_AdvanceMoneyRecord> GetModelPageList(Pagination pa, Guid CustomerId)
        {
            string Condition = " CustomerId ='" + CustomerId + "'";
 
            Query query = new Query();
            IList<Criterion> criterias = new List<Criterion>()
            {
                new Criterion("", Condition),
                new Criterion("orderBy"," LastUpdateTime DESC ")
            };
            query.Criteria = criterias;
            return _IOA_AdvanceMoneyRecordDal.SelectModelPage(query, pa);
        }
 
        /// <summary>
        /// 预付款存入
        /// </summary>
        /// <param name="m_OA_FirmAccount"></param>
        /// <param name="m_OA_CorporateClients"></param>
        /// <param name="m_OA_FirmAccountRecord"></param>
        /// <param name="m_OA_AdvanceMoneyRecord"></param>
        /// <returns></returns>
        public bool DepositsMoney(OA_FirmAccount m_OA_FirmAccount, OA_CorporateClients m_OA_CorporateClients, OA_FirmAccountRecord m_OA_FirmAccountRecord, OA_AdvanceMoneyRecord m_OA_AdvanceMoneyRecord)
        {
            return _IOA_AdvanceMoneyRecordDal.DepositsMoney(m_OA_FirmAccount, m_OA_CorporateClients, m_OA_FirmAccountRecord, m_OA_AdvanceMoneyRecord);
        }
    }
}