public System.Data.DataTable selectByUser(ML_UsageLog UsageLog, int RowCount) { var para = new MySqlParameter[2]; para[0] = new MySqlParameter("@UserKey", UsageLog.UserKey); para[1] = new MySqlParameter("@RowCount", RowCount); return(MySQLHelper.ExecuteDataTable(DBConnection.connectionString, System.Data.CommandType.Text, "SELECT `Key`, UserKey, `From`, `To` FROM stc_oba.usagelog WHERE UserKey = @UserKey LIMIT @RowCount", para)); }
public bool update(ML_UsageLog UsageLog) { var para = new MySqlParameter[2]; para[0] = new MySqlParameter("@Key", UsageLog.Key); para[1] = new MySqlParameter("@To", UsageLog.To); MySQLHelper.ExecuteNonQuery(DBConnection.connectionString, System.Data.CommandType.Text, "UPDATE stc_oba.usagelog SET`To` = @To WHERE `Key` = @Key", para); return(true); }