-
大小: 59KB文件類型: .rar金幣: 2下載: 0 次發(fā)布日期: 2021-05-22
- 語言: C#
- 標(biāo)簽: c#??飛機(jī)系統(tǒng)??
資源簡介
包括了增三改操作,c#飛機(jī)訂票的查詢,增加,退訂等相關(guān)的內(nèi)容

代碼片段和文件信息
using?System;
using?System.Collections.Generic;
using?System.ComponentModel;
using?System.Data;
using?System.Drawing;
using?System.Text;
using?System.Windows.Forms;
using?System.Data.SqlClient;
namespace?WindowsApplication4
{
????public?partial?class?Form1?:?Form
????{
????????public?Form1()
????????{
????????????InitializeComponent();
????????}
????????private?void?button1_Click(object?sender?EventArgs?e)??????//查詢錄入查詢
????????{
????????????listView1.Items.Clear();
????????????bool?banduan?=?true;
????????????string?chufa?=?textBox1.Text.Trim();
????????????string?mudi?=?textBox2.Text.Trim();
????????????string?qifei?=?maskedTextBox1.Text.Trim();
????????????string?hangban?=?textBox3.Text.Trim();
????????????if?(chufa.Length?==?0?||?mudi.Length?==?0)
????????????{
????????????????if?(chufa.Length?==?0)?{?label28.Visible?=?true;?label28.Text?=?“不能為空!“;?}
????????????????if?(mudi.Length?==?0)?{?label29.Visible?=?true;?label29.Text?=?“不能為空!“;?}
????????????}
????????????else
????????????{
????????????????string?connstr?=?“Data?Source=WWW-0F1C1E941A1;Initial?Catalog=fly;Integrated?Security=True“;
????????????????SqlConnection?conn?=?new?SqlConnection(connstr);
????????????????conn.Open();
????????????????string?sqlStr2?=?“select?*?from?Flight;“;
????????????????SqlCommand?cmd2?=?new?SqlCommand(sqlStr2?conn);
????????????????SqlDataReader?dr?=?cmd2.ExecuteReader();
????????????????while?(dr.Read())
????????????????{
????????????????????string?c0?=?dr[0].ToString();?string?c1?=?dr[1].ToString();?string?c2?=?dr[2].ToString();?string?c3?=?dr[3].ToString();
????????????????????if?(hangban?==?c0?&&?chufa?==?c1?&&?mudi?==?c2?&&?qifei?==?c3)
????????????????????{
????????????????????????banduan?=?false;
????????????????????????ListViewItem?obj;
????????????????????????obj?=?listView1.Items.Add(dr[0].ToString()?0);
????????????????????????obj.SubItems.Add(dr[1].ToString());
????????????????????????obj.SubItems.Add(dr[2].ToString());
????????????????????????obj.SubItems.Add(dr[3].ToString());
????????????????????????obj.SubItems.Add(dr[7].ToString());
????????????????????????obj.SubItems.Add(dr[5].ToString());
????????????????????????obj.SubItems.Add(dr[6].ToString());
????????????????????}
????????????????}
????????????????dr.Close();
????????????????SqlDataReader?drdr?=?cmd2.ExecuteReader();
????????????????if?(banduan)
????????????????{
????????????????????while?(drdr.Read())
????????????????????{
????????????????????????string?c1?=?drdr[1].ToString();?string?c2?=?drdr[2].ToString();
????????????????????????if?(chufa?==?c1?&&?mudi?==?c2)?
????????????????????????{
????????????????????????????ListViewItem?obj;
????????????????????????????obj?=?listView1.Items.Add(drdr[0].ToString()?0);
????????????????????????????obj.SubItems.Add(drdr[1].ToString());
????????????????????????????obj.SubItems.Add(drdr[2].ToString());
????????????????????????????obj.SubItems.Add(drdr[3].ToString());
?
?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????文件??????45056??2010-12-30?11:11??c#飛機(jī)訂票系統(tǒng)sql\WindowsApplication4\bin\Debug\WindowsApplication4.exe
?????文件??????50688??2010-12-30?11:11??c#飛機(jī)訂票系統(tǒng)sql\WindowsApplication4\bin\Debug\WindowsApplication4.pdb
?????文件???????5632??2010-12-30?07:50??c#飛機(jī)訂票系統(tǒng)sql\WindowsApplication4\bin\Debug\WindowsApplication4.vshost.exe
?????文件??????15673??2010-12-30?11:11??c#飛機(jī)訂票系統(tǒng)sql\WindowsApplication4\Form1.cs
?????文件??????56185??2010-12-30?11:11??c#飛機(jī)訂票系統(tǒng)sql\WindowsApplication4\Form1.Designer.cs
?????文件???????5814??2010-12-30?11:11??c#飛機(jī)訂票系統(tǒng)sql\WindowsApplication4\Form1.resx
?????文件????????842??2010-12-30?11:11??c#飛機(jī)訂票系統(tǒng)sql\WindowsApplication4\obj\Debug\WindowsApplication4.csproj.GenerateResource.Cache
?????文件??????45056??2010-12-30?11:11??c#飛機(jī)訂票系統(tǒng)sql\WindowsApplication4\obj\Debug\WindowsApplication4.exe
?????文件????????180??2010-12-30?11:11??c#飛機(jī)訂票系統(tǒng)sql\WindowsApplication4\obj\Debug\WindowsApplication4.Form1.resources
?????文件??????50688??2010-12-30?11:11??c#飛機(jī)訂票系統(tǒng)sql\WindowsApplication4\obj\Debug\WindowsApplication4.pdb
?????文件????????180??2010-12-30?07:50??c#飛機(jī)訂票系統(tǒng)sql\WindowsApplication4\obj\Debug\WindowsApplication4.Properties.Resources.resources
?????文件????????352??2010-12-30?11:11??c#飛機(jī)訂票系統(tǒng)sql\WindowsApplication4\obj\WindowsApplication4.csproj.FileList.txt
?????文件????????478??2010-12-30?07:50??c#飛機(jī)訂票系統(tǒng)sql\WindowsApplication4\Program.cs
?????文件???????1210??2010-12-30?07:50??c#飛機(jī)訂票系統(tǒng)sql\WindowsApplication4\Properties\AssemblyInfo.cs
?????文件???????2892??2010-12-30?07:50??c#飛機(jī)訂票系統(tǒng)sql\WindowsApplication4\Properties\Resources.Designer.cs
?????文件???????5612??2010-12-30?07:50??c#飛機(jī)訂票系統(tǒng)sql\WindowsApplication4\Properties\Resources.resx
?????文件???????1102??2010-12-30?07:50??c#飛機(jī)訂票系統(tǒng)sql\WindowsApplication4\Properties\Settings.Designer.cs
?????文件????????249??2010-12-30?07:50??c#飛機(jī)訂票系統(tǒng)sql\WindowsApplication4\Properties\Settings.settings
?????文件???????3245??2010-12-30?07:50??c#飛機(jī)訂票系統(tǒng)sql\WindowsApplication4\WindowsApplication4.csproj
?????文件????????946??2010-12-30?07:50??c#飛機(jī)訂票系統(tǒng)sql\WindowsApplication4.sln
????..A..H.?????15872??2010-12-30?11:11??c#飛機(jī)訂票系統(tǒng)sql\WindowsApplication4.suo
?????目錄??????????0??2010-12-29?18:29??c#飛機(jī)訂票系統(tǒng)sql\WindowsApplication4\obj\Debug\TempPE
?????目錄??????????0??2010-12-30?07:51??c#飛機(jī)訂票系統(tǒng)sql\WindowsApplication4\bin\Debug
?????目錄??????????0??2010-12-30?11:11??c#飛機(jī)訂票系統(tǒng)sql\WindowsApplication4\obj\Debug
?????目錄??????????0??2010-12-29?18:29??c#飛機(jī)訂票系統(tǒng)sql\WindowsApplication4\bin
?????目錄??????????0??2010-12-30?07:51??c#飛機(jī)訂票系統(tǒng)sql\WindowsApplication4\obj
?????目錄??????????0??2010-12-30?07:51??c#飛機(jī)訂票系統(tǒng)sql\WindowsApplication4\Properties
?????目錄??????????0??2010-12-30?11:11??c#飛機(jī)訂票系統(tǒng)sql\WindowsApplication4
?????目錄??????????0??2010-12-30?07:51??c#飛機(jī)訂票系統(tǒng)sql
-----------?---------??----------?-----??----
............此處省略2個(gè)文件信息
評(píng)論
共有 條評(píng)論