/// <summary> /// 随机生成一条雇员信息 /// </summary> /// <returns></returns> public static IEmployee GetRandomEmployee() { int index_first = random.Next(0, firstNames.Length); int index_second = random.Next(0, lastNames.Length); int index_post = random.Next(0, posts.Length); IFactory factory = FactoryService.GetFactory(posts[index_post].Post_name); IEmployee emp = factory.Get(); emp.Id = int.Parse(CreateEmployeeID()); emp.Sex = (random.Next(0, 6) < 3 ? "男" : "女"); emp.Name = (firstNames[index_first] + " " + lastNames[index_second]); emp.Age = random.Next(18, 40); return(emp); }
/// <summary> /// 根据ID查询雇员信息 /// </summary> /// <param name="key">查询ID</param> /// <returns></returns> dynamic IModelService.Get(dynamic key) { string id = key; try { using (SqlConnection conn = sqlHelper.GetConnection()) { conn.Open(); string sql = "SELECT * FROM [dbo].[EmployeeInfo] WHERE Id = @Id;"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.Add("@Id", SqlDbType.NVarChar); cmd.Parameters["@Id"].Value = id; using (SqlDataReader reader = cmd.ExecuteReader()) { if (reader.Read()) { System.Data.IDataRecord record = reader; IFactory factory = FactoryService.GetFactory(record.GetString(4)); IEmployee emp = factory.Get(); emp.Id = int.Parse(record.GetString(0)); emp.Name = record.GetString(1); emp.Age = record.GetInt32(2); emp.Sex = record.GetString(6); return(emp); } else { return(null); } } } } catch (SqlException sqle) { throw sqle; } catch (Exception e) { throw e; } }