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