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 ConfirmLog(DeviceOperateLog log) { if (log.Id != 0) { var sql = "UPDATE `device_operate_log` SET `MarkedDateTime` = @MarkedDateTime, `ConfirmId` = @ConfirmId, `ConfirmTime` = @ConfirmTime, `IsPass` = @IsPass, `PassCount` = @PassCount, `FailCount` = @FailCount WHERE `Id` = @Id;"; ServerConfig.ApiDb.Execute(sql, log); } }