//string conStr = @"Data Source=D:\jinxiang\jinxiang.db;Version=3;Legacy Format=True;";
//private string constr1 = @"Server=localhost;Database=jinhe;Uid=root;Pwd=tianmeng";
//public async Task<IEnumerable<UserInfo>> GetList()
//{
// //IEnumerable<UserInfo> list = null;
// using (IDbConnection con = new MySqlConnection(constr1))
// {
// con.Open();
// string sql = "select * from userinfo";
// var list = await con.QueryAsync<UserInfo>(sql);
// return list.ToList();
// //list.ToList().ForEach(item =>
// //{
// // Console.WriteLine(item.Name);
// //});
// ////string sql = "insert into home (name) values (@Name);select last_insert_rowid() newid";
// //int id = con.Query<int>(sql, new { Name = "蛋蛋" }).FirstOrDefault();
// //string sql = "select * from home";
// //if (r > 0)
// //{
// // Console.WriteLine("插入了{0}", r);
// //}
// // Console.WriteLine(id);
// }
//}
public async Task <IEnumerable <UserInfo> > GetListAsync()
{
string sql = "select * from JH_userinfo where username=@UserName";
var list = await DapperHelper.QueryAsync <UserInfo>(sql, new { UserName = "******" });
return(list);
}
/// <summary>
/// 根据用户名或者用户id查找对应的用户
/// </summary>
/// <param name="userInfo"></param>
/// <returns></returns>
public async Task <IEnumerable <UserInfo> > GetUserInfoAsync(UserInfo userInfo)
{
string sql;
IEnumerable <UserInfo> userList;
if (userInfo.Id > 0)
{
sql = "select * from JH_userinfo where Id=@Id";
userList = await DapperHelper.QueryAsync <UserInfo>(sql, new { Id = userInfo.Id });
}
else if (!string.IsNullOrWhiteSpace(userInfo.UnionId))
{
sql = "select * from JH_userinfo where UnionId=@UnionId";
userList = await DapperHelper.QueryAsync <UserInfo>(sql, new { UnionId = userInfo.UnionId });
}
else
{
return(null);
}
return(userList);
}