• 大小: 2.74MB
    文件类型: .rar
    金币: 1
    下载: 0 次
    发布日期: 2023-09-08
  • 语言: 数据库
  • 标签: ktv  

资源简介

北大青鸟的s1毕业作业,KTV项目,有支持数据库,有前台和后台,采用sql数据库,visual2012版编写的代码

资源截图

代码片段和文件信息

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
        

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

     文件        800  2009-05-25 15:34  第一版KTV\app.config

     文件        800  2009-05-25 15:34  第一版KTV\Backup\app.config

     文件     929792  2009-05-25 13:08  第一版KTV\Backup\DB_51aspx\db_KTV.mdb

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

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

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

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

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

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

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

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

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

     文件       2317  2009-05-25 13:03  第一版KTV\Backup\frmLogin.cs

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

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

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

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

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

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

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

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

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

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

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

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

     文件       4736  2008-11-29 14:00  第一版KTV\Backup\frmPlay.Designer.cs

     文件       6713  2008-11-29 14:00  第一版KTV\Backup\frmPlay.resx

     文件       7597  2009-05-25 15:50  第一版KTV\Backup\KTV.csproj

     文件        535  2008-11-29 14:00  第一版KTV\Backup\KTV.csproj.user

     文件       6264  2008-11-29 14:00  第一版KTV\Backup\KTVclass\frmdictionaryMenthod.cs

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

评论

共有 条评论