C#和sql设计的 车辆管理系统 课程设计报告,附带代码

洛力/玄比修课程设计课程设计名称：车辆系统的管理与调度专业班级：计科0802班学号:：课程设计时间：2011年06月30日

计算机科学与技术专业课程设计任务书学生姓名李旭专业班级计科0802学号200848140202题目车辆系统的管理与调度课题性质其它课题来源自拟课题指导教师马宏琳同组姓名无主要内容本系统主要具有以下功能：（1）设计车辆信息，包括车辆信息维护和查询；（2）设计驾驶员信息，包括驾驶员信息维护和查询；（3）设计车场信息，包括车场信息维护和查询；（4）设计车辆调度；（5）实现系统界面，包括用户管理，修改密码，退出。任务要求综合运用所学的数据库基本知识，并能通过查阅相关文献材料，独立完成该课题的设计开发工作。设计车辆管理系统，进一步掌握通过编程访问数据库和对数据库的管理，用高级语言编写管理系统实现对车辆方面的管理。参考文献詹英.数据库技术与应用[M].北京：清华大学出版社.2008.9-14黄德才.数据库原理及其应用教程.[M].北京：科学出版社.2007.12-3[3]龚沛曾，杨志强.数据库技术与应用[M].北京高等教育出版社.2008任满杰.数据库实用教程[M].电子工业出版社.2006王珊，萨师煊.数据库系统概论[M].高等教育出版社出版.2005审查意见指导教师签字：教研室主任签字：年月日说明：本表由指导教师填写，由教研室主任审核后下达给选题学生，装订在设计（论文）首页1需求分析本课程设计要求了解车辆管理系统的过程，要求对车辆的管理有一定的理解，并进一步加深对车辆运作的实现和理解。要求用C#语言和SQLSERVER2000实现车辆相关信息记录和调度。要求建立一个数据库，然后用C#编程序，编号后要求把数据库与程序连接起来，组成一个大模块。车辆管理过程中涉及车辆的添加、删除、修改，驾驶员的添加、删除、修改，车场的添加、删除、修改，其中当实现车辆调度时能顺利完成要求，另外系统还可以实现修改用户，修改密码等功能。2概要设计本系统要求建立六个表，分别包括用户信息，车辆信息，驾驶员信息，车辆调度信息，车辆预约信息，车辆库存信息。在设计程序的时候要求完成的模块有（1）设计车辆信息，包括车辆信息维护和查询；（2）设计驾驶员信息，包括驾驶员信息维护和查询；（3）设计车场信息，包括车场信息维护和查询；（4）设计车辆调度；（5）实现系统界面，包括用户管理，修改密码，退出。在实现功能的时候要连接数据库，充分利用数据库中的数据。3运行环境WindousXP系统4开发工具和编程语言MicrosoftVisaulStadio2008MicrosoftSqlServer20005详细设计（！）首先建立一个数据库，在数据库中建立所需要的表，建立过程大概如下：CREATETABLE[dbo].[UserInfo]（[UserID][char]（5）COLLATEChinese_PRC_CI_ASNOTNULL,[UserName][varchar]（20）COLLATEChinese_PRC_CI_ASNULL,[passwod][varchar]（5）COLLATEChinese_PRC_CI_ASNOTNULL,[UserLevel][char]（1）COLLATEChinese_PRC_CI_ASNULL)ON[PRIMARY]UserIDIJserNidiriejiasswodIJserLevel►盂莉01W0Q2陈阳40U0003玖荏0CREATETABLE[dbo].[CarInfo]([CarlD][char](5)COLLATEChinese_PRC_CI_ASNOTNULL,[CarType][varchar](20)COLLATEChinese_PRC_CI_ASNOTNULL,[CarDriver][char](5)COLLATEChinese_PRC_CI_ASNOTNULL,[CarColor][char](5)COLLATEChinese_PRC_CI_ASNULL,[Carbuytime][datetime]NULL,[CarLoad][int]NULL)ON[PRIMARY]CarIDCarTypeC：=Lt_HriverC：=Lt-ColufC：=LrbuytimHC：=Lt_Load►2000-5-138C00022001-6-15SC00032004-3-104C00042011-1-45CLILIUS2011-1-46CREATETABLE[dbo].[CarOut]([OutID][char](5)COLLATEChinese_PRC_CI_ASNOTNULL,[OutCarID][char](5)COLLATEChinese_PRC_CI_ASNOTNULL,[CarOutTime][datetime]NOTNULL,[CarInTime][datetime]NOTNULL,[Outfee][money]NOTNULL)ON[PRIMARY]OutIDOutCarIDCarOutTimeCarInTimeOntfeeC00012010-1-132010-1-151E00T0002C00032010-6-142010-6-151000T0003C00042010-^-122010-^-201200CREATETABLE[dbo].[Driver]([DriverID][char](5)COLLATEChinese_PRC_CI_ASNOTNULL,[DriverName][varchar](20)COLLATEChinese_PRC_CI_ASNOTNULL,[DriverSex][char](5)COLLATEChinese_PRC_CI_ASNOTNULL,[DriverLevel][char](5)COLLATEChinese_PRC_CI_ASNOTNULL,[DriverAddress][varchar](50)COLLATEChinese_PRC_CI_ASNULL,[DriverPhone][char](11)COLLATEChinese_PRC_CI_ASNULL,[worktime][datetime]NULL)ON[PRIMARY]DnverlDDnverNaneDriverSesDriverLevelDriverAddressDriverPhonewjrktime张梅中颤河南剑州市中月136598741232D04-4-18D0002赵磊里高纽河南璀郑州市建土158469702362J00-5-14D0003陈着中融河南智郑州市胡135897410382D05-9-10D0004朱矣f的河南璀郑州市135469875202J11-1-42.CREATETABLE[dbo].[OrderInfo]([OrderID][char](5)COLLATEChinese_PRC_CI_ASNOTNULL,[OrderCarID][char](5)COLLATEChinese_PRC_CI_ASNOTNULL,[OrderPersonName][varchar](20)COLLATEChinese_PRC_CI_ASNOTNULL,[OrderTime][datetime]NOTNULL,[OrderReason][varchar](50)COLLATEChinese_PRC_CI_ASNULL)ON[PRIMARY]OrderIDOrderCarlDOrdprFyrEurLffjdJTif!OrdurTimuOriiprEuiEurLsiCOOOl王英2010-1-13菇礼R0002C0003洪小玲2010-6-13婚礼RDQO3COOQ4张军2Q10-9-10办公*CREATETABLE[dbo].[StopPlace]([SpID][char](5)COLLATEChinese_PRC_CI_ASNOTNULL,[SpName][varchar](20)COLLATEChinese_PRC_CI_ASNULL,[SpLocation][varchar](50)COLLATEChinese_PRC_CI_ASNULL,[bigcarnum][int]NOTNULL,[mediumcarnum][int]NOTNULL,[smallcarnum][int]NOTNULL)ON[PRIMARY]SpIDSpik眼SpL:c^ti:nbi安我num拯地下停车场飞翔公司203020S0002地方威何方神圣254545■drS0003家里自己公司253025（2）程序中各模块如下:1.namespaceDA模块publicDataTableCarInfoSelectAll()(using(SqlConnectionconn=DABase.CreateConnection())(if(ConnectionState.Closed==conn.State)(conn.Open();}using(SqlCommandcmd=conn.CreateCommand())(cmd.CommandType=CommandType.StoredProcedure;cmd.CommandText="CarInfoSelectAll";try(SqlDataAdapterAdapter=newSqlDataAdapter(cmd);DataSetds=newDataSet();Adapter.Fill(ds);conn.Close();returnds.Tables[0];}catch(SqlExceptionsqlEx)(throwsqlEx;}}}}publicCarInfoModuleCarInfoSelectOne(StringCarID)(using(SqlConnectionconn=DABase.CreateConnection())(if(ConnectionState.Closed==conn.State)(conn.Open();}using(SqlCommandcmd=conn.CreateCommand())(cmd.CommandType=CommandType.StoredProcedure;cmd.CommandText="CarInfoSelectOne";#region添加存储过程参数cmd.Parameters.AddWithValue("@CarID",CarID);//车辆标号#endregiontry(SqlDataReaderdr=cmd.ExecuteReader();if(dr.HasRows==false)(dr.Close();returnnull;}CarInfoModuleCarMod=newCarInfoModule();dr.Read();#region读取字段值CarMod.CarID=CommonSqlValue.GetString(0,dr);CarMod.CarType=CommonSqlValue.GetString(1,dr);CarMod.CarDriver=CommonSqlValue.GetString(2,dr);CarMod.CarColor=CommonSqlValue.GetString(3,dr);CarMod.Carbuytime=CommonSqlValue.GetDateTime(4,dr);CarMod.CarLoad=CommonSqlValue.GetInt32(5,dr);#endregiondr.Close();conn.Close();returnCarMod;}catch(SqlExceptionsqlEx)(throwsqlEx;}}}}publicvoidCarInfoDeleteOne(StringCarID)(using(SqlConnectionconn=DABase.CreateConnection())(if(ConnectionState.Closed==conn.State)(conn.Open();}using(SqlCommandcmd=conn.CreateCommand())(cmd.CommandType=CommandType.StoredProcedure;cmd.CommandText="CarInfoDeleteOne";#region添加存储过程参数cmd.Parameters.AddWithValue("@CarID",CarID);//记录序列号#endregiontry(cmd.ExecuteNonQuery();conn.Close();}catch(SqlExceptionsqlEx)(throwsqlEx;}}}}publicvoidCarInfoUpdateOne(CarInfoModuleCarMod)(using(SqlConnectionconn=DABase.CreateConnection())(if(ConnectionState.Closed==conn.State)(conn.Open();}using(SqlCommandcmd=conn.CreateCommand())(cmd.CommandType=CommandType.StoredProcedure;cmd.CommandText="CarInfoUpdateOne";#region添加存储过程参数cmd.Parameters.AddWithValue("@CarID",CarMod.CarlD);cmd.Parameters.AddWithValue(〃@CarType〃，CarMod.CarType);cmd.Parameters.AddWithValue(〃@CarDriver〃，CarMod.CarDriver);cmd.Parameters.AddWithValue(〃@CarColor〃，CarMod.CarColor);cmd.Parameters.AddWithValue(〃@Carbuytime〃，CarMod.Carbuytime);cmd.Parameters.AddWithValue(〃@CarLoad〃，CarMod.CarLoad);#endregiontry(cmd.ExecuteNonQuery();conn.Close();}catch(SqlExceptionsqlEx)(switch(sqlEx.Number)(case2601:case2627:thrownewException("修改记录失败!插入的键值已经存在，请确认后重试。如果仍有错误，请与管理员联系。",sqlEx);case8152:thrownewException("修改记录失败！字符串长度超出范围，请确认后重试。如果仍有错误，请与管理员联系。"，sqlEx);case8115:thrownewException("修改记录失败!数值超出范围，请确认后重试。如果仍有错误，请与管理员联系。",sqlEx);default:throwsqlEx;}}}}}publicvoidCarInfoInsertOne(CarInfoModuleCarMod)(using(SqlConnectionconn=DABase.CreateConnection())(if(ConnectionState.Closed==conn.State)(conn.Open();}using(SqlCommandcmd=conn.CreateCommand())(cmd.CommandType=CommandType.StoredProcedure;cmd.CommandText="CarInfoInsertOne";#region添加存储过程参数cmd.Parameters.AddWithValue("@CarID",CarMod.CarID);cmd.Parameters.AddWithValue("@CarType",CarMod.CarTypcmd.Parameters.AddWithValue("@CarDriver",CarMod.CarDriver);cmd.Parameters.AddWithValue("@CarColor",CarMod.CarColor);cmd.Parameters.AddWithValue("@Carbuytime",CarMod.Carbuytime);cmd.Parameters.AddWithValue("@CarLoad",CarMod.CarLoad);#endregiontry(cmd.ExecuteNonQuery();conn.Close();}catch(SqlExceptionsqlEx)switch(sqlEx.Number)(case2601:case2627:thrownewException("添加记录失败!插入的键值已经存在，请确认后重试。如果仍有错误，请与管理员联系。",sqlEx);case8152:thrownewException("添加记录失败！字符串长度超出范围，请确认后重试。如果仍有错误，请与管理员联系。"，sqlEx);case8115:thrownewException("添加记录失败!数值超出范围，请确认后重试。如果仍有错误，请与管理员联系。",sqlEx);default:throwsqlEx;}}}}}))namespaceDA(publicpartialclassCarOutDA(publicDataTableCarOutSelectAll()(using(SqlConnectionconn=DABase.CreateConnection())(if(ConnectionState.Closed==conn.State)(conn.Open();}using(SqlCommandcmd=conn.CreateCommand())(cmd.CommandType=CommandType.StoredProcedure;cmd.CommandText="CarOutSelectAll";try(SqlDataAdapterAdapter=newSqlDataAdapter(cmd);DataSetds=newDataSet();Adapter.Fill(ds);conn.Close();returnds.Tables[0];}catch(SqlExceptionsqlEx)(throwsqlEx;}}}}publicCarOutModuleCarOutSelectOne1(DateTimedate1,DateTimedate2)(using(SqlConnectionconn=DABase.CreateConnection())(if(ConnectionState.Closed==conn.State)(conn.Open();}using(SqlCommandcmd=conn.CreateCommand())(cmd.CommandType=CommandType.StoredProcedure;cmd.CommandText="CarOutSelectOnel";#region添加存储过程参数cmd.Parameters.AddWithValue("@date1",date1);cmd.Parameters.AddWithValue("@date2",date2);#endregiontry(SqlDataReaderdr=cmd.ExecuteReader();if(dr.HasRows==false)(dr.Close();returnnull;}CarOutModuleCarOutMod=newCarOutModule();dr.Read();#region读取字段值CarOutMod.OutID=CommonSqlValue.GetString(0,dr);CarOutMod.OutCarID=CommonSqlValue.GetString(1,dr);CarOutMod.CarOutTime=CommonSqlValue.GetDateTime(2,dr);CarOutMod.CarInTime=CommonSqlValue.GetDateTime(3,dr);CarOutMod.OutFee=CommonSqlValue.GetDecimal(4,dr);#endregiondr.Close();conn.Close();returnCarOutMod;}catch(SqlExceptionsqlEx)(throwsqlEx;}}}}publicvoidCarOutDeleteOne(StringOutID)(using(SqlConnectionconn=DABase.CreateConnection())(if(ConnectionState.Closed==conn.State)(conn.Open();}using(SqlCommandcmd=conn.CreateCommand())(cmd.CommandType=CommandType.StoredProcedure;cmd.CommandText="CarOutDeleteOne";#region添加存储过程参数cmd.Parameters.AddWithValue("@OutID",OutID);//用户编号#endregiontry(cmd.ExecuteNonQuery();conn.Close();catch(SqlExceptionsqlEx)(throwsqlEx;}}}}publicvoidCarOutUpdateOne(CarOutModuleCarOutMod)(using(SqlConnectionconn=DABase.CreateConnection())(if(ConnectionState.Closed==conn.State)(conn.Open();}using(SqlCommandcmd=conn.CreateCommand())(cmd.CommandType=CommandType.StoredProcedure;cmd.CommandText="CarOutUpdateOne”;#region添加存储过程cmd.Parameters.AddWithValue("@OutID”,CarOutMod.OutID);cmd.Parameters.AddWithValue("@OutCarID”,CarOutMod.OutCarlD);cmd.Parameters.AddWithValue("@CarOutTime”,CarOutMod.CarOutTime);cmd.Parameters.AddWithValue("@CarInTime”,CarOutMod.CarInTime);cmd.Parameters.AddWithValue("@OutFee”,CarOutMod.OutFee);#endregiotry(cmd.ExecuteNonQuery();conn.Close();}catch(SqlExceptionsqlEx)(switch(sqlEx.Number)(case2601:case2627:thrownewException("修改记录失败!插入的键值已经存在，请确认后重试。如果仍有错误，请与管理员联系。",sqlEx);case8152:thrownewException("修改记录失败！字符串长度超出范围，请确认后重试。如果仍有错误，请与管理员联系。",sqlEx);case8115:thrownewException("修改记录失败!数值超出范围，请确认后重试。如果仍有错误，请与管理员联系。",sqlEx);default:throwsqlEx;}}}}}publicvoidCarOutInsertOne(CarOutModuleCarOutMod)(using(SqlConnectionconn=DABase.CreateConnection())(if(ConnectionState.Closed==conn.State)(conn.Open();}using(SqlCommandcmd=conn.CreateCommand())(cmd.CommandType=CommandType.StoredProcedure;cmd.CommandText="CarOutInsertOne";#region添加存储过程参数cmd.Parameters.AddWithValue("@OutID”,CarOutMod.OutID);cmd.Parameters.AddWithValue("@OutCarID”,CarOutMod.OutCarID);cmd.Parameters.AddWithValue(〃@CarOutTime〃，CarOutMod.CarOutTime);cmd.Parameters.AddWithValue(〃@CarInTime〃，CarOutMod.CarInTime);cmd.Parameters.AddWithValue(〃@OutFee〃，CarOutMod.OutFee);#endregiontry(cmd.ExecuteNonQuery();conn.Close();}catch(SqlExceptionsqlEx)(switch(sqlEx.Number)(case2601:case2627:thrownewException("添加记录失败!插入的键值已经存在，请确认后重试。如果仍有错误，请与管理员联系。",sqlEx);case8152:thrownewException("添加记录失败！字符串长度超出范围，请确认后重试。如果仍有错误，请与管理员联系。"，sqlEx);case8115:thrownewException("添加记录失败！数值超出范围，请确认后重试。如果仍有错误，请与管理员联系。",sqlEx);default:throwsqlEx;}}}}}}}namespaceDA(publicclassCommonSqlValue(publicCommonSqlValue()(}publicstaticByte[]GetSqlBinary(Int16idx,SqlDataReaderdr)(if(!dr.IsDBNull(idx))(returndr.GetSqlBinary(idx).Value;}else(returnnull;}}publicstaticDateTimeGetDateTime(Int16idx,SqlDataReaderdr)(if(!dr.IsDBNull(idx))(returndr.GetDateTime(idx).Date;}else(returnDateTime.MinValue;}}publicstaticBooleanGetBoolean(Int16idx,SqlDataReaderdr)(if(!dr.IsDBNull(idx))(returndr.GetBoolean(idx);}else(returnfalse;}}publicstaticByteGetByte(Int16idx,SqlDataReaderdr)(if(!dr.IsDBNull(idx))(returndr.GetByte(idx);}else(return0;}}publicstaticInt16GetInt16(Int16idx,SqlDataReaderdr)(if(!dr.IsDBNull(idx))(returndr.GetInt16(idx);}else(return0;}}publicstaticInt32GetInt32(Int16idx,SqlDataReaderdr)(if(!dr.IsDBNull(idx))(returndr.GetInt32(idx);}else(return0;}}publicstaticInt64GetInt64(Int16idx,SqlDataReaderdr)(if(!dr.IsDBNull(idx))(returndr.GetInt64(idx);}else(return0;}}publicstaticSingleGetSingle(Int16idx,SqlDataReaderdr)(if(!dr.IsDBNull(idx))(returndr.GetFloat(idx);}else(return0;}}publicstaticDoubleGetDouble(Int16idx,SqlDataReaderdr)(if(!dr.IsDBNull(idx))(returndr.GetDouble(idx);}else(return0;}}publicstaticDecimalGetDecimal(Int16idx,SqlDataReaderdr)(if(!dr.IsDBNull(idx))(returndr.GetDecimal(idx);}else(return0;}}publicstaticStringGetString(Int16idx,SqlDataReaderdr)(if(!dr.IsDBNull(idx))(returndr.GetString(idx);}else(returnString.Empty;}}publicstaticGuidGetGuid(Int16idx,SqlDataReaderdr)(if(!dr.IsDBNull(idx))(returndr.GetGuid(idx);}else(returnGuid.Empty;}}}}namespaceDA(classDABaseprivatestaticstringConnectionString=System.Configuration.ConfigurationManager.ConnectionStrings[〃connStr〃].ToString();publicDABase()(}publicstaticSqlConnectionCreateConnection()(SqlConnectionconn=newSqlConnection(DABase.ConnectionString);returnconn;}}}namespaceDA(publicpartialclassDriverDA(publicDriverDA()(}publicDataTableDriverSelectAll()(using(SqlConnectionconn=DABase.CreateConnection())(if(ConnectionState.Closed==conn.State)(conn.Open();}using(SqlCommandcmd=conn.CreateCommand())(cmd.CommandType=CommandType.StoredProcedure;cmd.CommandText="DriverSelectAll";try(SqlDataAdapterAdapter=newSqlDataAdapter(cmd);DataSetds=newDataSet();Adapter.Fill(ds);conn.Close();returnds.Tables[0];}catch(SqlExceptionsqlEx)(throwsqlEx;}}}}publicDriverModuleDriverSelectOne(StringDriverID)(using(SqlConnectionconn=DABase.CreateConnection())(if(ConnectionState.Closed==conn.State)(conn.Open();}using(SqlCommandcmd=conn.CreateCommand())(cmd.CommandType=CommandType.StoredProcedure;cmd.CommandText="DriverSelectOne";#region添加存储过程参数cmd.Parameters.AddWithValue(〃@DriverID〃，DriverlD);//用户编号#endregiontry(SqlDataReaderdr=cmd.ExecuteReader();if(dr.HasRows==false)(dr.Close();returnnull;}DriverModuleDriverMod=newDriverModule();dr.Read();#region读取字段值DriverMod.DriverID=CommonSqlValue.GetString(0,dr);DriverMod.DriverName=CommonSqlValue.GetString(1,dr);DriverMod.DriverSex=CommonSqlValue.GetString(2,dr);DriverMod.DriverLevel=CommonSqlValue.GetString(3,dr);DriverMod.DriverAddress=CommonSqlValue.GetString(4,dr);DriverMod.DriverPhone=CommonSqlValue.GetString(5,dr);DriverMod.worktime=CommonSqlValue.GetDateTime(6,dr);#endregiondr.Close();conn.Close();returnDriverMod;}catch(SqlExceptionsqlEx)(throwsqlEx;}}}}publicvoidDriverDeleteOne(StringDriverID)(using(SqlConnectionconn=DABase.CreateConnection())(if(ConnectionState.Closed==conn.State)(conn.Open();}using(SqlCommandcmd=conn.CreateCommand())(cmd.CommandType=CommandType.StoredProcedure;cmd.CommandText="DriverDeleteOne";#region添加存储过程参数cmd.Parameters.AddWithValue("@DriverID",DriverID);//用户编号#endregiontry(cmd.ExecuteNonQuery();conn.Close();}catch(SqlExceptionsqlEx)(throwsqlEx;}}}}publicvoidDriverUpdateOne(DriverModuleDriverMod)(using(SqlConnectionconn=DABase.CreateConnection())(if(ConnectionState.Closed==conn.State)(conn.Open();}using(SqlCommandcmd=conn.CreateCommand())(cmd.CommandType=CommandType.StoredProcedure;cmd.CommandText="DriverUpdateOne”;#region添加存储过程参数cmd.Parameters.AddWithValue("@DriverID”,DriverMod.DriverlD);cmd.Parameters.AddWithValue("@DriverName”,DriverMod.DriverName);cmd.Parameters.AddWithValue("@DriverSex”,DriverMod.DriverSex);cmd.Parameters.AddWithValue("@DriverLevel”,DriverMod.DriverLevel);cmd.Parameters.AddWithValue("@DriverAddress”,DriverMod.DriverAddress);cmd.Parameters.AddWithValue("@DriverPhone”,DriverMod.DriverPhone);cmd.Parameters.AddWithValue("@worktime”,DriverMod.worktime);#endregiontry(cmd.ExecuteNonQuery();conn.Close();}catch(SqlExceptionsqlEx)(switch(sqlEx.Number)(case2601:case2627:thrownewException("修改记录失败!插入的键值已经存在，请确认后重试。如果仍有错误，请与管理员联系。",sqlEx);case8152:thrownewException("修改记录失败！字符串长度超出范围，请确认后重试。如果仍有错误，请与管理员联系。",sqlEx);case8115:thrownewException("修改记录失败!数值超出范围，请确认后重试。如果仍有错误，请与管理员联系。",sqlEx);default:throwsqlEx;}}}}}publicvoidDriverInsertOne(DriverModuleDriverMod)(using(SqlConnectionconn=DABase.CreateConnection())if(ConnectionState.Closed==conn.State)(conn.Open();}using(SqlCommandcmd=conn.CreateCommand())(cmd.CommandType=CommandType.StoredProcedure;cmd.CommandText="DriverInsertOne";#region添加存储过程参数cmd.Parameters.AddWithValue("@DriverID",DriverMod.DriverID);cmd.Parameters.AddWithValue("@DriverName",DriverMod.DriverName);cmd.Parameters.AddWithValue("@DriverSex",DriverMod.DriverSex);cmd.Parameters.AddWithValue("@DriverLevel",DriverMod.DriverLevel);cmd.Parameters.AddWithValue("@DriverAddress",DriverMod.DriverAddress);cmd.Parameters.AddWithValue("@DriverPhone",DriverMod.DriverPhone);cmd.Parameters.AddWithValue("@worktime",DriverMod.worktime);#endregiontry(cmd.ExecuteNonQuery();conn.Close();}catch(SqlExceptionsqlEx)(switch(sqlEx.Number)(case2601:case2627:thrownewException("添加记录失败!插入的键值已经存在，请确认后重试。如果仍有错误，请与管理员联系。"，sqlEx);case8152:thrownewException("添加记录失败！字符串长度超出范围，请确认后重试。如果仍有错误，请与管理员联系。",sqlEx);case8115:thrownewException("添加记录失败！数值超出范围，请确认后重试。如果仍有错误，请与管理员联系。",sqlEx);default:throwsqlEx;}}}}}}}namespaceDA(publicpartialclassOrderInfoDA(publicOrderInfoDA()(}publicDataTableOrderInfoSelectAll()(using(SqlConnectionconn=DABase.CreateConnection())(if(ConnectionState.Closed==conn.State)conn.Open();}using(SqlCommandcmd=conn.CreateCommand())(cmd.CommandType=CommandType.StoredProcedure;cmd.CommandText="OrderInfoSelectAll";try(SqlDataAdapterAdapter=newSqlDataAdapter(cmd);DataSetds=newDataSet();Adapter.Fill(ds);conn.Close();returnds.Tables[0];}catch(SqlExceptionsqlEx)(throwsqlEx;}}}}publicOrderInfoModuleOrderInfoSelectOne1(DateTimedate)(using(SqlConnectionconn=DABase.CreateConnection())(if(ConnectionState.Closed==conn.State)(conn.Open();}using(SqlCommandcmd=conn.CreateCommand())(cmd.CommandType=CommandType.StoredProcedure;cmd.CommandText="OrderInfoSelectOne1";#region添加存储过程参数cmd.Parameters.AddWithValue("@date",date);//预约时间#endregiontry(SqlDataReaderdr=cmd.ExecuteReader();if(dr.HasRows==false)(dr.Close();returnnull;}OrderInfoModuleOrderInfoMod=newOrderInfoModule();dr.Read();#region读取字段值OrderInfoMod.OrderID=CommonSqlValue.GetString(0,dr);OrderInfoMod.OrderCarID=CommonSqlValue.GetString(1,dr);OrderInfoMod.OrderPersonName=CommonSqlValue.GetString(2,dr);OrderInfoMod.OrderTime=CommonSqlValue.GetDateTime(3,dr);OrderInfoMod.OrderReason=CommonSqlValue.GetString(4,dr);#endregiondr.Close();conn.Close();returnOrderInfoMod;}catch(SqlExceptionsqlEx)(throwsqlEx;}}}}publicvoidOrderInfoDeleteOne(StringOrderID)(using(SqlConnectionconn=DABase.CreateConnection())(if(ConnectionState.Closed==conn.State)(conn.Open();}using(SqlCommandcmd=conn.CreateCommand())(cmd.CommandType=CommandType.StoredProcedure;cmd.CommandText="OrderInfoDeleteOne";#region添加存储过程参数cmd.Parameters.AddWithValue("@OrderID",OrderID);//用户编号#endregiontry(cmd.ExecuteNonQuery();conn.Close();}catch(SqlExceptionsqlEx)(throwsqlEx;}}}}publicvoidOrderInfoUpdateOne(OrderInfoModuleOrderInfoMod)(using(SqlConnectionconn=DABase.CreateConnection())(if(ConnectionState.Closed==conn.State)(conn.Open();}using(SqlCommandcmd=conn.CreateCommand())(cmd.CommandType=CommandType.StoredProcedure;cmd.CommandText="OrderInfoUpdateOne";#region添加存储过程参数cmd.Parameters.AddWithValue("@OrderID",OrderInfoMod.OrderID);cmd.Parameters.AddWithValue("@OrderCarID",OrderInfoMod.OrderCarID);cmd.Parameters.AddWithValue("@OrderPersonName",OrderInfoMod.OrderPersonName);cmd.Parameters.AddWithValue("@OrderTime",OrderInfoMod.OrderTime);cmd.Parameters.AddWithValue("@OrderReason",OrderInfoMod.OrderReason);#endregiontry(cmd.ExecuteNonQuery();conn.Close();}catch(SqlExceptionsqlEx)(switch(sqlEx.Number)(case2601:case2627:thrownewException("修改记录失败!插入的键值已经存在，请确认后重试。如果仍有错误，请与管理员联系。",sqlEx);case8152:thrownewException("修改记录失败!字符串长度超出范围，请确认后重试。如果仍有错误，请与管理员联系。"，sqlEx);case8115:thrownewException("修改记录失败!数值超出范围，请确认后重试。如果仍有错误，请与管理员联系。",sqlEx);default:throwsqlEx;}}}}}publicvoidOrderInfoInsertOne(OrderInfoModuleOrderInfoMod)(using(SqlConnectionconn=DABase.CreateConnection())(if(ConnectionState.Closed==conn.State)(conn.Open();}using(SqlCommandcmd=conn.CreateCommand())(cmd.CommandType=CommandType.StoredProcedure;cmd.CommandText="OrderInfoInsertOne";#region添加存储过程参数cmd.Parameters.AddWithValue("@OrderID",OrderInfoMod.OrderID);cmd.Parameters.AddWithValue("@OrderCarID",OrderInfoMod.OrderCarID);cmd.Parameters.AddWithValue("@OrderPersonName",OrderInfoMod.OrderPersonName);cmd.Parameters.AddWithValue("@OrderTime",OrderInfoMod.OrderTime);cmd.Parameters.AddWithValue("@OrderReason",OrderInfoMod.OrderReason);#endregiontry(cmd.ExecuteNonQuery();conn.Close();}catch(SqlExceptionsqlEx)(switch(sqlEx.Number)(case2601:case2627:thrownewException("添加记录失败！插入的键值已经存在，请确认后重试。如果仍有错误，请与管理员联系。",sqlEx);case8152:thrownewException("添加记录失败！字符串长度超出范围，请确认后重试。如果仍有错误，请与管理员联系。",sqlEx);case8115:thrownewException("添加记录失败!数值超出范围，请确认后重试。如果仍有错误，请与管理员联系。"，sqlEx);default:throwsqlEx;}}}}}))namespaceDA(publicpartialclassStopPlaceDA(publicStopPlaceDA()(}publicDataTableStopPlaceSelectAll()(using(SqlConnectionconn=DABase.CreateConnection())(if(ConnectionState.Closed==conn.State)(conn.Open();}using(SqlCommandcmd=conn.CreateCommand())(cmd.CommandType=CommandType.StoredProcedure;cmd.CommandText="StopPlaceSelectAll";try(SqlDataAdapterAdapter=newSqlDataAdapter(cmd);DataSetds=newDataSet();Adapter.Fill(ds);conn.Close();returnds.Tables[0];}catch(SqlExceptionsqlEx)(throwsqlEx;}}}}publicStopPlaceModuleStopPlaceSelectOne(StringSpID)(using(SqlConnectionconn=DABase.CreateConnection())(if(ConnectionState.Closed==conn.State)(conn.Open();}using(SqlCommandcmd=conn.CreateCommand())(cmd.CommandType=CommandType.StoredProcedure;cmd.CommandText="StopPlaceSelectOne";#region添加存储过程参数cmd.Parameters.AddWithValue("@SpID",SpID);//用户编号#endregiontry(SqlDataReaderdr=cmd.ExecuteReader();if(dr.HasRows==false)(dr.Close();returnnull;}StopPlaceModuleStopPlaceMod=newStopPlaceModule();dr.Read();#region读取字段值StopPlaceMod.SpID=CommonSqlValue.GetString(0,dr);StopPlaceMod.SpName=CommonSqlValue.GetString(1,dr);StopPlaceMod.SpLocation=CommonSqlValue.GetString(2,dr);StopPlaceMod.bigcarnum=CommonSqlValue.GetInt32(3,dr);StopPlaceMod.mediumcarnum=CommonSqlValue.GetInt32(4,dr);StopPlaceMod.smallcarnum=CommonSqlValue.GetInt32(5,dr);#endregiondr.Close();conn.Close();returnStopPlaceMod;}catch(SqlExceptionsqlEx)(throwsqlEx;}}}}publicvoidStopPlaceDeleteOne(StringSpID)(using(SqlConnectionconn=DABase.CreateConnection())(if(ConnectionState.Closed==conn.State)(conn.Open();}using(SqlCommandcmd=conn.CreateCommand())(cmd.CommandType=CommandType.StoredProcedure;cmd.CommandText="StopPlaceDeleteOne";#region添加存储过程参数cmd.Parameters.AddWithValue(〃@SpID〃，SpID);//用户编号#endregiontry(cmd.ExecuteNonQuery();conn.Close();}catch(SqlExceptionsqlEx)(throwsqlEx;}}}}publicvoidStopPlaceUpdateOne(StopPlaceModuleStopPlaceMod)(using(SqlConnectionconn=DABase.CreateConnection())(if(ConnectionState.Closed==conn.State)(conn.Open();}using(SqlCommandcmd=conn.CreateCommand())(cmd.CommandType=CommandType.StoredProcedure;cmd.CommandText="StopPlaceUpdateOne”;#region添加存储过程参数cmd.Parameters.AddWithValue("@SpID”,StopPlaceMod.SpID);cmd.Parameters.AddWithValue("@SpName”,StopPlaceMod.SpName);cmd.Parameters.AddWithValue("@SpLocation”,StopPlaceMod.SpLocation);cmd.Parameters.AddWithValue("@bigcarnum”,StopPlaceMod.bigcarnum);cmd.Parameters.AddWithValue("@mediumcarnum”,StopPlaceMod.mediumcarnum);cmd.Parameters.AddWithValue("@smallcarnum”,StopPlaceMod.smallcarnum);#endregiontry(cmd.ExecuteNonQuery();conn.Close();}catch(SqlExceptionsqlEx)(switch(sqlEx.Number)(case2601:case2627:thrownewException("修改记录失败！插入的键值已经存在，请确认后重试。如果仍有错误，请与管理员联系。",sqlEx);case8152:thrownewException("修改记录失败！字符串长度超出范围，请确认后重试。如果仍有错误，请与管理员联系。",sqlEx);case8115:thrownewException(”修改记录失败!数值超出范围，请确认后重试。如果仍有错误，请与管理员联系。",sqlEx);default:throwsqlEx;}}}}}publicvoidStopPlaceInsertOne(StopPlaceModuleStopPlaceMod)(using(SqlConnectionconn=DABase.CreateConnection())(if(ConnectionState.Closed==conn.State)(conn.Open();}using(SqlCommandcmd=conn.CreateCommand())(cmd.CommandType=CommandType.StoredProcedure;cmd.CommandText="StopPlaceInsertOne";#region添加存储过程参数cmd.Parameters.AddWithValue("@SpID”,StopPlaceMod.SpID);cmd.Parameters.AddWithValue("@SpName”,StopPlaceMod.SpName);cmd.Parameters.AddWithValue("@SpLocation”,StopPlaceMod.SpLocation);cmd.Parameters.AddWithValue("@bigcarnum”,StopPlaceMod.bigcarnum);cmd.Parameters.AddWithValue("@mediumcarnum”,StopPlaceMod.mediumcarnum);cmd.Parameters.AddWithValue(〃@smallcarnum〃，StopPlaceMod.smallcarnum);#endregiontry{cmd.ExecuteNonQuery();conn.Close();}catch(SqlExceptionsqlEx)(switch(sqlEx.Number)(case2601:case2627:thrownewException("添加记录失败!插入的键值已经存在，请确认后重试。如果仍有错误，请与管理员联系。",sqlEx);case8152:thrownewException("添加记录失败！字符串长度超出范围，请确认后重试。如果仍有错误，请与管理员联系。",sqlEx);case8115:thrownewException("添加记录失败!数值超出范围，请确认后重试。如果仍有错误，请与管理员联系。",sqlEx);default:throwsqlEx;}}}}}}}namespaceDA(publicpartialclassUserInfoDA(publicUserInfoDA()(}publicDataTableUserInfoSelectAll()(using(SqlConnectionconn=DABase.CreateConnection())(if(ConnectionState.Closed==conn.State)(conn.Open();}using(SqlCommandcmd=conn.CreateCommand())(cmd.CommandType=CommandType.StoredProcedure;cmd.CommandText="UserInfoSelectAll";try(SqlDataAdapterAdapter=newSqlDataAdapter(cmd);DataSetds=newDataSet();Adapter.Fill(ds);conn.Close();returnds.Tables[0];}catch(SqlExceptionsqlEx)(throwsqlEx;}}))publicUserInfoModuleUserInfoSelectOne(StringUserID)(using(SqlConnectionconn=DABase.CreateConnection())(if(ConnectionState.Closed==conn.State){conn.Open();}using(SqlCommandcmd=conn.CreateCommand())(cmd.CommandType=CommandType.StoredProcedure;cmd.CommandText="UserInfoSelectOne";#region添加存储过程参数cmd.Parameters.AddWithValue("@UserID",UserID);//用户编号#endregiontry(SqlDataReaderdr=cmd.ExecuteReader();if(dr.HasRows==false)(dr.Close();returnnull;}UserInfoModuleUserInfoMod=newUserInfoModule();dr.Read();#region读取字段值UserInfoMod.UserID=CommonSqlValue.GetString(0,dr);//用户编号UserInfoMod.UserName=CommonSqlValue.GetString(1,dr);//用户名UserInfoMod.passwod=CommonSqlValue.GetString(2,dr);//密码UserInfoMod.UserLevel=CommonSqlValue.GetString(3,dr);//用户级另U#endregiondr.Close();conn.Close();returnUserInfoMod;}catch(SqlExceptionsqlEx)(throwsqlEx;}}}}publicvoidUserInfoDeleteOne(StringUserID)(using(SqlConnectionconn=DABase.CreateConnection())(if(ConnectionState.Closed==conn.State)(conn.Open();}using(SqlCommandcmd=conn.CreateCommand())(cmd.CommandType=CommandType.StoredProcedure;cmd.CommandText="UserInfoDeleteOne";#region添加存储过程参数cmd.Parameters.AddWithValue("@UserID",UserID);//用户编号#endregiontry{cmd.ExecuteNonQuery();conn.Close();}catch(SqlExceptionsqlEx)(throwsqlEx;}}}}publicvoidUserInfoUpdateOne(UserInfoModuleUserInfoMod)(using(SqlConnectionconn=DABase.CreateConnection())(if(ConnectionState.Closed==conn.State)(conn.Open();}using(SqlCommandcmd=conn.CreateCommand())(cmd.CommandType=CommandType.StoredProcedure;cmd.CommandText="UserInfoUpdateOne”;#region添加存储过程参数cmd.Parameters.AddWithValue("@UserID”,UserInfoMod.UserID);//用户编号cmd.Parameters.AddWithValue("@UserName”,UserInfoMod.UserName);//用户名cmd.Parameters.AddWithValue("@passwod”,UserInfoMod.passwod);//密码cmd.Parameters.AddWithValue("@UserLevel”,UserInfoMod.UserLevel);//用户级别#endregiontry(cmd.ExecuteNonQuery();conn.Close();}catch(SqlExceptionsqlEx)(switch(sqlEx.Number)(case2601:case2627:thrownewException("修改记录失败!插入的键值已经存在，请确认后重试。如果仍有错误，请与管理员联系。",sqlEx);case8152:thrownewException("修改记录失败！字符串长度超出范围，请确认后重试。如果仍有错误，请与管理员联系。",sqlEx);case8115:thrownewException(”修改记录失败!数值超出范围，请确认后重试。如果仍有