/// <summary>
/// 能过userid查询
/// </summary>
/// <param name="UserlistDomain"></param>
/// <returns></returns>
public static UserlistDomain QueryByUserId(UserlistDomain UserlistDomain)
{
using (IDbConnection connection = new SqlConnection(conStr))
{
return(connection.Query <UserlistDomain>("select * from DDUsers where userid=@userid", UserlistDomain).SingleOrDefault());
}
}
/// <summary>
/// 修改
/// </summary>
/// <param name="sqlStr"></param>
/// <param name="user"></param>
/// <returns></returns>
public static int Update(string sqlStr, UserlistDomain user)
{
try
{
using (IDbConnection connection = new SqlConnection(conStr))
{
return(connection.Execute(sqlStr, user));
}
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 查询指定数据
/// </summary>
/// <param name="UserlistDomain"></param>
/// <returns></returns>
public static UserlistDomain Query(string sqlStr, UserlistDomain UserlistDomain)
{
try
{
using (IDbConnection connection = new SqlConnection(conStr))
{
return(connection.Query <UserlistDomain>(sqlStr, UserlistDomain).SingleOrDefault());
}
}
catch (Exception)
{
throw;
}
}
public static int UpdateByUserId(UserlistDomain user)
{
using (IDbConnection connection = new SqlConnection(conStr))
{
return(connection.Execute(@"update DDUsers set
unionid=@unionid
,[order]=@order
,isAdmin=@isBoss
,isBoss=@isBoss
,isHide=@isHide
,isLeader=@isLeader
,name=@name
,active=@active
,department=@department
,position=@position
,avatar=@avatar
,jobnumber=@jobnumber
where userid=@userid", user));
}
}
