Backup/RearchForm.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

  //添加引用

namespace FamilyFinance
{
    public partial class RearchForm : Form
    {
        DBhelper dbh = new DBhelper();
        MainForm mf = new MainForm();
        public RearchForm()
        {
            InitializeComponent();
        }

        private void btnResearch_Click(object sender, EventArgs e)
        {
         
         

            string startDate = cmbBeginYear.Text + '-' + cmbBeginMonth.Text + '-' + cmbEndDay.Text;
            string endDate = cmbEndYear.Text + '-' + cmbEndMonth.Text + '-' + cmbEndDay.Text;


            if (rdbDate.Checked)
            {
                txtSignleAmount.Text = ""; //将单个收入总金额设置为空
                string sql = string.Format("SELECT * FROM Consumption WHERE consumptDate Between '{0}' AND '{1}' ", startDate, endDate);

                dgwResearch.DataSource = dbh.GetTable(sql);

                //取得区间的总收入与总支出


                double receiveTotal = dbh.GetSpanMoney("收入", startDate, endDate);

                double consumptTotal = dbh.GetSpanMoney("支出", startDate, endDate);

                txtFindIn.Text = Convert.ToString(receiveTotal); //总收入
                txtFindOut.Text = Convert.ToString(consumptTotal);//总支出
                txtFindSpan.Text = Convert.ToString(receiveTotal - consumptTotal);//总收入-总支出＝差额
                if (receiveTotal - consumptTotal >= 0)
                {
                    txtFindSpan.ForeColor = Color.Goldenrod;

                }
                else
                {
                    txtFindSpan.ForeColor = Color.Red;

                }