public int Update(Model.Model.UserInfo user) { using (IDbConnection cn = new MySqlConnection(cns)) { string sql = "Update userinfo set password=@password,qq=@qq,email=@email,type=@type,userimg=@userImg where username@userName"; return(cn.Execute(sql, user)); } }
public int Add(Model.Model.UserInfo user) { using (IDbConnection cn = new MySqlConnection(cns)) { string sql = "insert into userinfo value(@userName,@passWord,@qq,@email,@type,@userImg);"; return(cn.Execute(sql, user)); } }
public void TestMethod2() { Model.Model.UserInfo user = new Model.Model.UserInfo { userName = "******", passWord = "******", type = "¹ÜÀíÔ±" }; Console.WriteLine(DAL.UserInfo.Instance.Add(user)); Console.WriteLine(JsonConvert.SerializeObject(DAL.UserInfo.Instance.GetAll())); user.qq = "104512708"; Console.WriteLine(DAL.UserInfo.Instance.Update(user)); var model = DAL.UserInfo.Instance.GetModel("Guest"); Console.WriteLine(JsonConvert.SerializeObject(model)); Console.WriteLine(DAL.UserInfo.Instance.Delete("Guest")); var page = DAL.UserInfo.Instance.GetPage(new Model.Model.Page { pageIndex = 2, pageSize = 2 }); Console.WriteLine(JsonConvert.SerializeObject(page)); Console.WriteLine(DAL.UserInfo.Instance.GetCount()); }