C#编写的KTV系统（附access数据库）

C#编写的KTV系统

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using KTV.KTVclass;
using System.Data.OleDb;
namespace KTV
{
    public partial class frmAuton : Form
    {
        public frmAuton（）
        {
            InitializeComponent（）;
        }
        public frmAuton（int intcuntstring strId）
        {
            InitializeComponent（）;
            intFalg = intcunt;
            strgetId = strId;
        }
        public int intFalg = 0;
        public string strgetId = null;
        frmdictionaryMenthod frmDictiyon = new frmdictionaryMenthod（）;
        tb_authorinfo tbAu = new tb_authorinfo（）;
        tb_authorinfoMenthod tbAuMenthod = new tb_authorinfoMenthod（）;
        private void frmAuton_Load（object sender EventArgs e）
        {
            frmDictiyon.dictionaryFind（“1“cmbauthorcompany）;
         
            if （intFalg == 1）
            {
                txtauthorId.Text = tbAuMenthod.gettb_authorinfoID（）;
            }
            if （intFalg == 2）
            {
                getFill（）;
            }

         }

        public void getFill（）
        {
            OleDbDataReader dr = tbAuMenthod.AuthFind（strgetId）;
            dr.Read（）;
            if （dr.HasRows）
            {
                txtauthorId.Text = dr[0].ToString（）;
                txtauthorName.Text=dr[1].ToString（）;
                cmbauthorSex.Text=dr[2].ToString（）;
                daAuthorbirthday.Value=Convert.ToDateTime（dr[3].ToString（））;
                comboBox2.Text=dr[4].ToString（）;
               cmbauthorcompany.Text=dr[5].ToString（）;
                txtauthorRecma.Text=dr[6].ToString（）;
                  txtauthorzjm.Text=dr[7].ToString（）;
           
            }
            dr.Close（）;
        }
        private void bntSure_Click（object sender EventArgs e）
        {
            if （txtauthorName.Text == ““）
            {
                MessageBox.Show（“姓名不能为空“）;
                return;
            }
            tbAu.intauthorId = txtauthorId.Text;
            tbAu.strauthorName = txtauthorName.Text;
            tbAu.strauthorSex = cmbauthorSex.Text;
            tbAu.daauthorbirthday = daAuthorbirthday.Value;
            tbAu.strauthorGenre = comboBox2.Text;
            tbAu.strauthorcompany = cmbauthorcompany.Text;
            tbAu.strauthorRecma = txtauthorRecma.Text;
            tbAu.strauthorzjm = txtauthorzjm.Text;
            tbAu.daRdateTime = DateTime.Now;
            if （intFalg == 1）
            {
                if （tbAuMenthod.AuthAdd（tbAu） == 1）
                {
                    MessageBox.Show（“添加成功！“）;
                    frmMain frm = （frmMain）this.Owner;
                    tbAuMenthod.tb_authorinfoFill（“2“frm.lvAuton）;
                    intFalg = 0;
                    this.Close（）;

                }
                else
        

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----

    ..A..H.     95232  2020-08-12 11:56  KTV\KTV\.vs\KTV\v14\.suo

    ..A..H.     92672  2021-02-03 09:58  KTV\KTV\.vs\KTV\v15\.suo

     文件          0  2021-02-03 09:56  KTV\KTV\.vs\KTV\v15\Server\sqlite3\db.lock

     文件       4096  2021-02-03 09:56  KTV\KTV\.vs\KTV\v15\Server\sqlite3\storage.ide

     文件      32768  2021-02-03 09:56  KTV\KTV\.vs\KTV\v15\Server\sqlite3\storage.ide-shm

     文件     650992  2021-02-03 09:56  KTV\KTV\.vs\KTV\v15\Server\sqlite3\storage.ide-wal

     文件        798  2008-11-29 14:00  KTV\KTV\Backup\KTV\app.config

     文件     929792  2008-11-29 14:01  KTV\KTV\Backup\KTV\Database\db_KTV.mdb

     文件       9430  2008-11-29 14:00  KTV\KTV\Backup\KTV\frmAuton.cs

     文件      11824  2008-11-29 14:00  KTV\KTV\Backup\KTV\frmAuton.Designer.cs

     文件       5814  2008-11-29 14:00  KTV\KTV\Backup\KTV\frmAuton.resx

     文件       3136  2008-11-29 14:00  KTV\KTV\Backup\KTV\frmDaiGe.cs

     文件       8583  2008-11-29 14:00  KTV\KTV\Backup\KTV\frmDaiGe.Designer.cs

     文件       5814  2008-11-29 14:00  KTV\KTV\Backup\KTV\frmDaiGe.resx

     文件       2886  2008-11-29 14:00  KTV\KTV\Backup\KTV\frmdictionary.cs

     文件       5836  2008-11-29 14:00  KTV\KTV\Backup\KTV\frmdictionary.Designer.cs

     文件       5814  2008-11-29 14:00  KTV\KTV\Backup\KTV\frmdictionary.resx

     文件       2253  2008-11-29 14:00  KTV\KTV\Backup\KTV\frmLogin.cs

     文件       6738  2008-11-29 14:00  KTV\KTV\Backup\KTV\frmLogin.Designer.cs

     文件       5814  2008-11-29 14:00  KTV\KTV\Backup\KTV\frmLogin.resx

     文件      12361  2008-11-29 14:00  KTV\KTV\Backup\KTV\frmMain.cs

     文件      27913  2008-11-29 14:00  KTV\KTV\Backup\KTV\frmMain.Designer.cs

     文件       5814  2008-11-29 14:00  KTV\KTV\Backup\KTV\frmMain.resx

     文件      10339  2008-11-29 14:00  KTV\KTV\Backup\KTV\frmMusicinfo.cs

     文件      11479  2008-11-29 14:00  KTV\KTV\Backup\KTV\frmMusicinfo.Designer.cs

     文件       6010  2008-11-29 14:00  KTV\KTV\Backup\KTV\frmMusicinfo.resx

     文件       4676  2008-11-29 14:00  KTV\KTV\Backup\KTV\frmNumber.cs

     文件       3907  2008-11-29 14:00  KTV\KTV\Backup\KTV\frmNumber.Designer.cs

     文件       5814  2008-11-29 14:00  KTV\KTV\Backup\KTV\frmNumber.resx

     文件       1515  2008-11-29 14:00  KTV\KTV\Backup\KTV\frmPlay.cs

............此处省略186个文件信息