/// <summary>
/// 删除
/// </summary>
/// <returns></returns>
public int DeleteUserInfo(UserInfo userInfo)
{
string sql = "delete from UserInfo where id = @id ";
using (var conn = DapperDataHelper.GetDbConnection())
{
return(conn.Execute(sql, userInfo));
}
}
/// <summary>
/// 更新
/// </summary>
/// <returns></returns>
public int UpdateUserInfo(UserInfo userInfo)
{
string sql = " Update UserInfo set [UserName] = @UserName,[UserLoginName] = @UserLoginName,[UserPsd] = @UserPsd,[IsOnline] = @IsOnline,[IsUseful] = @IsUseful,[UserRealName] = @UserRealName,[UserMail] = @UserMail where id = @id ";
using (var conn = DapperDataHelper.GetDbConnection())
{
return(conn.Execute(sql, userInfo));
}
}
/// <summary>
/// 获取UserInfo
/// </summary>
/// <param name="userInfo"></param>
/// <returns></returns>
public IEnumerable <UserInfo> GetUserInfoByDapper(UserInfo userInfo)
{
string sql = "select ID, [UserName],[UserLoginName],[UserPsd],[IsOnline],[IsUseful],[UserRealName],[UserMail] from UserInfo where UserLoginName = @UserLoginName and UserPsd = @UserPsd";
using (var con = DapperDataHelper.GetDbConnection())
{
return(con.Query <UserInfo>(sql, userInfo));
}
}
/// <summary>
/// 增加用户
/// </summary>
/// <returns></returns>
public int AddUserInfo(UserInfo userInfo)
{
string sql = " INSERT INTO [dbo].[UserInfo] ([Name],[Age],[WorkCode],[Company],[Department],[CId]) VALUES(@Name, @Age, @WorkCode, @Company, @Department, @CId)";
using (var conn = DapperDataHelper.GetDbConnection())
{
return(conn.Execute(sql, userInfo));
}
}
/// <summary>
/// 增加用户
/// </summary>
/// <returns></returns>
public int AddUserInfo(UserInfo userInfo)
{
string sql = " INSERT INTO [dbo].[UserInfo] ([UserName],[UserLoginName],[UserPsd],[IsOnline],[IsUseful],[UserRealName],[UserMail])" +
"VALUES(@UserName, @UserLoginName, @UserPsd, @IsOnline, @IsUseful, @UserRealName, @UserMail)";
using (var conn = DapperDataHelper.GetDbConnection())
{
return(conn.Execute(sql, userInfo));
}
}
