C# 记账小软件源码（附数据库）

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.SqlClient;
namespace WindowsFormsApp1
{
  public  class DBHelper
    {
        public static string constring = “server=127.0.0.1\\MSSQLSERVER2;database=accountBook;uid=sa;pwd=1625862412“;
        public static SqlConnection con = null;
        public static SqlCommand cmd = null;
        public static bool sqlOpen（string sql） 
        {
            try
            {
                con = new SqlConnection（constring）;
                cmd = new SqlCommand（sql con）;
                con.Open（）;
                int count = 0;
                if （sql.Contains（“insert“） == true && sql.Contains（“update“） == true && sql.Contains（“delete“） == true）
                {
                    count = cmd.ExecuteNonQuery（）;
                    if （count > 0）
                    {
                        return true;
                    }
                    else 
                    {
                        return false;
                    }
                }
                else if（sql.Contains（“COUNT“））
                {
                    count =Convert.ToInt32（ cmd.ExecuteScalar（））;
                    if （count > 0）
                    {
                        return true;
                    }
                    else 
                    {
                        return false;
                    }
                }
                else
                {
                 SqlDataReader hehe  = cmd.ExecuteReader（）;
                    if （hehe != null）
                    {
                        return true;
                    }
                    else 
                    {
                        return false;
                    }
                }
            }
            catch （Exception）
            {
                return false;
            }
        }
    }
}