/// <summary> /// AliveTaskInfo (只要sql查询有结果即会在每次时间节点到达时触发事件,如果想要以此结果处理业务,可以在处理业务前Pause,处理完成后再Resume,或者更新sql cmd) /// </summary> /// <param name="yourTaskName">Task Name</param> /// <param name="sqlcmd">sql</param> /// <param name="intervalTime">interval Time</param> /// <param name="yourExecuteMySqlDrive">SqlDrive</param> public AliveTaskInfo(string yourTaskName, String sqlcmd, int intervalTime, MySqlDrive yourExecuteMySqlDrive) { Name = yourTaskName; TaskSqlcmd = sqlcmd; IntervalTime = intervalTime; IsKill = false; executeMySqlDrive = yourExecuteMySqlDrive; }
/// <summary> /// SqlMonitor constructor /// </summary> /// <param name="yourTaskName">task name</param> /// <param name="sqlcmd">sql</param> /// <param name="monitorRowIndex">RowIndex start with 0 (not x y)</param> /// <param name="monitorColumnIndex">ColumnIndex start with 0 (not x y)</param> /// <param name="intervalTime">interval Time</param> /// <param name="yourExecuteMySqlDrive">MySqlDrive</param> public SqlMonitor(string yourTaskName, String sqlcmd, int monitorRowIndex, int monitorColumnIndex, int intervalTime, MySqlDrive yourExecuteMySqlDrive) { Name = yourTaskName; TaskSqlcmd = sqlcmd; MonitorRowIndex = monitorRowIndex; MonitorColumnIndex = monitorColumnIndex; IntervalTime = intervalTime; IsKill = false; executeMySqlDrive = yourExecuteMySqlDrive; }