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