public void Exit(string accessToken) { const string commandText = @"Update chz_users Set access_token = null Where access_token = @access_token"; var parameter = new UserAccessTokenParameter() { AccessToken = accessToken }; var transaction = Transact <object> .Create(ConnectionString, commandText, parameter : parameter); transaction.ExecuteNonQuery(); }
public UserModel Get(string accessToken) { const string commandText = @"Select chz_user_id,first_name,last_name,login,password,access_token,date_time,is_lock From chz_users Where is_lock=0 And access_token = @access_token"; var parameter = new UserAccessTokenParameter() { AccessToken = accessToken }; var transaction = Transact <UserModel> .Create(ConnectionString, commandText, parameter : parameter); return(transaction.ExecuteReader().FirstOrDefault()); }