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