-
大小: 2.88MB文件類型: .rar金幣: 2下載: 1 次發(fā)布日期: 2023-10-26
- 語(yǔ)言: 其他
- 標(biāo)簽:
資源簡(jiǎn)介
有詳細(xì)的系統(tǒng)設(shè)計(jì)和文檔資料,提供分享~
這個(gè)旅游訂票管理系統(tǒng)主要是處理旅客買票,訂票,退票,以及各類查詢結(jié)算。該系統(tǒng)針對(duì)的用戶是單個(gè)中小型門票銷售部門,由于門票銷售,查詢以及計(jì)算各天或者不同時(shí)間段的收入比較繁瑣,此系統(tǒng)方便簡(jiǎn)單的實(shí)現(xiàn)了這些功能,使得管理員與職工方便很多,讓這個(gè)門票銷售都變得條條有理。

代碼片段和文件信息
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?數(shù)據(jù)庫(kù)設(shè)計(jì)
{
????public?partial?class?booking?:?Form
????{
????????string?this_name_admin;
????????public?booking(?Form1?booking1string?admin_name)
????????{
????????????this_name_admin?=?admin_name;
????????????InitializeComponent();
????????????id.Text?=?this_name_admin;
????????}
????????private?void?button1_Click(object?sender?EventArgs?e)
????????{
???????????
????????????string?s?=?“DATAbase=menpiaoxitong;SERVER=localhost;uid=sa;pwd=123;“;
?????????????SqlConnection?conn?=?new?SqlConnection(s);
????????????int?i;
????????????string?sql1?=?“select?count(status)?from?everyday?where?status=‘成功‘or?status=‘預(yù)定‘“;
????????????SqlCommand?cmd1?=?new?SqlCommand(sql1?conn);
????????????conn.Open();
????????????string?num?=?cmd1.ExecuteScalar().ToString?();
????????????conn.Close();
????????????
????????????if?(Convert?.ToInt32?(num)<=12)
????????????{
????????????for?(i?=?1;?i?<=?Convert.ToInt32(piaoshu.Text?);?i++)
????????????{
???????????????
????????????????string?sql?=?“Insert?into?everyday(staff_idbuyerpricevipdatatimetime_intstatusmarkingremarks)?Values(‘“?+?id.Text?+?“‘‘“?+?buyer.SelectedItem?+?“‘‘0‘‘“?+?vip.SelectedItem?+?“‘‘“?+?DateTime.Now.ToString()?+?“‘‘“?+?DateTime.Now.ToShortDateString()?+?“‘‘預(yù)定‘‘1‘‘“?+?name.Text?+?shenfen_id.Text?+?“‘)“;
????????????????SqlCommand?cmd?=?new?SqlCommand(sql?conn);
????????????????conn.Open();
????????????????try
????????????????{
????????????????????cmd.ExecuteNonQuery();
???????????????????
????????????????}
????????????????catch?(Exception?ex)
????????????????{
????????????????????if?(ex?!=?null)?MessageBox.Show(“系統(tǒng)沒(méi)被啟用!請(qǐng)正常啟用系統(tǒng)!“);
????????????????}
????????????????conn.Close();
????????????}
????????????MessageBox.Show(“訂票中!“);
????????????
????????????Close();
????????????}
????????????else?{?MessageBox.Show(“今日票已經(jīng)售完!“);?}
????????}
????????private?void?booking_Load(object?sender?EventArgs?e)
????????{
????????????string?s?=?“DATAbase=menpiaoxitong;SERVER=localhost;uid=sa;pwd=123?“;
????????????SqlConnection?conn?=?new?SqlConnection(s);
????????????string?sql1?=?“select?count(status)?from?everyday?where?status=‘成功‘or?status=‘預(yù)定‘“;
????????????SqlCommand?cmd1?=?new?SqlCommand(sql1?conn);
????????????conn.Open();
????????????sold.Text?=?cmd1.ExecuteScalar().ToString();
????????????conn.Close();
????????????sold.Text?=?Convert.ToString(100?-?Convert.ToInt32(sold.Text));
????????????if?(?Convert.ToInt32(sold.Text)?10)?MessageBox.Show(“請(qǐng)注意,今日的票數(shù)剩下不到十張!“);
????????}
???????
????}
}
?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????文件???????3957??2010-05-06?11:04??旅游訂票數(shù)據(jù)庫(kù)設(shè)計(jì)\u=37764171862520732257&fm=3&gp=0.jpg
?????文件???????1652??2010-05-06?11:09??旅游訂票數(shù)據(jù)庫(kù)設(shè)計(jì)\u=8423356481994022508&fm=3&gp=0.jpg
?????文件?????288477??2010-05-11?23:02??旅游訂票數(shù)據(jù)庫(kù)設(shè)計(jì)\截圖1272812565.png
?????文件??????96289??2010-05-11?23:00??旅游訂票數(shù)據(jù)庫(kù)設(shè)計(jì)\截圖1273500663.png
?????文件??????44507??2010-05-11?23:00??旅游訂票數(shù)據(jù)庫(kù)設(shè)計(jì)\截圖1273500721.png
?????文件?????376166??2010-05-11?23:07??旅游訂票數(shù)據(jù)庫(kù)設(shè)計(jì)\截圖1273590439.png
?????文件????1048576??2010-04-27?15:48??旅游訂票數(shù)據(jù)庫(kù)設(shè)計(jì)\數(shù)據(jù)庫(kù)文檔\menpiaoxitong_Data.MDF
?????文件????1048576??2010-04-27?15:48??旅游訂票數(shù)據(jù)庫(kù)設(shè)計(jì)\數(shù)據(jù)庫(kù)文檔\menpiaoxitong_Log.LDF
?????文件?????155136??2010-06-01?23:14??旅游訂票數(shù)據(jù)庫(kù)設(shè)計(jì)\數(shù)據(jù)庫(kù)文檔\數(shù)據(jù)庫(kù)設(shè)計(jì).doc
?????文件??????72704??2010-05-12?14:11??旅游訂票數(shù)據(jù)庫(kù)設(shè)計(jì)\數(shù)據(jù)庫(kù)文檔\需求分析說(shuō)明書2.doc
?????文件????????719??2010-05-04?15:13??旅游訂票數(shù)據(jù)庫(kù)設(shè)計(jì)\數(shù)據(jù)庫(kù)設(shè)計(jì)\app.config
?????文件?????541696??2010-05-12?16:59??旅游訂票數(shù)據(jù)庫(kù)設(shè)計(jì)\數(shù)據(jù)庫(kù)設(shè)計(jì)\bin\Debug\數(shù)據(jù)庫(kù)設(shè)計(jì).exe
?????文件????????719??2010-05-04?15:13??旅游訂票數(shù)據(jù)庫(kù)設(shè)計(jì)\數(shù)據(jù)庫(kù)設(shè)計(jì)\bin\Debug\數(shù)據(jù)庫(kù)設(shè)計(jì).exe.config
?????文件?????269824??2010-05-12?16:59??旅游訂票數(shù)據(jù)庫(kù)設(shè)計(jì)\數(shù)據(jù)庫(kù)設(shè)計(jì)\bin\Debug\數(shù)據(jù)庫(kù)設(shè)計(jì).pdb
?????文件??????14328??2010-05-12?17:00??旅游訂票數(shù)據(jù)庫(kù)設(shè)計(jì)\數(shù)據(jù)庫(kù)設(shè)計(jì)\bin\Debug\數(shù)據(jù)庫(kù)設(shè)計(jì).vshost.exe
?????文件????????719??2010-05-04?15:13??旅游訂票數(shù)據(jù)庫(kù)設(shè)計(jì)\數(shù)據(jù)庫(kù)設(shè)計(jì)\bin\Debug\數(shù)據(jù)庫(kù)設(shè)計(jì).vshost.exe.config
?????文件????????490??2009-06-11?05:14??旅游訂票數(shù)據(jù)庫(kù)設(shè)計(jì)\數(shù)據(jù)庫(kù)設(shè)計(jì)\bin\Debug\數(shù)據(jù)庫(kù)設(shè)計(jì).vshost.exe.manifest
?????文件???????2907??2010-05-12?14:26??旅游訂票數(shù)據(jù)庫(kù)設(shè)計(jì)\數(shù)據(jù)庫(kù)設(shè)計(jì)\booking.cs
?????文件??????11681??2010-05-10?01:09??旅游訂票數(shù)據(jù)庫(kù)設(shè)計(jì)\數(shù)據(jù)庫(kù)設(shè)計(jì)\booking.Designer.cs
?????文件???????5814??2010-05-10?01:09??旅游訂票數(shù)據(jù)庫(kù)設(shè)計(jì)\數(shù)據(jù)庫(kù)設(shè)計(jì)\booking.resx
?????文件???????1126??2010-05-09?19:53??旅游訂票數(shù)據(jù)庫(kù)設(shè)計(jì)\數(shù)據(jù)庫(kù)設(shè)計(jì)\buyer_check.cs
?????文件???????5560??2010-05-09?19:53??旅游訂票數(shù)據(jù)庫(kù)設(shè)計(jì)\數(shù)據(jù)庫(kù)設(shè)計(jì)\buyer_check.Designer.cs
?????文件???????5814??2010-05-09?19:53??旅游訂票數(shù)據(jù)庫(kù)設(shè)計(jì)\數(shù)據(jù)庫(kù)設(shè)計(jì)\buyer_check.resx
?????文件??????77035??2010-04-20?20:36??旅游訂票數(shù)據(jù)庫(kù)設(shè)計(jì)\數(shù)據(jù)庫(kù)設(shè)計(jì)\data_designDataSet.Designer.cs
?????文件??????????3??2010-04-20?20:36??旅游訂票數(shù)據(jù)庫(kù)設(shè)計(jì)\數(shù)據(jù)庫(kù)設(shè)計(jì)\data_designDataSet.xsc
?????文件??????14020??2010-04-20?20:36??旅游訂票數(shù)據(jù)庫(kù)設(shè)計(jì)\數(shù)據(jù)庫(kù)設(shè)計(jì)\data_designDataSet.xsd
?????文件??????????3??2010-04-20?20:36??旅游訂票數(shù)據(jù)庫(kù)設(shè)計(jì)\數(shù)據(jù)庫(kù)設(shè)計(jì)\data_designDataSet.xss
?????文件???????7352??2010-05-12?17:00??旅游訂票數(shù)據(jù)庫(kù)設(shè)計(jì)\數(shù)據(jù)庫(kù)設(shè)計(jì)\Form1.cs
?????文件??????33085??2010-05-11?23:08??旅游訂票數(shù)據(jù)庫(kù)設(shè)計(jì)\數(shù)據(jù)庫(kù)設(shè)計(jì)\Form1.Designer.cs
?????文件?????637725??2010-05-11?23:08??旅游訂票數(shù)據(jù)庫(kù)設(shè)計(jì)\數(shù)據(jù)庫(kù)設(shè)計(jì)\Form1.resx
............此處省略125個(gè)文件信息
評(píng)論
共有 條評(píng)論