/// <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); } }