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

来源：网络收集时间：2020-06-23 下载这篇文档手机版

说明：文章内容仅供预览，部分内容可能不全，需要完整文档或者需要复制内容，请下载word后使用。下载word有问题请添加微信号:或QQ：处理（尽可能给您提供完整文档），感谢您的支持与谅解。

1. namespace DA模块

public DataTable CarInfoSelectAll()

{ using (SqlConnection conn = DABase.CreateConnection()) { if (ConnectionState.Closed == conn.State) { conn.Open(); }

using (SqlCommand cmd = conn.CreateCommand())

{ cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = \ try

{ SqlDataAdapter Adapter = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); Adapter.Fill(ds); conn.Close();

return ds.Tables[0]; }

catch (SqlException sqlEx) { throw sqlEx; } } } }

public CarInfoModule CarInfoSelectOne(String CarID)

{ using (SqlConnection conn = DABase.CreateConnection()) { if (ConnectionState.Closed == conn.State) { conn.Open(); }

using (SqlCommand cmd = conn.CreateCommand()) { cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = \ #region 添加存储过程参数

cmd.Parameters.AddWithValue(\车辆标号 #endregion try

{ SqlDataReader dr = cmd.ExecuteReader(); if (dr.HasRows == false) { dr.Close(); return null; }

CarInfoModule CarMod = new CarInfoModule(); 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); #endregion dr.Close(); conn.Close(); return CarMod; }

catch (SqlException sqlEx) { throw sqlEx; } } } }

public void CarInfoDeleteOne(String CarID)

{ using (SqlConnection conn = DABase.CreateConnection()) { if (ConnectionState.Closed == conn.State) { conn.Open(); }

using (SqlCommand cmd = conn.CreateCommand()) {

cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = \ #region 添加存储过程参数

cmd.Parameters.AddWithValue(\记录序列号 #endregion try

{ cmd.ExecuteNonQuery(); conn.Close(); }

catch (SqlException sqlEx) { throw sqlEx; } } } }

public void CarInfoUpdateOne(CarInfoModule CarMod)

{ using (SqlConnection conn = DABase.CreateConnection()) { if (ConnectionState.Closed == conn.State) { conn.Open(); }

using (SqlCommand cmd = conn.CreateCommand())

{ cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = \

#region 添加存储过程参数

cmd.Parameters.AddWithValue(\ cmd.Parameters.AddWithValue(\ cmd.Parameters.AddWithValue(\ cmd.Parameters.AddWithValue(\ cmd.Parameters.AddWithValue(\ cmd.Parameters.AddWithValue(\ #endregion try

{ cmd.ExecuteNonQuery(); conn.Close(); }

catch (SqlException sqlEx) {

switch (sqlEx.Number) { case 2601: case 2627:

throw new Exception(\修改记录失败!插入的键值已经存在，请确认后重试。如果仍有错误，请与管理员联系。\

case 8152: throw new Exception(\修改记录失败!字符串长度超出范围，请确认后重试。如果仍有错误，请与管理员联系。\

case 8115: throw new Exception(\修改记录失败!数值超出范围，请确认后重试。如果仍有错误，请与管理员联系。\default: throw sqlEx;

} } } } }

public void CarInfoInsertOne(CarInfoModule CarMod)

{ using (SqlConnection conn = DABase.CreateConnection()) { if (ConnectionState.Closed == conn.State) { conn.Open(); }

using (SqlCommand cmd = conn.CreateCommand())

{ cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = \ #region 添加存储过程参数

cmd.Parameters.AddWithValue(\cmd.Parameters.AddWithValue(\

cmd.Parameters.AddWithValue(\ cmd.Parameters.AddWithValue(\ cmd.Parameters.AddWithValue(\ cmd.Parameters.AddWithValue(\ #endregion try { cmd.ExecuteNonQuery(); conn.Close(); }

catch (SqlException sqlEx)

{

switch (sqlEx.Number) {

case 2601: case 2627: throw new Exception(\添加记录失败!插入的键值已经存在，请确认后重试。如果仍有错误，请与管理员联系。\

case 8152: throw new Exception(\添加记录失败!字符串长度超出范围，请确认后重试。如果仍有错误，请与管理员联系。\

case 8115: throw new Exception(\添加记录失败!数值超出范围，请确认后重试。如果仍有错误，请与管理员联系。\ default: throw sqlEx;

} } } } } }} namespace DA

{ public partial class CarOutDA {

public DataTable CarOutSelectAll()

{ using (SqlConnection conn = DABase.CreateConnection()) {

if (ConnectionState.Closed == conn.State) { conn.Open(); }

using (SqlCommand cmd = conn.CreateCommand()) {

cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = \ try {

SqlDataAdapter Adapter = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); Adapter.Fill(ds); conn.Close();

return ds.Tables[0]; }

catch (SqlException sqlEx) { throw sqlEx; } } } }

public CarOutModule CarOutSelectOne1(DateTime date1,DateTime date2) { using (SqlConnection conn = DABase.CreateConnection()) { if (ConnectionState.Closed == conn.State) { conn.Open(); }

using (SqlCommand cmd = conn.CreateCommand()) {

cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = \ #region 添加存储过程参数

cmd.Parameters.AddWithValue(\ cmd.Parameters.AddWithValue(\ #endregion try

{ SqlDataReader dr = cmd.ExecuteReader(); if (dr.HasRows == false) { dr.Close(); return null; }

CarOutModule CarOutMod = new CarOutModule(); 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); #endregion dr.Close(); conn.Close(); return CarOutMod; }

catch (SqlException sqlEx) { throw sqlEx; } } } }

public void CarOutDeleteOne(String OutID)

{ using (SqlConnection conn = DABase.CreateConnection()) { if (ConnectionState.Closed == conn.State) {

conn.Open(); }

using (SqlCommand cmd = conn.CreateCommand())

{ cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = \ #region 添加存储过程参数

cmd.Parameters.AddWithValue(\用户编号 #endregion try

{ cmd.ExecuteNonQuery(); conn.Close(); }

百度搜索“77cn”或“免费范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读，免费范文网，提供经典小说教育文库C#和sql设计的车辆管理系统课程设计报告，附带代码(2)在线全文阅读。

C#和sql设计的车辆管理系统课程设计报告，附带代码(2).doc 将本文的Word文档下载到电脑，方便复制、编辑、收藏和打印下载失败或者文档不完整，请联系客服人员解决！

下载这篇word文档

本文链接：https://www.77cn.com.cn/wenku/jiaoyu/1124104.html（转载请注明文章来源）

上一篇：2017河南专监复习资料
下一篇：2018版中国止咳化痰药市场现状研究前景趋势预测报告目录

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

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