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