public static void ConfirmSchedule(DeviceOperateScheduleDetail schedule, DeviceOperateLog log)
{
var sql = "CALL OperateSchedule_Confirm(@Id, @markedDateTime, @ConfirmId, @IsPass, @PassCount, @FailCount);";
ServerConfig.ApiDb.Execute(sql, new { schedule.Id, schedule.MarkedDateTime, schedule.ConfirmId, schedule.IsPass, schedule.PassCount, schedule.FailCount });
DeviceOperateLogHelper.ConfirmLog(log);
}
public static void CompleteSchedule(DeviceOperateScheduleDetail schedule)
{
var sql = "UPDATE `device_operate_schedule` SET `MarkedDateTime` = @MarkedDateTime, " +
"`EndTime` = @EndTime, `EndCount` = @EndCount, `LastLogId` = @LastLogId WHERE `Id` = @Id;";
ServerConfig.ApiDb.Execute(sql, schedule);
//var sql = "CALL OperateSchedule_Complete(@Id, @OperatorId, @markedDateTime, @LastLogId);";
//ServerConfig.ApiDb.Execute(sql, new { schedule.Id, schedule.OperatorId, schedule.MarkedDateTime, schedule.LastLogId });
}
public DeviceOperateLog(DeviceOperateScheduleDetail schedule)
{
}
private static void NextSchedule(DeviceOperateScheduleDetail schedule)
{
var sql = "CALL OperateSchedule_Next(@OperatorId, @markedDateTime);";
ServerConfig.ApiDb.Execute(sql, new { schedule.OperatorId, schedule.MarkedDateTime });
}
public static void BackSchedule(DeviceOperateScheduleDetail schedule)
{
var sql = "CALL OperateSchedule_Back(@Id, @markedDateTime);";
ServerConfig.ApiDb.Execute(sql, new { schedule.Id, schedule.MarkedDateTime });
}
