好文档 - 专业文书写作范文服务资料分享网站

车站售票管理系统资料

天下 分享 时间: 加入收藏 我要投稿 点赞

3,员工管理界面:

修改/删除操作代码: (1)try

{

SqlCommandBuilder scb = newSqlCommandBuilder(sd); sd.Update(ds, \); ds.AcceptChanges(); MessageBox.Show(\修改成功!\); } catch (Exception ex) {

MessageBox.Show(ex.Message.ToString()); }

(2)try

{

SqlCommandBuilder scb = newSqlCommandBuilder(sd); int a = dataGridView1.CurrentRow.Index;

ds.Tables[0].Rows[a].Delete(); sd.Update(ds, \); ds.AcceptChanges(); MessageBox.Show(\删除成功!\); } catch (Exception ex) {

MessageBox.Show(ex.Message.ToString()); }

4,汽车信息管理界面:

添加操作代码:

(1)DAL.CoachDAO coach = new Coach.DAL.CoachDAO(); SqlHelper helper = newSqlHelper();

(2) if (string.IsNullOrEmpty(coachnumber) || string.IsNullOrEmpty(seatnumber1) || string.IsNullOrEmpty(coachholder))

{MessageBox.Show(\车牌号,座位数量,负责人均不能为空!\); } else

{

if (coach.Add(coachtype,coachnumber,date2,seatnumber,ishavetv,ishavecon,coachholder)) MessageBox.Show(\添加成功!\); else

MessageBox.Show(\添加失败!\);

}

(3)实体类CoachDAO.cs中:

publicbool Add(string coachtype,string coachnumber,DateTime date2, int seatnumber,string ishavetv,string ishavecon,string coachholder) {

bool flag = false;

DataTable dt = newDataTable(); string cmdText = \;

SqlParameter[] paras = newSqlParameter[]{ newSqlParameter(\,coachtype),

newSqlParameter(\,coachnumber), newSqlParameter(\,date2),

newSqlParameter(\,seatnumber), newSqlParameter(\,ishavetv), newSqlParameter(\,ishavecon), newSqlParameter(\,coachholder) };

int res = helper.ExecuteNonQuery(cmdText, paras, CommandType.StoredProcedure); if (res > 0)

{

flag = true; } return flag; }

(4)存储过程:

ALTER PROCEDURE dbo.AddCoach @coachtype nvarchar(20), @coachnumber nvarchar(20), @date2 datetime, @seatnumber int, @ishavetv char(10), @ishavecon char(10),

@coachholder nvarchar(20) /* (

@parameter1 int = 5,

@parameter2 datatype OUTPUT ) */ AS

/* SET NOCOUNT ON */ BEGIN

insert into Coach (Ctype,Coachnumber,Ctime,Cnum,Ctv,Ccondition,Coachholder) values (@coachtype,@coachnumber,@date2,@seatnumber,@ishavetv,@ishavecon,@coachholder)

END

5,线路信息管理界面:

搜索操作代码:

(1)SqlHelper helper = newSqlHelper();

SqlConnection conn = newSqlConnection(\); SqlDataAdapter sd; //定义一个数据适配器 DataSet ds; //定义一个数据集 (2)string str1 = \编号,Ldepart as 起始城市,Larrival as 到达城市,convert(varchar(10),Ltime,108)

as 路程时间 from Line where Lno =\ + lineid + \; dataBind(str1); (3)privatevoid dataBind(string str) { try

{

sd = newSqlDataAdapter(str, conn); ds = newDataSet(); sd.Fill(ds, \);

dataGridView1.DataSource = ds; dataGridView1.DataMember = \; } catch (Exception ex) {

MessageBox.Show(ex.Message); } }

6,车票信息管理界面:

7,车票信息管理中,选择汽车和路线界面:

8,票务管理界面 :

车站售票管理系统资料

3,员工管理界面:修改/删除操作代码:(1)try{SqlCommandBuilderscb=newSqlCommandBuilder(sd);sd.Update(ds,\);ds
推荐度:
点击下载文档文档为doc格式
6af4s1f6ru7b8vd538ce5nrap1rg8p00xgd
领取福利

微信扫码领取福利

微信扫码分享