/// <summary>
/// 创建车辆信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Create(dynamic model)
{
Vehicle vehicle = model;
string sql = "INSERT INTO [dbo].[Vehicle] VALUES(@License, @Type, @Height, @Weight, @Load);";
try
{
using (SqlConnection conn = sqlHelper.GetConnection())
{
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.Add("@License", SqlDbType.NVarChar);
cmd.Parameters["@License"].Value = vehicle.License;
cmd.Parameters.Add("@Type", SqlDbType.NVarChar);
cmd.Parameters["@Type"].Value = vehicle.Type;
cmd.Parameters.Add("@Height", SqlDbType.Float);
cmd.Parameters["@Height"].Value = vehicle.Height;
cmd.Parameters.Add("@Weight", SqlDbType.Float);
cmd.Parameters["@Weight"].Value = vehicle.Weight;
cmd.Parameters.Add("@Load", SqlDbType.Float);
cmd.Parameters["@Load"].Value = vehicle.Load;
int result = cmd.ExecuteNonQuery();
if (result == 0)
{
return(false);
}
else
{
return(true);
}
}
}
catch (SqlException sqle)
{
throw sqle;
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// 添加新雇员到信息表中
/// </summary>
/// <param name="emp"></param>
/// <returns></returns>
public static int Create(IEmployee emp)
{
string sql = "INSERT INTO [dbo].[EmployeeInfo] VALUES(@Id, @Name, @Sex, @Age, @Post_Name);";
using (SqlConnection conn = sqlHelper.GetConnection())
{
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.Add("@Id", SqlDbType.Int);
cmd.Parameters["@Id"].Value = emp.Id;
cmd.Parameters.Add("@Name", SqlDbType.NVarChar);
cmd.Parameters["@Name"].Value = emp.Name;
cmd.Parameters.Add("@Sex", SqlDbType.NVarChar);
cmd.Parameters["@Sex"].Value = emp.Sex;
cmd.Parameters.Add("@Age", SqlDbType.Int);
cmd.Parameters["@Age"].Value = emp.Age;
cmd.Parameters.Add("@Post_Name", SqlDbType.NVarChar);
cmd.Parameters["@Post_Name"].Value = emp.Emp_Post.Post_Name;
return(cmd.ExecuteNonQuery());
}
}
/// <summary>
/// 获取所有雇员的信息
/// </summary>
/// <returns></returns>
public static List <IEmployee> GetEmployeeInfo()
{
using (SqlConnection conn = sqlHelper.GetConnection())
{
conn.Open();
List <IEmployee> list = new List <IEmployee>();
string sql = "SELECT * FROM [dbo].[EmployeeInfo];";
SqlCommand cmd = new SqlCommand(sql, conn);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
System.Data.IDataRecord record = reader;
IEmployee emp = null;
if (record.GetString(4).Equals("Worker"))
{
emp = new WorkerFactory().Get();
}
else if (record.GetString(4).Equals("Manager"))
{
emp = new ManagerFactory().Get();
}
else
{
emp = new DriverFactory().Get();
}
emp.Id = record.GetInt32(0);
emp.Name = record.GetString(1);
emp.Sex = record.GetString(2);
emp.Age = record.GetInt32(3);
list.Add(emp);
}
}
conn.Dispose();
cmd.Dispose();
return(list);
}
}
