catch (SqlException sqlEx) { throw sqlEx; } } } }
public void CarOutUpdateOne(CarOutModule CarOutMod)
{ 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(\ #endregio 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 CarOutInsertOne(CarOutModule CarOutMod)
{ 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(\
10
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 class CommonSqlValue { public CommonSqlValue() { }
public static Byte[] GetSqlBinary(Int16 idx, SqlDataReader dr) {
if (!dr.IsDBNull(idx))
{ return dr.GetSqlBinary(idx).Value; } else
{ return null; } }
public static DateTime GetDateTime(Int16 idx, SqlDataReader dr) { if (!dr.IsDBNull(idx))
{ return dr.GetDateTime(idx).Date; } else
{ return DateTime.MinValue; }
11
}
public static Boolean GetBoolean(Int16 idx, SqlDataReader dr) {
if (!dr.IsDBNull(idx))
{ return dr.GetBoolean(idx); } else
{ return false; } }
public static Byte GetByte(Int16 idx, SqlDataReader dr) { if (!dr.IsDBNull(idx))
{ return dr.GetByte(idx); } else
{ return 0; } }
public static Int16 GetInt16(Int16 idx, SqlDataReader dr) { if (!dr.IsDBNull(idx))
{ return dr.GetInt16(idx); } else
{ return 0; } }
public static Int32 GetInt32(Int16 idx, SqlDataReader dr) { if (!dr.IsDBNull(idx))
{ return dr.GetInt32(idx); } else
{ return 0; } }
public static Int64 GetInt64(Int16 idx, SqlDataReader dr) { if (!dr.IsDBNull(idx))
{ return dr.GetInt64(idx); } else
{ return 0; } }
public static Single GetSingle(Int16 idx, SqlDataReader dr) {
12
if (!dr.IsDBNull(idx)) {
return dr.GetFloat(idx); } else {
return 0; } }
public static Double GetDouble(Int16 idx, SqlDataReader dr) { if (!dr.IsDBNull(idx))
{ return dr.GetDouble(idx); } else
{ return 0; } }
public static Decimal GetDecimal(Int16 idx, SqlDataReader dr) { if (!dr.IsDBNull(idx)) {
return dr.GetDecimal(idx); } else
{ return 0; } }
public static String GetString(Int16 idx, SqlDataReader dr) { if (!dr.IsDBNull(idx))
{ return dr.GetString(idx); } else
{ return String.Empty; } }
public static Guid GetGuid(Int16 idx, SqlDataReader dr) { if (!dr.IsDBNull(idx))
{ return dr.GetGuid(idx); } else
{ return Guid.Empty; } } }} namespace DA
{ class DABase {
13
private static string ConnectionString =
System.Configuration.ConfigurationManager.ConnectionStrings[\].ToString();
public DABase() { }
public static SqlConnection CreateConnection() {
SqlConnection conn = new SqlConnection(DABase.ConnectionString); return conn; } }} namespace DA
{ public partial class DriverDA { public DriverDA() { }
public DataTable DriverSelectAll()
{ 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 DriverModule DriverSelectOne(String DriverID)
{ using (SqlConnection conn = DABase.CreateConnection()) { if (ConnectionState.Closed == conn.State) { conn.Open(); }
using (SqlCommand cmd = conn.CreateCommand())
{ cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = \ #region 添加存储过程参数
14