GridView增删改 三层 完整版0.docVIP

： 1)DiaryModel（业务实体层），新建一个User类 代码如下： using System; using System.Collections.Generic; using System.Text; namespace DiaryModel { [Serializable] //序列化 public class Users { int _UserID; string _UserName; string _Password; public int UserID { get { return _UserID; } set { _UserID = value; } } /// summary /// 用户名 /// /summary public string UserName { get { return _UserName; } set { _UserName = value; } } /// summary /// 密码 /// /summary public string Password { get { return _Password; } set { _Password = value; } } } } 该类可以获得User类的各个字段。 appSettings add key=DbHelperProvider value=System.Data.SqlClient/ /appSettings connectionStrings add name=DbHelperConnectionString connectionString=Data Source=FAN;Initial Catalog=test;User ID=sa;Password=20;Connect Timeout=18000/ /connectionStrings （将DBHelper.cs类纺织DiaryDAL目录下，要注意的是DBHelper类下的命名空间要改为DiaryDAL） 新建一个UserService.cs类，实现增删改查等相关操作，具体代码如下所示： using System; using System.Collections.Generic; using System.Text; using System.Data; using DiaryModel; //记得要添加引用 namespace DiaryDAL { public class UserService { //添加 public static bool Add(Users user) { string sql = insert into Users(username,password) values(@username,@password); Dictionarystring,object dic=new Dictionarystring,object(); dic.Add(@username, user.UserName); dic.Add(@password, user.Password); return DBHelper.ExecuteNonQuery(sql, dic) 0 ? true : false ; } //删除 public static bool Delete(int UserID) { string sql = delete from Users where ID=@UserID; Dictionarystring, object dic = new Dictionarystring, object(); dic.Add(@UserID, UserID); return DBHelper.ExecuteNonQuery(sql, dic) 0