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,票务管理界面 :
车站售票管理系统资料
![](/skin/haowen/images/icon_star.png)
![](/skin/haowen/images/icon_star.png)
![](/skin/haowen/images/icon_star.png)
![](/skin/haowen/images/icon_star.png)