实体类的创建

实体类的创建一、实验目的：1、能够使用实体类和命名空间实现用户注册功能2、拥有良好的编程习惯3、拥有分析问题、解决问题的能力4、拥有独立思考意识、勇于克服困难的素质二、实验内容创建用户实体类、药品实体类、商家实体类三、实验步骤1、创建用户实体类：1)在MedicineBLL层创建代码：namespace MedicineBLL{public static class UserManager{public static void AddUser(User user){UserService.AddUser(user);}public static void DeleteUser(User user){UserService.DeleteUser(user);}public static void ModifyUser(User user){UserService.ModifyUser(user);}public static IList<User> GetUsers(){return UserService.GetUsers();}/// <summary>/// 登录验证（通过判断用户登录名是否存在，密码是否正确，验证是否为合法用户） /// </summary>/// <param name="loginName">用户登录名</param>/// <param name="loginPwd">用户密码</param>/// <param name="validUser">用户对象</param>/// <returns>布尔值</returns>public static bool UserLogin(string UserName, string UserPwd, out User validUser) {User user = UserService.GetUserByLoginName(UserName);if (user == null) //登录名不存在{validUser = null;return false;}else if (erPwd != UserPwd) //密码错误{validUser = null;return false;}else{validUser = user;return true;}}/// <summary>/// 注册新用户/// </summary>/// <param name="user">用户对象</param>/// <returns>布尔值</returns>public static bool UserRegister(User user){if (UserService.GetUserByLoginName(erName) != null){return false;}else{AddUser(user);return true;}}public static User GetUserById(int id){return UserService.GetUserById(id);}}}2）在MedicineDAL层创建代码：namespace MedicineDAL{public class UserService{private static string connectionString =ConfigurationManager.ConnectionStrings["MedicineCon"].ConnectionString;/// <summary>/// 添加用户/// </summary>/// <param name="user">用户对象</param>public static void AddUser(User user){using (SqlConnection cn = new SqlConnection(connectionString)){cn.Open();SqlCommand cm = new SqlCommand();cm.Connection = cn;string sql ="INSERT Users (UserName, UserPwd, RealName, Sex, Role, Remark, Phone)" + "VALUES (@UserName, @UserPwd, @RealName, @Sex, @Role, @Remark, @Phone)"; mandText = sql;cm.Parameters.AddWithValue("@UserName", erName);cm.Parameters.AddWithValue("@UserPwd", erPwd);cm.Parameters.AddWithValue("@RealName", user.RealName);cm.Parameters.AddWithValue("@Sex", user.Sex);cm.Parameters.AddWithValue("@Role", user.Role);cm.Parameters.AddWithValue("@Remark", user.Remark);cm.Parameters.AddWithValue("@Phone", user.Phone);cm.ExecuteNonQuery();}}/// <summary>/// 删除用户/// </summary>/// <param name="user">用户对象</param>.public static void DeleteUser(User user){using (SqlConnection cn = new SqlConnection(connectionString)){cn.Open();SqlCommand cm = new SqlCommand();cm.Connection = cn;string sql = "DELETE Users WHERE ID = @ID";mandText = sql;cm.Parameters.AddWithValue("@ID", user.ID);cm.ExecuteNonQuery();}}/// <summary>/// 修改用户/// </summary>/// <param name="user">用户对象</param>public static void ModifyUser(User user){using (SqlConnection cn = new SqlConnection(connectionString)) {cn.Open();SqlCommand cm = new SqlCommand();cm.Connection = cn;string sql ="UPDATE Users " +"SET " +"UserName = @UserName, " +"UserPwd = @UserPwd, " +"RealName = @RealName, " +"Sex = @Sex, " +"Role = @Role, " +"Remark = @Remark, " +"Phone = @Phone " +"WHERE ID = @ID";mandText = sql;cm.Parameters.AddWithValue("@ID", user.ID);cm.Parameters.AddWithValue("@UserName", erName);cm.Parameters.AddWithValue("@UserPwd", erPwd);cm.Parameters.AddWithValue("@RealName", user.RealName);cm.Parameters.AddWithValue("@Sex", user.Sex);cm.Parameters.AddWithValue("@Role", user.Role);cm.Parameters.AddWithValue("@Remark", user.Remark);cm.Parameters.AddWithValue("@Phone", user.Phone);cm.ExecuteNonQuery();}}/// <summary>/// 查询所有用户的所有字段/// </summary>/// <returns>用户对象集合</returns>public static IList<User> GetUsers(){using (SqlConnection cn = new SqlConnection(connectionString)){cn.Open();SqlCommand cm = new SqlCommand();cm.Connection = cn;string sql = "SELECT * FROM Users";mandText = sql;SqlDataReader dr = cm.ExecuteReader();List<User> list = new List<User>();while (dr.Read()){User user = new User();user.ID = (int)dr["ID"];erName = (string)dr["UserName"];erPwd = (string)dr["UserPwd"];user.RealName = (string)dr["RealName"];user.Sex = (string)dr["Sex"];user.Role = (string)dr["Role"];user.Remark = (string)dr["Remark"];user.Phone = (string)dr["Phone"];list.Add(user);}dr.Close();return list;}}/// <summary>/// 根据登录名查询用户/// </summary>/// <param name="loginName">用户登录名</param>/// <returns>用户对象</returns>public static User GetUserByLoginName(string UserName){using (SqlConnection cn = new SqlConnection(connectionString)){cn.Open();SqlCommand cm = new SqlCommand();cm.Connection = cn;string sql = "SELECT * FROM Users WHERE UserName = @UserName"; mandText = sql;cm.Parameters.AddWithValue("@UserName", UserName);SqlDataReader dr = cm.ExecuteReader();if (dr.Read()){User user = new User();user.ID = (int)dr["ID"];erName = (string)dr["UserName"];erPwd = (string)dr["UserPwd"];user.RealName = (string)dr["RealName"];user.Sex = (string)dr["Sex"];user.Role = (string)dr["Role"];user.Remark = (string)dr["Remark"];user.Phone = (string)dr["Phone"];dr.Close();return user;}else{dr.Close();return null;}}}/// <summary>/// 根据Id查询用户/// </summary>/// <param name="id">用户Id</param>/// <returns>用户对象</returns>public static User GetUserById(int id){using (SqlConnection cn = new SqlConnection(connectionString)) {cn.Open();SqlCommand cm = new SqlCommand();cm.Connection = cn;string sql = "SELECT * FROM Users WHERE ID = @ID";mandText = sql;cm.Parameters.AddWithValue("@ID", id);SqlDataReader dr = cm.ExecuteReader();if (dr.Read()){User user = new User();user.ID = (int)dr["ID"];erName = (string)dr["UserName"];erPwd = (string)dr["UserPwd"]; user.RealName = (string)dr["RealName"]; user.Sex = (string)dr["Sex"];user.Role = (string)dr["Role"];user.Remark = (string)dr["Remark"];user.Phone = (string)dr["Phone"];dr.Close();return user;}else{dr.Close();return null;}}3）在MedicineModels创建代码：namespace MedicineModels{[Serializable()]public class User{private int Id;private string Username = String.Empty;private string Userpwd = String.Empty;private string Realname = String.Empty;private string sex = String.Empty;private string role = String.Empty;private string remark = String.Empty;private string phone = String.Empty;public User() { }public int ID{get { return this.Id;}set { this.Id = value;}}public string UserName{get { return ername;}set { ername = value;}}public string UserPwd{get { return erpwd;}set { erpwd = value;}}public string RealName{get { return this.Realname;}set { this.Realname = value;}}public string Sex{get { return this.sex;}set { this.sex = value;}}public string Role{get { return this.role;}set { this.role = value;}}public string Remark{get { return this.remark;}set { this.remark = value;}}public string Phone{get { return this.phone; }set { this.phone = value; }}}}2、药品实体类1）在MedicineModels层创建代码：namespace MedicineModels{[Serializable()]public class Medicines{public Medicines() { }private int Id;public int ID{get { return this.Id;}set { this.Id = value;}}private string number = String.Empty;public string Number{get { return number; }set { number = value; }}private string medName = String.Empty;public string MedName{get { return medName; }set { medName = value; }}private int kindId;public int KindId{get { return kindId; }set { kindId = value; }}private string Productiondate;public string ProductionDate{get { return Productiondate; }set { Productiondate = value; }}private string description = String.Empty;public string Description{get { return description; }set { description = value; }}private string img = String.Empty;public string Img{get { return img; }set { img = value; }}private string medValid;public string MedValid{get { return medValid; }set { medValid = value; }}private string medfactory = String.Empty;public string MedFactory{get { return medfactory; }set { medfactory = value; }}private string medprice = String.Empty;public string MedPrice{get { return medprice; }set { medprice = value; }}}}2）在MedicineDAL层创建代码：namespace MedicineDAL{public static class MedicineService{private static string connectionString =ConfigurationManager.ConnectionStrings["MedicineCon"].ConnectionString;//根据id查找药品public static Medicines GetMedicineById(int id){using (SqlConnection cn = new SqlConnection(connectionString )) {cn.Open();SqlCommand cm = new SqlCommand();cm.Connection = cn;string sql = "select * from Medicine where ID=@id";mandText = sql;cm.Parameters.AddWithValue("@id", id);SqlDataReader dr = cm.ExecuteReader();if (dr.Read()){Medicines med = new Medicines();med.ID = (int)dr["ID"];med.Number = (string)dr["Number"];med.MedName = (string)dr["MedName"];med.KindId = (int)dr["KindId"];med.ProductionDate = (string)dr["ProductionDate"];med.Description = (string)dr["Description"];med.Img = (string)dr["Img"];med.MedValid = (string)dr["MedValid"];med.MedFactory = (string)dr["MedFactory"];med.MedPrice = (string)dr["MedPrice"];dr.Close();return med;}else{dr.Close();return null;}}}//删除public static void DeleteMedicine(Medicines medicine){using (SqlConnection cn = new SqlConnection(connectionString)) {cn.Open();SqlCommand cm = new SqlCommand();cm.Connection = cn;string sql = "Delete from Medicine where ID=@ID";mandText = sql;cm.Parameters.AddWithValue("@ID", medicine .ID );cm.ExecuteNonQuery();}}//添加药品public static void Addmedicine(Medicines med){using (SqlConnection cn = new SqlConnection(connectionString)){cn.Open();SqlCommand cm = new SqlCommand();cm.Connection = cn;string sql = "insert into Medicine( Number,MedName,KindId,Description,Img,MedValid,MedFactory,MedPrice,ProductionDate)values( @Number,@MedName,@KindId,@Description,@Img,@MedValid,@MedFactory,@MedPrice,@Producti onDate )";mandText = sql;cm.Parameters.AddWithValue("@Number", med.Number);cm.Parameters.AddWithValue("@MedName", med.MedName);cm.Parameters.AddWithValue("@KindId", med.KindId);cm.Parameters.AddWithValue("@Description", med.Description);cm.Parameters.AddWithValue("@Img", med.Img);cm.Parameters.AddWithValue("@MedValid", med.MedValid);cm.Parameters.AddWithValue("@MedFactory", med.MedFactory);cm.Parameters.AddWithValue("@MedPrice", med.MedPrice);cm.Parameters.AddWithValue("@ProductionDate", med.ProductionDate);cm.ExecuteNonQuery();}}//修改public static void ModifyMedicine(Medicines med){using (SqlConnection cn = new SqlConnection(connectionString)){cn.Open();SqlCommand cm = new SqlCommand();cm.Connection = cn;string sql = "update Medicine setNumber=@Number,MedName=@MedName,KindId=@KindId,ProductionDate=@ProductionDate,Description=@D escription,Img=@Img,MedValid=@MedValid,MedFactory=@MedFactory,MedPrice=@MedPrice whereID=@ID";mandText = sql;cm.Parameters.AddWithValue("@Number", med.Number);cm.Parameters.AddWithValue("@MedName", med.MedName);cm.Parameters.AddWithValue("@KindId", med.KindId);cm.Parameters.AddWithValue("@ProductionDate", med.ProductionDate);cm.Parameters.AddWithValue("@Description", med.Description);cm.Parameters.AddWithValue("@Img", med.Img);cm.Parameters.AddWithValue("@MedValid", med.MedValid);cm.Parameters.AddWithValue("@MedFactory", med.MedFactory);cm.Parameters.AddWithValue("@MedPrice", med.MedPrice);cm.Parameters.AddWithValue("@ID", med.ID);cm.ExecuteNonQuery();}}//查找所有药品public static IList<Medicines> GetMedicine(){using (SqlConnection cn = new SqlConnection(connectionString)) {cn.Open();SqlCommand cm=new SqlCommand ();cm.Connection =cn;string sql="select * from Medicine";mandText =sql;SqlDataReader dr=cm.ExecuteReader ();List <Medicines> list = new List<Medicines>();while (dr.Read()){Medicines medicine = new Medicines();medicine.ID = (int)dr["ID"];medicine.Number = (string)dr["Number"];medicine.MedName = (string)dr["MedName"];medicine.KindId = (int)dr["KindId"];medicine.ProductionDate = (string)dr["ProductionDate"]; medicine.Description = (string)dr["Description"];medicine.Img = (string)dr["Img"];medicine.MedValid = (string)dr["MedValid"];medicine.MedFactory = (string)dr["MedFactory"];medicine.MedPrice = (string)dr["MedPrice"];list.Add(medicine);}dr.Close();return list;}}}}3）在MedicineBLL创建代码：namespace MedicineBLL{public static class MedicineManager{public static void DeleteMedicine(Medicines medicine) {MedicineService.DeleteMedicine(medicine);}public static void ModifyMedicine(Medicines medicine) {MedicineService.ModifyMedicine(medicine);}public static IList<Medicines> GetMedicine(){return MedicineService.GetMedicine();}public static Medicines GetMedicineById(int id){return MedicineService.GetMedicineById(id);}public static void Addmedicine(Medicines med){MedicineService.Addmedicine(med);}}}3、商家实体类1）在MedicineBLL层创建代码namespace MedicineBLL{public class FactoryManager{public static void DeleteFactory(Factorys fac){FactoryService.DeleteFactory(fac);}public static void ModifyFactory(Factorys fac){FactoryService.ModifyFactory(fac);}public static IList<Factorys> GetFactroy(){return FactoryService.GetFactory();}public static Factorys GetFactoryById(int id){return FactoryService.GetFactoryById(id);}{FactoryService.AddFactory(fac);}}}2）在MedicineDAL层创建代码namespace MedicineDAL{public class FactoryService{private static string connectionString =ConfigurationManager.ConnectionStrings["MedicineCon"].ConnectionString;//根据id查找厂家public static Factorys GetFactoryById(int id){using (SqlConnection cn = new SqlConnection(connectionString)) {cn.Open();SqlCommand cm = new SqlCommand();cm.Connection = cn;string sql = "select * from Factory where ID=@id";mandText = sql;cm.Parameters.AddWithValue("@id", id);SqlDataReader dr = cm.ExecuteReader();if (dr.Read()){Factorys fac= new Factorys ();fac.ID = (int)dr["ID"];fac.FactoryName = (string)dr["FactoryName"];fac.FactoryStruction = (string)dr["FactoryStruction"]; return fac;}else{dr.Close();return null;}}}//删除{using (SqlConnection cn = new SqlConnection(connectionString)){cn.Open();SqlCommand cm = new SqlCommand();cm.Connection = cn;string sql = "Delete from Factory where ID=@ID";mandText = sql;cm.Parameters.AddWithValue("@ID", fac.ID );cm.ExecuteNonQuery();}}//修改public static void ModifyFactory(Factorys fac){using (SqlConnection cn = new SqlConnection(connectionString)){cn.Open();SqlCommand cm = new SqlCommand();cm.Connection = cn;string sql = "UPDATE Factory setFactoryName=@FactoryName,FactoryStruction=@FactoryStruction where ID=@ID";mandText = sql;cm.Parameters.AddWithValue("@FactoryName", fac.FactoryName);cm.Parameters.AddWithValue("@FactoryStruction", fac.FactoryStruction); cm.Parameters.AddWithValue("@ID", fac.ID);cm.ExecuteNonQuery();}}//添加厂家信息public static void AddFactory(Factorys fac){using (SqlConnection cn = new SqlConnection(connectionString)){cn.Open();SqlCommand cm = new SqlCommand();cm.Connection = cn;string sql = "insert into Factory ( FactoryName,FactoryStruction) values(@FactoryName,@FactoryStruction )";mandText = sql;cm.Parameters.AddWithValue("@FactoryName", fac.FactoryName);cm.Parameters.AddWithValue("@FactoryStruction", fac.FactoryStruction);cm.ExecuteNonQuery();}}//查找所有厂家信息public static IList<Factorys> GetFactory(){using (SqlConnection cn = new SqlConnection(connectionString)) {cn.Open();SqlCommand cm = new SqlCommand();cm.Connection = cn;string sql = "select * from Factory";mandText = sql;SqlDataReader dr = cm.ExecuteReader();List<Factorys> list = new List<Factorys>();while (dr.Read()){Factorys fac = new Factorys ();fac.ID = (int)dr["ID"];fac.FactoryName = (string)dr["FactoryName"];fac.FactoryStruction = (string)dr["FactoryStruction"]; list.Add(fac );}dr.Close();return list;}}}}3）在MedicineModels层创建代码namespace MedicineModels{[Serializable()]public class Factorys{public Factorys() { }private int Id;public int ID{get { return Id; }set { Id = value; }}private string factoryname = String.Empty;public string FactoryName{get { return factoryname ;}set { factoryname = value; }}public string factorystruction = String.Empty;public string FactoryStruction{get { return factorystruction; }set { factorystruction = value; }}}}实验总结：使用SqlDataReader对象执行数据读取操作时，先用SqlCommand对象的ExecuteReader（）方法创建一个SqlDataReader类的对象实例，再用SqlDataReader对象的Read（）方法读取数据（若有多条记录，可通过while循环读取，最后用SqlDataReader对象的Close（）方法关闭该对象）。