数据库连接

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
105
106
107
108
109
110
111
112
113
114
115
116
117
118
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using CY.Model;
using CY.Infrastructure.Common;
using CY.BLL.OA;
using CY.BLL.Sys;
 
namespace CY.WebForm.Pages.financial
{
    public partial class FirmAccountExpensesEdit : BasePage
    {
        Sys_DictionaryBLL _Sys_DictionaryBLL = null;
        OA_SubjectSetBLL _OA_SubjectSetBLL = null;
        OA_FirmAccountBLL _OA_FirmAccountBLL = null;
        OA_FirmAccountRecordBLL _OA_FirmAccountRecordBLL = null;
        OA_FirmAccountRecord firmAccountRecord = null;
        OA_FirmAccount firmAccount = null;
 
        public FirmAccountExpensesEdit()
        {
            firmAccount = new OA_FirmAccount();
            _Sys_DictionaryBLL = new Sys_DictionaryBLL();
            _OA_FirmAccountBLL = new OA_FirmAccountBLL();
            _OA_FirmAccountRecordBLL = new OA_FirmAccountRecordBLL();
            _OA_SubjectSetBLL = new OA_SubjectSetBLL();
            firmAccountRecord = new OA_FirmAccountRecord();
        }
 
        protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                switch (Request["DataType"])
                {
                    case "change":
                        Response.Write(reLoadAccountName(Request["TypeName"].ToString2()));
                        break;
                    default://一般情况不处理
                        if (IsPostBack || IsCallback)
                            return;
                        else
                        {
                            InitialData();
                        }
                        return;
                }
            }
            catch (Exception ex)
            {
                PAGEHandleException(ex);
                Response.Clear();
                Response.Write("-1");
            }
            Response.End();
        }
 
        protected void InitialData()
        {
            //科目名称
            selSubject.DataSource = _OA_SubjectSetBLL.getAllSubject(CurrentUser.MemberId, "贷");
            selSubject.DataBind();
            selSubject.Items.Insert(0, new ListItem("请选择", ""));
 
            ///账户类型
            selAcoountType.DataSource = _Sys_DictionaryBLL.GetDataByType("账户类型");
            selAcoountType.DataBind();
        }
 
        protected string reLoadAccountName(string selAcoountType)
        {
            return JsonHelper.GetJsonStringByObject(_OA_FirmAccountBLL.getAllSubject(CurrentUser.MemberId, selAcoountType));
        }
 
        protected void btn_Submit_Click(object sender, EventArgs e)
        {
            try
            {
                firmAccount = _OA_FirmAccountBLL.getSingleSubject(Request["selAccountName"].ToInt32());
 
                firmAccountRecord.AccountId = Request["selAccountName"].ToInt32();
                firmAccountRecord.LastUpdateTime = DateTime.Now;
                firmAccountRecord.Money = this.txtMoney.Value.ToDecimal2();
                firmAccountRecord.OperationalMatters = this.txtOperationalMatters.Value;
                firmAccountRecord.Operator = CurrentUser.ShortName;
                firmAccountRecord.PaymentUnit = this.txtPaymentUnit.Value;
                firmAccountRecord.RecordTypeId = 2;//支出
                firmAccountRecord.Remark = this.txtRemark.Value;
                firmAccountRecord.SubjectId = this.selSubject.Value.ToInt32();
                firmAccountRecord.ResidualAmount = firmAccount.Balance - this.txtMoney.Value.ToDecimal2();
                firmAccountRecord.Department = this.txtDepartment.Value;
 
                firmAccount.AllExpenses = this.txtMoney.Value.ToDecimal2() + firmAccount.AllExpenses;
                firmAccount.Balance = firmAccount.Balance - this.txtMoney.Value.ToDecimal2();
 
                if (_OA_FirmAccountRecordBLL.AddModel(firmAccountRecord, firmAccount))
                {
                    this.selSubject.Value = "";
                    this.txtMoney.Value = "";
                    this.txtDepartment.Value = "";
                    this.txtPaymentUnit.Value = "";
                    this.txtOperationalMatters.Value = "";
                    JavaScript.MessageBox("添加成功", this, false, true);
                }
                else
                    JavaScript.MessageBox("添加失败", this);
            }
            catch (Exception ex)
            {
                PAGEHandleException(ex);
                JavaScript.MessageBox("添加失败", this);
            }
        }
    }
}