Backup/addInOut.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 addInOut : Form
    {
        DBhelper dbh = new DBhelper();
        public addInOut()
        {
            InitializeComponent();
        }

        private void label4_Click(object sender, EventArgs e)
        {

        }

        private void btnAdd_Click(object sender, EventArgs e)
        {
            



            string addFormDate = cmbAddYear.Text + '-' + cmbAddMonth.Text + '-' + cmbAddDay.Text;
           // MessageBox.Show(addFormDate);
            string sql = string.Format("Insert into Consumption ( consumptDate,[type],category,consumptMoney,description) Values('{0}','{1}','{2}',{3},'{4}' )",

                addFormDate, cmbAddCategory.Text,cmbAddItem.Text, txtAddAmount.Text.Trim(), txtAddNotes.Text.Trim());

            SqlCommand sqlCmd = new SqlCommand(sql, dbh.sqlConn);
            dbh.sqlConn.Open();
            int effAccount = sqlCmd.ExecuteNonQuery();
            if (effAccount > 0)
            {
                MessageBox.Show("数据添加成功！");


            }
            else
            {
                MessageBox.Show("数据添加失败，请检查服务器");
            }
            dbh.sqlConn.Close();
           
           
        }

        private void addInOut_Load(object sender, EventArgs e)
        {
            //初始化年月日
            for (int i = 1970; i < 2060; i++)