数据库连接

username@email.com

2022-01-21 b18a7c8e54b51a5caa400e55cb8cc428c0301a0c

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
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_FirmAccountRecordDAL : ICommonDAL, IPaging<OA_FirmAccountRecord>, IGetAllModel<OA_FirmAccountRecord>
    {
        /// <summary>
        /// 分页查询
        /// </summary>
        /// <param name="pa"></param>
        /// <param name="FirmId"></param>
        /// <param name="RegTimeStart"></param>
        /// <param name="RegTimeEnd"></param>
        /// <param name="AccountName"></param>
        /// <param name="AcoountType"></param>
        /// <param name="Operator"></param>
        /// <param name="SubjectId"></param>
        /// <param name="RecordTypeId"></param>
        /// <param name="PaymentUnit"></param>
        /// <param name="OperationalMatters"></param>
        /// <returns></returns>
        IEnumerable<Model.OA_FirmAccountRecord> SelectModelPage(Pagination pa, Guid FirmId, DateTime? RegTimeStart, DateTime? RegTimeEnd, string AccountName, string AcoountType, string Operator, string SubjectId, string RecordTypeId, string PaymentUnit, string OperationalMatters);
 
        /// <summary>
        /// 金额统计
        /// </summary>
        /// <param name="pa"></param>
        /// <param name="FirmId"></param>
        /// <param name="RegTimeStart"></param>
        /// <param name="RegTimeEnd"></param>
        /// <param name="AccountName"></param>
        /// <param name="AcoountType"></param>
        /// <param name="Operator"></param>
        /// <param name="SubjectId"></param>
        /// <param name="RecordTypeId"></param>
        /// <param name="PaymentUnit"></param>
        /// <returns></returns>
        Model.OA_FirmAccountRecord SumRecordMoney(Pagination pa, Guid FirmId, DateTime? RegTimeStart, DateTime? RegTimeEnd, string AccountName, string AcoountType, string Operator, string SubjectId, string RecordTypeId, string PaymentUnit);
 
        /// <summary>
        /// 获取单个账户支出收益表
        /// </summary>
        /// <param name="Keyid"></param>
        /// <param name="FirmId"></param>
        /// <returns></returns>
        Model.OA_FirmAccountRecord SelectSingleModel(string Keyid, Guid FirmId);
 
        /// <summary>
        /// 添加收入/支出记录
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        bool AddModel(OA_FirmAccountRecord model, OA_FirmAccount m_OA_FirmAccount);
 
        /// <summary>
        /// 添加收入/支出记录,并更改会员状态
        /// </summary>
        /// <param name="model"></param>
        /// <param name="m_OA_FirmAccount"></param>
        /// <param name="memberBasic"></param>
        /// <returns></returns>
        bool AddModel(OA_FirmAccountRecord model, OA_FirmAccount m_OA_FirmAccount, EC_MemberBasic memberBasic, EC_PaymentRecord paymentRecord);
 
 
        /// <summary>
        /// 账户转账
        /// </summary>
        /// <param name="m_OA_FirmAccountIn"></param>
        /// <param name="m_OA_FirmAccountOut"></param>
        /// <param name="m_OA_FirmAccountRecordIn"></param>
        /// <param name="m_OA_FirmAccountRecordOut"></param>
        /// <returns></returns>
        bool AccountOToO(OA_FirmAccount m_OA_FirmAccountIn, OA_FirmAccount m_OA_FirmAccountOut, OA_FirmAccountRecord m_OA_FirmAccountRecordIn, OA_FirmAccountRecord m_OA_FirmAccountRecordOut);
 
        /// <summary>
        /// 订单收款
        /// </summary>
        /// <param name="accountId">账户编号</param>
        /// <param name="money">操作金额</param>
        /// <param name="subjectId">科目编号</param>
        /// <param name="payTime">支付时间</param>
        /// <param name="PaymentUnit">支付方</param>
        /// <param name="Operator">操作人</param>
        /// <returns></returns>
        bool OrderReceivables(int? accountId, decimal? money, int? subjectId, DateTime? payTime, string PaymentUnit, string Operator);
 
        /// <summary>
        /// 更具ID数据获取列表
        /// </summary>
        /// <param name="FirmId"></param>
        /// <param name="keyids"></param>
        /// <returns></returns>
        IEnumerable<Model.OA_FirmAccountRecord> SelectModelListByKeyids(Guid FirmId, string keyids);
    }
}