91av视频/亚洲h视频/操亚洲美女/外国一级黄色毛片 - 国产三级三级三级三级

  • 大小: 2.05MB
    文件類型: .rar
    金幣: 2
    下載: 0 次
    發布日期: 2024-02-02
  • 語言: C#
  • 標簽: c#??SQL??

資源簡介

某旅行社要開發一個小型旅游管理子系統，主要涉及的基本實體及其基本信息如下： 旅游線路：線路編號、起點、終點、旅游天數、主要景點。 旅游班次：班次編號、出發日期、回程日期、旅游標準、報價、折扣率。 導游：導游編號、身份證號、姓名、性別、出生日期、住址、聯系電話、語種、等級。 賓館：賓館編號、賓館名稱、所在城市、星級、標準房價、聯系人、職務、聯系地址、聯系電話、傳真。 游客：游客編號、身份證號、姓名、性別、出生日期、住址、聯系電話，旅游線路、出發日期、回程日期。 保險：保險單號、人均保險費、保險期限。

資源截圖

代碼片段和文件信息 

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?travel
{
????public?partial?class?accompany?:?Form
????{
????????DBconn?db;
????????SqlConnection?conn;

????????void?ShowAccompany（）
????????{
????????????db?=?new?DBconn（）;
????????????string?selectCmd1;
????????????selectCmd1?=?“Select?Accomp_no?as?陪同單號?Guide_no?as?導游編號?Group_no?as?團號?Accomp_start?as?出發日期?Accomp_days?as?陪同天數?From?tb_accompany“;
????????????SqlDataAdapter?accompAdapter;
????????????DataSet?accompDataSet?=?new?DataSet（）;
????????????conn?=?db.buildSqlConnection（）;
????????????conn.Open（）;
????????????accompAdapter?=?new?SqlDataAdapter（selectCmd1?conn）;
????????????accompAdapter.Fill（accompDataSet?“accompany“）;
????????????dataGridView1.DataSource?=?accompDataSet;
????????????dataGridView1.DataMember?=?“accompany“;

????????}

????????public?accompany（）
????????{
????????????InitializeComponent（）;
????????}

????????private?void?accompany_Load（object?sender?EventArgs?e）
????????{
????????????db?=?new?DBconn（）;
????????????string?selectCmd1?selectCmd2?selectCmd3;
????????????//“Accomp_no　as?陪同單號Guide_no?as?導游編號?Group_no?as?團號?Accomp_start?as?出發日期?Accomp_days?as?陪同天數?“
????????????selectCmd1?=?“Select?Accomp_no?as?陪同單號?Guide_no?as?導游編號?Group_no?as?團號?Accomp_start?as?出發日期?Accomp_days?as?陪同天數?From?tb_accompany“;
????????????selectCmd2?=?“Select?*??From?V_chkGroup“;
????????????selectCmd3?=?“Select?*?From?tb_Guide?Order?by?Guide_no“;
????????????SqlDataAdapter?ViewAdapter;
????????????DataSet?ViewDataset?=?new?DataSet（）;
????????????SqlDataAdapter?accompAdapter;
????????????DataSet?accompDataSet?=?new?DataSet（）;
????????????SqlDataAdapter?GuideAdapter;
????????????DataSet?GuideDataset?=?new?DataSet（）;

????????????conn?=?db.buildSqlConnection（）;
????????????conn.Open（）;
????????????accompAdapter?=?new?SqlDataAdapter（selectCmd1?conn）;
????????????accompAdapter.Fill（accompDataSet?“accompany“）;
????????????dataGridView1.DataSource?=?accompDataSet;
????????????dataGridView1.DataMember?=?“accompany“;

????????????comboBox1.DataSource?=?accompDataSet;
????????????comboBox1.DisplayMember?=?“accompany.陪同單號“;
????????????comboBox1.Text?=?““;

????????????ViewAdapter?=?new?SqlDataAdapter（selectCmd2?conn）;
????????????ViewAdapter.Fill（ViewDataset?“V_chkGroup“）;

????????????comboBox3.DataSource?=?ViewDataset;
????????????comboBox3.DisplayMember?=?“V_chkGroup.團號“;
????????????label10.DataBindings.Add（“Text“?ViewDataset?“V_chkGroup.團名“）;
????????????label11.DataBindings.Add（“Text“?ViewDataset?“V_chkGroup.旅游線路“）;
????????????label12.DataBindings.Add（“Text“?ViewDataset?“V_chkGroup.出發日期“）;
????????????label13.DataBindings.Add（“Text“?ViewDataset?“V_chkGroup.旅游天數“）;

????????????GuideAdapter?=?new?SqlDataAdapter（selectCmd3?conn）;
????????????GuideAd

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件???10485760??2010-12-13?19:09??travel\data\Tourdat1.mdf

?????文件???10485760??2010-12-13?01:45??travel\data2\Tourdat2.ndf

?????文件???10485760??2010-12-13?19:09??travel\log\Tourlog1.ldf

?????文件???????7904??2010-12-14?01:41??travel\travel\accompany.cs

?????文件??????12911??2010-12-14?00:09??travel\travel\accompany.Designer.cs

?????文件???????5814??2010-12-14?00:09??travel\travel\accompany.resx

?????文件????????857??2010-12-13?22:40??travel\travel\app.config

?????文件?????663552??2010-12-14?16:26??travel\travel\bin\Debug\travel.exe

?????文件????????857??2010-12-13?22:40??travel\travel\bin\Debug\travel.exe.config

?????文件????1017344??2010-12-14?16:26??travel\travel\bin\Debug\travel.pdb

?????文件???????5632??2005-11-11?22:25??travel\travel\bin\Debug\travel.vshost.exe

?????文件????????857??2010-12-13?22:40??travel\travel\bin\Debug\travel.vshost.exe.config

?????文件??????20082??2010-12-14?14:22??travel\travel\chkGroup.cs

?????文件??????29572??2010-12-14?01:12??travel\travel\chkGroup.Designer.cs

?????文件???????5814??2010-12-14?01:12??travel\travel\chkGroup.resx

?????文件???????3929??2010-12-14?14:22??travel\travel\chkGuide.cs

?????文件???????7391??2010-12-14?10:49??travel\travel\chkGuide.Designer.cs

?????文件???????5814??2010-12-14?10:49??travel\travel\chkGuide.resx

?????文件???????3363??2010-12-14?14:19??travel\travel\chkHotels.cs

?????文件???????7732??2010-12-14?02:10??travel\travel\chkHotels.Designer.cs

?????文件???????5814??2010-12-14?02:10??travel\travel\chkHotels.resx

?????文件??????12779??2010-12-14?14:16??travel\travel\chkLine.cs

?????文件??????13687??2010-12-14?01:29??travel\travel\chkLine.Designer.cs

?????文件???????5814??2010-12-14?01:29??travel\travel\chkLine.resx

?????文件??????13156??2010-12-14?14:13??travel\travel\chkOrder.cs

?????文件??????13934??2010-12-14?11:07??travel\travel\chkOrder.Designer.cs

?????文件???????5814??2010-12-14?11:07??travel\travel\chkOrder.resx

?????文件???????3347??2010-12-14?14:13??travel\travel\chkVisitor.cs

?????文件???????7738??2010-12-14?02:10??travel\travel\chkVisitor.Designer.cs

?????文件???????5814??2010-12-14?02:10??travel\travel\chkVisitor.resx

............此處省略133個文件信息

評論

共有 條評論